Andreas Pflug wrote:
> It's _always_ fine, because GetSchema obeys the search path and the
> reengineered SQL is meant to be used in a search path situation as it
> was at the time of reengineering. There are plenty of other situations
> where the reduced form (omitting search-pathed schema) won't work.
Let me back up and make clear what I'm saying. The code I originally
submitted is not correct. The code you committed is not correct either.
To correctly determine what the default value for a serial will look
like, you need to know what the search_path was at table creation time.
Knowing its current value is not relevent.
Run the following in psql.
SET search_path TO public;
CREATE schema s1;
CREATE TABLE s1.t1(a serial);
SET search_path TO s1;
CREATE TABLE s1.t2(a serial);
Note how one default includes the schema and the other doesn't. Explain
how pgadmin can correctly determine the default value for both of these
In response to
pgadmin-hackers by date
|Next:||From: Edward Di Geronimo Jr.||Date: 2006-02-20 19:29:15|
|Subject: Re: Query tool results in grid|
|Previous:||From: Magnus Hagander||Date: 2006-02-20 15:34:06|
|Subject: pgagent commandline|