Re: Couple of schema queries... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Couple of schema queries...
Date
Msg-id 28776.1020828628@sss.pgh.pa.us
Whole thread Raw
In response to Couple of schema queries...  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Creating new system catalog
Next
From: Joe Conway
Date:
Subject: Re: a couple of minor itches: RI Trigger Names, and