X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B780A9DC857 for ; Wed, 22 Feb 2006 12:45:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44311-01 for ; Wed, 22 Feb 2006 12:45:34 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.205]) by postgresql.org (Postfix) with ESMTP id D9EC99DC808 for ; Wed, 22 Feb 2006 12:45:32 -0400 (AST) Received: by nproxy.gmail.com with SMTP id x4so1031979nfb for ; Wed, 22 Feb 2006 08:45:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=MLW8qkRmIhkmNJJjTiITlD2Ofn0fSgdNEd+/V/d6DKU4iye6FLTNhiYjrkP7kFTabBYakBMA6GGvPmi1BDmJDQhDbcwo04ypop1TZlukGVsHTud7b/nsZc0YRVe8sl6DxQkaw98ooZqd/ch0qiXn360H6FhcYphp2x+gttGMTbE= Received: by 10.49.8.11 with SMTP id l11mr1934905nfi; Wed, 22 Feb 2006 08:45:31 -0800 (PST) Received: by 10.48.157.7 with HTTP; Wed, 22 Feb 2006 08:45:31 -0800 (PST) Message-ID: Date: Wed, 22 Feb 2006 17:45:31 +0100 From: "Christian Sengstock" To: pgsql-admin@postgresql.org Subject: broken restore.sql script !? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7632_2035766.1140626731202" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.272 required=5 tests=[HTML_10_20=0.945, HTML_MESSAGE=0.001, PLING_QUERY=0.326] X-Spam-Score: 1.272 X-Spam-Level: * X-Archive-Number: 200602/263 X-Sequence-Number: 20684 ------=_Part_7632_2035766.1140626731202 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi list, i have a auto-generated restore.sql script which doesn't work for me becaus= e 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 =3D 16, INPUT =3D box2d_in, OUTPUT =3D box2d_out, ALIGNMENT =3D int4, STORAGE =3D plain ); ALTER TYPE geo.box2d OWNER TO postgres; ---------------------------------------------------------------------------= -------------------------------------------- thankx, chris ------=_Part_7632_2035766.1140626731202 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 =3D 16,
    INPUT =3D box2d_in,
    OUTPUT =3D box2d_out,
    ALIGNMENT =3D int4,
    STORAGE =3D plain
);

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


thankx,
chris
------=_Part_7632_2035766.1140626731202--