Re: dblink_build_sql_update versus dropped columns

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: dblink_build_sql_update versus dropped columns
Date: 2010-06-14 18:47:26
Message-ID: 4C16793E.9020300@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 06/14/2010 11:21 AM, Tom Lane wrote:
> Actually, I was working on it myself. On further reflection I think
> that logical numbers are clearly the right thing --- if we define it
> as being physical numbers then we will have headaches in the future
> when/if we support rearranging columns. However, there is some small
> chance of breaking things in existing DBs if we back-patch that change.
> Thoughts?

I didn't even think people were using those functions for many years
since I never heard any complaints. I'd say better to not backpatch
changes to logical ordering, but FWIW the attached at least fixes the
immediate bug in head and ought to work at least a few branches.

> It strikes me also that the code is not nearly careful enough about
> defending itself against garbage input in the primary_key_attnums
> argument ...

Probably not :-(

Joe

Attachment Content-Type Size
dblink.2010.06.14.01.diff text/x-patch 6.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2010-06-14 18:48:24 Re: Typo in plperl doc ?
Previous Message Magnus Hagander 2010-06-14 18:35:06 Re: warning message in standby