On Wed, 17 Aug 2011, David Johnston wrote:
To be honest I was too and maybe I somehow implied that to you. Anyway, I
believe if you are dealing with CSV import then you are correct but
apparently SQL is not as forgiving. I use a third-party application to
import my CSV usually so whether that
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rich Shepard
Sent: Wednesday, August 17, 2011 12:27 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Not Seeing Syntax Error
On Wed, 17 Aug 2011, Thom Brown wrote
On Wed, 17 Aug 2011, Thom Brown wrote:
The error message points to the problem. No value, not even NULL, has
been specified for 5th column. Either put DEFAULT or NULL in there. You
can't put nothing.
I was under the impression (obviously wrong) that a blank field was
accepted as a NULL.
On 17 August 2011 16:49, Rich Shepard wrote:
> For several INSERT INTO rows I get a syntax error when the quant column is
> NULL for one specific parameter. I don't see my error. Here is an example
> row:
>
> psql:insert.sql:8: ERROR: syntax error at or near ","
> LINE 1: ...ALUES ('9609-0759',
