| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Anthony Apollis <anthony(dot)apollis(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: No Data Being Inserted |
| Date: | 2023-10-11 15:14:31 |
| Message-ID: | 6596f3c2-0be5-4fae-8105-23c880808984@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atul Kumar | 2023-10-11 16:45:48 | log wal file transfer in error logs |
| Previous Message | Eugen Konkov | 2023-10-11 14:52:13 | Re: A question about possible recovery inconsistency |