> -----Original Message-----
> From: Tom Lane [mailto:[EMAIL PROTECTED]] 
> Sent: 21 May 2002 20:09
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] More schema queries 
>
> 
> I guess your version of getopt() won't cooperate with -- 
> switches. I've committed this change in CVS.

Thanks.

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

I've just been playing with this as you suggested, and using an initdb
with both 'create view foo' and 'create view pg_catalog.bar', with the
-- style switch I get (for both types of view): 

namespace_search_path   = $user,public
newRelation->schemaname = null
namespaceId             = 2200 (public)

So I guess the problem is a combination of the getopt() that we've
already found, and schemaname being null in the newRelation structure. 

Using the -c style switch in PGSQL_OPTS gives namespace_search_path =
pg_catalog as expected.

I am interested in learning more about this so any pointers you might
offer would be useful (I seriously doubt I'd find the fault myself
though) but I do understand that you probably have better things to do
than help me begin to understand the internals so I won't be overly
offended if you don't have time :-)

Cheers, Dave.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to