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

BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.

From: "Julius Tuskenis" <julius(at)nsoft(dot)lt>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4061: after backup/restore pg_attrdef.adsrc column lacks schema name.
Date: 2008-03-26 09:00:09
Message-ID: 200803260900.m2Q9098Y052042@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4061
Logged by:          Julius Tuskenis
Email address:      julius(at)nsoft(dot)lt
PostgreSQL version: 8.2.7
Operating system:   WinXp
Description:        after backup/restore pg_attrdef.adsrc column lacks
schema name.
Details: 

Problem with backup/restore databases with schemas other than public. After
restoring pg_attrdef.adsrc doesn't contain schema name of the sequence -
only sequence itself. It is big problem then using Zeos lib components for
Delphi, becouse they get wrong default values and no insert is possible
then.

To replicate the bug do the folowing:

1. create DB and new schema in it (not public).
2. create table in new schema with column of datatype serial;
3. go to pg_attrdef and find the desciption of default value of the new
column (adsrc). See it contains NEXTVAL('schema.sequence').
4. do backup/restore (using pg_dump binary backup)
5. after restoring see the column pg_attrdef.adsrc of the new database.
6. See it contains NEXTVAL('sequence');

Responses

pgsql-bugs by date

Next:From: Tomasz OstrowskiDate: 2008-03-26 09:08:02
Subject: Re: BUG: PG do not use index
Previous:From: Eugen.KonkovDate: 2008-03-26 08:41:18
Subject: Re: BUG: PG do not use index

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