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

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

From
"Dave Page"
Date:

> ------- Original Message -------
> From: David Fetter <david@fetter.org>
> To: Simon Riggs <simon@2ndquadrant.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