| 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>, David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Ben <bench(at)silentmedia(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DDL triggers [was Re: database constraints] |
| Date: | 2004-10-07 20:43:53 |
| Message-ID: | 23610.1097181833@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
David Fetter <david(at)fetter(dot)org> writes:
> How big a project would it be to have generalized DDL triggers? Apart
> from resource allocation, what are some downsides of providing such a
> facility?
BEFORE triggers on the system catalogs are Right Out. In principle we
could support AFTER triggers, which would only fire after the catalog
operation is fully complete (but before it's committed of course). So
you could have a veto, but not really affect the system behavior
on-the-fly. See past discussions in the pghackers archives.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Bitner | 2004-10-07 21:07:08 | regular expression searches |
| Previous Message | Steven Klassen | 2004-10-07 20:43:49 | Re: Question about timezones |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-10-07 20:46:35 | Re: [HACKERS] Call for BOFs Linux World Expo Boston |
| Previous Message | Reini Urban | 2004-10-07 20:41:04 | Re: plans for bitmap indexes? |