Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E7DD61337B7E for ; Fri, 14 Jan 2011 18:41:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 67348-03 for ; Fri, 14 Jan 2011 22:41:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 7C38E133616B for ; Fri, 14 Jan 2011 18:41:32 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p0EMfV3c013138; Fri, 14 Jan 2011 17:41:31 -0500 (EST) To: Fabricio cc: pgsql-admin@postgresql.org Subject: Re: PostgreSQL 9.0.2. This is a Bug? In-reply-to: References: Comments: In-reply-to Fabricio message dated "Fri, 14 Jan 2011 14:45:13 -0700" Date: Fri, 14 Jan 2011 17:41:31 -0500 Message-ID: <13137.1295044891@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/95 X-Sequence-Number: 36535 Fabricio writes: > A developer is writing a function in C code and when he makes some change and replace the old library with the new one and if run CREATE OR REPLACE FUNCTION Postgre crash and restart. After restart CREATE OR REPLACE FUNCTION does not crash postgres, only the first time. He makes a function test. You didn't say what platform this is, but overwriting an actively-used .so file isn't a safe thing to do on all systems. There's nothing Postgres can do about that. regards, tom lane