Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: cannot open relation config - Mailing list pgsql-admin

From Tom Lane
Subject Re: ERROR: cannot open relation config
Date
Msg-id 20967.987693368@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: cannot open relation config  ("Barnes, Sandy (Sandra)" <Sandy.Barnes@Honeywell.com>)
List pgsql-admin
Tree view 
"Barnes, Sandy (Sandra)" <Sandy.Barnes@Honeywell.com> writes:
>> 3) creating a database named 'config'
>> 4) creating the table 'config' in the database named 'config'

Can't reproduce any problem with that here.  What PG version are you
using, anyway?  What's the exact series of commands you're issuing?

>> Also, I notice that when I try to use config as the table name the
>> $PGDATA/config file does NOT get created,

It'd be $PGDATA/base/config/config

            regards, tom lane

pgsql-admin by date:

Previous
From: Fabio Alberto Sobral
Date:
Subject: Help with postgres functions
Next
From: lbottorff@harveycounty.com
Date:
Subject: Can't do pg_dump(all)