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: (view raw, whole thread or download thread mbox)
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.

Kamil Giza

Attachment: kamilg.vcf
Description: text/x-vcard (204 bytes)


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-2017 The PostgreSQL Global Development Group