Re: ERROR: column "crc" does not exist

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: ERROR: column "crc" does not exist
Date: 2007-04-12 12:21:44
Message-ID: 20070412122144.GB24825@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Apr 12, 2007 at 09:23:39AM -0300, ezequias(at)fastcon(dot)com(dot)br wrote:
>
> "CRC" character varying(255),
^^^^^

> Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82'
^^^

"CRC" != crc. You need to spell the column name correctly. Or don't
quote the identifier when you create the table.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message ezequias 2007-04-12 12:23:39 ERROR: column "crc" does not exist
Previous Message George Weaver 2007-04-12 12:21:23 Re: ERROR: column "crc" does not exist