Re: While restoring -getting error if dump contain sql statements generated from generated.sql file

2020-04-19 Thread Masahiko Sawada
On Fri, 17 Apr 2020 at 22:50, Masahiko Sawada wrote: > > On Tue, 14 Apr 2020 at 22:41, tushar wrote: > > > > Hi , > > > > We have a sql file called 'generated.sql' under src/test/regress/sql > > folder . if we run this file on psql , take the dump and try to restore > > it on another db > > we

Re: While restoring -getting error if dump contain sql statements generated from generated.sql file

2020-04-17 Thread Masahiko Sawada
On Tue, 14 Apr 2020 at 22:41, tushar wrote: > > Hi , > > We have a sql file called 'generated.sql' under src/test/regress/sql > folder . if we run this file on psql , take the dump and try to restore > it on another db > we are getting error like - > > psql:/tmp/x:434: ERROR: column "b" of

While restoring -getting error if dump contain sql statements generated from generated.sql file

2020-04-14 Thread tushar
Hi , We have a sql file  called 'generated.sql' under src/test/regress/sql folder . if we run this file on psql , take the dump and try to restore it on another db we are getting error like - psql:/tmp/x:434: ERROR:  column "b" of relation "gtest1_1" is a generated column psql:/tmp/x:441: