Re: [GENERAL] Problem with inserting data into a table.....

2005-02-22 Thread Ragnar Hafstað
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

Re: [GENERAL] Problem with inserting data into a table.....

2005-02-22 Thread FERREIRA William (COFRAMI)
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'); --

Re: [GENERAL] Problem with inserting data into a table.....

2005-02-22 Thread Richard Huxton
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

[GENERAL] Problem with inserting data into a table.....

2005-02-22 Thread Sharon Abu
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