On 6 Feb 2011, at 16:19, P.V.Anthony wrote: > 3. PostgreSQL version 8.0.15
That's a pretty ancient version of PG. IIRC, PG 8.1 was EOL'ed recently. You should have a look at 8.4 or even 9.0. Mind the usual upgrade instructions between major releases in either case and check the release notes. For example, implicit type casts have gotten much more strict in 8.3. If you have other databases you may want to check that they'll still work after the upgrade. > ----------------- start -------------------------- > [02/06/2011 22:24:30] 18734: ERROR: type "e" does not exist > : SELECT coalesce(substring(split_part(split_part(version(),' > ',2),'.',1) FROM E'\\d+')::int2,0) > [02/06/2011 22:24:30] 18734: ERROR: type "e" does not exist > : SELECT coalesce(substring(split_part(split_part(version(),' > ',2),'.',2) FROM E'\\d+')::int2,0) Your version doesn't have a notion of escape-string syntax. Not sure when that went in, but I think 8.2 has it, maybe 8.1 even. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:1126,4d4edef511731375354790! ------------------------------------------------------------------------------ The modern datacenter depends on network connectivity to access resources and provide services. The best practices for maximizing a physical server's connectivity to a physical network are well understood - see how these rules translate into the virtual world? http://p.sf.net/sfu/oracle-sfdevnlfb _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
