

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Sent: 17 May 2002 23:24
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] More schema queries 
> 
> 
> >          2200 | pg_stat_all_tables
> >          2200 | pg_stat_sys_tables
> 
> Bizarre.  It's not that way here.  Would you mind updating to 
> CVS tip, rebuilding, and seeing if you can duplicate that?  
> Also, make sure you're using the right initdb script ...

OK, brand new Cygwin installation, built from CVS tip and still the
views are in public. I checked 4 times that I'm using the correct
initdb, even manually installing it from the source tree. I then hacked
initdb and prepended 'pg_catalog.' to the view names in the CREATE
VIEWs. Cleared my data dir, ran initdb and the views are still in
public. I then cleared & ran initdb with --debug. The views were *again*
in public, and no errors were seen.

I'm confused. Does the standalone backend not deal with schemas fully
and is silently failing 'cos there's nothing technically wrong with the
pg_catalog.viewname syntax? Or do I just not know what the heck I'm
doing :-)

> Curious.  I have not noticed much of any change in postmaster 
> startup time on Unix.  Can you run a profile or something to 
> see where the time is going?

On my clean cygwin installation this problem is no longer present. I
guess something got screwed up in my old installation that - maybe
something from the 7.2 installation that ran in parallel (thought that
worked fine).

Regards, Dave.

Mon, 20 May 2002 20:22:51 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: More schema queries 
"Dave Page" <dpage@vale-housing.co.uk> writes:
> I'm confused. Does the standalone backend not deal with schemas fully
> and is silently failing 'cos there's nothing technically wrong with the
> pg_catalog.viewname syntax?

The standalone backend does schemas just fine.  What is supposed to
ensure that the views get created in pg_catalog is the bit in initdb:

PGSQL_OPT="$PGSQL_OPT -O --search_path=pg_catalog"

The -- parameter should do the equivalent of
	SET search_path = pg_catalog;
but apparently it's not working for you; if it weren't there then the
views would indeed get created in public.

Any idea why it's not working?

			regards, tom lane

Mon, 20 May 2002 20:00:13 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: More schema queries 