Rhhh Lin writes:
> So I decided to intervene and terminate some active sessions (Which were
> active and not waiting) which were all querying this table with a similar
> query, by using pg_backend_terminate(pid). Some of these sessions were in an
> active state for a few days executing this que
Hi All,
While trying to track down my logical decoding problem, I noticed that
my pg_logical/snapshots directory has ~5000 .snap files and is growing at a
rate of about 4 files a minute. The earliest file is from yesterday
afternoon, dating to the time I took our site down and added a column to a
Guys,
New to Postgres - here's my code inside an event trigger:
ELSIF (TG_OP = 'INSERT') THEN
EXECUTE format('INSERT INTO %I SELECT statement_timestamp(),
''INSERT'', $1.*', TG_TABLE_NAME || '_cdc')
USING NEW;
RETURN NEW;
Here's the error I am receiving - when I am attempt
On Saturday, November 4, 2017, Robert Lakes 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 colum
