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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
