Re: ALTER TABLE RENAME column

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com>, "Jim Nasby" <decibel(at)decibel(dot)org>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER TABLE RENAME column
Date: 2006-11-17 15:48:33
Message-ID: 36e682920611170748m4116c876rb1a050a0beea4262@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/17/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> No, it should not, because that risks breaking other references to the
> sequence (eg, in user-written functions). If the user is feeling that
> he wants consistency, he can rename the sequence himself and take
> responsibility for any side-effects on his code.

I concur.

--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 2nd Floor | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-11-17 16:39:19 Re: [PATCHES] replication docs: split single vs.
Previous Message Tom Lane 2006-11-17 15:37:35 Re: ALTER TABLE RENAME column