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

Re: [BUGS] pg_tables view definition incorrect??

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mike Quinn <mquinn(at)co(dot)merced(dot)ca(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] pg_tables view definition incorrect??
Date: 2003-07-21 15:20:05
Message-ID: 200307211520.h6LFK5b11934@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
You are correct.  Patch attached and applied.

---------------------------------------------------------------------------

Mike Quinn wrote:
>                             version                            
> ---------------------------------------------------------------
>  PostgreSQL 7.3.2 on i586-pc-linux-gnu, compiled by GCC 2.95.3
> (1 row)
> 
>     View "pg_catalog.pg_tables"
>    Column    |  Type   | Modifiers 
> -------------+---------+-----------
>  schemaname  | name    | 
>  tablename   | name    | 
>  tableowner  | name    | 
>  hasindexes  | boolean | 
>  hasrules    | boolean | 
>  hastriggers | boolean | 
> View definition: SELECT n.nspname AS schemaname, c.relname AS tablename, pg_get_userbyid(c.relowner) AS tableowner, c.relhasindex AS hasindexes, c.relhasrules AS hasrules, (c.reltriggers > 0) AS hastriggers FROM (pg_class c LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE ((c.relkind = 'r'::"char") OR (c.relkind = 's'::"char"));
> 
> Given that 'S' => Sequence and 's' => special shouldn't the last condition in the WHERE clause be:
> 
> c.relkind = 'S'::"char"
> 
> instead of
> 
> c.relkind = 's'::"char"
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2003-07-21 17:33:46
Subject: Re: deadlock_timeout and pg_ctl reload
Previous:From: Alex RodinDate: 2003-07-21 10:53:28
Subject: PostgreSQL 7.3.3 with pgcrypto on FreeBSD 5.1

pgsql-patches by date

Next:From: Bruce MomjianDate: 2003-07-21 20:37:15
Subject: Re: createlang/droplang fix
Previous:From: Tom LaneDate: 2003-07-21 13:36:47
Subject: Re: Eliminate information_schema from oid2name listing

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