From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Mike Quinn" <mquinn(at)co(dot)merced(dot)ca(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: pg_tables view definition incorrect?? |
Date: | 2003-07-10 15:24:43 |
Message-ID: | 6919.1057850683@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
"Mike Quinn" <mquinn(at)co(dot)merced(dot)ca(dot)us> writes:
> Given that 'S' => Sequence and 's' => special shouldn't the last condition in the WHERE clause be:
> c.relkind = 'S'::"char"
Only if you suppose that pg_tables should show sequences, which was not
the intention. (I'm not real sure why 's' relations are listed, since
they're not really tables either, but the view is operating as
designed.)
I'm prepared to listen to an argument that pg_tables should show
sequences, but that's a definition change not a bug fix. Want to
bring it up on -general or -hackers?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jonas Lindholm | 2003-07-12 02:54:50 | Daylight saving bug in PostgreSQL 7.2.1 ? |
Previous Message | Tom Lane | 2003-07-10 15:20:48 | Re: Out of memory |
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Jensen | 2003-07-11 16:25:48 | Revised sslmode patch |
Previous Message | Bruce Momjian | 2003-07-09 17:58:47 | Re: fix for new SUSET GUC variables |