Access, pass-through queries and isolation level - Mailing list pgsql-odbc

From Philippe Lang
Subject Access, pass-through queries and isolation level
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F420AF72F@poweredge.attiksystem.ch
Whole thread Raw
Responses Re: Access, pass-through queries and isolation level
List pgsql-odbc
Hello,

I'm not sure if this problem is related to ODBC or Access...

Imagine we have the following function: (Note: I know about the serial type, this is juste for illustration purpose...)

----------------------------------

CREATE OR REPLACE FUNCTION public.func_test_insert() RETURNS int8 AS
'
DECLARE
   next_id   int8;
BEGIN

   next_id = max(func_test_data.id)+1;
   insert into public."func_test_data" values(next_id);

   RETURN next_id;
END;
'
  LANGUAGE 'plpgsql' VOLATILE;

----------------------------------


pgsql-odbc by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: bug in EN_set_odbc3 macro
Next
From: Jeff Eckermann
Date:
Subject: Re: Access, pass-through queries and isolation level