Re: ERROR: invalid input syntax for integer: "INSERT"

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Robert Lakes <robertl(at)propaas(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: invalid input syntax for integer: "INSERT"
Date: 2017-11-05 04:05:08
Message-ID: CAKFQuwYoYYz8fek_a6mZPuN74=sFp+gkdNEqWAW+PPAo7k=2Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, November 4, 2017, Robert Lakes <robertl(at)propaas(dot)com> wrote:
>
> Here's the error I am receiving - when I am attempting to insert a record
> into a table:
>
> ERROR: invalid input syntax for integer: "INSERT"
> LINE 1: ...T INTO listings_cdc SELECT statement_timestamp(), 'INSERT', ...
>
>

The second column of listings_cdc has a type of integer. The word INSERT
is not a valid value to store there.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neto pr 2017-11-05 12:49:18 Runtime analysis
Previous Message Robert Lakes 2017-11-05 03:57:16 ERROR: invalid input syntax for integer: "INSERT"