Re: [Postgres-xc-general] consistency check on SPI tuple count failed & PL/pgsql

[Johan A. <joh...@up...>]

You can run EXECUTE statements and run cursors for fetching data.

Best Regards,
Johan Arve


________________________________________
Från: Thibault Marquand <thi...@ec...>
Skickat: den 20 juni 2014 10:25
Till: Masataka Saito
Kopia: Postgres-XC mailing list
Ämne: Re: [Postgres-xc-general] consistency check on SPI tuple count failed & PL/pgsql

Is there any way to work around with this ?
Like Execute statement or any thing else ?

Le 20/06/2014 03:49, Masataka Saito a écrit :
> Unfortunately it's a restriction.
>
> DML cannot be used in plpgsql functions.
>   * http://postgres-xc.sourceforge.net/docs/1_2/release-xc-1-2.html#AEN126656
>
> Regards.


------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general