On Wed, Jun 28, 2006 at 05:54:31PM -0300, Carlos H. Reimer wrote:
> Should not some applications be changed, if a new column is added to a
> table? If the application is inserting lines without column names for
> example, or using the select *.
Yes. Such applications should be changed by throwing them away and
replacing them with new ones. It is very, very dangerous coding
practice ever to do either SELECT * or INSERT-blindly. A SELECT *
has no way of predicting how things will come back to it, or whether
what it thinks it is going to get is what it will in fact get.
Similarly, blind INSERT is a good way to mess up your database by
putting things in the wrong columns. You should fix such
applications irrespective of whether you're going to use Slony.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
