Couple of schema queries...
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.
"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