Thread: ERROR: cannot open relation config

ERROR: cannot open relation config

From
"Barnes, Sandy (Sandra)"
Date:
> In the postgresql [/etc/rc.d/init.d] script we are
>
>     1) initializing the database
>     2) starting postmaster
>     3) creating a database named 'config'
>     4) creating the table 'config' in the database named 'config'
>
> Everything looks good until I try to access the config table.  I get the
> following errors:
> NOTICE: mdopen: couldn't open config: No such file or directory
> NOTICE: RelationIdBuildRelation: smgropen(config): No such file or
> directory
> ERROR: cannot open relation config
>
> If I change the name of the database table to something other than
> 'config' it works fine?
> Also, I notice that when I try to use config as the table name the
> $PGDATA/config file does NOT get created,
> but the config_pkey file does get created.
>
> Any idea why this happens?? Thx...
>
> Sandy Barnes
> Honeywell
> Business & General Aviation Engineering
> One Technology Center
> 23500 West 105th Street
> Olathe, KS.     66061
> tel         913.712.2027
> fax        913.712.1347
> email    sandy.barnes@honeywell.com
>

Re: ERROR: cannot open relation config

From
Tom Lane
Date:
"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