On 2013-04-26, Michael Graham wrote:
> Hi all,
>
> I'm trying to create a table that contains only valid table names.
could you get by with a view off pg_catalog.pg_tables or
information_schema.tables
--
⚂⚃ 100% natural
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Regards
From: Richard Huxton
To: Michael Graham
Cc: "pgsql-general@postgresql.org"
Sent: Friday, April 26, 2013 5:21 PM
Subject: Re: [GENERAL] Table containing only valid table names
On 26/04/13 16:09, Michael Graham wrote:
> I'm pretty sure
On 26/04/13 16:09, Michael Graham wrote:
I'm pretty sure I can't do what I need as postgres doesn't support
triggers on DDL but maybe I'm wrong.
If you're still in development and not live, it'll be worth checking out 9.3
http://www.postgresql.org/docs/devel/static/event-triggers.html
--
R
Hi all,
I'm trying to create a table that contains only valid table names. I'm
currently using reglass for the field type which works fine for when you
are adding to the table (i.e. you can't add invalid tablesnames to the
table). But it is still possible to leave the table in an invalid sta
