Re: Column does not exist when trying to insert data. - Mailing list pgsql-general

Parthan SR wrote:
> I get the following error in the browser, whent he fields for unit and
> returnedas are left blank and hence becomes None.
> I also tried to have some string value such as 'nos' and 'not reqd' for
> 'unit' and 'requiredas' but still it get a similar error
> saying column 'nos' does not exist.
>
> *ProgrammingError*: ERROR: column "none" does not exist INSERT INTO
> orderitem
> (item,quantity,unit,conference,seller,incharge,orderdate,duedate,returnedas)
>
> VALUES (6,10.000000,None,39,1,1,2007-3-16,20-03-2007,None)
>      args = ('ERROR: column "none" does not exist\n\nINSERT INT...,
> 10.000000,None,39,1,1,2007-3-16,20-03-2007,None)',)

You're looking for "Null" rather than "None".

Oh, and your dates need to be quoted too.

--
   Richard Huxton
   Archonet Ltd