Thread: error messages

error messages

From
"P. Jourdan"
Date:
I have found some errors in my pgsql error file:
FATAL 1: Database :"template0" is not currently accepting connections
ERROR: Relation 'visits'does not have attribute 'path'
ERROR: Bad boolean external representation '<font
color=red><b>YES></b></font>'
ERROR: Relation "mustdie" does not exist
NOTICE: Adding missing FROM-caluse entry for table "customer"
ERROR: No such atribute or function 'pcustomer_id'
I would like to understand what these statements mean so I can trace and
correct problems in the database.
I do not understand what is the use of the "template0" - is it the base
"model" for newly created databases? I was under the impression that that
was template1...
sorry for my ignorance, but I have to start somewhere... :-)
Philip Jourdan


Re: error messages

From
Oliver Elphick
Date:
On Wed, 2002-05-01 at 16:39, P. Jourdan wrote:
> I have found some errors in my pgsql error file:
> FATAL 1: Database :"template0" is not currently accepting connections

template0 is the backup for template1 (template1 is copied into every
new database created).  Normally, template0 is not accessible.  If you
mess up template1, you can restore it from template0 (see the manuals
for what to specify to allow access to template0 for that purpose.)

> ERROR: Relation 'visits'does not have attribute 'path'

You asked for something that doesn't exist, but I'm not sure what.  What
was the context?

> ERROR: Bad boolean external representation '<font
> color=red><b>YES></b></font>'

Boolean values are either true or false; you have got not only 'YES' but
some surrounding HTML..

From the user manual:

    Valid literal values for the "true" state are:

    TRUE
    't'
    'true'
    'y'
    'yes'
    '1'

    For the "false" state, the following values can be used:

    FALSE
    'f'
    'false'
    'n'
    'no'
    '0'

> ERROR: Relation "mustdie" does not exist

You asked for rows from a table that does not exist

> NOTICE: Adding missing FROM-caluse entry for table "customer"

You specified customer.column in a select, but did not include customer
in the from clause.

> ERROR: No such atribute or function 'pcustomer_id'

Means what it says (spelling aside)!  With some context, I might be more
helpful.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "For if ye forgive men their trespasses, your heavenly
      Father will also forgive you; But if ye forgive not
      men their trespasses, neither will your Father forgive
      your trespasses."         Matthew 6:14,15

Attachment