Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
Date
Msg-id 199905111604.MAA18158@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
List pgsql-hackers
> On Mon, 10 May 1999, Bruce Momjian wrote:
> 
> > Date: Mon, 10 May 1999 12:48:15 -0400 (EDT)
> > From: Bruce Momjian <maillist@candle.pha.pa.us>
> > To: Tom Lane <tgl@sss.pgh.pa.us>
> > Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> > Subject: Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604
> > 
> > 
> > Is this a valid item?
> > 
> 
> After compilation of current cvs at home I test this and it works.
> But explain shows that select will not use indices, which exists !
> select station_id from metro_stations except select  metro_id from work_flats;

Indexes aren't much use if you don't have a WHERE restriction, no?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] SERIAL + PRIMARY KEY = redundant indexes
Next
From: reedstrm@wallace.ece.rice.edu (Ross J. Reedstrom)
Date:
Subject: Re: [INTERFACES] Bug in psql?