Re: pg_restore error on function

2022-11-03 Thread Ron
On 11/3/22 09:57, Adrian Klaver wrote: On 11/3/22 07:45, Ron wrote: On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db What was the *complete* pg_dump command? I'm going to say

Re: pg_restore error on function

2022-11-03 Thread Tom Lane
"David G. Johnston" writes: > On Thu, Nov 3, 2022 at 8:39 AM Post Gresql wrote: >> Could it be that the >> create function . >> in the dump file does not implicitly create the schema as a >> create table . >> would? > I don't know where you got the idea that a schema is implicitly created via >

Re: pg_restore error on function

2022-11-03 Thread Adrian Klaver
On 11/3/22 08:38, Post Gresql wrote: On 2022-11-03 15:43, Adrian Klaver wrote: On 11/3/22 07:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U pos

Re: pg_restore error on function

2022-11-03 Thread David G. Johnston
On Thu, Nov 3, 2022 at 8:39 AM Post Gresql wrote: > > On 2022-11-03 15:43, Adrian Klaver wrote: > > On 11/3/22 07:28, Post Gresql wrote: > >> Hello > >> > >> I first successfully ran > >> > >> pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema > --no-owner -v my_db > >> > >> b

Re: pg_restore error on function

2022-11-03 Thread Post Gresql
On 2022-11-03 15:43, Adrian Klaver wrote: On 11/3/22 07:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump fa

Re: pg_restore error on function

2022-11-03 Thread Post Gresql
On 2022-11-03 15:57, Adrian Klaver wrote: On 11/3/22 07:45, Ron wrote: On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db What was the *complete* pg_dump command? I'm going to

Re: pg_restore error on function

2022-11-03 Thread Adrian Klaver
On 11/3/22 07:45, Ron wrote: On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db What was the *complete* pg_dump command? I'm going to say the above. -- Adrian Klaver adrian.kl

Re: pg_restore error on function

2022-11-03 Thread Ron
On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump failed with pg_restore: connecting to databas

Re: pg_restore error on function

2022-11-03 Thread Adrian Klaver
On 11/3/22 07:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump failed with pg_restore: connecting to databas

pg_restore error on function

2022-11-03 Thread Post Gresql
Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump failed with pg_restore: connecting to database for restore pg_restore: creating FUNC