Inter-DB Connectivity / Bugs / #12 LOCK bug

#12 LOCK bug

Status: open

Owner: nobody

Labels: pgsql_fdw (6)

Priority: 5

Updated: 2012-10-08

Created: 2012-10-08

Creator: Anonymous

Private: No

HI,

I try to link two PostgreSQL databases and I found a weird issue about lock.

If I use a foreign table in a view and I execute a SELECT query twice, the second time there is a AccessShareLock for the table in the linked database.

The file I attached explains this supposed bug.

Thanks

Discussion

Comment has been marked as spam.
Undo

View and moderate all "bugs Discussion" comments posted by this user

Mark all as spam, and block user from posting to "Bugs"

Anonymous - 2012-10-08

SQL script to reproduce the bug

SQL script to reproduce the bug

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

lock_bug.sql

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

LOCK bug

Group

Searches

Help

#12 LOCK bug

Discussion