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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-08-30 14:17:40 | Re: referential integrity requires write permission to a table which only needs to be read |
Previous Message | pgsql-bugs | 2000-08-30 06:15:30 | referential integrity requires write permission to a table which only needs to be read |