X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 090DF556D3 for ; Sat, 5 Mar 2005 22:48:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68448-04 for ; Sat, 5 Mar 2005 22:48:37 +0000 (GMT) Received: from ns.parma.ru (mail.parma.ru [217.24.112.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4257E52D8A for ; Sat, 5 Mar 2005 22:48:29 +0000 (GMT) Received: from inta (ip-217-24-121-31.parma.ru [217.24.121.31]) by ns.parma.ru (8.13.1/8.11.4) with SMTP id j25MTAmX016784 for ; Sun, 6 Mar 2005 01:29:12 +0300 Content-Type: text/plain; charset="koi8-r" From: Igor Radtchenko To: pgsql-admin@postgresql.org Subject: Build from file syntax troublem. Date: Sun, 6 Mar 2005 01:45:01 +0300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <05030601450100.01195@inta> Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.868 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/66 X-Sequence-Number: 16564 Hello, All! I have to fiil datebase from file contains strings alike such: CREATE SEQUENCE public.blacklist_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE2147483647 CACHE 1; and CREATE FUNCTION public.from_days(int4) RETURNS timestamp AS ' select ''0000-01-02''::timestamp + ($1 || '' days'')::interval as result ' LANGUAGE 'sql' VOLATILE; The parser abuse that 'parse error at or near '"." ', 'parse error at or near "public'" ', 'parse error at or near "#'" '. PostgeSQL version is 7.2.3. I've nowhere found isuch syntax in the net (I mean with dot - 'public.funcname(...)'). There is plpgsql only in the database; When I try ./createlang -dbname=mydb sql it says "unsupported language". But SELECT * FROM pg_language show that it's present. Where I'm wrong? Successes & good luck for all, Igor