Thread: Greenplum: Functions that execute SQL statements from the segDBs are not yet supported.

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.

kirancnair <kirncha@gmail.com> wrote:

> segDBs

The community version of PostgreSQL does not have segDBs.  You
should probably contact Greenplum.

-Kevin

On Sun, Jan 2, 2011 at 10:55 PM, kirancnair <kirncha@gmail.com> wrote:
>
> 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:
>
...
> 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

If you don't have a support contract with GP, then you can try getting
help from here: http://community.greenplum.com/index.php