From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | priyeshkaratha(at)gmail(dot)com |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14154: In pgpool while using delete query inside postgresql function , it is not deletingdata from all serve |
Date: | 2016-05-23 15:31:17 |
Message-ID: | CAKFQuwZxxy86xo=SLxad7H3z8d4Brn=RNw-CKXqVjU1KMpWP6A@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, May 23, 2016 at 9:29 AM, <priyeshkaratha(at)gmail(dot)com> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14154
> Logged by: Priyesh Karatha
> Email address: priyeshkaratha(at)gmail(dot)com
> PostgreSQL version: 9.4.0
> Operating system: Ubuntu14
> Description:
>
>
> I have created following function in pgpool .
>
> CREATE OR REPLACE Function fun1(Id int)
> RETURNS boolean as $executionStatus$
> DECLARE
>
> BEGIN
> DELETE FROM table1 where table1_id = Id ;
> DELETE from table2 where table2_id = Id ;
> DELETE from table3 where table3_id = Id ;
> RETURN true;
> END;
> $executionStatus$ LANGUAGE plpgsql;
> I run following command inside the postgres shell of pgpool
>
> select fun1(1);
> It is deleted the data only from master. I tried again then it is deleted
> from different server.So replication fails in this case. But if i use
> delete
> queries separately then it is working fine.It is deleting data from all
> servers.
>
> DELETE FROM table1 where table1_id = 1 ;DELETE from table2 where table2_id
> = 1 ;DELETE from table3 where table3_id = 1 ;
> Please let me know how to fix this issue .
This is not a PostgreSQL bug. Its likely not even a bug.
Please direct you question to the appropriate forum.
The following seems likely to be of help in determining where that may be:
http://www.pgpool.net/mediawiki/index.php/Mailing_lists
However, unless pgpool is doing something really unusual, the transaction
that you establish by using a function is likely disabling the very pooling
behavior you are attempting to use.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2016-05-23 16:44:19 | Re: BUG #14138: Inconsistent rounding behavior in float4 coercion |
Previous Message | David G. Johnston | 2016-05-23 15:17:09 | Re: please help me |