Re: [BUGS] BUG #1329: Bug in IF-ELSEIF-ELSE construct

2004-11-26 Thread Neil Conway
Tom Lane wrote: There is no ELSEIF construct. Sure, but it would be nice to throw a syntax error rather than silently accepting the function. Unfortunately the way PL/PgSQL's parser works doesn't make this very easy. (BTW, I think that fixing how we do parsing would be one of the prime motivatio

Re: [BUGS] Sequence creation bug: 8.0.0beta4 win32

2004-11-26 Thread Bruce Momjian
I could not reproduce any of your problems on Win32 or Unix. Are you still seeing these failures? --- Nick Farrell wrote: > Hi. I'm seeing a couple of strange things. > > default encoding: unicode > locale: en_AU > running

Re: [BUGS] use of initcap() causes segfault in v8.0.0beta5, where it doesn't in v7.4.6 (coredump included)

2004-11-26 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: > I'll look into the possibility of upgrading libc, but given the source of > oracle_compat.c, would it be possible to get the v7.4.6 behaviour back for > the time being by fiddling the #define USE_WIDE_UPPER_LOWER ? Yeah, IIRC it should be a one-liner

Re: [BUGS] use of initcap() causes segfault in v8.0.0beta5, where it doesn't in v7.4.6 (coredump included)

2004-11-26 Thread Frank van Vugt
> Possibly a bug in your old glibc version? Could be, a quick search does reveal some reports on a problem with the combination of glibc 2.1.3 an towupper. I'll look into the possibility of upgrading libc, but given the source of oracle_compat.c, would it be possible to get the v7.4.6 behaviour

Re: [BUGS] use of initcap() causes segfault in v8.0.0beta5, where it doesn't in v7.4.6 (coredump included)

2004-11-26 Thread Tom Lane
> Since this probably has to do with the db encoding, both versions of pgsql > were initdb'd using UNICODE and no-locale. BTW, would you confirm that that means u=# show server_encoding; server_encoding - UNICODE (1 row) u=# show lc_ctype; lc_ctype -- C (1 row) u

Re: [BUGS] use of initcap() causes segfault in v8.0.0beta5, where it doesn't in v7.4.6 (coredump included)

2004-11-26 Thread Tom Lane
Frank van Vugt <[EMAIL PROTECTED]> writes: > (Further examination revealed that a simple 'select initcap('f')' is > enough to bring the backend down..) Works for me in unicode encoding + C locale on a couple different platforms. > # uname -a > Linux gatefox 2.2.16 #15 Wed Feb 12 12:14:42 CET

[BUGS] use of initcap() causes segfault in v8.0.0beta5, where it doesn't in v7.4.6 (coredump included)

2004-11-26 Thread Frank van Vugt
L.S. I've been using a certain pgsql function (IMMUTABLE/STRICT) happily in v7.4.6, but when trying out v8.0.0beta5 the exact same function causes the backend to segfault. (Further examination revealed that a simple 'select initcap('f')' is enough to bring the backend down..) db=# select

Re: [BUGS] BUG #1329: Bug in IF-ELSEIF-ELSE construct

2004-11-26 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Description:Bug in IF-ELSEIF-ELSE construct There is no ELSEIF construct. Try ELSIF. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmas

Re: [BUGS] postgresql-8.0.0-beta5-en.msi -- does not install

2004-11-26 Thread Magnus Hagander
> Dear POSTGRESQL developers, > > I would like to test the new PostgreSQL version, but was not > able to start > > postgresql-8.0.0-beta5-en.zip > > i.e., the Windows Installer stopped without saying anything. > That happen under Windows 2000 _and_ under Windows XP. The > same happened wi

Re: [BUGS] Version control for DLLs installed into WINNT/system32

2004-11-26 Thread Magnus Hagander
> I've found that if you have installed a previous beta release > (e.g. beta4) and deinstall it, then the DLLs in system32 are > not removed (e.g. libpq.dll). That is not good, and needs to be fixed. Please log a bug with the pginstaller project on pgfoundry.org. > Furthermore, if you then ins

[BUGS] postgresql-8.0.0-beta5-en.msi -- does not install

2004-11-26 Thread Hans Werner Borchers
Dear POSTGRESQL developers, I would like to test the new PostgreSQL version, but was not able to start postgresql-8.0.0-beta5-en.zip i.e., the Windows Installer stopped without saying anything. That happen under Windows 2000 _and_ under Windows XP. The same happened with older Beta-Versions, I

[BUGS] Build libpq for win32

2004-11-26 Thread Ovcharenko
Hi!   I need libpq static library for my Borland compiler (win32).   make -DCFG=Release /f bcc32.makis not working in 8.0.0beta5 sourcesand is working nicely in 7.4.6 sources... Vlad Ovcharenko, Russia

[BUGS] Version control for DLLs installed into WINNT/system32

2004-11-26 Thread Markus Öllinger
I've found that if you have installed a previous beta release (e.g. beta4) and deinstall it, then the DLLs in system32 are not removed (e.g. libpq.dll). Furthermore, if you then install beta5, it does not complain but doesn't overwrite the old versions either. As a consequence, the old DLLs are

Re: [BUGS] BUG #1330: Incorrect String Order By In tr_TR Locale

2004-11-26 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 26 Nov 2004, PostgreSQL Bugs List wrote: I use 8.0 Beta-5. I am using a PostgreSQL cluster which I have created with locale tr_TR. When I use "Order By", the strings are not ordered correctly. The spaces are ignored when I use "Order By" cla

[BUGS] BUG #1330: Incorrect String Order By In tr_TR Locale

2004-11-26 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1330 Logged by: Özgür Çaycı Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Debian Woody Description:Incorrect String Order By In tr_TR Locale Details: I use 8.0 Beta-5. I

Re: [BUGS] Beta Testing of postgresql-8.0.0-beta5

2004-11-26 Thread Harald Armin Massa
Siva, thank you very much for all your reporting! I would like to ask you for one more favour: within the installer there is bundled quite a lot of different products, esp. postgreSQL, pg_admin, ODBC/ JDBD / .NET installers, Contrib-Modules and finally the installer All these products are create

[BUGS] BUG #1329: Bug in IF-ELSEIF-ELSE construct

2004-11-26 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1329 Logged by: Rico Wind Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Windows XP, SP2 Description:Bug in IF-ELSEIF-ELSE construct Details: Beta 1. The following always