Postgres Pro
Downloads
Home   >   mailing lists

Re: insert into table - Mailing list pgsql-admin

From Yambu
Subject Re: insert into table
Date
Msg-id CALhHtcBtCT8qMpqd+z2mC+eByzUBXCLES_TeRUKJgm92mbLSyw@mail.gmail.com
Whole thread Raw
In response to Re: insert into table  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
Hi David

There is no error, it just says zero rows affected, but when i run select it brings results

On Sat, May 29, 2021 at 6:29 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, May 28, 2021 at 9:22 PM Yambu <hyambu@gmail.com> wrote:
may i know why the below mysql is not inserting into table analyze_checks
insert into analyze_checks(dbname,table_name,frag_ratio, days,needs_optimization,needs_analyzing )
(select


Since I don't have the benefit of seeing an error message I'm going to presume the parentheses surrounding the select query are being rejected.

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: insert into table
Next
From: Holger Jakobs
Date:
Subject: Re: Upgrading password encryption from md5 to scram-sh-256