| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: INSERTing rows from external file |
| Date: | 2011-08-16 22:48:27 |
| Message-ID: | alpine.LNX.2.00.1108161546500.23855@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 16 Aug 2011, David Johnston wrote:
> Your INSERT statement is syntactically incorrect; the error has nothing to
> do with PSQL other than the fact that PSQL is reporting the error to you.
David,
I see that now.
> Odds are you are wrapping your Boolean input with single quotes and the
> empty string is not valid input for a Boolean. Because of the quotes the
> system will not use NULL since the input data is not missing but instead
> it has the empty-string as a value.
Yep. Gotta' correct them all so the proper columns are listed and those
with no values are not.
Thanks for pointing out the obvious.
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-08-16 22:51:25 | Re: Using Postgresql as application server |
| Previous Message | Scott Ribe | 2011-08-16 22:23:28 | Re: INSERTing rows from external file |