Re: Problem with inserting data into a table.....

On Tue, 2005-02-22 at 14:08 +0200, Sharon Abu wrote:

> insert into  COL_LED_TBL
> (LED_STATE_COLOR,NEID,LED_STATE_MODE,PHY_INDEX,PORT_INDEX,MODE_DFGH)
> values (1,1234,3,0,104,'test led numbetr 1');
>
> the name of the table & its columns are correct (I've checked it....)
>
> The execution fails with the following message :  ERROR:  relation
> "col_led_tbl" does not exist

postgres folds names to lowercase. either create your table and it's
columns with lowercase names, or quote the names:

insert into  "COL_LED_TBL" ("LED_STATE_COLOR", "NEID","LED_STATE_MODE",
"PHY_INDEX", "PORT_INDEX", "MODE_DFGH")
values (1,1234,3,0,104,'test led numbetr 1');

gnari