Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 80A9E632FE8
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  9 Dec 2009 09:34:04 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 50888-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed,  9 Dec 2009 13:33:46 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com
	[209.85.218.213])
	by mail.postgresql.org (Postfix) with ESMTP id 3142563355E
	for <pgsql-sql@postgresql.org>; Wed,  9 Dec 2009 09:33:52 -0400 (AST)
Received: by bwz5 with SMTP id 5so5255653bwz.3
	for <pgsql-sql@postgresql.org>; Wed, 09 Dec 2009 05:33:51 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:content-type;
	bh=m03J3oP1d5N2o71OXTKEKa5qs9uEE25F9l9cRjHFIl0=;
	b=lgM1dBRoCAnoYmi+VseKghZUalOEFYsMKgLQlkpZl8/p2yO0wN37Rmpur3QlGVhVRU
	oewAF28kX0BhYWnKfaJ5kwR5FDNfaDuDxBmVk3eeQN+ofM84B8v/WOflt5q1s1irT6Jx
	09BsZV6ZVWjISpXC8/0U+xIrDo4wYZpeURD3I=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:content-type;
	b=gSrROPPSgF+eNj5Jzk9dJSKfvQOVDZQAhI9eXfx3EIE0Y4dFXJ8GGsV3tl2EuZ07mi
	nYyGr97/fgIkPVHdfJV/KwvOlHYhESpTDgXpCABij5yfZRJxbh1s1v7uKDJ2DUDD7QHA
	yDQOH4dsj7TSEEccb4zuDSr/gmLAWXqEhRBEQ=
MIME-Version: 1.0
Received: by 10.204.155.73 with SMTP id r9mr6658850bkw.14.1260365627307; Wed,
	09 Dec 2009 05:33:47 -0800 (PST)
In-Reply-To: <20091209132454.GC5519@a-kretschmer.de>
References: <bebe9cb90912090510w67d1265cq789b39b79ccef396@mail.gmail.com>
	<20091209132454.GC5519@a-kretschmer.de>
Date: Wed, 9 Dec 2009 14:33:47 +0100
Message-ID: <bebe9cb90912090533s7e2c945ei65f9beb06b63c4fe@mail.gmail.com>
Subject: Re: SQL state 58P01 triggered by a database script execution
From: aymen marouani <marouani.aymen@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0015175cfa8e80b7cc047a4bbdb2
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.994 tagged_above=-10 required=5 tests=AWL=0.604,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200912/25
X-Sequence-Number: 33463

--0015175cfa8e80b7cc047a4bbdb2
Content-Type: text/plain; charset=ISO-8859-1

Thanks for the help,

In deed I found those lines in my script

"--
-- TOC entry 25 (class 1255 OID 16409)
-- Dependencies: 6
-- Name: bt_metap(text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION bt_metap(relname text, OUT magic integer, OUT version
integer, OUT root integer, OUT level integer, OUT fastroot integer, OUT
fastlevel integer) RETURNS record
    AS '$libdir/pageinspect', 'bt_metap'
    LANGUAGE c STRICT;
"

Can I comment those lines to remove the error ?

2009/12/9 A. Kretschmer <andreas.kretschmer@schollglas.com>

> In response to aymen marouani :
> > Hi,
> >
> > I have a database under Postgres v8.3 and I generated its backups script
> using
> > PGAdmin III.
> > I executed the same script under Postgres v8.2 in order to create the
> same
> > database but I get the following error
> >
> > " ERROR: could not access file "$libdir/pageinspect": No such file or
> directory
> >   SQL state :58P01"
> >
>
> Pageinspect is a contrib-modul, so i think, you should install that. But
> i don't know if this available for 8.2.
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
> GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

--0015175cfa8e80b7cc047a4bbdb2
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks for the help,<div><br></div><div>In deed I found th=
ose lines in my script</div><div><br></div><div>&quot;--</div><div>-- TOC e=
ntry 25 (class 1255 OID 16409)</div><div>-- Dependencies: 6</div><div>-- Na=
me: bt_metap(text); Type: FUNCTION; Schema: public; Owner: postgres</div>
<div>--</div><div><br></div><div>CREATE FUNCTION bt_metap(relname text, OUT=
 magic integer, OUT version integer, OUT root integer, OUT level integer, O=
UT fastroot integer, OUT fastlevel integer) RETURNS record</div><div>=A0=A0=
 =A0AS &#39;$libdir/pageinspect&#39;, &#39;bt_metap&#39;</div>
<div>=A0=A0 =A0LANGUAGE c STRICT;</div><div>&quot;</div><div><br></div><div=
>Can I comment those lines to remove the error ?</div><div><br><div class=
=3D"gmail_quote">2009/12/9 A. Kretschmer <span dir=3D"ltr">&lt;<a href=3D"m=
ailto:andreas.kretschmer@schollglas.com">andreas.kretschmer@schollglas.com<=
/a>&gt;</span><br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">In response to aymen marouani :<br>
<div class=3D"im">&gt; Hi,<br>
&gt;<br>
&gt; I have a database under Postgres v8.3 and I generated its backups scri=
pt using<br>
&gt; PGAdmin III.<br>
&gt; I executed the same script under Postgres v8.2 in order to create the =
same<br>
&gt; database but I get the following error<br>
&gt;<br>
&gt; &quot; ERROR: could not access file &quot;$libdir/pageinspect&quot;: N=
o such file or directory<br>
&gt; =A0=A0SQL state :58P01&quot;<br>
&gt;<br>
<br>
</div>Pageinspect is a contrib-modul, so i think, you should install that. =
But<br>
i don&#39;t know if this available for 8.2.<br>
<br>
<br>
Andreas<br>
--<br>
Andreas Kretschmer<br>
Kontakt: =A0Heynitz: 035242/47150, =A0 D1: 0160/7141639 (mehr: -&gt; Header=
)<br>
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 =A02EB0 389D 1DC2 3172 0C99<br>
<font color=3D"#888888"><br>
--<br>
Sent via pgsql-sql mailing list (<a href=3D"mailto:pgsql-sql@postgresql.org=
">pgsql-sql@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-sql" target=3D"_blank">=
http://www.postgresql.org/mailpref/pgsql-sql</a><br>
</font></blockquote></div><br></div></div>

--0015175cfa8e80b7cc047a4bbdb2--