Quick Links

Overwrite pg_catalog?

From:	Juliano <jplinux(at)protonmail(dot)com>
To:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	Overwrite pg_catalog?
Date:	2016-12-01 11:16:10
Message-ID:	Xvk2khpxF9nL7bKe01fBbkn18qELYkY0zpxZQPMfF8gTroqe_MrwF7LmuLsWW6OU7K6i3ULagrx_8l54P81jPLaxzVbrBAAwJ2tBlGyCMpg=@protonmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi everyone,

I tried to restore pg_catalog to my new database, but the existing pg_catalog can't be overwritten or dropped, and postgres auto creates pg_catalog when I create a new DB.

So, there is a way to restore the pg_catalog to a new database?

Regards,
Juliano

Responses

Re: Overwrite pg_catalog? at 2016-12-01 12:07:09 from Francisco Olarte
Re: Overwrite pg_catalog? at 2016-12-01 15:43:25 from David G. Johnston
Re: Overwrite pg_catalog? at 2016-12-01 16:56:57 from Joshua D. Drake

Browse pgsql-general by date

	From	Date	Subject
Next Message	Chris Withers	2016-12-01 11:56:57	btree gist indices, null and open-ended tsranges
Previous Message	George	2016-12-01 08:07:36	Re: Index is not used for "IN (non-correlated subquery)"