Re: Quick Help - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Quick Help
Date
Msg-id 1039134028.72042.8.camel@jester
Whole thread Raw
In response to Quick Help  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
It works very similarly to the way that ALTER TABLE ... ADD CHECK ..
works, with the tuple update added in.

Anyway, it's something like the below:

- Lock relation
- Pull out tuple
- Evaluate cooked default expression using EvalExpr
- heap_modifytuple (shove datum that EvalExpr returns into column)
- simple_heapupdate
- Goto step 2 (pull out next tuple)



On Thu, 2002-12-05 at 16:24, Christopher Kings-Lynne wrote:
> Hi guys,
>
> Messing about with ADD COLUMN...
>
> I'm not certain how to re-evaluate the default expression for each row?  How
> do I do this?  I have access to raw_default and cooked_default it seems.
>
> Thanks,
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: [GENERAL] PostgreSQL Global Development Group
Next
From: Justin Clift
Date:
Subject: Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster