Message-ID: <48157D01.5050405@archonet.com>
Date: Mon, 28 Apr 2008 08:30:09 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.12 (X11/20080213)
MIME-Version: 1.0
To: chester c young <chestercyoung@yahoo.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, sql pgsql <pgsql-sql@postgresql.org>
Subject: Re: psql: no schema info
References: <213749.31261.qm@web54304.mail.re2.yahoo.com>
In-Reply-To: <213749.31261.qm@web54304.mail.re2.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

chester c young wrote:
> using 8.2 and 8.3
> 
> here's (psychological) problem as I see it:
> 
> # set search_path=old_schema;
> #
> # create sequence new_schema.seq1;
> #
> # create table new_schema.table1(
> #    col1 integer default nextval( 'seq1' )
> # );
> 
> using old_schema.seq1, not new_schema.seq1
> 
> and imho to make matters more difficult to troubleshoot:
> 
> # \dt table1 -> does not show which schema for seq1

Must admit I thought you were wrong, but having tested it, I think I see 
what you mean.

If the schema in question is in the search_path then it doesn't get 
displayed. If you've forgotten what your search_path is set to then that 
can cause confusion.

Not a problem I see much of since I very rarely change my search_path. I 
  refer to schema.table by preference.

-- 
   Richard Huxton
   Archonet Ltd