broken restore.sql script !?

From: "Christian Sengstock" <csengstock(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: broken restore.sql script !?
Date: 2006-02-22 16:45:31
Message-ID: febbf1590602220845t6160e88do@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi list,

i have a auto-generated restore.sql script which doesn't work for me because
of an obvious error inside of it. because the script is working for other
people i thought of an os error (i use linux, others windows).

the problem:

The function is created outside of the 'geo' schema, but after that, the
'alter function' statement tries to alter the function inside of the 'geo'
schema. the restore.sql file is from pgadmin. maybe there's a statement so
that the function could be created inside of the geo schema without writing
it explicit. like '\set search_path', so that i can restore it on the linux
command line.

some lines of it: ...

------------------------------------------------------------------------------------------------------
--
-- Name: box2d_out(box2d); Type: FUNCTION; Schema: geo; Owner: postgres
--

CREATE FUNCTION box2d_out(box2d) RETURNS cstring
AS '$libdir/liblwgeom.so', 'BOX2DFLOAT4_out'
LANGUAGE c IMMUTABLE STRICT;

ALTER FUNCTION geo.box2d_out(box2d) OWNER TO postgres;

--
-- Name: box2d; Type: TYPE; Schema: geo; Owner: postgres
--

CREATE TYPE box2d (
INTERNALLENGTH = 16,
INPUT = box2d_in,
OUTPUT = box2d_out,
ALIGNMENT = int4,
STORAGE = plain
);

ALTER TYPE geo.box2d OWNER TO postgres;
-----------------------------------------------------------------------------------------------------------------------

thankx,
chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-02-22 17:00:04 Re: broken restore.sql script !?
Previous Message Andy Shellam 2006-02-22 16:26:49 WAL recovery