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
Title: RE: [GENERAL] Problem with inserting data into a table.
maybe you can try to add the name of the schema like this :
insert into my_schema.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');
--
Sharon Abu wrote:
Hi All,
new to postgreSQL.
I'm running postgreSQL 8.0.1 on win 2k and and i have created a database
(for testing) using pgAdmin-III application
i'v'e also managed to create table with just few simple columns... so far so
good.
the name of the table & its columns are co
Hi All,
new to postgreSQL.
I'm running postgreSQL 8.0.1 on win 2k and and i have created a database
(for testing) using pgAdmin-III application
i'v'e also managed to create table with just few simple columns... so far so
good.
The problem arises when i'm trying to insert some data int