Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

'column "prsnamespace" does not exist #10

Closed
onshorechet opened this issue Nov 23, 2011 · 5 comments
Closed

'column "prsnamespace" does not exist #10

onshorechet opened this issue Nov 23, 2011 · 5 comments

Comments

@onshorechet
Copy link

Most of my dbs work find with dbtoyaml however I have one that gives this error every time. I tracked down the offending query in the source and ran it directly on the db with no row results, but not error either.

Output from dbtoyaml:

Traceback (most recent call last):
File "/usr/local/bin/dbtoyaml", line 9, in
load_entry_point('Pyrseas==0.4.1', 'console_scripts', 'dbtoyaml')()
File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbtoyaml.py", line 40, in main
dbmap = db.to_map()
File "/usr/local/lib/python2.7/dist-packages/pyrseas/database.py", line 134, in to_map
self.from_catalog()
File "/usr/local/lib/python2.7/dist-packages/pyrseas/database.py", line 95, in from_catalog
self.db = self.Dicts(self.dbconn)
File "/usr/local/lib/python2.7/dist-packages/pyrseas/database.py", line 67, in init
self.tsparsers = TSParserDict(dbconn)
File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbobject/init.py", line 305, in init
self._from_catalog()
File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbobject/init.py", line 312, in _from_catalog
for obj in self.fetch():
File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbobject/init.py", line 322, in fetch
data = self.dbconn.fetchall(self.query)
File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbconn.py", line 91, in fetchall
curs = self._execute(query)
File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbconn.py", line 63, in _execute
curs.execute(query)
File "/usr/local/lib/python2.7/dist-packages/psycopg2/extras.py", line 121, in execute
return _cursor.execute(self, query, vars)
psycopg2.ProgrammingError: ('column "prsnamespace" does not exist\nLINE 7: JOIN pg_namespace n ON (prsnamespace = n.oid...\n ^\n', "SELECT nspname AS schema, prsname AS name,\n prsstart::regproc AS start, prstoken::regproc AS gettoken,\n prsend::regproc AS end, prslextype::regproc AS lextypes,\n prsheadline::regproc AS headline,\n obj_description(p.oid, 'pg_ts_parser') AS description\n FROM pg_ts_parser p\n JOIN pg_namespace n ON (prsnamespace = n.oid)\n WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')\n ORDER BY nspname, prsname")

postgresql log:

