|
From: Miles Elam <miles.elam@xxxxxxxxxxxxxx> Sadly, this is a cloud-managed database without direct access to 5432 from outside the VPC and bastian instances are frowned upon by our security folks. Guess I'm stuck with bisecting. Thanks for the confirmation. ==================== It'd slow you down a little, but you could install a before trigger to do the check and if it fails you'll have all the info you need and can call RAISE to communicate a record identifier, bad
value, whatever. If performance is really a big deal, set up the trigger only after you get a failure so you only have to run it on the 'bad batches'. Or else write a precheck program that looks at the data first and looks only for this and therefore can report the exact record before it feeds the good data to your real loader. Or there's probably other ways I'm not thinking of. The question is what options does your process allow, I suppose. HTH, Kevin . |
