Re: Immodest Proposal: pg_catalog.pg_ddl - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Immodest Proposal: pg_catalog.pg_ddl
Date
Msg-id 12672.1134534800@sss.pgh.pa.us
Whole thread Raw
In response to Immodest Proposal: pg_catalog.pg_ddl  (David Fetter <david@fetter.org>)
Responses Re: Immodest Proposal: pg_catalog.pg_ddl
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> The idea is to make a new table in pg_catalog called pg_ddl.

This seems rather poorly thought out --- I can't even tell whether your
intention is to make a log of past operations, or to provide a uniform
way to extract the current definition of every object.  If the latter,
recording text won't do it.  If the former, the notion that all DDL can
be uniquely keyed to one object OID is bogus, and I don't even see the
argument for doing it via a table rather than via the postmaster log.
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Immodest Proposal: pg_catalog.pg_ddl
Next
From: David Fetter
Date:
Subject: Re: Immodest Proposal: pg_catalog.pg_ddl