Received: from maia.hub.org (maia-1.hub.org [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 82258632190 for ; Sun, 2 May 2010 04:25:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 45632-09 for ; Sun, 2 May 2010 07:25:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from flicker.bmc.com (rubyred.bmc.com [198.147.195.5]) by mail.postgresql.org (Postfix) with SMTP id CCDC663336A for ; Sun, 2 May 2010 04:25:14 -0300 (ADT) Received: by flicker.bmc.com (Postfix, from userid 13749) id E6E251E70B0; Sun, 2 May 2010 00:25:12 -0700 (MST) Received: from PHX-HTPRD-02.adprod.bmc.com (phx-htprd-02.adprod.bmc.com [172.24.32.8]) by flicker.bmc.com (Postfix) with ESMTP id DDB131E70AD for ; Sun, 2 May 2010 00:25:12 -0700 (MST) Received: from PHXCCRPRD01.adprod.bmc.com ([172.24.32.5]) by PHX-HTPRD-02.adprod.bmc.com ([172.24.32.8]) with mapi; Sun, 2 May 2010 02:25:12 -0500 From: "Sofer, Yuval" To: "pgsql-sql@postgresql.org" CC: "Primor, Shay" Date: Sun, 2 May 2010 02:25:11 -0500 Subject: Re: regexp_replace and search/replace values stored in table Thread-Topic: [SQL] regexp_replace and search/replace values stored in table Thread-Index: AcrpU9cRZ2OSPCibTzOv4G1leFsXEwAdISOA Message-ID: <2C0926ABD16BB641A8E2F11A5492004227832AFF74@PHXCCRPRD01.adprod.bmc.com> References: <201004271343.48070.leif@solumslekt.org> <201005011929.03854.leif@solumslekt.org> In-Reply-To: <201005011929.03854.leif@solumslekt.org> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/4 X-Sequence-Number: 34052 Hi=20 Postgres crashes with - PG "FATAL: could not reattach to shared memory (key=3D5432001, addr=3D0210= 0000): Invalid argument. The version is 8.2.4, the platform is win32 Does someone know the reason/workaround ?=20 Thanks,=20 Yuval Sofer BMC Software CTM&D Business Unit DBA Team 972-52-4286-282 yuval_sofer@bmc.com -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org= ] On Behalf Of Leif Biberg Kristensen Sent: Saturday, May 01, 2010 8:29 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] regexp_replace and search/replace values stored in table Followup II: I've written a blog post on the subject at=20 . =20 regards, --=20 Leif Biberg Kristensen http://solumslekt.org/ --=20 Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql