Hi,

I'm currently updating pgAdmin to support schemas and have a couple of
(well three) questions:

1) How can I specify the schema in CREATE OPERATOR?
'OPERATOR(pg_catalog.+)' notation gives an error :-(

2) There are default comments for the system schemas in pg_description,
but COMMENT ON SCHEMA isn't implemented. Is it safe to assume it will be
before 7.3?

3) Likewise, Tom stated that DROP SCHEMA isn't yet implemented - is it
safe for me to assume that it will be before release?

And whilst I'm writing, many thanks for the hard work you've put into
this Tom.

Regards, Dave.


Tue, 7 May 2002 20:05:00 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Couple of schema queries...
"Dave Page" <dpage@vale-housing.co.uk> writes:
> 1) How can I specify the schema in CREATE OPERATOR?
> 'OPERATOR(pg_catalog.+)' notation gives an error :-(

You don't need the OPERATOR() decoration there, only in expressions.
(Yes, the documentation is still skimpy.)

> 2) There are default comments for the system schemas in pg_description,
> but COMMENT ON SCHEMA isn't implemented. Is it safe to assume it will be
> before 7.3?

It should be.

> 3) Likewise, Tom stated that DROP SCHEMA isn't yet implemented - is it
> safe for me to assume that it will be before release?

It will be.

			regards, tom lane

Tue, 07 May 2002 23:30:28 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Couple of schema queries... 