Bug or limitation?

Поиск
Список
Период
Сортировка
От Dean Gibson (DB Administrator)
Тема Bug or limitation?
Дата
Msg-id 5.1.0.14.2.20030507233121.00a84400@dba-sql.ultimeth.net
обсуждение исходный текст
Ответы Re: Bug or limitation?  (Bruno Wolff III <bruno@wolff.to>)
Re: Bug or limitation?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
createa 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
PSQLcommand. 

Sincerely, Dean


В списке pgsql-general по дате отправления:

Предыдущее
От: Abhishek Sharma
Дата:
Сообщение: Postgresql on Solaris
Следующее
От:
Дата:
Сообщение: Re: indices - used by which user ?