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 33E3256002 for ; Mon, 7 Mar 2005 10:22:09 +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 01269-07 for ; Mon, 7 Mar 2005 10:21:59 +0000 (GMT) Received: from ns.parma.ru (mail.parma.ru [217.24.112.2]) by svr1.postgresql.org (Postfix) with ESMTP id D1F9455ED3 for ; Mon, 7 Mar 2005 10:21:53 +0000 (GMT) Received: from 192.168.1.5 (ip-217-24-121-221.parma.ru [217.24.121.221]) by ns.parma.ru (8.13.1/8.11.4) with ESMTP id j27AJ2M8030123 for ; Mon, 7 Mar 2005 13:19:03 +0300 Date: Mon, 7 Mar 2005 13:21:47 +0300 From: Radtchenko Igor X-Mailer: The Bat! (v1.51) Personal Reply-To: Radtchenko Igor X-Priority: 3 (Normal) Message-ID: <936719781.20050307132147@komi.parma.ru> To: pgsql-admin@postgresql.org Subject: Re: Build from file syntax troublem (part II). In-Reply-To: <27861.1110065906@sss.pgh.pa.us> References: <05030601450100.01195@inta> <27861.1110065906@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----------3871AC1E7D413" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.323 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/74 X-Sequence-Number: 16572 ------------3871AC1E7D413 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello Tom, Thank you very much for such fast reply. But now, after I've installed 8.0.1, it says things as examples in little attach. <------ Where I have to dig?.. :( Sunday, March 06, 2005, 2:38:26 AM, you wrote: TL> Igor Radtchenko writes: >> 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. TL> You need 7.3 or later to deal with schema-aware commands. TL> regards, tom lane -- Best regards, Radtchenko mailto:inta@komi.parma.ru ------------3871AC1E7D413 Content-Type: application/octet-stream; name="nibs.errs" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="nibs.errs" ZnJlZW5pYnM9IyBDUkVBVEUgRlVOQ1RJT04gcHVibGljLmlmKGludDQsIGludDQsIGludDQpIFJF VFVSTlMgaW50NCBBUyAnCmZyZWVuaWJzJyMgREVDTEFSRQpmcmVlbmlicycjICBleHByMSBBTElB UyBGT1IgJDE7CmZyZWVuaWJzJyMgIGV4cHIyIEFMSUFTIEZPUiAkMjsKZnJlZW5pYnMnIyAgZXhw cjMgQUxJQVMgRk9SICQzOwpmcmVlbmlicycjCmZyZWVuaWJzJyMgQkVHSU4KZnJlZW5pYnMnIyAg SUYgZXhwcjEgaXMgbnVsbCBUSEVOCmZyZWVuaWJzJyMgICByZXR1cm4gZXhwcjM7CmZyZWVuaWJz JyMgIEVORCBJRjsKZnJlZW5pYnMnIwpmcmVlbmlicycjICBJRiBleHByMT0wIFRIRU4KZnJlZW5p YnMnIyAgIHJldHVybiBleHByMzsKZnJlZW5pYnMnIyAgRU5EIElGOwpmcmVlbmlicycjCmZyZWVu aWJzJyMgIFJFVFVSTiBleHByMjsKZnJlZW5pYnMnIwpmcmVlbmlicycjIEVORDsKZnJlZW5pYnMn IyAnICBMQU5HVUFHRSAnc3FsJyBWT0xBVElMRTsKRVJST1I6ICBzeW50YXggZXJyb3IgYXQgb3Ig bmVhciAiQUxJQVMiIGF0IGNoYXJhY3RlciA3OApMSU5FIDM6ICBleHByMSBBTElBUyBGT1IgJDE7 CgpmcmVlbmlicz0jIENSRUFURSBUQUJMRSBwdWJsaWMudXNlcnMgKApmcmVlbmlicygjICAgICB1 c2VybmFtZSB2YXJjaGFyKDY0KSBiaW5hcnkgREVGQVVMVCAnJyBOT1QgTlVMTCwKZnJlZW5pYnMo IyAgICAgdXNlcnBhc3MgdmFyY2hhcigyNTQpIGJpbmFyeSBERUZBVUxUICcqJyBOT1QgTlVMTCwK ZnJlZW5pYnMoIyAgICAgY3J5cHRfbWV0aG9kIGludDIgREVGQVVMVCAnMScgTk9UIE5VTEwsCmZy ZWVuaWJzKCMgICAgIHVpZCBpbnQ4IERFRkFVTFQgbmV4dHZhbCgndXNlcl91aWRfc2VxJzo6dGV4 dCkgTk9UIE5VTEwsCmZyZWVuaWJzKCMgICAgIGdpZCBpbnQ0IERFRkFVTFQgJzEnIE5PVCBOVUxM LApmcmVlbmlicygjICAgICBkZXBvc2l0IGZsb2F0OCBERUZBVUxUICcwLjAwMDAwMCcgTk9UIE5V TEwsCmZyZWVuaWJzKCMgICAgIGNyZWRpdCBmbG9hdDggREVGQVVMVCAnMC4wMDAwMDAnIE5PVCBO VUxMLApmcmVlbmlicygjICAgICBmaW8gdmFyY2hhcigxMjgpIERFRkFVTFQgJycgTk9UIE5VTEws CmZyZWVuaWJzKCMgICAgIHBob25lIHZhcmNoYXIoMTI4KSBERUZBVUxUICcnIE5PVCBOVUxMLApm cmVlbmlicygjICAgICBhZGRyZXNzIHZhcmNoYXIoMTI4KSBERUZBVUxUICcnIE5PVCBOVUxMLApm cmVlbmlicygjICAgICBwcmltIHZhcmNoYXIoMjU0KSBERUZBVUxUICcnIE5PVCBOVUxMLApmcmVl bmlicygjICAgICBhZGRfZGF0ZSBkYXRlIERFRkFVTFQgJzAwMDAtMDAtMDAnIE5PVCBOVUxMLApm cmVlbmlicygjICAgICBibG9ja2VkIGludDIgREVGQVVMVCAnMCcgTk9UIE5VTEwsCmZyZWVuaWJz KCMgICAgIGFjdGl2YXRlZCBpbnQyIERFRkFVTFQgJzEnIE5PVCBOVUxMLApmcmVlbmlicygjICAg ICBleHBpcmVkIGRhdGUgTk9UIE5VTEwgZGVmYXVsdCAnMDAwMC0wMC0wMCcsCmZyZWVuaWJzKCMg ICAgIHRvdGFsX3RpbWUgaW50NCBERUZBVUxUIDAgTk9UIE5VTEwsCmZyZWVuaWJzKCMgICAgIHRv dGFsX3RyYWZmaWMgaW50OCBERUZBVUxUICcwJyBOT1QgTlVMTCwKZnJlZW5pYnMoIyAgICAgdG90 YWxfbW9uZXkgZmxvYXQ4IERFRkFVTFQgJzAuMDAwMDAwJyBOT1QgTlVMTCwKZnJlZW5pYnMoIyAg ICAgbGFzdF9jb25uZWN0aW9uIGRhdGUgREVGQVVMVCAnMDAwMC0wMC0wMCcgTk9UIE5VTEwsCmZy ZWVuaWJzKCMgICAgIGZyYW1lZF9pcCB2YXJjaGFyKDE2KSBERUZBVUxUICcnIE5PVCBOVUxMLApm cmVlbmlicygjICAgICBmcmFtZWRfbWFzayB2YXJjaGFyKDE2KSBERUZBVUxUICcnIE5PVCBOVUxM LApmcmVlbmlicygjICAgICBjYWxsYmFja19udW1iZXIgdmFyY2hhcig2NCkgREVGQVVMVCAnJyBO T1QgTlVMTCwKZnJlZW5pYnMoIyAgICAgQ09OU1RSQUlOVCB1c2Vyc19wa2V5IFBSSU1BUlkgS0VZ ICh1aWQpCmZyZWVuaWJzKCMgKSBXSVRIIE9JRFM7CkVSUk9SOiAgc3ludGF4IGVycm9yIGF0IG9y IG5lYXIgImJpbmFyeSIgYXQgY2hhcmFjdGVyIDU0CkxJTkUgMjogICAgIHVzZXJuYW1lIHZhcmNo YXIoNjQpIGJpbmFyeSBERUZBVUxUICcnIE5PVCBOVUxMLAoKZnJlZW5pYnM9IyBDUkVBVEUgVEFC TEUgcHVibGljLmFjdGlvbnMgKApmcmVlbmlicygjICAgICB1c2VybmFtZSB2YXJjaGFyKDY0KSBE RUZBVUxUICcnIE5PVCBOVUxMLApmcmVlbmlicygjICAgICBnaWQgaW50NCBERUZBVUxUICcwJyBO T1QgTlVMTCwKZnJlZW5pYnMoIyAgICAgaWQgdmFyY2hhcigzMikgREVGQVVMVCAnJyBOT1QgTlVM TCwKZnJlZW5pYnMoIyAgICAgdW5pcXVlX2lkIHZhcmNoYXIoNjQpIERFRkFVTFQgJycgTk9UIE5V TEwsCmZyZWVuaWJzKCMgICAgIHRpbWVfb24gaW50NCwKZnJlZW5pYnMoIyAgICAgc3RhcnRfdGlt ZSB0aW1lc3RhbXAgREVGQVVMVCAnMjAwMy0wMS0wMSAwMDowMDowMCcsCmZyZWVuaWJzKCMgICAg IHN0b3BfdGltZSB0aW1lc3RhbXAgREVGQVVMVCAnMDAwMC0wMC0wMCAwMDowMDowMCcsCmZyZWVu aWJzKCMgICAgIGluX2J5dGVzIGludDgsCmZyZWVuaWJzKCMgICAgIG91dF9ieXRlcyBpbnQ4LApm cmVlbmlicygjICAgICBpcCB2YXJjaGFyKDE2KSBERUZBVUxUICcnIE5PVCBOVUxMLApmcmVlbmli cygjICAgICBzZXJ2ZXIgdmFyY2hhcigxNikgREVGQVVMVCAnJyBOT1QgTlVMTCwKZnJlZW5pYnMo IyAgICAgY2xpZW50X2lwIHZhcmNoYXIoMTYpIERFRkFVTFQgJycgTk9UIE5VTEwsCmZyZWVuaWJz KCMgICAgIHBvcnQgaW50NCwKZnJlZW5pYnMoIyAgICAgY2FsbF90byB2YXJjaGFyKDY0KSBERUZB VUxUICcnIE5PVCBOVUxMLApmcmVlbmlicygjICAgICBjYWxsX2Zyb20gdmFyY2hhcig2NCkgREVG QVVMVCAnJyBOT1QgTlVMTCwKZnJlZW5pYnMoIyAgICAgY29ubmVjdF9pbmZvIHZhcmNoYXIoMjU0 KSwKZnJlZW5pYnMoIyAgICAgcHJvdG9jb2wgdmFyY2hhcigzMiksCmZyZWVuaWJzKCMgICAgIHRl cm1pbmF0ZV9jYXVzZSB2YXJjaGFyKDY0KSBERUZBVUxUICcnIE5PVCBOVUxMLApmcmVlbmlicygj ICAgICBob3VyX2luX2J5dGVzIGludDggREVGQVVMVCAnMCcgTk9UIE5VTEwsCmZyZWVuaWJzKCMg ICAgIGhvdXJfb3V0X2J5dGVzIGludDggREVGQVVMVCAnMCcgTk9UIE5VTEwsCmZyZWVuaWJzKCMg ICAgIGhvdXJfdHJhZmZpY19tb25leSBmbG9hdDggREVGQVVMVCAnMC4wMDAwMDAnIE5PVCBOVUxM LApmcmVlbmlicygjICAgICBsYXN0X2NoYW5nZSBpbnQ0IERFRkFVTFQgJzAnIE5PVCBOVUxMLApm cmVlbmlicygjICAgICBiZWZvcmVfYmlsbGluZyBmbG9hdDggREVGQVVMVCAnMC4wMDAwMDAnIE5P VCBOVUxMLApmcmVlbmlicygjICAgICBiaWxsaW5nX21pbnVzIGZsb2F0OCBERUZBVUxUICcwLjAw MDAwMCcgTk9UIE5VTEwsCmZyZWVuaWJzKCMgKSBXSVRIIE9JRFM7CkVSUk9SOiAgc3ludGF4IGVy cm9yIGF0IG9yIG5lYXIgIikiIGF0IGNoYXJhY3RlciAxMDE3CkxJTkUgMjY6ICkgV0lUSCBPSURT OwoK ------------3871AC1E7D413--