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

Re: psql: no schema info

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chester c young <chestercyoung(at)yahoo(dot)com>
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: psql: no schema info
Date: 2008-04-27 22:36:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
chester c young <chestercyoung(at)yahoo(dot)com> writes:
> however, just got burnt big time on sequences!  need to qualify them as
> well, eg
>   col1 integer default nextval( 'schema1.seq1' )

Move to something newer than 8.0.x, and this is automatic (because
nextval's argument is actually a regclass constant).

			regards, tom lane

In response to


pgsql-sql by date

Next:From: chester c youngDate: 2008-04-27 23:33:26
Subject: Re: psql: no schema info
Previous:From: chester c youngDate: 2008-04-27 21:33:33
Subject: psql: no schema info

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