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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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