Skip site navigation (1) Skip section navigation (2)

Re: ERROR : column c.reltriggers does not exist

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 (view raw or flat)
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



In response to

pgsql-jdbc by date

Next:From: Eric JainDate: 2009-10-20 00:31:31
Subject: How to ensure that SSL is enabled?
Previous:From: dmpDate: 2009-10-19 20:51:39
Subject: Re: ERROR : column c.reltriggers does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group