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

BUG #5494: pg_dump dependiences sequence problem

From: "Ovidiu Tanasiciuc" <tanasiciuc(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5494: pg_dump dependiences sequence problem
Date: 2010-06-08 11:03:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5494
Logged by:          Ovidiu Tanasiciuc
Email address:      tanasiciuc(at)yahoo(dot)com
PostgreSQL version: 8.4.1
Operating system:   Windows XP
Description:        pg_dump dependiences sequence problem

I have 2 tables a and b
a have column id - bigserial
b have column Id - bigserial with I uppercase
both automatic have 2 sequences
the problem is then i make pg_dump with data only and insert command,even
like or from pgadmin
E:/Programe/PostgreSQL/8.4/bin\pg_dump.exe --host servercnp --port 5432
--username postgres --format plain --data-only --column-inserts --verbose
--file "C:\Users\ovidiu\Desktop\x.sql" --table public.a secretariat

the table a.sql file have the line
SELECT pg_catalog.setval('a_id_seq', 4392, false);
but the tabel b doesn't have this line.

this is a bug because it's mean tha pg_depend doesn't read ok dependiences
for columns with uppercase character.  

my problem is that i like to make a backup without command set sequences,but
i can't find any parameters for this.

Anyway, even if is corect to make backup with set seuences includes, please
make to work and for columns uppercases.


pgsql-bugs by date

Next:From: Greg Sabino MullaneDate: 2010-06-08 13:37:15
Subject: Re: [BUGS] Invalid YAML output from EXPLAIN
Previous:From: Florian WeimerDate: 2010-06-08 08:01:20
Subject: Re: [HACKERS] Invalid YAML output from EXPLAIN

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