Strange...

Started by Michal Mosiewiczalmost 28 years ago3 messages
#1Michal Mosiewicz
mimo@interdata.com.pl

Hello,

Postgres 6.3.1. I was just trying to profile the backend. Somehow I
cannot drop the log table.
xxx=> \d

Database    = xxx
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | mimo             | a                                | sequence |
 | postgres         | log                              | table    |
 | mimo             | test                             | table    |
 +------------------+----------------------------------+----------+
xxx=> drop table log;
ERROR:  DeletePgTypeTuple: log type nonexistent     

Mike

--
WWW: http://www.lodz.pdi.net/~mimo tel: Int. Acc. Code + 48 42 148340
add: Michal Mosiewicz * Bugaj 66 m.54 * 95-200 Pabianice * POLAND

#2Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Michal Mosiewicz (#1)
Re: [HACKERS] Strange...

Hello,

Postgres 6.3.1. I was just trying to profile the backend. Somehow I
cannot drop the log table.
xxx=> \d

Database    = xxx
+------------------+----------------------------------+----------+
|  Owner           |             Relation             |   Type   |
+------------------+----------------------------------+----------+
| mimo             | a                                | sequence |
| postgres         | log                              | table    |
| mimo             | test                             | table    |
+------------------+----------------------------------+----------+
xxx=> drop table log;
ERROR:  DeletePgTypeTuple: log type nonexistent     

Just tried it

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)
#3Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Michal Mosiewicz (#1)
Re: [HACKERS] Strange...

Hello,

Postgres 6.3.1. I was just trying to profile the backend. Somehow I
cannot drop the log table.
xxx=> \d

Database    = xxx
+------------------+----------------------------------+----------+
|  Owner           |             Relation             |   Type   |
+------------------+----------------------------------+----------+
| mimo             | a                                | sequence |
| postgres         | log                              | table    |
| mimo             | test                             | table    |
+------------------+----------------------------------+----------+
xxx=> drop table log;
ERROR:  DeletePgTypeTuple: log type nonexistent     

Just tried it with 6.3.2:

test=> create table log(x int);
CREATE
test=> drop table log;
DROP
test=>

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)