Skip site navigation (1) Skip section navigation (2)

Re: Strange Insert Problem

From: Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com>
To: Lola Lee <lola(at)his(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Strange Insert Problem
Date: 2004-01-09 10:38:16
Message-ID: 3FFE8498.7020900@net6d.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

First, in insert, every strings must be quoted. Your query becomes :

INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num, 
yarn_color_desc, yarn_color_lud) VALUES ( 15, 'Anemone', 616, 
'whatever', now() ).

Try this and report back.

Bruno



Lola Lee wrote:

> I'm having a really strange insert problem, which I cannot figure out.
>
> I have a table in my database, which I created using the following 
> query (I'm using Postgresql 7.4, if this helps):
>
> CREATE TABLE yarncolor (
>        yarn_color_id       SERIAL,
>        yarn_id             int NULL,
>        yarn_color_nm        varchar(35) NULL,
>        yarn_color_num       varchar(10) NULL,
>        yarn_color_desc      varchar(50) NULL,
>        discontinued_flg     boolean NULL,
>        yarn_color_lud       timestamp NULL,
>        PRIMARY KEY (yarn_color_id),
>        FOREIGN KEY (yarn_id)
>                              REFERENCES yarn
> );
>
> Everytime I try to insert a record in this table via ColdFusion 
> generated page, I get this error message (I also get this in 
> phpPgMyAdmin):
>
> SQL error:
> ERROR:  column "anemone" does not exist
>
>
> In statement:
> INSERT INTO YarnColortwo (yarn_id, yarn_color_nm, yarn_color_num, 
> yarn_color_desc, yarn_color_lud) VALUES ( 15, Anemone, 616, whatever, 
> now() )
>
> I'm at a loss as to why does Postgresql think there is a column named 
> "anemone".  Yes, I tried another string of character and get the same 
> message.  Anyone have an idea what may be going on?
>
>

-- 
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno(dot)leveque(at)net6d(dot)com
http://www.net6d.com


In response to

Responses

pgsql-novice by date

Next:From: John K. HerreshoffDate: 2004-01-09 11:34:29
Subject: Re: Strange Insert Problem
Previous:From: Lola LeeDate: 2004-01-09 10:25:57
Subject: Strange Insert Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group