From: | "Mike Quinn" <mquinn(at)co(dot)merced(dot)ca(dot)us> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | pg_tables view definition incorrect?? |
Date: | 2003-07-07 21:58:01 |
Message-ID: | sf098a85.068@dp_mail.co.merced.ca.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
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"
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Tkach | 2003-07-07 21:58:53 | Re: Backwards index scan |
Previous Message | Stephan Szabo | 2003-07-07 21:44:46 | Re: Backwards index scan |
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Yarra | 2003-07-07 23:48:27 | Fwd: Re: [HACKERS] OSF build fixed |
Previous Message | Shridhar Daithankar | 2003-07-07 06:45:59 | Re: Another POC initdb patch |