Hi,
I get an error on delete, insert and update statements of the form :-
insert into fault_log t1 select....
update fault_log t1 set ...
delete from fault_log t1 where ....
etc.
It seems that postgress doesn't accept aliases for the tablename in updates,
inserts, and deletes as it does do for selects ????
All the above work with just
insert into fault_log select ... etc,
but not having the shorthand alias for the table name to use in a subselect is
a royal pain (porting from a database that does allow aliases here)
Oh well - lots of rewriting of insert, update and delete statements to do -
icky, icky icky :)
Regards,
Wayne