Re: Not Seeing Syntax Error - Mailing list pgsql-general

From Rich Shepard
Subject Re: Not Seeing Syntax Error
Date
Msg-id alpine.LNX.2.00.1108170941050.1129@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Not Seeing Syntax Error  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
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 observation applies to PSQL or other
> mechanisms (like pg_loader) I cannot say.

David,

   It may well be different between COPY and INSERT INTO. Anywho, I altered
the column and set the default to NULL. That works.

Regards,

Rich

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Using Postgresql as application server
Next
From: Lonni J Friedman
Date:
Subject: Re: streaming replication: one problem & several questions