| From: | "Ilja Golshtein" <ilejn(at)yandex(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | table is not a table |
| Date: | 2006-01-25 13:22:09 |
| Message-ID: | 43D77B81.000005.00490@mfront8.yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello!
Could you please help me with an issue I have on a PG installation.
The problem is it is impossible to drop any table.
Looks like this.
==
[ilejn(at)wombat bin]$ ./psql postgres ilejn
Welcome to psql 8.1.1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# create table ddd(f1 int4);
CREATE TABLE
postgres=# drop table ddd;
ERROR: "ddd" is not a table
postgres=# select * from pg_authid where rolname='ilejn';
rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcatupdate | rolcanlogin | rolconnlimit | rolpassword | rolvaliduntil | rolconfig
---------+----------+------------+---------------+-------------+--------------+-------------+--------------+-------------+---------------+-----------
ilejn | t | t | t | t | t | t | -1 | | |
(1 row)
postgres=# select * from pg_tables where tablename='ddd';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------+------------+------------+------------+----------+-------------
public | ddd | ilejn | | f | f | f
(1 row)
postgres=# alter table ddd add column f2 text;
ALTER TABLE
==
There is no magic about 'ddd' - same thing for every table.
I can ALTER this 'ddd', I can do any DML, but cannot drop!
Any ideas what's wrong with permissions/roles or something?
Thanks.
--
Best regards
Ilja Golshtein
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergiusz Jarczyk | 2006-01-25 13:36:08 | Re: Does this look ethical to you? |
| Previous Message | James Croft | 2006-01-25 11:42:07 | Temporary table visibility |