Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 73B991337B8C
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 14 Jan 2011 18:53:47 -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 81566-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 14 Jan 2011 22:53:40 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from snt0-omc2-s48.snt0.hotmail.com (snt0-omc2-s48.snt0.hotmail.com
	[65.54.61.99])
	by mail.postgresql.org (Postfix) with ESMTP id 117741337B7E
	for <pgsql-admin@postgresql.org>; Fri, 14 Jan 2011 18:53:39 -0400 (AST)
Received: from SNT139-W3 ([65.55.90.71]) by snt0-omc2-s48.snt0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.4675);
	Fri, 14 Jan 2011 14:53:38 -0800
Message-ID: <SNT139-w3FD290E618C8FFD3ECD80FEF30@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_3aaefd17-131a-4074-95a5-2499b0362251_"
X-Originating-IP: [189.186.159.225]
From: Fabricio <fabrixio1@hotmail.com>
To: <tgl@sss.pgh.pa.us>
CC: <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL 9.0.2. This is a Bug?
Date: Fri, 14 Jan 2011 15:53:37 -0700
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 14 Jan 2011 22:53:38.0259 (UTC)
	FILETIME=[E1AFCA30:01CBB43D]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.354 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553,
	FREEMAIL_FROM=0.001,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201101/96
X-Sequence-Number: 36536

--_3aaefd17-131a-4074-95a5-2499b0362251_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable







Linux Slackware 13.1gcc 4.5.1

This .so files works fine in older postgres's versions.Postgres has support=
 for this=2C but postgres team says do not use it?
thanks tom=2C regards...=20


> To: fabrixio1@hotmail.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] PostgreSQL 9.0.2. This is a Bug?=20
> Date: Fri=2C 14 Jan 2011 17:41:31 -0500
> From: tgl@sss.pgh.pa.us
>=20
> Fabricio <fabrixio1@hotmail.com> writes:
> > A developer is writing a function in C code and when he makes some chan=
ge and replace the old library with the new one and if run CREATE OR REPLAC=
E FUNCTION Postgre crash and restart. After restart CREATE OR REPLACE FUNCT=
ION does not crash postgres=2C only the first time. He makes a function tes=
t. =20
>=20
> You didn't say what platform this is=2C 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.
>=20
> 			regards=2C tom lane

 		 	   		  =

--_3aaefd17-131a-4074-95a5-2499b0362251_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style>
</head>
<body class=3D'hmmessage'>


<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style>

<div><br></div>Linux Slackware 13.1<div>gcc 4.5.1</div><div><br></div><div>=
<br></div><div>This .so files works fine in older postgres's versions.</div=
><div>Postgres has support for this=2C but postgres team says do not use it=
?</div><div><br></div><div>thanks tom=2C regards...&nbsp=3B</div><div><br><=
/div><div><br><br>&gt=3B To: fabrixio1@hotmail.com<br>&gt=3B CC: pgsql-admi=
n@postgresql.org<br>&gt=3B Subject: Re: [ADMIN] PostgreSQL 9.0.2. This is a=
 Bug? <br>&gt=3B Date: Fri=2C 14 Jan 2011 17:41:31 -0500<br>&gt=3B From: tg=
l@sss.pgh.pa.us<br>&gt=3B <br>&gt=3B Fabricio &lt=3Bfabrixio1@hotmail.com&g=
t=3B writes:<br>&gt=3B &gt=3B A developer is writing a function in C code a=
nd when he makes some change and replace the old library with the new one a=
nd if run CREATE OR REPLACE FUNCTION Postgre crash and restart. After resta=
rt CREATE OR REPLACE FUNCTION does not crash postgres=2C only the first tim=
e. He makes a function test.  <br>&gt=3B <br>&gt=3B You didn't say what pla=
tform this is=2C but overwriting an actively-used<br>&gt=3B .so file isn't =
a safe thing to do on all systems.  There's nothing<br>&gt=3B Postgres can =
do about that.<br>&gt=3B <br>&gt=3B 			regards=2C tom lane<br></div>
 		 	   		  </body>
</html>=

--_3aaefd17-131a-4074-95a5-2499b0362251_--