Well in Ingres there is a WORLD of difference! For a start, you don't
lock out the system catalog. Secondly it is an unlogged event, so it
beats "delete from table_name" hands down! Then, of course, it preserves
all permissions, you keep the same OID, so views, et al, can remain in
tact, as wi
If you double-alias a column in a query (yeah, stupid, I know, but I did
it by mistake and others will too!), then the dreaded "fmgr_info:
function : cache lookup failed" message is kicked out. For example:
select * from company c, references r where r.company_id=c.company.id;
Note that c.co
Or else people in our situation where it takes forever to upgrade the
software because of its heavy use and the risk involved in upgrading, not
to mention the problems encountered when we did test-runs of the upgrade.
Then there is always the thorny issue of loads of software that uses the
datab