Re: error messages - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: error messages
Date
Msg-id 1020272317.16881.128.camel@linda
Whole thread Raw
In response to error messages  ("P. Jourdan" <pippo@videotron.ca>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Once again about 'OID'
Next
From: Terrence Brannon
Date:
Subject: if postmaster is started on a certain port, should I be able to telnet there?