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

Browse pgsql-bugs by date

  From Date Subject
Next Message Dror 2006-08-01 12:57:17 BUG #2558: initDB failed to run
Previous Message Jan Cruz 2006-08-01 12:24:27 pg_restore