From: | OLSEN Frank <frank(dot)olsen(at)soprasteria(dot)com> |
---|---|
To: | "pljava-dev(at)lists(dot)postgresql(dot)org" <pljava-dev(at)lists(dot)postgresql(dot)org> |
Subject: | Sequences not updated after restore |
Date: | 2022-09-22 07:18:23 |
Message-ID: | PA4PR07MB7070D635189554A412768D5CF74E9@PA4PR07MB7070.eurprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi,
I did a simple test of installing pljava (1.5.6), adding the example and a function to test.
Then I did a pg_dump of the database containing the sqlj schema.
Drop / recreate the database and import from the dump:
- Data is present in all tables
- However, sequences are recreated with no call to setval (...) to reset the values.
Maybe this is not specific to PL/Java extension, but I have only seen the issue for this case.
In the same database, if I create a sequence manually and a table DEFAULT nextval('myseq') the import contains a setval statement so that after restore the sequence is correct.
Thanks a lot for any help!
Best regards,
Frank OLSEN
C2 - Usage restreint
From | Date | Subject | |
---|---|---|---|
Next Message | Bear Giles | 2023-06-08 20:39:34 | Announcing docker hub repos with auto-updating pgxnclient and pl/java pre-installed |
Previous Message | Brewer, Peter W - (pbrewer) | 2022-05-30 21:53:39 | postgresql-14-pljava deb package on Debian Bullseye |