Hi all,
Sorry for the late reply.
I could handle the pb by transforming my function check ( with an exception )
by a simple sql immutable function.
Function before
CREATE OR REPLACE FUNCTION test_id(ltree[])
RETURNS boolean AS
$BODY$
DECLARE
id public.ltree;
BEGIN
FOR id IN SELECT unnest($1) LOOP
Hi,
On 2018-07-01 11:02:24 +0200, Mai Peng wrote:
> Hello, how could I relax the subtransaction restriction, I used the
> Parallel Unsafe option, but still have the same issue.
> Rgds.
I'm unclear why you still get the error. Could you please give us the
query triggering the error, including an e
On Sun, Jul 1, 2018 at 5:02 AM, Mai Peng wrote:
> Hello, how could I relax the subtransaction restriction, I used the Parallel
> Unsafe option, but still have the same issue.
There's no user option for that. Somebody would need to enhance
PostgreSQL by writing a patch.
I agree with Andres that
Hello, how could I relax the subtransaction restriction, I used the
Parallel Unsafe option, but still have the same issue.
Rgds.
Le ven. 29 juin 2018 20:47, Andres Freund a écrit :
> Hi,
>
> On 2018-06-29 20:37:23 +0200, Tomas Vondra wrote:
> > My guess is that it's a PL/pgSQL function with an E
Hi,
On 2018-06-29 20:37:23 +0200, Tomas Vondra wrote:
> My guess is that it's a PL/pgSQL function with an EXCEPTION block, and
> there's no easy way to "fix" that.
Obviously not going to immediately help the OP, but I do think we should
be able to relax the subtransaction restriction around paral
On 06/29/2018 07:22 PM, Andres Freund wrote:
On 2018-06-29 16:50:47 +0200, Tomas Vondra wrote:
On 06/29/2018 04:00 PM, Mai Peng wrote:
Hello,
On a pG10.4 instance, my query ( a simple select from a view) throw this
error:
ERROR: cannot start subtransactions during a parallel operation
On 2018-06-29 16:50:47 +0200, Tomas Vondra wrote:
> On 06/29/2018 04:00 PM, Mai Peng wrote:
> > Hello,
> >
> > On a pG10.4 instance, my query ( a simple select from a view) throw this
> > error:
> > ERROR: cannot start subtransactions during a parallel operatio
On 06/29/2018 04:00 PM, Mai Peng wrote:
Hello,
On a pG10.4 instance, my query ( a simple select from a view) throw this
error:
ERROR: cannot start subtransactions during a parallel operation
CONTEXT: PL/pgSQL function check_validity(ltree[]) line 4 during
statement block entry
So, what
Hello,
On a pG10.4 instance, my query ( a simple select from a view) throw this error:
ERROR: cannot start subtransactions during a parallel operation
CONTEXT: PL/pgSQL function check_validity(ltree[]) line 4 during statement
block entry
But prefixing this query by &quo
