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,
I know that one of the main reasons why schemas are there is to make it
possible to use identical table names, but this time they want to use
it to separate tables purely because they feel they would find their
ways better that way. On the other hand I feel that this separation
will be somewhat arb
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Can I create a trigger that runs when a new object is created and see
> if its name is in an expected format and if not reject it?
Sounds like you need a database-wide trigger on DDL. PostgreSQL has nothing
like that at the moment. Your best bet
