Re: [GENERAL] enable thready safety on Mac OS X 10.3.4

2004-07-05 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > On 6/26/04 3:01 PM, "Keary Suska" <[EMAIL PROTECTED]> wrote: > > >> I attempted to compile 7.4.3 with enable-thread-safety but it fails and > >> says it's not supported. My configure command was: > >> > >> ./configure --enable-thread-safety > > > > This is what I did f

Re: [GENERAL] could not access file "$libdir/plpython" when

2004-07-05 Thread mike g
Seems your FC2 box did not have the python language support compiled into the version of postgresql that was installed on that box or possibly not installed in the template1 database so it would be available to any other database created in your FC2. I do believe python is included in the rpm ve

Re: [GENERAL] SUBSTRING for a regular expression

2004-07-05 Thread mike g
What language are you using for this plperl? That command listed in the documentation certainly works in psql or plpgsql but I don't know about plperl. Are you assigning the result to a variable and then printing the result of that variable before the function ends or printing based on what the f

Re: [GENERAL] Multi-Language upper(),lower()

2004-07-05 Thread Bruce Momjian
Tom Lane wrote: > Ara Anjargolian <[EMAIL PROTECTED]> writes: > > Am I mistaken, or was multi-language support for > > upper(), lower() and friends recently added to 7.5? > > I fixed upper/lower so that they would work on multi-byte character set > encodings, given that the platform supports the

Re: [GENERAL] server closed the connection unexpectedly

2004-07-05 Thread mike g
Can you use pg_dump to backup the database and possibly then upgrade the db? 7.2 is rather old. I recall reading similar postings in the mailing this that recommend you upgrade to 7.2.4 or .6(?) if you must stay on 7.2. On Mon, 2004-07-05 at 17:48, ruben wrote: > Hi: > > I'm getting this error

[GENERAL] could not access file "$libdir/plpython" when restoring

2004-07-05 Thread Clodoaldo Pinto Neto
Hi all, I'm restoring a database from 7.3.4 FC1 to 7.4.2 FC2: [EMAIL PROTECTED] bak]$ pg_restore -d KakaoStats KakaoStats.dump pg_restore: [compressão de arquivo (banco de dados)] could not execute query: ERROR: could not access file "$libdir/plpython": No such file or directory The dump was ge

[GENERAL] SUBSTRING for a regular expression

2004-07-05 Thread btober
I can't seem to get right the regular expression for parsing data like these four sample rows (names and addresses changed to ficticious values) from a text-type column: Yolanda Harris, 38, of 40 South Main St., Newtown City, was charged Sunday with breach of peace and interfering with a police of

[GENERAL] server closed the connection unexpectedly

2004-07-05 Thread ruben
Hi: I'm getting this error when accessing a table with certain WHERE condition: "server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed." I've read through

Re: [GENERAL] ERROR: tables can have at most 1600 columns

2004-07-05 Thread Ron St-Pierre
Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: On Sun, Jun 27, 2004 at 11:11:32AM -0700, Ron St-Pierre wrote: STATEMENT: ALTER TABLE victoria.eodData DROP COLUMN tickDate; ERROR: tables can have at most 1600 columns STATEMENT: ALTER TABLE victoria.eodData ADD COLUMN tickerID