| From: | bsreejithin <bsreejithin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Junk date getting uploaded into date field |
| Date: | 2013-11-05 09:04:00 |
| Message-ID: | 1383642240942-5776969.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
We have a csv file which we upload into postgres DB. If there are some
errors, like a data mismatch with the database table columns, postgres
should raise and error and upload should fail.
What is happening now is that, in case we get some junk date in the upload
file, postgres does auto-correction and does not raise an error!
A wrong date like ,say, 33-Oct-2013 gets converted as 2-Nov-2013 when the
data is loaded into a date field. No error raised.Data gets uploaded!
How can I prevent this ? I don't want this junk data to get loaded.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Junk-date-getting-uploaded-into-date-field-tp5776969.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2013-11-05 09:13:14 | Re: Junk date getting uploaded into date field |
| Previous Message | Jayadevan | 2013-11-05 04:05:00 | Re: Explanantion on pgbouncer please |