[Postgres-xl-developers] Fw:about Postgres-XL does not support DML queries in PL/pgSQL

Koichi Suzuki koichi.dbms at gmail.com
Wed Sep 17 21:59:37 PDT 2014


Yes, your observation is correct.    In XL (and in XC as well), only
one DML may be allowed.    We need to support SAVEPOINT and
surrounding features to allow DMLs in plpgsql.
---
Koichi Suzuki


2014-09-17 23:56 GMT+09:00 bryain <pgdevuser at 163.com>:
> just do a test,the same function can be used in postgresql but not in PG-XL.
>
>
> -------- Forwarding messages --------
> From: "bryain" <pgdevuser at 163.com>
> Date: 2014-09-17 10:38:40
> To: "postgres-xl-developers at lists.sourceforge.net"
> <postgres-xl-developers at lists.sourceforge.net>
> Subject: about Postgres-XL does not support DML queries in PL/pgSQL
>
> Hi all,
> I want to create a function contains the update operation,an error occured
> when calling this function.
> "ERROR:  Postgres-XL does not support DML queries in PL/pgSQL"
>
> Is the XL version does not support,or is there any other way to use the
> update operation in  PL/pgSQL function?
> thanks!
>
> Regards,
> bryain
>
>
>
>
>
> ------------------------------------------------------------------------------
> Want excitement?
> Manually upgrade your production database.
> When you want reliability, choose Perforce
> Perforce version control. Predictably reliable.
> http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xl-developers mailing list
> Postgres-xl-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-developers
>




More information about the Postgres-xl-developers mailing list