Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group