Thanks Tom et al,
I appreciate the explanation.
I am certainly more appreciative of what is going on behind the scenes now
when I see 'tuple concurrently updated' errors.
I couldn't initially find a way to grant select on all present *and
future*tables in a schema, which is why we took the approac
Adrian Klaver writes:
> On 02/27/2014 06:54 PM, Jason Daly wrote:
>> When I attempt to execute the non-query "GRANT SELECT ON TABLE
>> . TO ", I occasionally encounter an exception from
>> postgresql, 'tuple concurrently updated'.
> My guess this is covered here:
> http://rhaas.blogspot.com/2013/
On 02/27/2014 06:54 PM, Jason Daly wrote:
Hi,
When I attempt to execute the non-query "GRANT SELECT ON TABLE
. TO ", I occasionally encounter an exception from
postgresql, 'tuple concurrently updated'.
I think the tuple it is referring to is the role.
Our app is multi-threaded, and it is very p
Hi,
When I attempt to execute the non-query "GRANT SELECT ON TABLE
. TO ", I occasionally encounter an exception from
postgresql, 'tuple concurrently updated'.
I think the tuple it is referring to is the role.
Our app is multi-threaded, and it is very possible for more than one thread
to be attem
That's a bit interesting ... what PG version is this exactly?
"PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"
What else might be touching that table at the same time?
Maybe some other client executes same or other command at same time in same
dat
"Andrus" <[EMAIL PROTECTED]> writes:
> My application receives the folllowing error sometimes.
> 7/XX000:Error while executing the query;ERROR: tuple concurrently updated
> CONTEXT: SQL statement "DROP TABLE templsabi"PL/pgSQL function "drop_table"
> line 2 at execute statement
That's a bit int
My application receives the folllowing error sometimes.
Any idea how to fix ?
Andrus.
7/XX000:Error while executing the query;ERROR: tuple concurrently updated
CONTEXT: SQL statement "DROP TABLE templsabi"PL/pgSQL function "drop_table"
line 2 at execute statement
SELECT drop_table('templs
