| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Quick Help |
| Date: | 2002-12-06 00:20:29 |
| Message-ID: | 1039134028.72042.8.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-12-06 00:34:21 | Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster |
| Previous Message | mlw | 2002-12-05 23:40:42 | Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster |