upgrade from postgres 8.x to 9.x problem

From: Ray <rui(dot)vapps(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: upgrade from postgres 8.x to 9.x problem
Date: 2010-11-18 01:42:44
Message-ID: c76e15b1-7940-4bfa-b672-1e467a82878b@30g2000yql.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a table column name is called begin, tried to move it to
postgresql9 from postgresql8.4. the function failed to call
New.begin.

here is a quick test.

CREATE TABLE test(id serial primary key not null, begin timestamp
without time zone not null);
CREATE TABLE test2(id bigint not null, begin timestamp without time
zone not null);
create or replace function my_test() returns "trigger"
as $$
begin
insert into test2 values (
new.id,
new.begin);
return null;
end
$$
language plpgsql;
create trigger my_trigger after insert on test for each row execute
procedure my_test();

after create everything, run
INSERT INTO test values (default, now());

on postgresql 8.4
INSERT INTO test values (default, now());
INSERT 0 1

on postgresql 9
INSERT INTO test values (default, now());
ERROR: missing FROM-clause entry for table "new"
LINE 3: new.begin)
^
QUERY: insert into test2 values (
new.id,
new.begin)
CONTEXT: PL/pgSQL function "my_test" line 2 at SQL statement

thanks for any help!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray 2010-11-18 02:57:09 Re: upgrade from postgres 8.x to 9.x problem
Previous Message Aleksey Tsalolikhin 2010-11-18 00:51:10 feature request: log bytes out for each request