On Tue, 26 Oct 2004 18:22:55 +0900, Joel <[EMAIL PROTECTED]> wrote:
> I seem to remember reading a post on this, but searching marc does not
> seem to bring it up immediately.
>
> Company BBS is on postgresql, but it's still at 7.1. The guy in charge
> of it wants some ballpark estimates and warnings about upgrading to 7.4
> so he doesn't have to worry about the recent vulnerabilities.
>
> War stories? Things to watch out for?
Off the top of my head: over-length data inserted into varchar fields
will no longer be silently truncated, raising an error instead ( a big
source of problems with web-based apps); also, the LIMIT x,y syntax
will no longer work.
Your best bet is fro someone who knows your system to go through the
PostgreSQL release notes.
Ian Barwick
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
