The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
18 views

Aggregate functions not allowed in trigger

I need help with a postgres/postgis trigger. I have a table of retaining walls, each of which is associated with the adjacent road, except where the wall abuts a junction, where it will be split and ...
1
vote
2answers
71 views

How to setup a SQL trigger in CartoDB

I need to setup 2 SQL triggers in CartoDB that will update my inland and coastal tables each time my obs table is updated. I have never setup a SQL trigger but I have looked at the documentation and ...
2
votes
1answer
35 views

How can a column in a feature class be automatically updated as soon as another column is changed?

I have a feature class in a file geodatabase and it contains a field called [curing] in short integer type and another field called [IsPopulated] in short integer as well. What I want to achieve is ...
0
votes
1answer
32 views

PostgreSQL Trigger on inherited tables [closed]

In my PostgreSQL I have a parent table and a number of child tables (inherited from the parent table). How to create a trigger which will be bind to all the current and future child tables derived ...
2
votes
0answers
63 views

How to simulate events from Openlayers 2?

I am working on a GIS API that uses OpenLayers. I am testing it using QUnit. The problem is I need to simulate clicks and trigger some events to be able to test the whole code. For example, I have a ...
0
votes
0answers
59 views

Add primary key to all tables in PostgreSQL automatically

I have a database with 10 schema and every schema has 10 tables which could be points, lines, etc.). I have created a folder called data and sub-folder with the same name of schema.. I use FME to ...
1
vote
0answers
66 views

Spatialite android trigger problem

I am developing an android application that uses the database spatialite, I use this project to integrate the database on android https://code.google.com/p/spatialite-android/ It works normally, ...
2
votes
1answer
193 views

plpgsql | before update trigger: insert the new pseudo-record in another record and leave the old one as it was

I've got the following table: CREATE TABLE alumbrado_puntos_luz ( id numeric(8,0), "GEOMETRY" geometry, revision_actual numeric(10,0), revision_expirada numeric(10,0), CONSTRAINT ...
1
vote
1answer
940 views

Postgresql Trigger to insert records in my table from another one

I spent few days trying to resolve this question but it was impossible. I have two tables: Table1. CREATE TABLE point ( id_point integer NOT NULL DEFAULT, layer text, elevation numeric, ...
2
votes
2answers
107 views

How to hand over polygon attribute to new point while digitizing?

My task is to work with bird observation data in an area, that is divided into zones as different polygons (A1, A2, etc.). I have the hand-written lists of observations and want to bring all entries ...
1
vote
2answers
591 views

Trigger to fill attributes (data, client ip) in table for each new objects, PostGIS

In PostgreSQL/PostGIS database stores shapefiles. Client users software - QGIS. Please help me write PostgreSQL/PostGIS trigger, which for each newly added/updated feature in layer added 'time create' ...
3
votes
1answer
177 views

PostGIS Trigger doesn't work

The trigger below don't works and I need that when a new pipeline (adutoras) is inserted or updated, the procedure check what are the municipalities (municipios) that intersects the pipes and put the ...
0
votes
1answer
152 views

Trigger on link length and filling attribute table

I create linear geometry in QGIS 1.8.0 (geometry stored in PostGIS 2.0). Help create trigger functions: in database should not be a lines less than 2 meters (linear geometry with length <2 meters ...
3
votes
1answer
232 views

Using multiversion view trigger to maintain unique ID in ArcSDE for Oracle?

I'm trying to identify the best way to automatically maintain a unique id column in Oracle ArcSDE. I don't want to use a class extension, since I've multiple third party users of the data and it's ...