From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Jaromír Kamler <kamler(at)centrum(dot)cz> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: delay of function |
Date: | 2006-03-01 18:37:01 |
Message-ID: | 20060301183701.GA81594@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 table geometry_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
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2006-03-01 18:41:59 | Re: Alternative to MS Access Last() function |
Previous Message | Jaromír Kamler | 2006-03-01 18:33:54 | Re: delay of function |