pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedGreenplum: Functions that execute SQL statements from the segDBs are not yet supported.
3+ messages / 3 participants
[nested] [flat]
* Greenplum: Functions that execute SQL statements from the segDBs are not yet supported.
@ 2011-01-03 06:55 kirancnair <kirncha@gmail.com>
2011-01-03 17:18 ` Re: Greenplum: Functions that execute SQL statements from the segDBs are not yet supported. Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-01-03 17:29 ` Re: Greenplum: Functions that execute SQL statements from the segDBs are not yet supported. bricklen <bricklen@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: kirancnair @ 2011-01-03 06:55 UTC (permalink / raw)
To: 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-seg...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Greenplum: Functions that execute SQL statements from the segDBs are not yet supported.
2011-01-03 06:55 Greenplum: Functions that execute SQL statements from the segDBs are not yet supported. kirancnair <kirncha@gmail.com>
@ 2011-01-03 17:18 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2011-01-03 17:18 UTC (permalink / raw)
To: kirancnair <kirncha@gmail.com>; pgsql-admin
kirancnair <kirncha@gmail.com> wrote:
> segDBs
The community version of PostgreSQL does not have segDBs. You
should probably contact Greenplum.
-Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Greenplum: Functions that execute SQL statements from the segDBs are not yet supported.
2011-01-03 06:55 Greenplum: Functions that execute SQL statements from the segDBs are not yet supported. kirancnair <kirncha@gmail.com>
@ 2011-01-03 17:29 ` bricklen <bricklen@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: bricklen @ 2011-01-03 17:29 UTC (permalink / raw)
To: kirancnair <kirncha@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-01-03 17:29 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-01-03 06:55 Greenplum: Functions that execute SQL statements from the segDBs are not yet supported. kirancnair <kirncha@gmail.com>
2011-01-03 17:18 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-01-03 17:29 ` bricklen <bricklen@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox