[GENERAL] primary keys

2006-04-19 Thread Orion Henry
I'm trying to craft a query that will determine what column(s) are the primary key for a given table. I have succeeded but the query is so ugly that it borders on silly and cannot work for an arbitrary number of tables since indkey is an int2vect and the ANY keyword does not work on it. Ple

[GENERAL] Re: Fast Inserts and Hardware Questions

2001-03-14 Thread Orion Henry
Richard H wrote: > > On 3/14/01, 7:08:48 PM, Orion Henry <[EMAIL PROTECTED]> wrote > regarding [GENERAL] Fast Inserts and Hardware Questions: > > Please bear in mind that you are operating well above anything I do, so > I'm not speaking from experience. I ap

[GENERAL] Re: Fast Inserts and Hardware Questions

2001-03-14 Thread Orion Henry
Peter Eisentraut wrote: > > Orion Henry writes: > > > The indexes will be > > int8 (primary key) > > int4 (group number) > > timestamp (creation date) > > int4 (customer id) > > Since one query can only use one index per table, you should only ne