Re: pg_dump insert column GENERATED - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_dump insert column GENERATED
Date
Msg-id 15ee1aef-6b36-dc58-a610-b0f665ac652a@aklaver.com
Whole thread Raw
In response to Re: pg_dump insert column GENERATED  (Дмитрий Иванов <firstdismay@gmail.com>)
Responses Re: pg_dump insert column GENERATED  (Дмитрий Иванов <firstdismay@gmail.com>)
List pgsql-general
On 11/21/21 07:23, Дмитрий Иванов wrote:
> Yes and yes.
> I don't get regular results in my experiments. I filled in some of the 
> tables this morning, but now I can't do it again.
>  > INSERT INTO bpd.plan_calendar (create in version 12)
>  > OK
> I can't do it again.

You are going need to provide more information about the above:

1) Define regular results.

2) The query used.

3) The outcome vs what you expected.


> Are the below from the bpd.sql file?
> Yes
> Why does pg_dump insert data into the calculated columns?

It shouldn't that is the point of this discussion, why it is happening 
in your case? So far we have not been able to replicate this behavior on 
our end, hence the many questions as to your set up.

> I entered the data manually via export/import, excluding the problematic 
> field because its value will be calculated when inserted.
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert column monetary type ver 2
Next
From: "David G. Johnston"
Date:
Subject: Re: Error when rewriting a query into multiple queries