Re: Build from file syntax troublem (part II).

From: Radtchenko Igor <inta(at)komi(dot)parma(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Build from file syntax troublem (part II).
Date: 2005-03-07 10:21:47
Message-ID: 936719781.20050307132147@komi.parma.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <inta(at)komi(dot)parma(dot)ru> 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(at)komi(dot)parma(dot)ru

Attachment Content-Type Size
nibs.errs application/octet-stream 3.4 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markus Schaber 2005-03-07 12:01:59 Re: [SQL] Postgres schema comparison.
Previous Message Stef 2005-03-07 09:33:12 Postgres schema comparison.