Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2079: strage PREPARE/EXECUTE behavior - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2079: strage PREPARE/EXECUTE behavior
Date
Msg-id 29541.1133374355@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2079: strage PREPARE/EXECUTE behavior  ("Yuriy Vostrikoff" <mon@lcpi.ru>)
List pgsql-bugs
Tree view 
"Yuriy Vostrikoff" <mon@lcpi.ru> writes:
> EXECUTE return wrong result after ALTER TABLE ALTER COLUMN TYPE. Is this
> expected behavior?

The prepared plan really should be invalidated by the ALTER, but we
don't currently have any infrastructure that would allow that to happen.
I think Neil Conway is looking into it for 8.2, though.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2078: lock freeing problem in transaction (?)
Next
From: Dirk Lutzebäck
Date:
Subject: Re: pg_dump: schema with OID 559701082 does not exist