[BUGS] TRUNCATE violates Referential Integrity

2000-06-25 Thread Oliver Elphick
This is a problem in release 7.0.2. I had never heard of the truncate command! It seems that it ought to be disallowed on a table that is a target for RI checks, since checking that deletions are OK would frustrate the whole purpose of truncate as opposed to delete. --- Forwarded Message D

[BUGS] bug fix request for odbc driver

2000-06-25 Thread Travis Bauer
As explained to me a while back, if the precision of a numeric is undefined, postgresql returns a -1 where it would otherwise return a precision. I changed the jdbc driver to deal with this, but at least as of the last version of postgresql before 7.0, this was a problem in the odbc driver as w