2011-11-23 08:17:16 MST LOG: 00000: duration: 0.791 ms statement: BEGIN
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 1.123 ms statement: set search_path to public, pg_catalog
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.093 ms statement: COMMIT
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.905 ms statement: SHOW server_version_num
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.060 ms statement: ROLLBACK
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.068 ms statement: BEGIN
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 17.638 ms statement: SELECT lanname AS name, lanpltrusted AS trusted,
obj_description(l.oid, 'pg_language') AS description
FROM pg_language l
WHERE lanispl
ORDER BY lanname
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.094 ms statement: ROLLBACK
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.028 ms statement: BEGIN
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 35.562 ms statement: SELECT castsource::regtype AS source,
casttarget::regtype AS target,
CASE WHEN castmethod = 'f' THEN castfunc::regprocedure
ELSE NULL::regprocedure END AS function,
castcontext AS context, castmethod AS method,
obj_description(c.oid, 'pg_cast') AS description
FROM pg_cast c
JOIN pg_type s ON (castsource = s.oid)
JOIN pg_namespace sn ON (s.typnamespace = sn.oid)
JOIN pg_type t ON (casttarget = t.oid)
JOIN pg_namespace tn ON (t.typnamespace = tn.oid)
LEFT JOIN pg_proc p ON (castfunc = p.oid)
LEFT JOIN pg_namespace pn ON (p.pronamespace = pn.oid)
WHERE substring(sn.nspname for 3) != 'pg_'
OR substring(tn.nspname for 3) != 'pg_'
OR (castfunc != 0 AND substring(pn.nspname for 3) != 'pg_')
ORDER BY castsource, casttarget
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.062 ms statement: ROLLBACK
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.028 ms statement: BEGIN
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 1.440 ms statement: SELECT nspname AS name,
obj_description(n.oid, 'pg_namespace') AS description
FROM pg_namespace n
WHERE nspname NOT IN ('pg_catalog', 'information_schema',
'pg_temp_1', 'pg_toast', 'pg_toast_temp_1')
ORDER BY nspname
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.051 ms statement: ROLLBACK
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 56.556 ms statement: SELECT nspname AS schema, typname AS name, typtype AS kind,
format_type(typbasetype, typtypmod) AS type,
typnotnull AS not_null, typdefault AS default,
ARRAY(SELECT enumlabel FROM pg_enum e WHERE t.oid = enumtypid
ORDER BY e.oid) AS labels,
typinput::regproc AS input, typoutput::regproc AS output,
typreceive::regproc AS receive, typsend::regproc AS send,
typmodin::regproc AS typmod_in,
typmodout::regproc AS typmod_out,
typanalyze::regproc AS analyze,
typlen AS internallength, typalign AS alignment,
typstorage AS storage, typdelim AS delimiter,
obj_description(t.oid, 'pg_type') AS description
FROM pg_type t
JOIN pg_namespace n ON (typnamespace = n.oid)
LEFT JOIN pg_class c ON (typrelid = c.oid)
WHERE typisdefined AND (typtype in ('d', 'e')
OR (typtype = 'c' AND relkind = 'c')
OR (typtype = 'b' AND typarray != 0))
AND nspname NOT IN ('pg_catalog', 'pg_toast',
'information_schema')
ORDER BY nspname, typname
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.072 ms statement: ROLLBACK
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:16 MST LOG: 00000: duration: 0.028 ms statement: BEGIN
2011-11-23 08:17:16 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 1013.915 ms statement: SELECT nspname AS schema, relname AS name, relkind AS kind,
CASE WHEN relkind = 'v' THEN pg_get_viewdef(c.oid, TRUE)
ELSE '' END AS definition,
obj_description(c.oid, 'pg_class') AS description
FROM pg_class c
JOIN pg_namespace ON (relnamespace = pg_namespace.oid)
WHERE relkind in ('r', 'S', 'v')
AND (nspname != 'pg_catalog'
AND nspname != 'information_schema')
ORDER BY nspname, relname
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.238 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.067 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 1.443 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_566_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.063 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.039 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 43.950 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_566_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.081 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.054 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.825 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_567_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.039 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 12.031 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_567_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.054 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.044 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.849 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_568_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.045 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.045 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 11.760 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_568_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.071 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.045 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.595 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_569_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.029 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 11.926 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_569_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.064 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.053 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 1.053 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_570_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.044 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.028 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 12.925 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_570_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.052 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.655 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_571_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.032 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.038 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 10.630 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_571_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.062 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.042 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.772 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_572_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.029 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 10.861 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_572_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.055 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.635 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_573_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.031 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 16.640 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_573_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.092 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.023 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.839 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_574_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.020 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.028 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 12.523 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_574_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.067 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.031 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.827 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_575_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.044 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.015 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 11.863 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_575_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.056 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.711 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_576_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.031 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.027 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 10.985 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_576_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.053 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.038 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.642 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_577_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.040 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.018 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 10.174 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_577_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.039 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.018 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.719 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_578_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.019 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.020 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 10.462 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_578_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.040 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.031 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.870 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM imports.apsxls_agency_579_id_seq
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.026 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.017 ms statement: BEGIN
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 10.488 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'imports.apsxls_agency_579_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:17 MST LOG: 00000: duration: 0.069 ms statement: ROLLBACK
2011-11-23 08:17:17 MST LOCATION: exec_simple_query, postgres.c:1095
.
.
.
.
.
.
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.015 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.683 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'pqmd_prevalent_diseases_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.053 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.036 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 2.175 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'pqmd_prevalent_diseases_id_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.040 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.017 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.510 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.pqmd_shipment_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.031 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.081 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'pqmd_shipment_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.056 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.031 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.751 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.pqmd_shipment_products_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.031 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.032 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.054 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'pqmd_shipment_products_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.050 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.032 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 2.116 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'pqmd_shipment_products_id_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.052 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.027 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.522 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.profile_publisher_publisher_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.040 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.035 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.165 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'profile_publisher_publisher_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.062 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.040 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.605 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.program_access_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.194 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'program_access_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.049 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.043 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.665 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.program_dbs_os989_test_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.042 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.268 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'program_dbs_os989_test_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.065 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.041 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 2.230 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'program_dbs_os989_test_record_id_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.054 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.039 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.529 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.program_dbs_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.041 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.001 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'program_dbs_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.060 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.724 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.reg_activate_verify_rav_pk_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.034 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.026 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.030 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'reg_activate_verify_rav_pk_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.061 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.693 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.reg_schl_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.042 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.148 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'reg_schl_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.068 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 1.921 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'reg_schl_id_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.039 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.037 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.478 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.registration_agreements_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.535 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'registration_agreements_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.061 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.434 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.registration_rrecnum_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.028 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 16.718 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'registration_rrecnum_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.045 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.023 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 2.281 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'registration_rrecnum_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.047 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.628 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.report_group_config_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.047 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.034 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.925 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'report_group_config_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.087 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.032 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.531 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.report_group_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.048 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.025 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.080 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'report_group_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.069 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.575 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.report_group_report_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.593 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'report_group_report_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.053 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.023 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.513 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.report_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.033 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.015 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.827 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'report_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.040 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.021 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.569 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.reservation_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.020 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.017 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 11.748 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'reservation_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.090 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 3.058 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'reservation_record_id_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.041 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.017 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.381 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.rost_event_eventid_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.018 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.015 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.140 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'rost_event_eventid_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.056 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.504 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.rost_meeting_meetingid_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.030 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.906 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'rost_meeting_meetingid_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.057 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.020 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.563 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.roster_event_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.018 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.015 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.153 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'roster_event_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.040 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.518 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.roster_meeting_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.015 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.759 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'roster_meeting_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.038 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.018 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.628 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.safe_search_history_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.028 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.078 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'safe_search_history_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.044 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.652 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.sdesxml_fema_exchange_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.852 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'sdesxml_fema_exchange_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.038 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.193 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.504 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.security_template_template_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.018 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.033 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.904 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'security_template_template_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.037 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.673 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.server_prefs_recordid_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.018 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.410 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'server_prefs_recordid_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.038 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.018 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 2.073 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'server_prefs_recordid_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.029 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.018 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.544 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.service_access_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.037 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.468 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'service_access_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.039 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.514 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.service_dbs_os989_test_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.022 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.111 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'service_dbs_os989_test_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.039 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 1.925 ms statement: SELECT adrelid::regclass
FROM pg_attrdef a JOIN pg_depend ON (a.oid = objid)
WHERE refobjid = 'service_dbs_os989_test_record_id_seq'::regclass
AND classid = 'pg_attrdef'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.027 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.432 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.service_dbs_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.017 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 9.978 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'service_dbs_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.040 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.019 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.575 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.service_post_record_id_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.020 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 10.824 ms statement: SELECT refobjid::regclass, refobjsubid
FROM pg_depend
WHERE objid = 'service_post_record_id_seq'::regclass
AND refclassid = 'pg_class'::regclass
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.038 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.028 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.637 ms statement: SELECT start_value, increment_by, max_value, min_value,
cache_value
FROM public.servicetracker_extra10_seq
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.020 ms statement: ROLLBACK
2011-11-23 08:17:22 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:22 MST LOG: 00000: duration: 0.016 ms statement: BEGIN
2011-11-23 08:17:22 MST LOCATION: exec_simple
@onshorechet
Copy link
Author

