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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
