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

Re: COPY and default values

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: COPY and default values
Date: 2002-05-28 00:22:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
On Mon, 27 May 2002 19:28:30 -0400
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> This has been hashed out in several prior threads, and in fact I think
> Brent Verner has a nearly-ready-to-go patch implementing the agreed-on
> behavior.  Now that I think about it, your patch is heading off in a
> quite different direction from what was agreed to: we were never
> intending that omitting trailing fields would be the cue for inserting
> default values.  Without a way to specify a target column list, that's
> far too restrictive; and with it, it's unnecessary.

Ok, sounds fair. I think my patch is an improvement over the current
behavior (if you're going to silently insert arbitrary data for
missing attributes, I'd say the default value is a better choice
than NULL), but I would agree that this kind of behavior as a whole
is not optimal. Assuming that the patch from Brent materializes, I'll
be happy to take his solution over mine.



Neil Conway <neilconway(at)rogers(dot)com>

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2002-05-28 02:39:04
Subject: Re: COPY and default values
Previous:From: Tom LaneDate: 2002-05-27 23:51:22
Subject: Re: SSL (patch 5)

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