[BUGS] plpgsql function error after alter table add

2000-12-12 Thread Tim Dunnington
FROM car; carname - mytoyota_Toyota (1 row) junk-#DROP FUNCTION carname(car); DROP junk=#CREATE FUNCTION carname(car) RETURNS text AS ' junk'#declare junk'#tmp alias for $1; junk'#begin junk'#

[BUGS] renaming columns do not update foreign key triggers

2000-12-12 Thread Tim Dunnington
Synopsis: If you create a table with a foreign key reference, and later change the name of the referenced field in the referenced table, subsequent updates on the given table will result in an error that the old field name does not exist. I've also seen the corollary to this, where an update