On Wed, Mar 01, 2006 at 10:58:24AM -0700, Michael Fuhr wrote:
> On Wed, Mar 01, 2006 at 05:57:34PM +0100, Jaromr Kamler wrote:
> > I have table:
> > CREATE TABLE basic_metadata(name text,size text, ......);
> >
> > Inside I want insert some records (name of new table, size of new table and etc.), so I created trigger on the
tablegeometry_columns:
> > CREATE TRIGGER ins_metdta AFTER INSERT ON geometry_columns FOR EACH ROW EXECUTE PROCEDURE insert_new();
>
> Non-PostGIS users might not understand what you're doing here. To
> add a PostGIS geometry column to a table you call the AddGeometryColumn
> function, which among other things inserts a record into geometry_columns.
> It looks like you want that insert to trigger additional bookkeeping.
What's the purpose of the basic_metadata table? Could you use a
view instead?
--
Michael Fuhr