From: | "Reshat Sabiq" <sabiq(at)purdue(dot)edu> |
---|---|
To: | "'Rod Kreisler'" <rod(at)23net(dot)net>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: using functions to generate custom error messages |
Date: | 2002-11-17 05:56:24 |
Message-ID: | 000001c28dfe$13acb350$1f83d380@main |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks Rod,
I certainly find it a must to use such features as referential integrity
(even it costs a little), transaction support, custom objects, etc.
which make postgreSQL stand apart from mySQL, etc. Such standard
features as value checks, which I believe can be ported quite easily
also don't arouse my doubts.
I guess features that don't port well across DBs are stored procedures
and consequently triggers. Those are the things I am referring to. For
example, if we need to increment a field by a certain value once in
every 2 weeks, would you suggest using stored procedures to accomplish
it, or app logic? And in general, when would you say it's worth to use
stored procedures?
Thanks,
r.
-----Original Message-----
From: Rod Kreisler [mailto:rod(at)23net(dot)net]
Sent: Saturday, November 16, 2002 9:02 AM
To: Reshat Sabiq; 'Joel Rodrigues'; pgsql-novice(at)postgresql(dot)org
Subject: RE: [NOVICE] using functions to generate custom error messages
Reshat,
You have some points, however just as there is the possibility of
switching
RDBMS, there is a possibility that the frontend language will change as
well. Furthermore, a greater possibility, I think, that multiple
frontends
under different platforms will access the one data source.
Data integrity constraints MUST be in the database itself anyway (if
not,
then I suggest using MySQL...), otherwise you are hoping that multiple
ADs
are going to properly maintain integrity in the applications.
IMHO, what Joel suggests is quite reasonable.
Rod
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2002-11-17 19:19:02 | Portability, was: using functions to generate custom error messages |
Previous Message | Joel Rodrigues | 2002-11-17 05:44:12 | Re: using functions to generate custom error messages |