Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#12 LOCK bug

open
nobody
pgsql_fdw (6)
5
2012-10-08
2012-10-08
Anonymous
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


  • Anonymous
    2012-10-08

    SQL script to reproduce the bug

     
    Attachments