table rename oddity
От | Ari Jolma |
---|---|
Тема | table rename oddity |
Дата | |
Msg-id | 200005251244.PAA18592@water.hut.fi обсуждение исходный текст |
Ответы |
Re: table rename oddity
|
Список | pgsql-general |
Hello, Is this kind of behavior intended. When I try to rename a table to a reserved word - I have tried to use 'lseg' which is a type - postgres gives me an error but the change has been partly done and the only way back seems to be to go to the database directory and rename the file. I have tested this with version 7.0. Regards, Ari Jolma An example: template1=> create table a (a int); CREATE template1=> alter table a rename to lseg; ERROR: TypeRename: type lseg already defined template1=> \dt Database = template1 +------------------+----------------------------------+----------+ | Owner | Relation | Type | +------------------+----------------------------------+----------+ | ajolma | a | table | +------------------+----------------------------------+----------+ template1=> select * from a; NOTICE: mdopen: couldn't open a: No such file or directory NOTICE: RelationIdBuildRelation: smgropen(a): No such file or directory NOTICE: mdopen: couldn't open a: No such file or directory NOTICE: mdopen: couldn't open a: No such file or directory NOTICE: mdopen: couldn't open a: No such file or directory NOTICE: mdopen: couldn't open a: No such file or directory ERROR: cannot open relation a template1=> drop table a; NOTICE: mdopen: couldn't open a: No such file or directory NOTICE: mdopen: couldn't open a: No such file or directory DROP template1=> \dt Couldn't find any tables!
В списке pgsql-general по дате отправления: