Thread: I must be daft, but I can't figure out what is wrong with this

I must be daft, but I can't figure out what is wrong with this

From
"Dann Corbit"
Date:
I am toying around with a SQL92 INFORMATION_SCHEMA model.  I have
created the SQL to try to explore the idea, but I can't get off the
ground.

What is my utter and obvious idiocy?

E.g.:

schema_test=> CREATE SCHEMA INFORMATION_SCHEMA AUTHORIZATION
INFORMATION_SCHEMA ;
ERROR:  parser: parse error at or near "authorization"
schema_test=>


Re: I must be daft, but I can't figure out what is wrong with this

From
Tom Lane
Date:
"Dann Corbit" <DCorbit@connx.com> writes:
> schema_test=> CREATE SCHEMA INFORMATION_SCHEMA AUTHORIZATION
> INFORMATION_SCHEMA ;
> ERROR:  parser: parse error at or near "authorization"
> schema_test=>

Judging by the spelling of the error message, you're trying to do this
in a pre-7.3 PG.  We didn't have schemas back then.

            regards, tom lane