Re: [HACKERS] DDL triggers [was Re: [GENERAL] database constraints]

2004-10-07 Thread Gavin Sherry
On Thu, 7 Oct 2004, David Fetter wrote: > On Thu, Oct 07, 2004 at 11:47:55AM +0700, David Garamond wrote: > > Joshua D. Drake wrote: > > >>This brings up an interesting idea. What if it were possible to set > > >>some kind of rules on DDL at database creation time? For example, I'd > > >>like to

Re: [HACKERS] DDL triggers [was Re: [GENERAL] database constraints]

2004-10-07 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> 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,

[HACKERS] DDL triggers [was Re: [GENERAL] database constraints]

2004-10-07 Thread David Fetter
On Thu, Oct 07, 2004 at 11:47:55AM +0700, David Garamond wrote: > Joshua D. Drake wrote: > >>This brings up an interesting idea. What if it were possible to set > >>some kind of rules on DDL at database creation time? For example, I'd > >>like to be able to throw an error if somebody tries to nam