Sorry it cut off the end of the postgres log I'll just give you the last query:

2011-11-23 08:17:32 MST LOG: 00000: duration: 0.046 ms statement: BEGIN
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST LOG: 00000: duration: 1.453 ms statement: SELECT nspname AS schema, conname AS name,
pg_encoding_to_char(c.conforencoding) AS source_encoding,
pg_encoding_to_char(c.contoencoding) AS dest_encoding,
conproc AS function, condefault AS default,
obj_description(c.oid, 'pg_conversion') AS description
FROM pg_conversion c
JOIN pg_namespace n ON (connamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, conname
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST LOG: 00000: duration: 0.028 ms statement: ROLLBACK
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST LOG: 00000: duration: 0.017 ms statement: BEGIN
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST ERROR: 42703: column "prsnamespace" does not exist at character 391
2011-11-23 08:17:32 MST LOCATION: transformColumnRef, parse_expr.c:766
2011-11-23 08:17:32 MST STATEMENT: SELECT nspname AS schema, prsname AS name,
prsstart::regproc AS start, prstoken::regproc AS gettoken,
prsend::regproc AS end, prslextype::regproc AS lextypes,
prsheadline::regproc AS headline,
obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname

@jmafc
Copy link
Member

jmafc commented Nov 23, 2011

A couple of questions: What version of Postgres are you using? Second, could you please connect to the database with psql, issue the following query and let me know what happens:

SELECT nspname AS schema, prsname AS name,
       prsstart::regproc AS start, prstoken::regproc AS gettoken,
       prsend::regproc AS end, prslextype::regproc AS lextypes,
       prsheadline::regproc AS headline,
       obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
     JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;

Also, it appears you're using the head from the GitHub master repo. Maybe you want to switch to branch r0.4 or tag r0.4.1, which doesn't have the TEXT SEARCH code that it's still being worked on.

@onshorechet
Copy link
Author

Actually I installed it using pip:
Metadata-Version: 1.0
Name: Pyrseas
Version: 0.4.1
Summary: Framework and utilities to upgrade and maintain databases
Home-page: http://www.pyrseas.org/
Author: Joe Abbate
Author-email: jma@freedomcircle.com
License: BSD
Description: =======
Pyrseas
=======

    Pyrseas provides a framework and utilities to upgrade and maintain a
    relational database.  Its purpose is to enhance and follow through

on
the concepts of the Andromeda Project <http://www.andromeda-project.org/>_.

    Pyrseas currently includes the dbtoyaml utility to create a `YAML
    <http://yaml.org/>`_ description of a PostgreSQL database's tables,
    and the yamltodb utility to generate SQL statements to modify a
    database to match an input YAML specification.

    Pyrseas is distributed under the BSD license.

Platform: OS-independent
Classifier: Development Status :: 3 - Alpha
Classifier: Environment :: Console
Classifier: Environment :: Web Environment
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Information Technology
Classifier: Intended Audience :: System Administrators
Classifier: License :: OSI Approved :: BSD License
Classifier: Natural Language :: English
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: SQL
Classifier: Topic :: Database :: Front-Ends
Classifier: Topic :: Software Development :: Code Generators
Classifier: Topic :: Software Development :: Version Control

My postgres version is:
Postges 9.1.1

And the query is:
cos=> SELECT nspname AS schema, prsname AS name,
prsstart::regproc AS start, prstoken::regproc AS gettoken,
prsend::regproc AS end, prslextype::regproc AS lextypes,
prsheadline::regproc AS headline,
obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;
schema | name | start | gettoken | end | lextypes | headline | description
--------+------+-------+----------+-----+----------+----------+-------------
(0 rows)

cos=>

On Wed, Nov 23, 2011 at 9:00 AM, Joe Abbate <
reply@reply.github.com

wrote:

A couple of questions: What version of Postgres are you using? Second,
could you please connect to the database with psql, issue the following
query and let me know what happens:

SELECT nspname AS schema, prsname AS name,
      prsstart::regproc AS start, prstoken::regproc AS gettoken,
      prsend::regproc AS end, prslextype::regproc AS lextypes,
      prsheadline::regproc AS headline,
      obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
    JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;

Also, it appears you're using the head from the GitHub master repo. Maybe
you want to switch to branch r0.4 or tag r0.4.1, which doesn't have the
TEXT SEARCH code that it's still being worked on.

Reply to this email directly or view it on GitHub:
#10 (comment)

@onshorechet
Copy link
Author

So i took you sugestion:
sudo pip uninstall pyrseas
and
git checkout v0.4.1
sudo python setup.py install

ran it on the offending db with no problems

On Wed, Nov 23, 2011 at 10:13 AM, Chet Henry chet.0x.henry@gmail.comwrote:

Actually I installed it using pip:
Metadata-Version: 1.0
Name: Pyrseas
Version: 0.4.1
Summary: Framework and utilities to upgrade and maintain databases
Home-page: http://www.pyrseas.org/
Author: Joe Abbate
Author-email: jma@freedomcircle.com
License: BSD
Description: =======
Pyrseas
=======

    Pyrseas provides a framework and utilities to upgrade and maintain

a
relational database. Its purpose is to enhance and follow through
on
the concepts of the Andromeda Project <http://www.andromeda-project.org/>_.

    Pyrseas currently includes the dbtoyaml utility to create a `YAML
    <http://yaml.org/>`_ description of a PostgreSQL database's

tables,
and the yamltodb utility to generate SQL statements to modify a
database to match an input YAML specification.

    Pyrseas is distributed under the BSD license.

Platform: OS-independent
Classifier: Development Status :: 3 - Alpha
Classifier: Environment :: Console
Classifier: Environment :: Web Environment
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Information Technology
Classifier: Intended Audience :: System Administrators
Classifier: License :: OSI Approved :: BSD License
Classifier: Natural Language :: English
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: SQL
Classifier: Topic :: Database :: Front-Ends
Classifier: Topic :: Software Development :: Code Generators
Classifier: Topic :: Software Development :: Version Control

My postgres version is:
Postges 9.1.1

And the query is:
cos=> SELECT nspname AS schema, prsname AS name,
prsstart::regproc AS start, prstoken::regproc AS gettoken,
prsend::regproc AS end, prslextype::regproc AS lextypes,
prsheadline::regproc AS headline,
obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;
schema | name | start | gettoken | end | lextypes | headline |
description

--------+------+-------+----------+-----+----------+----------+-------------
(0 rows)

cos=>

On Wed, Nov 23, 2011 at 9:00 AM, Joe Abbate <
reply@reply.github.com

wrote:

A couple of questions: What version of Postgres are you using? Second,
could you please connect to the database with psql, issue the following
query and let me know what happens:

SELECT nspname AS schema, prsname AS name,
      prsstart::regproc AS start, prstoken::regproc AS gettoken,
      prsend::regproc AS end, prslextype::regproc AS lextypes,
      prsheadline::regproc AS headline,
      obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
    JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;

Also, it appears you're using the head from the GitHub master repo.
Maybe you want to switch to branch r0.4 or tag r0.4.1, which doesn't have
the TEXT SEARCH code that it's still being worked on.

Reply to this email directly or view it on GitHub:
#10 (comment)

@jmafc
Copy link
Member

jmafc commented Nov 23, 2011

I'm afraid that I'll have to repackage the 0.4.1 release on PyPI (and elsewhere). I see that it includes pyrseas/dbobject/textsearch.py, whereas that's not present in the Git repo tag. Thanks for raising this issue.

@jmafc jmafc closed this as completed Nov 23, 2011
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jmafc @onshorechet