Re: pgsql: If an index depends on no columns of itstab le, give it a

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "David Fetter" <david(at)fetter(dot)org>
Cc: "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: If an index depends on no columns of itstab le, give it a
Date: 2007-11-10 21:37:43
Message-ID: 200711102137430000@851319467
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

> ------- Original Message -------
> From: David Fetter <david(at)fetter(dot)org>
> To: Simon Riggs <simon(at)2ndquadrant(dot)com>
> Sent: 10/11/07, 20:40:15
> Subject: Re: [COMMITTERS] pgsql: If an index depends on no columns of itstable, give it a
>
> > If I invented zero-column tables
>
> You don't have to.
>
> CREATE TABLE foo();
>
> already works. As I understand it, this is there to allow people to
> rearrange tables completely--drop all the columns and replace them,
> for example--and not have that fail.

Or create an empty table that just inherits others.

/D

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2007-11-10 21:48:51 pgsql: Add pg_ctl -t/timeout parameter to control amount of time to wait
Previous Message David Fetter 2007-11-10 20:40:15 Re: pgsql: If an index depends on no columns of its table, give it a