broken restore.sql script !?

Поиск
Список
Период
Сортировка
От Christian Sengstock
Тема broken restore.sql script !?
Дата
Msg-id febbf1590602220845t6160e88do@mail.gmail.com
обсуждение исходный текст
Ответы Re: broken restore.sql script !?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Andy Shellam
Дата:
Сообщение: WAL recovery
Следующее
От: Tom Lane
Дата:
Сообщение: Re: broken restore.sql script !?