On 2/7/2011 1:48 AM, Alban Hertroys wrote: > 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.
Thank you for the advice. I will upgrade the database. P.V.Anthony ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
