On Jan 13, 2013, at 1:36 PM, AI Rumman <rumman...@gmail.com> wrote: > CREATE VIEW stats_slowest_queries AS > SELECT pg_stat_activity.procpid, (('now'::text)::timestamp(6) with time > zone - pg_stat_activity.query_start) AS execution_time, > pg_stat_activity.current_query FROM pg_stat_activity WHERE > (pg_stat_activity.current_query !~~ '<IDLE%'::text) ORDER BY > (('now'::text)::timestamp(6) with time zone - pg_stat_activity.query_start) > DESC; > psql:pg_upgrade_dump_db.sql:498897: ERROR: column pg_stat_activity.procpid > does not exist > LINE 2: SELECT pg_stat_activity.procpid, (('now'::text)::timesta... > ^ > It failed.
Reason is: From postgreSQL 9.2 onwards, pg_stat_activity.procpid is renamed as pg_stat_activity.pid. http://www.postgresql.org/docs/9.2/interactive/release-9-2.html Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general