Home > Archive > PostgreSQL Discussion > April 2005 > I must be daft, but I can't figure out what is wrong with this









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

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

2005-04-27, 8:24 pm

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=>


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Tom Lane

2005-04-27, 8:24 pm

"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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com