Re: Could not open relation with OID (table partitioning issue?)

This is different from the actual error, just wanted to post about this also.
When queries are running on partition table, EXPLAIN statements are going to
waiting state.
For ex:
I am running
SELECT
    events.dp AS target_port,
    count(events.dp) as hits
FROM
    events
WHERE
    events.rid02 = 23243
    AND events.sip = 455545
    AND events.dp IS NOT NULL
    AND (events.evt_time >= '2010-09-01 16:00:00')
    AND events.evt_time <= '2010-09-01 16:05:00')
GROUP BY
    events.dp
ORDER BY
    2 DESC
LIMIT 10

And in a different session I am running
EXPLAIN <same sql statement mentioned above>
THis EXPLAIN statement is in waiting state. Is this expected behaviour?

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Could-not-open-relation-with-OID-table-partitioning-issue-tp3265708p3277881.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.