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.