Re: BUG #5259: the table name double - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: BUG #5259: the table name double
Date
Msg-id 4B419DAA.8070403@postnewspapers.com.au
Whole thread Raw
In response to BUG #5259: the table name double  ("David" <goodomens@21cn.com>)
Responses Re: BUG #5259: the table name double  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 4/01/2010 2:26 PM, David wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5259
> Logged by:          David
> Email address:      goodomens@21cn.com
> PostgreSQL version: 8.0
> Operating system:   RHEL5
> Description:        the table name double
> Details:
>
> hi
>
>    the table name double,why?

How about some information?

Is this the output of psql's `\dp' command? If so, where are the actual
privelege rows - did you delete them, or is the output you pasted
actually EXACTLY what came out of psql?

What version of the ancient and approaching-retirement 8.0 are you
using? "select pg_version()".

What's the output of this query:

   \o output.txt
   SELECT c.oid AS coid, n.oid AS noid, c.relname AS "Name", n.nspname
AS "namespace" FROM pg_catalog.pg_class c LEFT OUTER JOIN
pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN
('r', 'v', 'S');
   \o

Please attach "output.txt" rather than copying and pasting, so that line
wrapping is preserved.


--
Craig Ringer

pgsql-bugs by date:

Previous
From: "Ben Woosley"
Date:
Subject: BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints
Next
From: Jasen Betts
Date:
Subject: Re: BUG #5258: Unique and foreign key constraints fail on columns with reserved names, but not check constraints