From: | dmp <danap(at)ttc-cmc(dot)net> |
---|---|
To: | m_muthukumar(at)yahoo(dot)com, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: ERROR : column c.reltriggers does not exist |
Date: | 2009-10-19 21:23:28 |
Message-ID: | 4ADCD8D0.9080907@ttc-cmc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Sorry, looks like you wanted > 0 so should have been:
(c.relhastriggers = 't') AS "Has Triggers",
danap
http://dandymadeproductions.com
> I'm showing in PostgreSQL 8.3.3 has the field reltriggers, but in
> 8.4.0 the
> field no longer exists and looks like may have been replaced with
> relhastriggers,
> which is boolean? Try:
>
> SELECT c.relname AS "Name",
> n.nspname AS "Schema",
> pg_get_userbyid(c.relowner) AS "Owner",
> t.spcname AS "Tablespace",
> c.relhasindex AS "Has Indexes",
> c.relhasrules AS "Has Rules",
> (c.relhastriggers = 'f') AS "Has Triggers",
> c.relisshared AS "Is Shared",
> c.relnatts AS "N Cols",
> pg_catalog.obj_description(c.oid, 'pg_class') AS "Comment"
> FROM pg_class c
> LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
> LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
> WHERE c.relkind = 'r'::"char"
> AND n.nspname LIKE 'public'
> AND c.relname LIKE '%'
> ORDER BY n.nspname, c.relname
>
> danap
> http://dandymadeproductions.com
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Jain | 2009-10-20 00:31:31 | How to ensure that SSL is enabled? |
Previous Message | dmp | 2009-10-19 20:51:39 | Re: ERROR : column c.reltriggers does not exist |