Bug or limitation?

From: "Dean Gibson (DB Administrator)" <dba-sql(at)ultimeth(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Bug or limitation?
Date: 2003-05-08 06:31:24
Message-ID: 5.1.0.14.2.20030507233121.00a84400@dba-sql.ultimeth.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm using PostgreSQL 7.3.2 (from RPM on this site) on RH Linux 7. I'm investigating using "schemas", but after I create a schema, I try to rename an existing table into the new schema with:

ALTER TABLE name RENAME TO schema.name;

This fails in parsing. Is this a bug or a (current) limitation of schemas?

Also, the only way I could find to list my schemas is:

SELECT * FROM pg_namespace;

And I had to go to the mailing lists to find that out; is it in the docs? For version 7.4 I'd suggest "\dn" as a new PSQL command.

Sincerely, Dean

Responses

Browse pgsql-general by date

  From Date Subject
Next Message g.hintermayer 2003-05-08 07:20:31 Re: indices - used by which user ?
Previous Message Tom Lane 2003-05-08 04:36:32 Re: qsort (was Re: Solaris)