Re: Immodest Proposal: pg_catalog.pg_ddl

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Immodest Proposal: pg_catalog.pg_ddl
Date: 2005-12-14 04:33:20
Message-ID: 12672.1134534800@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Fetter <david(at)fetter(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2005-12-14 04:43:10 Re: Immodest Proposal: pg_catalog.pg_ddl
Previous Message Premsun Choltanwanich 2005-12-14 03:58:34 Re: lo function changed in PostgreSQL 8.1.1