"Boris" <boris_k@iname.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