Tom,
Thanks for the update on this query. I'm not positive where I found this
query, but I'm pretty sure it was for a v6.5x something. Anyway, thanks.
phpPgAdmin has been updated.
-Dan
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Dan Wilson" <[EMAIL PROTECTED]>
Cc: <
"Willis, Ian (Ento, Canberra)" <[EMAIL PROTECTED]> writes:
> Does anyone know what the status of external large objects is?
Not sure what you consider an "external" large object is. 7.0.* has
a few remnants of what apparently used to be support for three or four
kinds of large objects, but the c
Does anyone know what the status of external large objects is?
Did they disappear without a trace and will they ever make a comeback? I was
reading about Xdelta the other night and I thought that postgresql would be
a great interface for this sort of program if it still supported the
interface.
"Dan Wilson" <[EMAIL PROTECTED]> writes:
> Here is the query from phpPgAdmin that does what you are asking for:
> SELECT
>...
>and
>(
> i.indkey[0] = a.attnum
> or
> i.indkey[1] = a.attnum
> or
> i.indkey[2] = a.attnum
> or
> i.indkey[3] = a.attnum
>
Here is the query from phpPgAdmin that does what you are asking for:
SELECT
ic.relname AS index_name,
bc.relname AS tab_name,
a.attname AS column_name,
i.indisunique AS unique_key,
i.indisprimary AS primary_key
FROM
pg_class bc,
pg_class ic,
pg_index i,
pg_attribute
Hi,
Thankyou for your help with pg_trigger :)
I am trying to list the indexes for a table. So far I've come up with this SQL
query:
SELECT bc.relname AS TABLE_NAME,
a.attname AS COLUMN_NAME,
a.attnum as KEY_SEQ,
ic.relname as PK_NAME
FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a
WH
Is there a reason why _any_ user can create a table on a database? Even if
they do not own or have any permissions to it?
I don't think that should happen. Is there a specific reason why it does?
-Dan Wilson
Steve Ackerman writes:
> Has the row limit setting been moved in 7.0.3?
No
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
