TED]>
To: "pgsql-hackers" <[EMAIL PROTECTED]>
Sent: Saturday, October 06, 2001 7:49 PM
Subject: Re: [HACKERS] ALTER RENAME and indexes
> On 05 Oct 2001 at 10:18 (-0400), Brent Verner wrote:
> | On 05 Oct 2001 at 09:46 (-0400), Tom Lane wrote:
> | | Brent Verner <[EMA
On 07 Oct 2001 at 04:03 (-0700), Stephan Szabo wrote:
|
| On Sat, 6 Oct 2001, Brent Verner wrote:
|
| > On 06 Oct 2001 at 20:13 (-0400), Rod Taylor wrote:
| > | Of course, in 7.1 foreign key constraints become rather confused when
| > | you rename columns on them.
| > 1) modify this tgargs val
On Sat, 6 Oct 2001, Brent Verner wrote:
> On 06 Oct 2001 at 20:13 (-0400), Rod Taylor wrote:
> | Of course, in 7.1 foreign key constraints become rather confused when
> | you rename columns on them.
> |
> | create table parent (id serial);
> | create table child (id int4 references parent(id) o
On 06 Oct 2001 at 20:13 (-0400), Rod Taylor wrote:
| Of course, in 7.1 foreign key constraints become rather confused when
| you rename columns on them.
|
| create table parent (id serial);
| create table child (id int4 references parent(id) on update cascade);
| alter table parent rename column
On 05 Oct 2001 at 10:18 (-0400), Brent Verner wrote:
| On 05 Oct 2001 at 09:46 (-0400), Tom Lane wrote:
| | Brent Verner <[EMAIL PROTECTED]> writes:
| | > 'ALTER TABLE tbl RENAME col1 TO col2' does not update any indices that
| | > reference the old column name.
| |
| | It doesn't need to; the in
On 05 Oct 2001 at 09:46 (-0400), Tom Lane wrote:
| Brent Verner <[EMAIL PROTECTED]> writes:
| > 'ALTER TABLE tbl RENAME col1 TO col2' does not update any indices that
| > reference the old column name.
|
| It doesn't need to; the indexes link to column numbers, not column
| names.
Forgive my inc
Brent Verner <[EMAIL PROTECTED]> writes:
> 'ALTER TABLE tbl RENAME col1 TO col2' does not update any indices that
> reference the old column name.
It doesn't need to; the indexes link to column numbers, not column
names.
regards, tom lane
---(end
