This is a discussion on Re: BUG #2307: Buckup and sequences in DEFAULT part within the pgsql Bugs forums, part of the PostgreSQL category; --> It's a problem because after restore, server is looking for sequence in schema "public" but sequence was created in ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| It's a problem because after restore, server is looking for sequence in schema "public" but sequence was created in schema "schema". When I'm inserting new row to the table I have an error because server can't find the sequence. I know I can set proper searchpath, but now I can't because I have sequences with the same names in different schemas. regards, Kamil Giza ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
| Thread Tools | |
| Display Modes | |
|
|