Re: delay of function - Mailing list pgsql-novice

From Jaromír Kamler
Subject Re: delay of function
Date
Msg-id 200603012244.12427@centrum.cz
Whole thread Raw
In response to Re: delay of function  (Michael Fuhr <mike@fuhr.org>)
Responses Re: delay of function  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
>Could you provide a high-level explanation of the problem you're
>trying to solve? The "what" instead of the "how."

I am trying to build data storage for spatial data. Users can export or import inside the storage their spatial data
andother users can viewed that data on their PC's by some software (GRASS, QGIS, ...). But in that data storage may be
manyof tables (spatial layers) and nobody will watching all of them (different projection, accurancy, extend-maximal
valueof north, east and minimal value of south and west). There must by table with basic informations about all tables
indata storage. So that, when someone import any spatial table, some function must write this basic informations inside
tablebasic_metadata. I was trying do this by trigger, like you see, but it looks like bad way, becouse function
AddGeomColl()firstly insert record in geometry_columns (i fire my wrong trigger) and after that is created table. I
mustfire some function after insert all records in new table, but I don't know how. Any ideas? 


Thanks,
Jaromír Kamler


pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: delay of function
Next
From:
Date:
Subject: Re: install