Re: error messages

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(dot)Elphick(at)lfix(dot)co(dot)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