Re: BUG #2307: Buckup and sequences in DEFAULT part

From: Kamil Giza <kamilg(at)zeto(dot)olsztyn(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: BUG #2307: Buckup and sequences in DEFAULT part
Date: 2006-03-09 13:18:07
Message-ID: 44102B0F.9050801@zeto.olsztyn.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
kamilg.vcf text/x-vcard 204 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stefan Miefert 2006-03-09 13:27:05 [postgres] Postgres auf Ubuntu installieren
Previous Message 小野寺 あかね 2006-03-09 12:42:02 【質問】lo_openについて[ERROR: invalid flags: 0]