From: | Rod Taylor <rbt(at)rbt(dot)ca> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Problems with renaming a column |
Date: | 2003-06-05 15:11:24 |
Message-ID: | 1054825883.7579.3.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 2003-06-04 at 22:28, Christopher Kings-Lynne wrote:
> > Which ones are missing, and should we really be looking at creating a
> > pg_definition_schema instead?
>
> Missing:
>
> Database, schema, table, domain, cast, conversion, function...
>
> Maybe a definition schema might be better.....dunno...it would need to use
> the pg_get_*def functions anyway methinks.
As an interface writer, do you prefer dealing with functions like
pg_get_constraintdef() or a view like the information schema provides?
The function doesn't easily allow determination of items such as the ON
UPDATE or ON DELETE type (statement parsing is required), but the
information schema gives the information in a segregated manner.
The pg_get_*def() functions seem to have been created primarily for psql
and pg_dump.
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-06-05 15:13:15 | Re: Aggregates containing outer references don't work per |
Previous Message | Rasmus Resen Amossen | 2003-06-05 14:24:24 | Re: Broken RR? |