On 03/06/2014 04:08 PM, Susan Cassidy wrote:
I'm having a problem with a trigger function. I've been googling for
over an hour, with no luck with my specific problem.
I get this error:
ERROR: missing FROM-clause entry for table "new"
LINE 1: insert into metric_double_values_201203 values (NEW.
On Wed, 3 Sep 2008, Mira Dimitrijevic wrote:
> Hi,
> I wrote the trigger function below and when trying to execute it, I
> get the following error:
>
> 15:00:42 [CREATE - 0 row(s), 0.000 secs] [Error Code: 0, SQL
> State: 42601] ERROR: syntax error at or near "INSERT"
>
> I am using DBVisuali