Re: attribute ordering
The column presentation issue maybe should be cross referenced with the problem with rowtypes
where the referenced table has dropped columns.
This is the one where in plpgsql you do a select *
into a rowtype of a table with dropped columns
you get a mismatch on the types. Implementing
the presentation ordering will probably give a solution to the rowtype problem.
Recompiling the function should be totally sufficient. That you mention this as a problem indicates that you have self modifying code or are developing on your production system. Which of them is it?
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings