Re: enforce naming convention - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: enforce naming convention
Date
Msg-id 20060417144225.GB19191@svana.org
Whole thread Raw
In response to Re: enforce naming convention  ("SunWuKung" <Balazs.Klein@t-online.hu>)
List pgsql-general
On Mon, Apr 17, 2006 at 07:26:24AM -0700, SunWuKung wrote:
> This may be totally wronb, but what about writing a Before Insert
> trigger on the pg_catalog.pg_class table checking if there is already a
> table with that name and if yes prevent the insert?
> Is there something against doing so?

Yes, triggers don't work on system catalogs.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: "SunWuKung"
Date:
Subject: Re: enforce naming convention
Next
From: Jan Wieck
Date:
Subject: Re: [Slony1-general] Is a high tab_reloid worrying?