Hi all.  Running 6.5.3 on Intel Linux.  I think problems related to this
have been reported in the past but the mailing list archives are running
incredibly slowly lately so I'm not *absolutely* sure:

[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

mail=> begin transaction ;
BEGIN
mail=> create temp table tbl1 ( x int4 ) ;
CREATE
mail=> drop table tbl1 ;
DROP
mail=> commit transaction ;
NOTICE:  trying to delete a reldesc that does not exist.
NOTICE:  trying to delete a reldesc that does not exist.
END
mail=>

A two-parter:

(1) For myself: Is this at all dangerous/problematic for my database?

(2) For Postgres: Is this addressed in the latest 7.0 source or on the
	TODO list?

Thanks...

- K

Kristofer Munn * KMI * 973-509-9414 * AIM KrMunn * http://www.munn.com/


Sun, 16 Jan 2000 01:57:41 -0500 (EST)
Kristofer Munn <kmunn@munn.com>
Temp Tables: Trying to delete a reldesc...
> Hi all.  Running 6.5.3 on Intel Linux.  I think problems related to this
> have been reported in the past but the mailing list archives are running
> incredibly slowly lately so I'm not *absolutely* sure:
> 
> [PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
> 
> mail=> begin transaction ;
> BEGIN
> mail=> create temp table tbl1 ( x int4 ) ;
> CREATE
> mail=> drop table tbl1 ;
> DROP
> mail=> commit transaction ;
> NOTICE:  trying to delete a reldesc that does not exist.
> NOTICE:  trying to delete a reldesc that does not exist.
> END
> mail=>
> 
> A two-parter:
> 
> (1) For myself: Is this at all dangerous/problematic for my database?

Not a problem.  Was some issue with flushing the cache, I bet.

> 
> (2) For Postgres: Is this addressed in the latest 7.0 source or on the
> 	TODO list?

Fixed in current tree.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sun, 16 Jan 2000 02:09:44 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Temp Tables: Trying to delete a reldesc...
Kristofer Munn <kmunn@munn.com> writes:
> [ 6.5.3 acts funny about deleting a temp table created in the same
>   transaction ]

> (1) For myself: Is this at all dangerous/problematic for my database?

AFAIR the notice is harmless; we'd have tried harder to back-patch a
fix if the consequences of the bug were critical.

> (2) For Postgres: Is this addressed in the latest 7.0 source or on the
> 	TODO list?

It's fixed in current sources.

			regards, tom lane

Sun, 16 Jan 2000 02:13:19 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Temp Tables: Trying to delete a reldesc... 