Thread: What pgAdmin version(s) needed these tables/functions?
Hi, In a database that has been around for a long, long time, there are several pgAdmin-related relations and functions: I assume these are things that were needed for some ancient version of pgAdmin in some ancient version of PostgreSQL? I tried finding something in current pgAdmin docs about them, but in the pgAdmin 4 or 3 docs I find nothing. Older docs are harder to find. Can I safely conclude these are obsolete, and get rid of them without impairing any reasonably recent version of pgAdmin? With what version did they become obsolete, if they are? Thanks, Chapman Flack pgadmin_desc pgadmin_functions pgadmin_param pgadmin_rev_log pgadmin_seq_cache pgadmin_table_cache pgadmin_triggers pgadmin_views pgadmin_get_col_def() pgadmin_get_desc() pgadmin_get_handler() pgadmin_get_pgdesc() pgadmin_get_rows() pgadmin_get_sequence() pgadmin_get_type()
Chapman,
I am not PgAdmin support, but AFAIK, there never was, or are, any tables
or functions that PgAdmin is dependent on.
My guess is that the former dba or owner of the database in question
made those tables and functions as a shortcut or workaround to using
regular PostgreSQL catalogs and functions.
You can execute the following queries to see if there are any comments which
might give you a hint as to what they are used for.
SELECT DISTINCT ON (c.relname)
n.nspname as schema,
c.relname,
a.rolname as owner,
0 as col_seq,
'' as column,
d.description as comment
FROM pg_class c
LEFT JOIN pg_attribute col ON (col.attrelid = c.oid)
LEFT JOIN pg_description d ON (d.objoid = col.attrelid AND d.objsubid = 0)
JOIN pg_namespace n ON (n.oid = c.relnamespace)
JOIN pg_authid a ON ( a.OID = c.relowner )
WHERE n.nspname NOT LIKE 'information%'
AND relname NOT LIKE 'pg_%'
AND relname NOT LIKE 'information%'
AND relname NOT LIKE 'sql_%'
AND relname LIKE 'pgadmin%'
AND relkind = 'r'
AND d.description IS NOT NULL
UNION
SELECT n.nspname as schema,
c.relname,
'' as owner,
col.attnum as col_seq,
col.attname as column,
d.description
FROM pg_class c
JOIN pg_attribute col ON (col.attrelid = c.oid)
LEFT JOIN pg_description d ON (d.objoid = col.attrelid AND d.objsubid = col.attnum)
JOIN pg_namespace n ON (n.oid = c.relnamespace)
JOIN pg_authid a ON ( a.OID = c.relowner )
WHERE n.nspname NOT LIKE 'information%'
AND relname NOT LIKE 'pg_%'
AND relname NOT LIKE 'information%'
AND relname NOT LIKE 'sql_%'
AND relname LIKE 'pgadmin%'
AND relkind = 'r'
AND d.description IS NOT NULL
AND col.attnum >= 0
ORDER BY 1, 2, 4;
n.nspname as schema,
c.relname,
a.rolname as owner,
0 as col_seq,
'' as column,
d.description as comment
FROM pg_class c
LEFT JOIN pg_attribute col ON (col.attrelid = c.oid)
LEFT JOIN pg_description d ON (d.objoid = col.attrelid AND d.objsubid = 0)
JOIN pg_namespace n ON (n.oid = c.relnamespace)
JOIN pg_authid a ON ( a.OID = c.relowner )
WHERE n.nspname NOT LIKE 'information%'
AND relname NOT LIKE 'pg_%'
AND relname NOT LIKE 'information%'
AND relname NOT LIKE 'sql_%'
AND relname LIKE 'pgadmin%'
AND relkind = 'r'
AND d.description IS NOT NULL
UNION
SELECT n.nspname as schema,
c.relname,
'' as owner,
col.attnum as col_seq,
col.attname as column,
d.description
FROM pg_class c
JOIN pg_attribute col ON (col.attrelid = c.oid)
LEFT JOIN pg_description d ON (d.objoid = col.attrelid AND d.objsubid = col.attnum)
JOIN pg_namespace n ON (n.oid = c.relnamespace)
JOIN pg_authid a ON ( a.OID = c.relowner )
WHERE n.nspname NOT LIKE 'information%'
AND relname NOT LIKE 'pg_%'
AND relname NOT LIKE 'information%'
AND relname NOT LIKE 'sql_%'
AND relname LIKE 'pgadmin%'
AND relkind = 'r'
AND d.description IS NOT NULL
AND col.attnum >= 0
ORDER BY 1, 2, 4;
SELECT p.oid,
p.proname AS function,
d.description AS comment
FROM pg_proc p
JOIN pg_description d ON d.objoid = p.oid
WHERE p.proname LIKE 'pgadmin%';
p.proname AS function,
d.description AS comment
FROM pg_proc p
JOIN pg_description d ON d.objoid = p.oid
WHERE p.proname LIKE 'pgadmin%';
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Tuesday, January 30, 2018, 4:14:41 PM EST, Chapman Flack <chap@anastigmatix.net> wrote:
Hi,
In a database that has been around for a long, long time, there are
several pgAdmin-related relations and functions:
I assume these are things that were needed for some ancient version
of pgAdmin in some ancient version of PostgreSQL? I tried finding
something in current pgAdmin docs about them, but in the pgAdmin 4
or 3 docs I find nothing. Older docs are harder to find.
Can I safely conclude these are obsolete, and get rid of them without
impairing any reasonably recent version of pgAdmin?
With what version did they become obsolete, if they are?
Thanks,
Chapman Flack
pgadmin_desc
pgadmin_functions
pgadmin_param
pgadmin_rev_log
pgadmin_seq_cache
pgadmin_table_cache
pgadmin_triggers
pgadmin_views
pgadmin_get_col_def()
pgadmin_get_desc()
pgadmin_get_handler()
pgadmin_get_pgdesc()
pgadmin_get_rows()
pgadmin_get_sequence()
pgadmin_get_type()
Hi
Wow, that takes me back. They're from pgAdmin 1 iirc, and haven't been used in 15+ years.
--
On Tue, Jan 30, 2018 at 9:14 PM, Chapman Flack <chap@anastigmatix.net> wrote:
Hi,
In a database that has been around for a long, long time, there are
several pgAdmin-related relations and functions:
I assume these are things that were needed for some ancient version
of pgAdmin in some ancient version of PostgreSQL? I tried finding
something in current pgAdmin docs about them, but in the pgAdmin 4
or 3 docs I find nothing. Older docs are harder to find.
Can I safely conclude these are obsolete, and get rid of them without
impairing any reasonably recent version of pgAdmin?
With what version did they become obsolete, if they are?
Thanks,
Chapman Flack
pgadmin_desc
pgadmin_functions
pgadmin_param
pgadmin_rev_log
pgadmin_seq_cache
pgadmin_table_cache
pgadmin_triggers
pgadmin_views
pgadmin_get_col_def()
pgadmin_get_desc()
pgadmin_get_handler()
pgadmin_get_pgdesc()
pgadmin_get_rows()
pgadmin_get_sequence()
pgadmin_get_type()
Wow, that takes me back. They're from pgAdmin 1 iirc, and haven't been used in 15+ years.
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On 01/31/2018 04:02 AM, Dave Page wrote: > Wow, that takes me back. They're from pgAdmin 1 iirc, and haven't > been used in 15+ years. Thanks! I suspected as much. Won't feel too bad about making them go away then. -Chap