Re: Error with pg_dump (of data), with --role

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Error with pg_dump (of data), with --role
Date: 2021-02-20 00:21:53
Message-ID: 3149167.1613780513@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> writes:
> One thing about the search path though, regarding pg_temp. If I add a
> SET search_path = public;
> Do I need instead to specify "public, pg_temp" to prevent it from being
> (silently) at the beginning?

Yeah, that would be slightly safer. If the public schema is
world-writable, though, you're in big trouble anyway ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Tanzer 2021-02-20 00:38:34 Re: Error with pg_dump (of data), with --role
Previous Message Ken Tanzer 2021-02-20 00:02:17 Re: Error with pg_dump (of data), with --role