Re: BUG #2307: Buckup and sequences in DEFAULT part - Mailing list pgsql-bugs

From Kamil Giza
Subject Re: BUG #2307: Buckup and sequences in DEFAULT part
Date
Msg-id 44102B0F.9050801@zeto.olsztyn.pl
Whole thread Raw
In response to BUG #2307: Buckup and sequences in DEFAULT part  ("Giza Kamil" <kamilg@zeto.olsztyn.pl>)
List pgsql-bugs
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

Attachment

pgsql-bugs by date:

Previous
From: "Hans Guijt"
Date:
Subject: Re: BUG #2305: "No bufferspace available" error on large insert
Next
From: 小野寺 あかね
Date:
Subject: 【質問】lo_openについて[ERROR: invalid flags: 0]