Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 668691337B71 for ; Mon, 3 Jan 2011 13:29:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 16411-06 for ; Mon, 3 Jan 2011 17:29:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f42.google.com (mail-ww0-f42.google.com [74.125.82.42]) by mail.postgresql.org (Postfix) with ESMTP id 5A8601337B6E for ; Mon, 3 Jan 2011 13:29:09 -0400 (AST) Received: by wwi17 with SMTP id 17so14036910wwi.1 for ; Mon, 03 Jan 2011 09:29:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=91Bhq5XNWeto34toLf9CyvZvJHFqTMFiA097nWrp/Tc=; b=rfh0aGhtkv6lJY9V4UYEB/WoCfD/xoE5LShyq13+IVMjA+2IJo3VJW0SJX2VIcyhXe 7U7fAu3RbfD6w4AlrHP9NuE/QAKTquOLgckRsVskIYEqXbhk5671FMb8R+IBBV2P6UtB 2ZBOz7DCsSVjkP2O894u1Hykc3I6BPRzuwkt0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=k3x162SWza74DWgMwVGlIKCaIAaMjKuQGYI3EpigQoKAcQ4iYv+s2KDkRsc/Sp84s4 WxwUgfcl9U9t/R3RFqNihbatNw7KX9SrYZ3UBwWSZBLi+rpycLgjIrry9wbg41hi1TJ7 IY0QsghhDEKs4/KjKD0WG7ND+ysrRwRBLhpeM= MIME-Version: 1.0 Received: by 10.216.48.197 with SMTP id v47mr23417423web.82.1294075747931; Mon, 03 Jan 2011 09:29:07 -0800 (PST) Received: by 10.216.18.13 with HTTP; Mon, 3 Jan 2011 09:29:07 -0800 (PST) In-Reply-To: <1294037730835-3325407.post@n5.nabble.com> References: <1294037730835-3325407.post@n5.nabble.com> Date: Mon, 3 Jan 2011 09:29:07 -0800 Message-ID: Subject: Re: Greenplum: Functions that execute SQL statements from the segDBs are not yet supported. From: bricklen To: kirancnair Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201101/10 X-Sequence-Number: 36450 On Sun, Jan 2, 2011 at 10:55 PM, kirancnair 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