pg_tables view definition incorrect??

Поиск
Список
Период
Сортировка
От Mike Quinn
Тема pg_tables view definition incorrect??
Дата
Msg-id sf098a85.068@dp_mail.co.merced.ca.us
обсуждение исходный текст
Ответы Re: pg_tables view definition incorrect??  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
version=20=20=20=20=20=20=20=20=20=20=20=20=20=
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20
---------------------------------------------------------------
 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=20
-------------+---------+-----------
 schemaname  | name    |=20
 tablename   | name    |=20
 tableowner  | name    |=20
 hasindexes  | boolean |=20
 hasrules    | boolean |=20
 hastriggers | boolean |=20
View definition: SELECT n.nspname AS schemaname, c.relname AS tablename, pg=
_get_userbyid(c.relowner) AS tableowner, c.relhasindex AS hasindexes, c.rel=
hasrules AS hasrules, (c.reltriggers > 0) AS hastriggers FROM (pg_class c L=
EFT JOIN pg_namespace n ON ((n.oid =3D c.relnamespace))) WHERE ((c.relkind =
=3D 'r'::"char") OR (c.relkind =3D 's'::"char"));

Given that 'S' =3D> Sequence and 's' =3D> special shouldn't the last condit=
ion in the WHERE clause be:

c.relkind =3D 'S'::"char"

instead of

c.relkind =3D 's'::"char"

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Ivan Boscaino
Дата:
Сообщение: Out of memory
Следующее
От: Philip Edelbrock
Дата:
Сообщение: Precision errors in float8 type casting (as of 7.3.2 and some earlier releases at least)