On 2010-11-18 03.57, Ray wrote:
On Nov 17, 8:42 pm, Ray wrote:
-- snip ---
figured out. the begin is keyword and need to double quoted.
This is one strong reason why you should avoid using keywords as object
names. Better to fix that early in the design since names has a tendency
to s
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, b
On Nov 17, 8:42 pm, Ray wrote:
> 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 no
