From: | Melvin Davidson <melvin6925(at)yahoo(dot)com> |
---|---|
To: | pgadmin-support(at)lists(dot)postgresql(dot)org, Chapman Flack <chap(at)anastigmatix(dot)net> |
Subject: | Re: What pgAdmin version(s) needed these tables/functions? |
Date: | 2018-01-30 23:47:33 |
Message-ID: | 553517705.4565.1517356053131@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 questionmade those tables and functions as a shortcut or workaround to usingregular PostgreSQL catalogs and functions.
You can execute the following queries to see if there are any comments whichmight 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;
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%';
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
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(at)anastigmatix(dot)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()
From | Date | Subject | |
---|---|---|---|
Next Message | Khushboo Vashi | 2018-01-31 06:08:32 | Re: Select, Update, and Insert script generation fails to load |
Previous Message | Chapman Flack | 2018-01-30 21:14:20 | What pgAdmin version(s) needed these tables/functions? |