Re: [GENERAL] How to have a blind-superuser

2006-04-24 Thread Orion
Qingqing Zhou wrote: >Basically I wonder if I can have a superuer that he has every priviliges as >he does now (create language, rotate log files, create checkpoint and >everything superuser can do) but one thing I want to make sure is that he >could not see any user data for security reason (just

[GENERAL] primary keys

2006-04-19 Thread Orion Henry
OR attnum = indkey[2]) AND relname = '$table'; Orion ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] locating a primary key

2006-04-19 Thread Orion
g_class ON (indrelid = pg_class.oid) JOIN pg_attribute ON (attrelid = pg_class.oid) WHERE indisprimary IS TRUE AND (attnum = indkey[0] OR attnum = indkey[1] OR attnum = indkey[2]) AND relname = '$table'; Orion ---(end of broadcast)--- T

[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