Re: No Data Being Inserted - Mailing list pgsql-general

From Adrian Klaver
Subject Re: No Data Being Inserted
Date
Msg-id 6596f3c2-0be5-4fae-8105-23c880808984@aklaver.com
Whole thread Raw
In response to No Data Being Inserted  (Anthony Apollis <anthony.apollis@gmail.com>)
List pgsql-general
On 10/11/23 04:46, Anthony Apollis wrote:
> I have a table that i populate using joins.
> One of the tables don't insert its data. Tables are:

> My Test to see if the data has been inserted:
> image.png
> I get blanks or no output for above test.
> 
> My Source Tables have data:
> image.png
> Can't seem to figure out where the issue is.


1) Verify that your client is not lying to you, use psql to see if there 
is data in the table.

2) Look at the Postgres log to see what is happening. You would want
log_statement in postgresql.conf to be at least 'mod'.

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Eugen Konkov
Date:
Subject: Re: A question about possible recovery inconsistency
Next
From: Atul Kumar
Date:
Subject: log wal file transfer in error logs