Dave Hughes writes:
> I recently noticed that my default superuser "postgres" cannot create
> tables in new schemas I create, but can in some existing ones.
> So as the postgres user I ran:
> afleads=# create schema mytest;
> CREATE SCHEMA
> afleads=# create table mytest.test (col1 int);
> ERROR:
On 9/7/19 4:50 μ.μ., Dave Hughes wrote:
Sure thing. I attached it as a txt file. Thanks for the help!
PostgreSQL version?
On Tue, Jul 9, 2019 at 9:29 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
On 9/7/19 3:31 μ.μ., Dave Hughes wrote:
>
> Has anyone ran acr
On 9/7/19 3:31 μ.μ., Dave Hughes wrote:
Has anyone ran across something like this before?
can you show your pg_dumpall -x --schema-only
?
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
