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

Re: Insert ... (a, b, DEFAULT, c, d);

From: "Rod Taylor" <rbt(at)zort(dot)ca>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Insert ... (a, b, DEFAULT, c, d);
Date: 2002-03-31 03:22:39
Message-ID: 0da101c1d865$955b2700$8001a8c0@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
Added Copy and Equal nodes -- although InsertDefault doesn't actually
have any contents.

Opted for method b as transformTargetList is used in a number of other
places which are unaffected.  Making them work around the calling
conventions for a single place seemed silly.

Previously attached insert.out and insert.sql are the same.

Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rod Taylor" <rbt(at)zort(dot)ca>
Cc: <pgsql-patches(at)postgresql(dot)org>
Sent: Saturday, March 30, 2002 2:06 PM
Subject: Re: [PATCHES] Insert ... (a, b, DEFAULT, c, d);

> Rod Taylor <rbt(at)zort(dot)ca> writes:
> > Adds inserts with defaults.
> A few gripes about this ---
> * You can't simply invent a node type without creating any support
> for it.  See backend/nodes/.  copyfuncs and equalfuncs are
> functionality; infuncs/outfuncs are somewhat more negotiable.  For a
> node type that never gets past parse analysis it's okay to omit
> and you can get away with omitting outfuncs too.
> * I find it really ugly (not to say fragile) to overload resjunk
> this meaning.  The best solution would be to restructure the calling
> conventions for transformTargetList to fix the problem of not being
> to access all the lists that need to be updated.  Failing that, my
> inclination would be to pass back the unaltered InsertDefault node
> (instead of a Resdom) as part of transformTargetList's result list;
> an IsA test in transformInsertStmt would work to detect which
> are real.
> regards, tom lane
> ---------------------------(end of
> TIP 6: Have you searched our list archives?

Attachment: insert.patch
Description: application/octet-stream (9.6 KB)
Attachment: insert.out
Description: application/octet-stream (703 bytes)
Attachment: insert.sql
Description: application/octet-stream (487 bytes)

In response to


pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2002-03-31 05:35:00
Subject: Re: ALT*R T*BL* S*T / DR*P N*T N*LL patch - 4th try
Previous:From: Tom LaneDate: 2002-03-30 20:20:36
Subject: Re: ALT*R T*BL* S*T / DR*P N*T N*LL patch - 4th try

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