Re: [BUGS] Upgrade from 7.4.5 to 8.3.3

2008-10-27 Thread Harvey, Allan AC
Zdenek, > > Hmm, It does not look good. Your OS does not return proper > information about > codeset. Following code is broken: > > setlocale(LC_CTYPE, ctype); > sys = nl_langinfo(CODESET); > sys = strdup(sys); > > See > http://www.opengroup.org/onlinepubs/009695399/function

Re: [BUGS] Upgrade from 7.4.5 to 8.3.3

2008-10-27 Thread Peter Eisentraut
Harvey, Allan AC wrote: Zdenek, Hmm, It does not look good. Your OS does not return proper information about codeset. Following code is broken: setlocale(LC_CTYPE, ctype); sys = nl_langinfo(CODESET); sys = strdup(sys); See http://www.opengroup.org/onlinepubs/00969539

[BUGS] Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (text field is boolean?)

2008-10-27 Thread Oleg Serov
I can't get hstore value by key. i have very interesting error DEMO SQL CODE: -- ROLLBACK; BEGIN; -- VERSION INFO SELECT VERSION(); -- RESULT: -- PostgreSQL 8.3.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 2

Re: [BUGS] Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (text field is boolean?)

2008-10-27 Thread hubert depesz lubaczewski
On Mon, Oct 27, 2008 at 05:08:35PM +0300, Oleg Serov wrote: > I can't get hstore value by key. i have very interesting error the problem is that -> has very low priority, but you work with it anyway: # select tconvert('a', 'b')->'a' is null; ERROR: operator does not exist: hstore -> boolean LINE

Re: [BUGS] BUG #4491: regression in gist indexes

2008-10-27 Thread Teodor Sigaev
Looks like this is a dup of #4479: Yep, exactly http://archives.postgresql.org/pgsql-bugs/2008-10/msg00094.php -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs mail

Re: [BUGS] Bug in pl/pgsql with hstore OR bug in pl/pgsql IF (text field is boolean?)

2008-10-27 Thread Oleg Serov
Ok, thanks... it is not a bug; 2008/10/27 hubert depesz lubaczewski <[EMAIL PROTECTED]>: > On Mon, Oct 27, 2008 at 05:08:35PM +0300, Oleg Serov wrote: >> I can't get hstore value by key. i have very interesting error > > the problem is that -> has very low priority, but you work with it > anyway:

[BUGS] Bug (#3484) - Missing pg_clog/0AE6

2008-10-27 Thread Alexandra Nitzschke
Hi, since our last report at 15.02.2008 we again encountered database errors: Livesystem: 30.04.2008 ERROR: invalid page header in block 12324 of relation "tzf_taf_fk" -- - 12.09.2008 Update postgres from 8.1.3 to 8.3.3. --

Re: [BUGS] Bug (#3484) - Missing pg_clog/0AE6

2008-10-27 Thread Tom Lane
Alexandra Nitzschke <[EMAIL PROTECTED]> writes: > since our last report at 15.02.2008 we again encountered database errors: > Livesystem: > 30.04.2008 ERROR: invalid page header in block 12324 of relation "tzf_taf_fk" > -- >