

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Sent: 21 May 2002 14:17
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] More schema queries 
> 
> 
> 
> Try changing the PGOPTS setting to use
> 
> 	-c search_path=pg_catalog 
> 
> That shouldn't make any difference but ...

Shouldn't but does :-). Checked & double-checked, that works perfectly.

> Also, you could try setting a breakpoint at 
> RangeVarGetCreationNamespace (in backend/catalog/namespace.c) 
> to see what it thinks it's doing and what's in 
> namespace_search_path at the time.

I'm going to try to do this regardless of the fact it now works - this
will be my first play with gdb so it might take me a while but would
probably be a useful learning experience. I'll let you know what I find.

Regards, Dave.

Tue, 21 May 2002 14:38:34 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: More schema queries 
"Dave Page" <dpage@vale-housing.co.uk> writes:
>> Try changing the PGOPTS setting to use
>> -c search_path=pg_catalog 
>> That shouldn't make any difference but ...

> Shouldn't but does :-). Checked & double-checked, that works perfectly.

I guess your version of getopt() won't cooperate with -- switches.
I've committed this change in CVS.

I'm still interested in why explicitly saying "create view pg_catalog.foo"
didn't work ...

			regards, tom lane

Tue, 21 May 2002 15:08:50 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: More schema queries 