Skip site navigation (1) Skip section navigation (2)

inconsistent debug log output

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: inconsistent debug log output
Date: 2000-08-30 06:36:39
Message-ID: 200008300636.e7U6ad990088@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Dave E Martin (xxiii(at)cyberdude(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
inconsistent debug log output

Long Description
a transaction from psql shows referential integrity statements in the output, but a transaction from a client using libpq does not; they are both using the same backend, PGDEBUG=2:

<PRE>
libpq:
000829.20:05:17.179  [2521] StartTransactionCommand
000829.20:05:17.180  [2521] query: INSERT INTO NAS (...) VALUES (...)
000829.20:05:17.180  [2521] ProcessQuery
000829.20:05:17.182  [2521] CommitTransactionCommand
000829.20:05:17.182  [2521] StartTransactionCommand
000829.20:05:17.182  [2521] query: COMMIT
000829.20:05:17.182  [2521] ProcessUtility: COMMIT
000829.20:05:17.182  [2521] CommitTransactionCommand
000829.20:05:17.183  [2521] ERROR:  nas_make: Permission denied.
000829.20:05:17.183  [2521] AbortCurrentTransaction

psql:
000829.23:18:08.413  [2542] StartTransactionCommand
000829.23:18:08.413  [2542] query: INSERT INTO NAS (...) VALUES (...);
000829.23:18:08.414  [2542] ProcessQuery
000829.23:18:08.417  [2542] CommitTransactionCommand
000829.23:18:46.444  [2542] StartTransactionCommand
000829.23:18:46.444  [2542] query: commit;
000829.23:18:46.444  [2542] ProcessUtility: commit;
000829.23:18:46.444  [2542] CommitTransactionCommand
000829.23:18:46.446  [2542] query: SELECT oid FROM "nas_make" WHERE "id" = $1 FOR UPDATE OF "nas_make"
000829.23:18:46.450  [2542] ERROR:  nas_make: Permission denied.
000829.23:18:46.450  [2542] AbortCurrentTransaction
</PRE>

Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2000-08-30 14:17:40
Subject: Re: referential integrity requires write permission to a table which only needs to be read
Previous:From: pgsql-bugsDate: 2000-08-30 06:15:30
Subject: referential integrity requires write permission to a table which only needs to be read

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group