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

Re: BUG #2557: field`s default value not restored in big sql script

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Boris" <boris_k(at)iname(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2557: field`s default value not restored in big sql script
Date: 2006-08-01 12:40:12
Message-ID: 1182.1154436012@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Boris" <boris_k(at)iname(dot)com> writes:
> But table "auth"."access_flag" has wrong def value for "access_flag_id".
> I think ii must be
> nextval('auth.access_flag_access_flag_id_seq'::regclass).

> From script it becomes nextval('access_flag_access_flag_id_seq'::regclass)

This is not wrong, or at least you haven't provided enough info to prove
that it is wrong.  The display of a regclass constant is schema-aware.
Try doing \d on the table with search_path set to something that doesn't
include the auth schema ... does it show as auth.something then?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: DrorDate: 2006-08-01 12:57:17
Subject: BUG #2558: initDB failed to run
Previous:From: Jan CruzDate: 2006-08-01 12:24:27
Subject: pg_restore

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