pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSQL state 58P01 triggered by a database script execution
4+ messages / 2 participants
[nested] [flat]
* SQL state 58P01 triggered by a database script execution
@ 2009-12-09 13:10 aymen marouani <marouani.aymen@gmail.com>
2009-12-09 13:24 ` Re: SQL state 58P01 triggered by a database script execution A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 1 reply; 4+ messages in thread
From: aymen marouani @ 2009-12-09 13:10 UTC (permalink / raw)
To: pgsql-sql
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"
Is this error related to the difference of versions ?
Thanks in advance.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: SQL state 58P01 triggered by a database script execution
2009-12-09 13:10 SQL state 58P01 triggered by a database script execution aymen marouani <marouani.aymen@gmail.com>
@ 2009-12-09 13:24 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2009-12-09 13:33 ` Re: SQL state 58P01 triggered by a database script execution aymen marouani <marouani.aymen@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: A. Kretschmer @ 2009-12-09 13:24 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: SQL state 58P01 triggered by a database script execution
2009-12-09 13:10 SQL state 58P01 triggered by a database script execution aymen marouani <marouani.aymen@gmail.com>
2009-12-09 13:24 ` Re: SQL state 58P01 triggered by a database script execution A. Kretschmer <andreas.kretschmer@schollglas.com>
@ 2009-12-09 13:33 ` aymen marouani <marouani.aymen@gmail.com>
2009-12-09 13:46 ` Re: SQL state 58P01 triggered by a database script execution A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 1 reply; 4+ messages in thread
From: aymen marouani @ 2009-12-09 13:33 UTC (permalink / raw)
To: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: SQL state 58P01 triggered by a database script execution
2009-12-09 13:10 SQL state 58P01 triggered by a database script execution aymen marouani <marouani.aymen@gmail.com>
2009-12-09 13:24 ` Re: SQL state 58P01 triggered by a database script execution A. Kretschmer <andreas.kretschmer@schollglas.com>
2009-12-09 13:33 ` Re: SQL state 58P01 triggered by a database script execution aymen marouani <marouani.aymen@gmail.com>
@ 2009-12-09 13:46 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 4+ messages in thread
From: A. Kretschmer @ 2009-12-09 13:46 UTC (permalink / raw)
To: pgsql-sql
In response to aymen marouani :
> 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 ?
Sure. But that don't solve your problem if you call that function
later...
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-12-09 13:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-12-09 13:10 SQL state 58P01 triggered by a database script execution aymen marouani <marouani.aymen@gmail.com>
2009-12-09 13:24 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2009-12-09 13:33 ` aymen marouani <marouani.aymen@gmail.com>
2009-12-09 13:46 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox