Re: Trouble with NEW

When I substitute new.fluid_id for the actual fluid)id the expression
returns the right value.

Following is the table -

CREATE TABLE p_id.fluids
(
  p_id_id integer,
  fluid_id serial,
  text_arrow geometry,
  line geometry,
  ip_op_equipment character varying(3),
  pipe_number character varying(100),
  pipe_size character varying,
  pipe_size_unit varchar (30),
  pipe_schedule varchar (30),
  dest_process varchar (30),
  dest_pump varchar (30),
  dest_pid varchar (30),
  source_process varchar (30),
  source_pump varchar (30),
  source_pid varchar (30),
  fluid_short character varying (10),
  fluid_name character varying(100),
  pump1 character varying(5),
  pump2 character varying(5),

  CONSTRAINT fluid_pk PRIMARY KEY (fluid_id)
);

Bob
-----Original Message-----
From: Adrian Klaver
Sent: Wednesday, July 18, 2012 1:07 PM
To: Bob Pawley
Cc: Alan Hodgson ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Trouble with NEW

On 07/18/2012 12:28 PM, Bob Pawley wrote:
> It's an insert after trigger function.
>
> The table has a column named fluid_id.

Can we see the table schema. What I am looking for is quoted column name
that would preserve case.

>
> Bob



--
Adrian Klaver
adrian.klaver@gmail.com