Re: bug in prepared statements, alter table <8.3 - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: bug in prepared statements, alter table <8.3
Date
Msg-id 87fxpgl9tf.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to bug in prepared statements, alter table <8.3  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: bug in prepared statements, alter table <8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>>>> "Merlin" == "Merlin Moncure" <mmoncure@gmail.com> writes:
Merlin> postgres=# alter table abc alter a type numeric;Merlin> ALTER TABLEMerlin> Time: 254.847 msMerlin> postgres=#
EXECUTEins_abc;Merlin> INSERT 0 1Merlin> Time: 0.452 msMerlin> postgres=# select * from abc;Merlin> ERROR:  invalid
memoryalloc request size 18446744073709551610
 
Merlin> :-)
Merlin> h/t to rhodium toad.

This is fairly obviously a simple consequence of the lack of plan
invalidation, it just happens to be more serious than most (you can,
as a normal user, break the backend in a dozen different ways, from
bad data or incomprehensible error messages up through SEGVs).

-- 
Andrew (irc:RhodiumToad)


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: patch: Add columns via CREATE OR REPLACE VIEW
Next
From: Tom Lane
Date:
Subject: Re: patch: Add columns via CREATE OR REPLACE VIEW