Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: kamilg.vcf
Description: text/x-vcard (204 bytes)

Responses

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group