On Jan 3, 2008, at 5:59 AM, Sebastián Baioni wrote:
I don't have any table called pg_locks in pg_catalog.
We let running pg_dump 8.2.5 at 1:30 AM after an automatic reboot
of the PostgreSQL service and it didn't finish. When I came to the
office at 9:00 there were a lot of locks, but all of them were from
the pg_dump conection.
The pg_locks view most certainly exists. Here's the list of all of
the system catalog tables and view: http://www.postgresql.org/docs/
8.2/interactive/catalogs.html. If you haven't looked at pg_locks how
do you know "there were a lot of locks"?
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
