Thread: Strange...

Strange...

From
Michal Mosiewicz
Date:
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

Re: [HACKERS] Strange...

From
Bruce Momjian
Date:
>
> 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)

Re: [HACKERS] Strange...

From
Bruce Momjian
Date:
>
> 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)