ource rocks!
Duarte
-Mensagem original-
De: Duarte Carreira
Enviada: 25 de janeiro de 2019 18:24
Para: Tom Lane
Cc: pgsql-gene...@postgresql.org
Assunto: RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
Tom, can't thank you enough.
Now, the 2nd query and result
equal(st_envelope,st_envelope)";"n"
"function st_envelope_equal(st_envelope,st_envelope)";"n"
"function st_geo_gist_equal(st_envelope,st_envelope,internal)";"n"
"function st_geo_gist_equal(st_envelope,st_envelope,internal)";"n"
I'
Duarte Carreira writes:
> So I proceeded with the 2 queries:
> select pg_describe_object(refclassid,refobjid,refobjsubid), deptype from
> pg_depend where objid = 'sde.st_envelope'::regtype;
> "schema sde";"n"
> "function st_envelope_in(cstring)";"n"
> "function st_envelope_out(st_envelope)";"n"
Lane'
Cc: pgsql-gene...@postgresql.org
Assunto: RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
First, I'd like to apologize for posting the dump file to the whole list... I
wish I could delete it, at least the attachment...
I ran the explain plan, and got a se
t;;"n"
"function st_envelope_equal(st_envelope,st_envelope)";"n"
"function st_envelope_equal(st_envelope,st_envelope)";"n"
"function st_geo_gist_equal(st_envelope,st_envelope,internal)";"n"
"function st_geo_gist_equal(st_
Duarte Carreira writes:
> Sure, I'll be sending you the dump shortly off-list.
Hmph. So the problem seems to be that pg_dump isn't emitting a "shell
type" command for sde.st_envelope. The first mention of that type is
in the "CREATE FUNCTION sde.st_envelope_in..." command, and that won't
have d
Sure, I'll be sending you the dump shortly off-list.
Duarte
-Mensagem original-
De: Tom Lane
Enviada: 25 de janeiro de 2019 14:28
Para: Duarte Carreira
Cc: pgsql-gene...@postgresql.org
Assunto: Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
Duarte Car
Duarte Carreira writes:
> Tom, just did a pg_dump -s from 9.3 and there are no warnings in the output
> file. It goes smoothly and fast (few seconds). Database is around 50GB,
> schema 9MB. Has postgis and a few more extensions - ogr_fdw (from postigs),
> file_fdw, postgres_fdw, table_func.
Hm
arreira
Cc: pgsql-gene...@postgresql.org<mailto:pgsql-gene...@postgresql.org>
Subject: Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5
Duarte Carreira mailto:dcarre...@edia.pt>> writes:
> I've trying to upgrade a 9.3 instance to 9.5 using pg_upgrade and facing
issue when using pg_upgrade to move from 9.3 to 9.5
Duarte Carreira writes:
> I've trying to upgrade a 9.3 instance to 9.5 using pg_upgrade and facing this
> issue...
9.5.what?
Perusing the commit logs, I note that 9.5.3 included a fix for a
pg_upgrade issue that could possibly lead
Duarte Carreira writes:
> I've trying to upgrade a 9.3 instance to 9.5 using pg_upgrade and facing this
> issue...
9.5.what?
Perusing the commit logs, I note that 9.5.3 included a fix for a
pg_upgrade issue that could possibly lead to this symptom, see
https://git.postgresql.org/gitweb/?p=postg
Hello.
I've trying to upgrade a 9.3 instance to 9.5 using pg_upgrade and facing this
issue...
I've found a similar thread, but going from 8.4 to 9.2:
https://www.postgresql.org/message-id/flat/52C44FA9.2080500%40gmail.com#14ab24f6c94287dd4c435652cb2d77f8
This ended up without really pinpointing
12 matches
Mail list logo
