On Sat, Nov 03, 2007 at 06:32:34PM -0400, Martin Pitt wrote:
> Tom Lane [2007-11-03 14:27 -0400]:
> > Martin Pitt <[EMAIL PROTECTED]> writes:
> > > The testsuite of 8.3 beta 2 fails on the Alpha architecture (versions
> > > up to 8.2 worked fine).
> >
> > We redid some of the float error handling
The following bug has been logged online:
Bug reference: 3718
Logged by: Dean
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Linux (opensuse 10.3 64-bit) and Windows 2000 SP4
Description:Unexpected undefined_table error after creating/dro
[Sorry for the late reply, but I've been on two business trips last week
without internet access.]
> The following statement:
>
> exec sql MOVE FORWARD :RowMove IN Sniffer;
>
> which worked correctly in 8.2.4 and previous versions, now fails to compile
> in 8.3beta1; I receive the following erro
"Dean" <[EMAIL PROTECTED]> writes:
> If I create a function which relies on the undefined_table exception to test
> if a table exists, it does not behave as expected.
Try issuing the DELETE via EXECUTE --- you're getting burnt by plan
caching.
But actually, do you really want something as destruc
> Try issuing the DELETE via EXECUTE --- you're getting burnt by plan>
> caching.>
Ah yes, that makes sense. So the planner is caching the failed query plan from
when the table didn't exist?
Not a bug after all I guess. Sorry.
I'm moving from an Oracle background, where dropping the table wou
ratq nomr <[EMAIL PROTECTED]> writes:
> I'm moving from an Oracle background, where dropping the table would
> have marked the function as invalid unless I had used EXECUTE
> IMMEDIATE, so I would have been less likely to make this mistake.
PG 8.3 will behave that way, but there's no support for i
