Re: [HACKERS] [GENERAL] PG crash on simple query, story continues

2003-07-11 Thread Maksim Likharev
So following modification seems to fixed all PG (7.3/7.3.3)crashes on Solaris ( NON C LOCALE ) selfuncs.c line 2356: I changed: xfrmsize = strlen(val) + 32;/*arbitrary pad value here...*/ to xfrmsize = strxfrm(NULL, val, 0) + 32; so basically instead of wild guess of transformed string size

Re: [HACKERS] again: Bug #943: Server-Encoding from

2003-07-11 Thread Enke, Michael
Tatsuo Ishii wrote: > > > I have looked into my Linux box and found this in /usr/share/i18n/charmaps/BIG5.gz: > > % Chinese charmap for BIG5 (CP950) > > % version: 0.92 > > % Contact: Tung-Han Hsieh <[EMAIL PROTECTED]> > > % Yuan-Chung Cheng <[EMAIL PROTECTED]> > > % Distribution and us

[HACKERS] corrupt data

2003-07-11 Thread Zeno R.R. Davatz
Hi List Out of some reason our data of our postgresql database has been corrupted. When we try to connect to the database we get: psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type_oid_index: No such file or directory REINDEX does not work. We get the same error. pgfsck gives us: wro

Re: [HACKERS] Transaction handling in extended query mode and Sync

2003-07-11 Thread Francisco Figueiredo Jr.
Carlos Guzman Alvarez wrote: Hello: Hello Carlos. I continue to work in the implementation of the 3.0 protocol in C#, i'm making a test that consist on: - Create a database. - Create a table in the new database. - Start transaction. - Insert 100 rows of data in the new table. - Commit transacti

Re: [HACKERS] btree fast-root on VACUUM FULL

2003-07-11 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Would it be right to set the fast-root as true root during a VACUUM > FULL? This would free all pages between true root and fast root. Possibly okay, but why bother? It's hardly likely to free a meaningful number of pages. And I think you'd need to i

[HACKERS] btree fast-root on VACUUM FULL

2003-07-11 Thread Alvaro Herrera
Hackers (especially Tom), Would it be right to set the fast-root as true root during a VACUUM FULL? This would free all pages between true root and fast root. (I'm not advocating to do it, nor volunteering; I'm merely wondering). -- Alvaro Herrera () "Ninguna manada de bestias tiene una voz ta