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
OR attnum = indkey[2])
AND relname = '$table';
Orion
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
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
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