bsreejithin, 05.11.2013 10:04: > 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. >
I'm pretty sure Postgres will not allow that. If I had to guess: you are using a Java program which uses SimpleDateFormat and the "lenient" parsing was not disabled. Because that's exactly what happens with a SimpleDateFormat in it's default configuration. http://docs.oracle.com/javase/6/docs/api/java/text/DateFormat.html#setLenient%28boolean%29 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
