Re: pg_dump insert column GENERATED

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: pg_dump insert column GENERATED
Дата
Msg-id 15ee1aef-6b36-dc58-a610-b0f665ac652a@aklaver.com
обсуждение исходный текст
Ответ на Re: pg_dump insert column GENERATED  (Дмитрий Иванов <firstdismay@gmail.com>)
Ответы Re: pg_dump insert column GENERATED
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: insert column monetary type ver 2
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Error when rewriting a query into multiple queries