Skip site navigation (1) Skip section navigation (2)

Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>, Jasen Betts <jasen(at)treshna(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can
Date: 2007-06-22 20:25:55
Message-ID: 26172.1182543955@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Heikki Linnakangas <heikki(at)enterprisedb(dot)com> writes:
> Tom Lane wrote:
>> IOW, we don't actually *know* at parse analysis time which table will be
>> affected.

> I don't understand that. Why would the execution be delayed to a future 
> transaction? You can't PREPARE an ALTER TABLE, right?

Yeah, you can.  Consider plpgsql, or protocol-level Bind.  The fact that
we don't expose these facilities as SQL doesn't mean they're not there.
A cached statement in plpgsql is actually the main case I'm worried
about...

>> Maybe we should give up doing any CREATE/ALTER processing at all at
>> parse analysis time, and push it all to execution time.

> We'll still need something smaller to back patch, I think. :(

At this point I don't think we'll try to fix this in the back branches.
It's never really worked, so I don't see 8.2's behavior as a regression,
and I don't see a small fix that doesn't create issues of its own.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-06-22 20:36:40
Subject: Re: BUG #3404: Mix ORDER BY ASC With DESC
Previous:From: Heikki LinnakangasDate: 2007-06-22 19:40:55
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group