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
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