[BUGS] rename column and trigger on column

2002-02-19 Thread Chris Sutton
create table ref_table ( id serial primary key ref_name varchar); create table data_table ( a int4 references ref_table); which of course creates 3 triggers. If you do: alter table data_table rename column a to b; The trigger on data_table still looks for column named "a" so sometime in

[BUGS] select real returns nothing

2002-06-13 Thread Chris Sutton
I'm getting some weird things happen when trying to search for a specific row in a table that contains "real" types. Here is my table structure table units ( unit_id int4, price_unit varchar(10), unit_covreal, unit_wt real); The following row exists