Package: pgadmin3 Version: 1.22.2-3 Severity: important Tags: upstream
pgadmin3: not supporting pgsql server 10. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ WARNING: 12:10:35: Warning: The server you are connecting to is not a version that is supported by this release of pgAdmin III. pgAdmin III may not function as expected. Supported server versions are 8.4 to 9.6. QUERY : 12:10:38: Set query (localhost:5432): SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc, CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused FROM pg_user WHERE usename=current_user ERROR : 12:10:38: Error: ERROR: function pg_last_xlog_receive_location() does not exist LINE 1: ...E NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xl... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ERROR : 12:10:40: Error: Column not found in pgSet: usecreatedb ERROR : 12:12:08: Error: Column not found in pgSet: usesuper ERROR : 12:12:10: Error: Column not found in pgSet: upsince ERROR : 12:12:10: Error: Column not found in pgSet: confloadedsince ERROR : 12:12:11: Error: Column not found in pgSet: inrecovery ERROR : 12:12:11: Error: Column not found in pgSet: replayloc ERROR : 12:12:11: Error: Column not found in pgSet: receiveloc ERROR : 12:12:11: Error: Column not found in pgSet: replay_timestamp ERROR : 12:12:11: Error: Column not found in pgSet: isreplaypaused assertion fail: ~~~~~~~~~~~~~~~~~ ASSERT INFO: db/pgSet.cpp(284): assert "col < nCols && col >= 0" failed in GetBool(). BACKTRACE: [1] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&) [2] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*) [3] wxEvtHandler::TryHereOnly(wxEvent&) [4] wxEvtHandler::DoTryChain(wxEvent&) [5] wxEvtHandler::ProcessEvent(wxEvent&) [6] wxWindowBase::TryAfter(wxEvent&) [7] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&) [8] wxGenericTreeCtrl::OnChar(wxKeyEvent&) [9] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&) [10] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*) [11] wxEvtHandler::TryHereOnly(wxEvent&) [12] wxEvtHandler::ProcessEventLocally(wxEvent&) [13] wxEvtHandler::ProcessEvent(wxEvent&) [14] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&) [15] wxEvtHandler::SafelyProcessEvent(wxEvent&) [16] g_closure_invoke [17] g_signal_emit_valist [18] g_signal_emit [19] gtk_window_propagate_key_event [20] g_closure_invoke [21] g_signal_emit_valist [22] g_signal_emit [23] gtk_propagate_event [24] gtk_main_do_event [25] g_main_context_dispatch [26] g_main_loop_run [27] gtk_main [28] wxGUIEventLoop::DoRun() [29] wxEventLoopBase::Run() [30] wxAppConsoleBase::MainLoop() [31] wxEntry(int&, wchar_t**) [32] __libc_start_main log files added as attachment ... -- System Information: Debian Release: buster/sid APT prefers testing-debug APT policy: (500, 'testing-debug'), (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 4.14.0-3-amd64 (SMP w/2 CPU cores) Locale: LANG=nl_NL.UTF-8, LC_CTYPE=nl_NL.UTF-8 (charmap=UTF-8), LANGUAGE=nl (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages pgadmin3 depends on: ii libc6 2.26-4 ii libgcc1 1:7.2.0-19 ii libgcrypt20 1.8.1-4 ii libpq5 10.1-3 ii libstdc++6 7.2.0-19 ii libwxbase3.0-0v5 3.0.3.1+dfsg2-1 ii libwxgtk3.0-0v5 3.0.3.1+dfsg2-1 ii libxml2 2.9.4+dfsg1-6.1 ii libxslt1.1 1.1.29-5 ii pgadmin3-data 1.22.2-3 Versions of packages pgadmin3 recommends: ii pgagent 3.4.1-5.pgdg90+1 ii postgresql-client 10+189.pgdg90+1 ii postgresql-client-10 [postgresql-client] 10.1-3 Versions of packages pgadmin3 suggests: pn postgresql-contrib <none> -- no debconf information
ASSERT INFO: db/pgSet.cpp(284): assert "col < nCols && col >= 0" failed in GetBool(). BACKTRACE: [1] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&) [2] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*) [3] wxEvtHandler::TryHereOnly(wxEvent&) [4] wxEvtHandler::DoTryChain(wxEvent&) [5] wxEvtHandler::ProcessEvent(wxEvent&) [6] wxWindowBase::TryAfter(wxEvent&) [7] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&) [8] wxGenericTreeCtrl::OnChar(wxKeyEvent&) [9] wxEvtHandler::ProcessEventIfMatchesId(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&) [10] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*) [11] wxEvtHandler::TryHereOnly(wxEvent&) [12] wxEvtHandler::ProcessEventLocally(wxEvent&) [13] wxEvtHandler::ProcessEvent(wxEvent&) [14] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&) [15] wxEvtHandler::SafelyProcessEvent(wxEvent&) [16] g_closure_invoke [17] g_signal_emit_valist [18] g_signal_emit [19] gtk_window_propagate_key_event [20] g_closure_invoke [21] g_signal_emit_valist [22] g_signal_emit [23] gtk_propagate_event [24] gtk_main_do_event [25] g_main_context_dispatch [26] g_main_loop_run [27] gtk_main [28] wxGUIEventLoop::DoRun() [29] wxEventLoopBase::Run() [30] wxAppConsoleBase::MainLoop() [31] wxEntry(int&, wchar_t**) [32] __libc_start_main
WARNING: 12:10:35: Warning: The server you are connecting to is not a version that is supported by this release of pgAdmin III. pgAdmin III may not function as expected. Supported server versions are 8.4 to 9.6. QUERY : 12:10:38: Set query (localhost:5432): SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc, CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused FROM pg_user WHERE usename=current_user ERROR : 12:10:38: Error: ERROR: function pg_last_xlog_receive_location() does not exist LINE 1: ...E NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xl... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ERROR : 12:10:40: Error: Column not found in pgSet: usecreatedb ERROR : 12:12:08: Error: Column not found in pgSet: usesuper ERROR : 12:12:10: Error: Column not found in pgSet: upsince ERROR : 12:12:10: Error: Column not found in pgSet: confloadedsince ERROR : 12:12:11: Error: Column not found in pgSet: inrecovery ERROR : 12:12:11: Error: Column not found in pgSet: replayloc ERROR : 12:12:11: Error: Column not found in pgSet: receiveloc ERROR : 12:12:11: Error: Column not found in pgSet: replay_timestamp ERROR : 12:12:11: Error: Column not found in pgSet: isreplaypaused
INFO : 12:10:30: ############################################################## INFO : 12:10:30: # pgAdmin III Version 1.22.2 Startup INFO : 12:10:30: ############################################################## INFO : 12:10:30: Running a DEBUG build. INFO : 12:10:30: i18n path : /usr/share/pgadmin3/i18n INFO : 12:10:30: UI path : INFO : 12:10:30: Doc path : /usr/share/pgadmin3/docs INFO : 12:10:30: Branding path : /usr/share/pgadmin3/branding INFO : 12:10:30: Plugins path : /usr/share/pgadmin3/plugins.d INFO : 12:10:30: Settings INI : /usr/share/pgadmin3/settings.ini INFO : 12:10:30: PG pg_dump : /usr/bin/pg_dump INFO : 12:10:30: PG pg_dumpall : /usr/bin/pg_dumpall INFO : 12:10:30: PG pg_restore : /usr/bin/pg_restore INFO : 12:10:30: EDB pg_dump : INFO : 12:10:30: EDB pg_dumpall: INFO : 12:10:30: EDB pg_restore: INFO : 12:10:30: Greenplum pg_dump : INFO : 12:10:30: Greenplum pg_dumpall: INFO : 12:10:30: Greenplum pg_restore: INFO : 12:10:31: Using embedded XRC data. INFO : 12:10:31: PG Help : http://www.postgresql.org/docs/current/static/ INFO : 12:10:31: EDB Help : http://www.enterprisedb.com/docs/en/current/server/ INFO : 12:10:31: Greenplum Help: http://gpdb.docs.pivotal.io/ INFO : 12:10:31: Slony Help : http://www.slony.info/documentation/ INFO : 12:10:31: Using fontmetrics 8/19, 10 Point INFO : 12:10:31: Native Description 'Noto Sans 10' INFO : 12:10:31: Draw size of 'M': w=12, h=19, descent 4, external lead 0. INFO : 12:10:31: Draw size of 'g': w=8, h=19, descent 4, external lead 0. INFO : 12:10:31: Draw size of 'Mg': w=20, h=19, descent 4, external lead 0. INFO : 12:10:31: Loading plugin ini files from /usr/share/pgadmin3/plugins.d INFO : 12:10:31: Loading plugin utilities from /usr/share/pgadmin3/plugins.d/plugins.ini INFO : 12:10:31: Adding plugin utility: PSQL Console INFO : 12:10:31: Command: /usr/bin/x-terminal-emulator -e "$$PGBINDIR/psql" --host "$$HOSTNAME" --port $$PORT --username "$$USERNAME" "$$DATABASE" INFO : 12:10:31: Description: Open a PSQL console to the current database. INFO : 12:10:31: Database?: Yes INFO : 12:10:31: Set Password?: Yes INFO : 12:10:31: Reloading servers... INFO : 12:10:31: Loading previously registered servers INFO : 12:10:31: Loading servers registered on the local machine INFO : 12:10:31: Displaying properties for Servers Servers STATUS : 12:10:31: Retrieving details on servers... STATUS : 12:10:31: Retrieving details on servers... (0 msec) INFO : 12:10:33: Displaying properties for Server localhost:5432 STATUS : 12:10:33: Retrieving details on server localhost... STATUS : 12:10:33: Retrieving details on server localhost... (3 msec) INFO : 12:10:35: Attempting to create a connection object... INFO : 12:10:35: Using password file /root/.pgpass STATUS : 12:10:35: Connecting to database... INFO : 12:10:35: Opening connection with connection string: host='localhost' dbname='postgres' user='postgres' port=5432 application_name='pgAdmin III - Browser' QUERY : 12:10:35: Scalar query (localhost:5432): SELECT version(); QUERY : 12:10:35: Query result: PostgreSQL 10.1 (Debian 10.1-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.2.0-19) 7.2.0, 64-bit QUERY : 12:10:35: Set query (localhost:5432): SET DateStyle=ISO; SET client_min_messages=notice; SET bytea_output=escape; SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid FROM pg_database WHERE datname='postgres' INFO : 12:10:35: Setting client_encoding to 'UNICODE' WARNING: 12:10:35: Warning: The server you are connecting to is not a version that is supported by this release of pgAdmin III. pgAdmin III may not function as expected. Supported server versions are 8.4 to 9.6. QUERY : 12:10:38: Set query (localhost:5432): SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as upsince, CASE WHEN usesuper THEN pg_conf_load_time() ELSE NULL END as confloadedsince, CASE WHEN usesuper THEN pg_is_in_recovery() ELSE NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xlog_receive_location() ELSE NULL END as receiveloc, CASE WHEN usesuper THEN pg_last_xlog_replay_location() ELSE NULL END as replayloc, CASE WHEN usesuper THEN pg_last_xact_replay_timestamp() ELSE NULL END as replay_timestamp, CASE WHEN usesuper AND pg_is_in_recovery() THEN pg_is_xlog_replay_paused() ELSE NULL END as isreplaypaused FROM pg_user WHERE usename=current_user ERROR : 12:10:38: Error: ERROR: function pg_last_xlog_receive_location() does not exist LINE 1: ...E NULL END as inrecovery, CASE WHEN usesuper THEN pg_last_xl... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. ERROR : 12:10:40: Error: Column not found in pgSet: usecreatedb ERROR : 12:12:08: Error: Column not found in pgSet: usesuper ERROR : 12:12:10: Error: Column not found in pgSet: upsince ERROR : 12:12:10: Error: Column not found in pgSet: confloadedsince ERROR : 12:12:11: Error: Column not found in pgSet: inrecovery ERROR : 12:12:11: Error: Column not found in pgSet: replayloc ERROR : 12:12:11: Error: Column not found in pgSet: receiveloc ERROR : 12:12:11: Error: Column not found in pgSet: replay_timestamp ERROR : 12:12:11: Error: Column not found in pgSet: isreplaypaused QUERY : 12:12:12: Set query (localhost:5432): SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user; STATUS : 12:12:12: Connecting to database... (01:36 minutes) STATUS : 12:12:12: Restoring previous environment... INFO : 12:12:12: pgServer object initialised as required. INFO : 12:12:12: Adding child object to server localhost:5432 QUERY : 12:12:12: Set query (localhost:5432): SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate, current_setting('default_tablespace') AS default_tablespace, descr.description , db.datconnlimit as connectionlimit, db.datcollate as collate, db.datctype as ctype, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=db.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=db.oid) AS providers FROM pg_database db LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID LEFT OUTER JOIN pg_shdescription descr ON (db.oid=descr.objoid AND descr.classoid='pg_database'::regclass) ORDER BY datname QUERY : 12:12:12: Set query (localhost:5432): SELECT ts.oid, spcname, pg_catalog.pg_tablespace_location(ts.oid) AS spclocation, spcoptions, pg_get_userbyid(spcowner) as spcuser, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=ts.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=ts.oid) AS providers FROM pg_tablespace ts ORDER BY spcname QUERY : 12:12:12: Scalar query (localhost:5432): SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace WHERE relname='pga_job' AND nspname='pgagent' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT') QUERY : 12:12:12: Query result: t QUERY : 12:12:12: Set query (localhost:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE NOT rolcanlogin ORDER BY rolname QUERY : 12:12:12: Scalar query (localhost:5432): SELECT has_table_privilege('pg_authid', 'SELECT') QUERY : 12:12:12: Query result: t QUERY : 12:12:12: Set query (localhost:5432): SELECT tab.oid, tab.*, pg_catalog.shobj_description(tab.oid, 'pg_authid') AS description, (SELECT array_agg(label) FROM pg_shseclabel sl1 WHERE sl1.objoid=tab.oid) AS labels, (SELECT array_agg(provider) FROM pg_shseclabel sl2 WHERE sl2.objoid=tab.oid) AS providers FROM pg_authid tab WHERE rolcanlogin ORDER BY rolname QUERY : 12:12:12: Set query (localhost:5432): SELECT setting FROM pg_settings WHERE name IN ('autovacuum', 'track_counts') INFO : 12:12:12: Displaying properties for Databases Databases INFO : 12:12:12: Displaying properties for Database opensim INFO : 12:12:12: Opening connection with connection string: host='localhost' dbname='opensim' user='postgres' port=5432 application_name='pgAdmin III - Browser' QUERY : 12:12:12: Scalar query (localhost:5432): SELECT version(); QUERY : 12:12:12: Query result: PostgreSQL 10.1 (Debian 10.1-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.2.0-19) 7.2.0, 64-bit QUERY : 12:12:12: Set query (localhost:5432): SET DateStyle=ISO; SET client_min_messages=notice; SET bytea_output=escape; SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid FROM pg_database WHERE oid = 16574 INFO : 12:12:12: Setting client_encoding to 'UNICODE' QUERY : 12:12:12: Scalar query (localhost:5432): SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16 QUERY : 12:12:12: Query result: pg_get_viewdef QUERY : 12:12:12: Scalar query (localhost:5432): SHOW search_path QUERY : 12:12:12: Query result: "$user", opensim, public QUERY : 12:12:12: Set query (localhost:5432): SELECT nspname, session_user=nspname AS isuser FROM pg_namespace QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='r' QUERY : 12:12:12: Query result: {Opensim_Tester=a*r*w*d*D*x*t*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='S' QUERY : 12:12:12: Query result: {Opensim_Tester=r*w*U*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='f' QUERY : 12:12:12: Query result: {Opensim_Tester=X*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 0::OID AND defaclobjtype='T' QUERY : 12:12:12: Query result: {Opensim_Tester=U*/postgres} INFO : 12:12:12: Adding child object to database opensim QUERY : 12:12:12: Set query (localhost:5432): SELECT 2 AS nsptyp, nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description, FALSE as cancreate FROM pg_namespace nsp LEFT OUTER JOIN pg_description des ON (des.objoid=nsp.oid AND des.classoid='pg_namespace'::regclass) WHERE ((nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1)) ) AND nspname NOT LIKE E'pg\\_temp\\_%'AND nspname NOT LIKE E'pg\\_toast_temp\\_%' ORDER BY 1, nspname QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='r' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='S' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='f' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 12703::oid AND defaclobjtype='T' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='r' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='S' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='f' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 11::oid AND defaclobjtype='T' INFO : 12:12:12: Query returned no tuples QUERY : 12:12:12: Set query (localhost:5432): SELECT e.oid, e.xmin, e.evtname AS name, REPLACE(e.evtevent, '_', ' ') AS eventname, pg_catalog.pg_get_userbyid(e.evtowner) AS eventowner, CASE e.evtenabled WHEN 'O' THEN 'enabled' WHEN 'R' THEN 'replica' WHEN 'A' THEN 'always' WHEN 'D' THEN 'disabled' END AS enabled, e.evtfoid AS eventfuncoid, e.evtfoid::regproc AS eventfunname, array_to_string(array(select quote_literal(x) from unnest(evttags) as t(x)), ', ') AS when, pg_catalog.obj_description(e.oid, 'pg_event_trigger') AS comment, p.prosrc AS source, p.pronamespace AS schemaoid, l.lanname AS language FROM pg_event_trigger e LEFT OUTER JOIN pg_proc p ON p.oid=e.evtfoid LEFT OUTER JOIN pg_language l ON l.oid=p.prolang WHERE 1=1 ORDER BY e.evtname QUERY : 12:12:12: Set query (localhost:5432): select x.oid, pg_get_userbyid(extowner) AS owner, x.extname, n.nspname, x.extrelocatable, x.extversion, e.comment FROM pg_extension x JOIN pg_namespace n on x.extnamespace=n.oid join pg_available_extensions() e(name, default_version, comment) ON x.extname=e.name ORDER BY x.extname QUERY : 12:12:12: Set query (localhost:5432): SELECT CASE WHEN nspname LIKE E'pg\\_temp\\_%' THEN 1 WHEN (nspname LIKE E'pg\\_%') THEN 0 ELSE 3 END AS nsptyp, nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl, description, has_schema_privilege(nsp.oid, 'CREATE') as cancreate, (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=nsp.oid) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=nsp.oid) AS providers FROM pg_namespace nsp LEFT OUTER JOIN pg_description des ON (des.objoid=nsp.oid AND des.classoid='pg_namespace'::regclass) WHERE NOT ((nspname = 'pg_catalog' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pg_class' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'pgagent' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'pga_job' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname = 'information_schema' AND EXISTS (SELECT 1 FROM pg_class WHERE relname = 'tables' AND relnamespace = nsp.oid LIMIT 1)) OR (nspname LIKE '_%' AND EXISTS (SELECT 1 FROM pg_proc WHERE proname='slonyversion' AND pronamespace = nsp.oid LIMIT 1)) ) AND nspname NOT LIKE E'pg\\_temp\\_%'AND nspname NOT LIKE E'pg\\_toast_temp\\_%' ORDER BY 1, nspname QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='r' QUERY : 12:12:12: Query result: {Opensim_Tester=a*r*w*d*D*x*t*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='S' QUERY : 12:12:12: Query result: {Opensim_Tester=r*w*U*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='f' QUERY : 12:12:12: Query result: {Opensim_Tester=X*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='T' QUERY : 12:12:12: Query result: {Opensim_Tester=U*/postgres} QUERY : 12:12:12: Set query (localhost:5432): SELECT nsp.oid, substr(nspname, 2) as clustername, nspname, pg_get_userbyid(nspowner) AS namespaceowner, description FROM pg_namespace nsp LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion' ORDER BY nspname QUERY : 12:12:12: Scalar query (localhost:5432): SELECT COUNT(*) FROM (SELECT tgargs from pg_trigger tr LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i' LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f' WHERE tgisinternal AND co.oid IS NULL GROUP BY tgargs HAVING count(1) = 3) AS foo QUERY : 12:12:12: Query result: 0 QUERY : 12:12:12: Set query (localhost:5432): WITH configs AS (SELECT rolname, unnest(setconfig) AS config FROM pg_db_role_setting s LEFT JOIN pg_roles r ON r.oid=s.setrole WHERE s.setdatabase=16574) SELECT rolname, split_part(config, '=', 1) AS variable, replace(config, split_part(config, '=', 1) || '=', '') AS value FROM configs INFO : 12:12:12: Displaying properties for Schemas Schemas INFO : 12:12:12: Displaying properties for Schema opensim INFO : 12:12:12: Adding child object to schema opensim QUERY : 12:12:12: Set query (localhost:5432): SELECT c.oid, c.collname, c.collcollate, c.collctype, pg_get_userbyid(c.collowner) as cowner, description FROM pg_collation c JOIN pg_namespace n ON n.oid=c.collnamespace LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid AND des.classoid='pg_collation'::regclass) WHERE c.collnamespace = 16579::oid ORDER BY c.collname QUERY : 12:12:12: Set query (localhost:5432): SELECT d.oid, d.typname as domname, d.typbasetype, format_type(b.oid,NULL) as basetype, pg_get_userbyid(d.typowner) as domainowner, c.oid AS colloid, c.collname, cn.nspname as collnspname, d.typlen, d.typtypmod, d.typnotnull, d.typdefault, d.typndims, d.typdelim, bn.nspname as basensp, description, (SELECT COUNT(1) FROM pg_type t2 WHERE t2.typname=d.typname) > 1 AS domisdup, (SELECT COUNT(1) FROM pg_type t3 WHERE t3.typname=b.typname) > 1 AS baseisdup, (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=d.oid) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=d.oid) AS providers FROM pg_type d JOIN pg_type b ON b.oid = d.typbasetype JOIN pg_namespace bn ON bn.oid=b.typnamespace LEFT OUTER JOIN pg_description des ON (des.objoid=d.oid AND des.classoid='pg_type'::regclass) LEFT OUTER JOIN pg_collation c ON d.typcollation=c.oid LEFT OUTER JOIN pg_namespace cn ON c.collnamespace=cn.oid WHERE d.typtype = 'd' AND d.typnamespace = 16579::oid ORDER BY d.typname QUERY : 12:12:12: Set query (localhost:5432): SELECT cfg.oid, cfg.cfgname, pg_get_userbyid(cfg.cfgowner) as cfgowner, cfg.cfgparser, parser.prsname as parsername, description FROM pg_ts_config cfg LEFT OUTER JOIN pg_ts_parser parser ON parser.oid=cfg.cfgparser LEFT OUTER JOIN pg_description des ON (des.objoid=cfg.oid AND des.classoid='pg_ts_config'::regclass) WHERE cfg.cfgnamespace = 16579::oid ORDER BY cfg.cfgname QUERY : 12:12:12: Set query (localhost:5432): SELECT dict.oid, dict.dictname, pg_get_userbyid(dict.dictowner) as dictowner, t.tmplname, dict.dictinitoption, description FROM pg_ts_dict dict LEFT OUTER JOIN pg_ts_template t ON t.oid=dict.dicttemplate LEFT OUTER JOIN pg_description des ON (des.objoid=dict.oid AND des.classoid='pg_ts_dict'::regclass) WHERE dict.dictnamespace = 16579::oid ORDER BY dict.dictname QUERY : 12:12:12: Set query (localhost:5432): SELECT prs.oid, prs.prsname, prs.prsstart, prs.prstoken, prs.prsend, prs.prslextype, prs.prsheadline, description FROM pg_ts_parser prs LEFT OUTER JOIN pg_description des ON (des.objoid=prs.oid AND des.classoid='pg_ts_parser'::regclass) WHERE prs.prsnamespace = 16579::oid ORDER BY prs.prsname QUERY : 12:12:12: Set query (localhost:5432): SELECT tmpl.oid, tmpl.tmplname, tmpl.tmplinit, tmpl.tmpllexize, description FROM pg_ts_template tmpl LEFT OUTER JOIN pg_description des ON (des.objoid=tmpl.oid AND des.classoid='pg_ts_template'::regclass) WHERE tmpl.tmplnamespace = 16579::oid ORDER BY tmpl.tmplname QUERY : 12:12:12: Set query (localhost:5432): SELECT proname, pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2 FROM pg_proc JOIN pg_namespace n ON n.oid=pronamespace WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf', 'pgstattuple', 'pgstatindex') AND nspname IN ('pg_catalog', 'public') QUERY : 12:12:12: Scalar query (localhost:5432): SELECT count(*) FROM pg_attribute WHERE attrelid = 'pg_catalog.pg_proc'::regclass AND attname = 'proargdefaults' QUERY : 12:12:12: Query result: 1 QUERY : 12:12:12: Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, pg_get_function_result(pr.oid) AS typname, typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals, pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description, (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=pr.oid) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=pr.oid) AS providers FROM pg_proc pr JOIN pg_type typ ON typ.oid=prorettype JOIN pg_namespace typns ON typns.oid=typ.typnamespace JOIN pg_language lng ON lng.oid=prolang LEFT OUTER JOIN pg_description des ON (des.objoid=pr.oid AND des.classoid='pg_proc'::regclass) WHERE proisagg = FALSE AND pronamespace = 16579::oid AND typname NOT IN ('trigger', 'event_trigger') ORDER BY proname QUERY : 12:12:12: Set query (localhost:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type QUERY : 12:12:12: Set query (localhost:5432): SELECT op.oid, op.oprname, pg_get_userbyid(op.oprowner) as opowner, op.oprkind, op.oprcanhash, op.oprcanmerge, op.oprleft, op.oprright, lt.typname as lefttype, rt.typname as righttype, et.typname as resulttype, co.oprname as compop, ne.oprname as negop, op.oprcode as operproc, op.oprjoin as joinproc, op.oprrest as restrproc, description FROM pg_operator op LEFT OUTER JOIN pg_type lt ON lt.oid=op.oprleft LEFT OUTER JOIN pg_type rt ON rt.oid=op.oprright JOIN pg_type et on et.oid=op.oprresult LEFT OUTER JOIN pg_operator co ON co.oid=op.oprcom LEFT OUTER JOIN pg_operator ne ON ne.oid=op.oprnegate LEFT OUTER JOIN pg_description des ON (des.objoid=op.oid AND des.classoid='pg_operator'::regclass) WHERE op.oprnamespace = 16579::oid ORDER BY op.oprname QUERY : 12:12:12: Set query (localhost:5432): SELECT cl.oid, relname, pg_get_userbyid(relowner) AS seqowner, relacl, description, (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=cl.oid) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=cl.oid) AS providers FROM pg_class cl LEFT OUTER JOIN pg_description des ON (des.objoid=cl.oid AND des.classoid='pg_class'::regclass) WHERE relkind = 'S' AND relnamespace = 16579::oid ORDER BY relname QUERY : 12:12:12: Set query (localhost:5432): SELECT rel.oid, rel.relname, rel.reltablespace AS spcoid, spc.spcname, pg_get_userbyid(rel.relowner) AS relowner, rel.relacl, rel.relhasoids, rel.relhassubclass, rel.reltuples, des.description, con.conname, con.conkey, EXISTS(select 1 FROM pg_trigger JOIN pg_proc pt ON pt.oid=tgfoid AND pt.proname='logtrigger' JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND pc.proname='slonyversion' WHERE tgrelid=rel.oid) AS isrepl, (select count(*) FROM pg_trigger WHERE tgrelid=rel.oid AND tgisinternal = FALSE) AS triggercount , rel.relpersistence , substring(array_to_string(rel.reloptions, ',') FROM 'fillfactor=([0-9]*)') AS fillfactor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS autovacuum_enabled , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS autovacuum_vacuum_threshold , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_vacuum_scale_factor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS autovacuum_analyze_threshold , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_analyze_scale_factor , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS autovacuum_vacuum_cost_delay , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS autovacuum_vacuum_cost_limit , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS autovacuum_freeze_min_age , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS autovacuum_freeze_max_age , substring(array_to_string(rel.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS autovacuum_freeze_table_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS toast_autovacuum_enabled , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS toast_autovacuum_vacuum_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_vacuum_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS toast_autovacuum_analyze_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_analyze_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS toast_autovacuum_vacuum_cost_delay , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS toast_autovacuum_vacuum_cost_limit , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS toast_autovacuum_freeze_min_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS toast_autovacuum_freeze_max_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS toast_autovacuum_freeze_table_age , rel.reloptions AS reloptions, tst.reloptions AS toast_reloptions , (CASE WHEN rel.reltoastrelid = 0 THEN false ELSE true END) AS hastoasttable , rel.reloftype, typ.typname , (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=rel.oid AND sl1.objsubid=0) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=rel.oid AND sl2.objsubid=0) AS providers FROM pg_class rel LEFT OUTER JOIN pg_tablespace spc on spc.oid=rel.reltablespace LEFT OUTER JOIN pg_description des ON (des.objoid=rel.oid AND des.objsubid=0 AND des.classoid='pg_class'::regclass) LEFT OUTER JOIN pg_constraint con ON con.conrelid=rel.oid AND con.contype='p' LEFT OUTER JOIN pg_class tst ON tst.oid = rel.reltoastrelid LEFT JOIN pg_type typ ON rel.reloftype=typ.oid WHERE rel.relkind IN ('r','s','t') AND rel.relnamespace = 16579::oid ORDER BY rel.relname QUERY : 12:12:12: Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, pg_get_function_result(pr.oid) AS typname, typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass) AS proargdefaultvals, pronargdefaults, proconfig, pg_get_userbyid(proowner) as funcowner, description, (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=pr.oid) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=pr.oid) AS providers FROM pg_proc pr JOIN pg_type typ ON typ.oid=prorettype JOIN pg_namespace typns ON typns.oid=typ.typnamespace JOIN pg_language lng ON lng.oid=prolang LEFT OUTER JOIN pg_description des ON (des.objoid=pr.oid AND des.classoid='pg_proc'::regclass) WHERE proisagg = FALSE AND pronamespace = 16579::oid AND (typname IN ('trigger', 'event_trigger') AND lanname NOT IN ('edbspl', 'sql', 'internal')) ORDER BY proname QUERY : 12:12:12: Set query (localhost:5432): SELECT oid, format_type(oid, NULL) AS typname FROM pg_type QUERY : 12:12:12: Set query (localhost:5432): SELECT c.oid, c.xmin, c.relname,c.reltablespace AS spcoid, c.relkind, c.relispopulated AS ispopulated,spc.spcname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definition, (SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=c.oid AND sl1.objsubid=0) AS labels, (SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE sl2.objoid=c.oid AND sl2.objsubid=0) AS providers, substring(array_to_string(c.reloptions, ',') FROM 'security_barrier=([a-z|0-9]*)') AS security_barrier, substring(array_to_string(c.reloptions, ',') FROM 'fillfactor=([0-9]*)') AS fillfactor , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS autovacuum_enabled , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS autovacuum_vacuum_threshold , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_vacuum_scale_factor , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS autovacuum_analyze_threshold , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS autovacuum_analyze_scale_factor , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS autovacuum_vacuum_cost_delay , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS autovacuum_vacuum_cost_limit , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS autovacuum_freeze_min_age , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS autovacuum_freeze_max_age , substring(array_to_string(c.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS autovacuum_freeze_table_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_enabled=([a-z|0-9]*)') AS toast_autovacuum_enabled , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_threshold=([0-9]*)') AS toast_autovacuum_vacuum_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_vacuum_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_threshold=([0-9]*)') AS toast_autovacuum_analyze_threshold , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_analyze_scale_factor=([0-9]*[.][0-9]*)') AS toast_autovacuum_analyze_scale_factor , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_delay=([0-9]*)') AS toast_autovacuum_vacuum_cost_delay , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_vacuum_cost_limit=([0-9]*)') AS toast_autovacuum_vacuum_cost_limit , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_min_age=([0-9]*)') AS toast_autovacuum_freeze_min_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_max_age=([0-9]*)') AS toast_autovacuum_freeze_max_age , substring(array_to_string(tst.reloptions, ',') FROM 'autovacuum_freeze_table_age=([0-9]*)') AS toast_autovacuum_freeze_table_age , c.reloptions AS reloptions, tst.reloptions AS toast_reloptions , (CASE WHEN c.reltoastrelid = 0 THEN false ELSE true END) AS hastoasttable , substring(array_to_string(c.reloptions, ',') FROM 'check_option=([a-z]*)') AS check_option FROM pg_class c LEFT OUTER JOIN pg_tablespace spc on spc.oid=c.reltablespace LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and des.objsubid=0 AND des.classoid='pg_class'::regclass) LEFT OUTER JOIN pg_class tst ON tst.oid = c.reltoastrelid WHERE ((c.relhasrules AND (EXISTS ( SELECT r.rulename FROM pg_rewrite r WHERE ((r.ev_class = c.oid) AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind = 'v'::char)) AND c.relnamespace = 16579::oid ORDER BY relname QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='r' QUERY : 12:12:12: Query result: {Opensim_Tester=a*r*w*d*D*x*t*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='S' QUERY : 12:12:12: Query result: {Opensim_Tester=r*w*U*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='f' QUERY : 12:12:12: Query result: {Opensim_Tester=X*/postgres} QUERY : 12:12:12: Scalar query (localhost:5432): SELECT defaclacl FROM pg_catalog.pg_default_acl dacl WHERE dacl.defaclnamespace = 16579::oid AND defaclobjtype='T' QUERY : 12:12:12: Query result: {Opensim_Tester=U*/postgres} STATUS : 12:12:12: Restoring previous environment... (392 msec) INFO : 12:12:14: Displaying properties for Database opensim STATUS : 12:12:14: Retrieving details on database opensim... STATUS : 12:12:15: Retrieving details on database opensim... (11 msec) INFO : 12:12:19: Displaying properties for Server localhost:5432 STATUS : 12:12:19: Retrieving details on server localhost... QUERY : 12:12:19: Scalar query (localhost:5432): SELECT version(); QUERY : 12:12:19: Query result: PostgreSQL 10.1 (Debian 10.1-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 7.2.0-19) 7.2.0, 64-bit STATUS : 12:12:19: Retrieving details on server localhost... (31 msec) INFO : 12:14:03: Storing listed servers for later... INFO : 12:14:03: Stored 1 servers.
_______________________________________________ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public