From: | kirancnair <kirncha(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Greenplum: Functions that execute SQL statements from the segDBs are not yet supported. |
Date: | 2011-01-03 06:55:30 |
Message-ID: | 1294037730835-3325407.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I get this error when I try to call a function from an Insert Trigger set on
one of my tables in the SNE GP Edition:
ERROR: Functions that execute SQL statements from the segDBs are not yet
supported (spi.c:203) (seg0 localhost:50001 pid=5504)
DETAIL:
SQL statement "SELECT DISTINCT min(zasn) FROM zeusasn WHERE zasn IN
(SELECT asn FROM asntable where ip >>= '10.29.249.121')"
PL/pgSQL function "eptriggerfn" line 5 at SQL statement
********** Error **********
ERROR: Functions that execute SQL statements from the segDBs are not yet
supported (spi.c:203) (seg0 localhost:50001 pid=5504)
SQL state: XX000
Detail:
SQL statement "SELECT DISTINCT min(zasn) FROM zeusasn WHERE zasn IN
(SELECT asn FROM asntable where ip >>= '10.29.249.121')"
PL/pgSQL function "eptriggerfn" line 5 at SQL statement
What can be the cause of this? Triggers + functions are working perfectly
fine with another table in the same DB.
Thanks in advance!
Rgds, Kiran
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Greenplum-Functions-that-execute-SQL-statements-from-the-segDBs-are-not-yet-supported-tp3325407p3325407.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | sharilalipv | 2011-01-03 06:57:42 | hanging query |
Previous Message | Ian Lea | 2010-12-31 09:10:53 | Re: syntax error at or near ";" at character 41 |