Re: PostgreSQL 8.3 temporary tables & stored functions - Mailing list pgsql-novice

From Gabriele Messineo
Subject Re: PostgreSQL 8.3 temporary tables & stored functions
Date
Msg-id 200806171712.26757.gabriele.messineo@winext.eu
Whole thread Raw
In response to Re: PostgreSQL 8.3 temporary tables & stored functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Tuesday 17 June 2008 15:11:06 Tom Lane wrote:
> Gabriele Messineo <gabriele.messineo@winext.eu> writes:
> > But actually I'm experiencing some issues because some statements does
> > not work at all, in particular, I can read from temporary tables without
> > any issue but my DELETEs fail silently.
>
> AFAICS the deletes work fine.  The only issue I can find with your
> example is that a regclass constant doesn't get re-evaluated ... which
> is a bug no doubt, but it shouldn't really affect normal use.
>
>             regards, tom lane

I finally realized a bug in my SQL code (I was checking with the equal
operator a variable that could assume NULL values).
I apologize for the previous mail, but I was driven on a false track when,
debugging, I started to find strange oids ... (they were the first thing I
checked when porting).

Thanks for your support.

Regards,

Gabriele Messineo

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.3 temporary tables & stored functions
Next
From: Gary
Date:
Subject: Step 1 with Visual Basic