ON tst.oid = rel.reltoastrelid
WHERE rel.relkind IN ('r','s','t') AND rel.relnamespace = 1047743::oid
ORDER BY rel.relname
2013-01-07 10:15:25 QUERY : Set query (10.4.0.121:5432): SELECT pr.oid,
pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, typns.nspnam
riginal Message-
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Guillaume Lelarge
Sent: Sunday, January 06, 2013 11:49 AM
To: Robert Klaus
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Large number of rows in pg_type and slow
laume Lelarge
Sent: Sunday, January 06, 2013 11:15 AM
To: Robert Klaus
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Large number of rows in pg_type and slow gui
(pgadmin) refresh
On Sat, 2013-01-05 at 12:38 -0600, Robert Klaus wrote:
> Below, I deleted the logfile, connec
e != 'd' AND t.typname NOT LIKE E'\\_%' AND t.typnamespace =
553544::oid
ORDER BY t.typname
2013-01-05 12:24:19 QUERY : Set query (10.4.0.121:5432): SELECT c.oid, c.xmin,
c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description,
pg_get_viewdef(c.oid, true)
ables and
views will grow tenfold very quickly.
-Original Message-
From: Guillaume Lelarge [mailto:guilla...@lelarge.info]
Sent: Friday, January 04, 2013 4:30 AM
To: Robert Klaus
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Large number of rows in pg_type and slo
This message was posted in the pgsql-general and novice lists, and I was
cirected here . . . sorry for those of you receiving multiple posts.
We have 36,000+ rows returned by " SELECT oid, format_type(oid, typtypmod)
AS typname FROM pg_type".
My manager says this is only a small numbe
