ERROR: cannot open relation config

From: "Barnes, Sandy (Sandra)" <Sandy(dot)Barnes(at)Honeywell(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Cc: "Barnes, Sandy (Sandra)" <Sandy(dot)Barnes(at)Honeywell(dot)com>
Subject: ERROR: cannot open relation config
Date: 2001-04-18 14:15:51
Message-ID: 4B3EBD3B46D7D21194B30008C7B1C76508CD725B@OLTEX134
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> 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(dot)barnes(at)honeywell(dot)com
>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christoph Lange 2001-04-18 17:34:07 Trouble with DBD-Pg
Previous Message Thomas Weholt 2001-04-18 13:44:26 Debian packages for 7.1 ???