by KoerbS » Tue Jun 30, 2020 5:33 am
I do have a similar error with the current last update of pt. I ve been trying the sollution posted here and have this errors:
NOTICE: drop cascades to function pph.hero_cash(integer)
NOTICE: function pph.hero_cash(pg_catalog.int4) does not exist, skipping
NOTICE: drop cascades to function pph.hero_tourney(integer)
NOTICE: function pph.hero_tourney(pg_catalog.int4) does not exist, skipping
ERROR: cannot drop schema pph because other objects depend on it
DETAIL: function pph.flop_texture(integer,integer,integer) depends on schema pph
function pph.monochrome_flop(smallint,smallint,smallint) depends on schema pph
function pph.duochrome_flop(smallint,smallint,smallint) depends on schema pph
function pph.trichrome_flop(smallint,smallint,smallint) depends on schema pph
function pph.paired_flop(smallint,smallint,smallint) depends on schema pph
function pph.wet_flop(smallint,smallint,smallint) depends on schema pph
function pph.dry_flop(smallint,smallint,smallint) depends on schema pph
HINT: Use DROP ... CASCADE to drop the dependent objects too.
********** Fehler **********
ERROR: cannot drop schema pph because other objects depend on it
SQL Status:2BP01
Detail:function pph.flop_texture(integer,integer,integer) depends on schema pph
function pph.monochrome_flop(smallint,smallint,smallint) depends on schema pph
function pph.duochrome_flop(smallint,smallint,smallint) depends on schema pph
function pph.trichrome_flop(smallint,smallint,smallint) depends on schema pph
function pph.paired_flop(smallint,smallint,smallint) depends on schema pph
function pph.wet_flop(smallint,smallint,smallint) depends on schema pph
function pph.dry_flop(smallint,smallint,smallint) depends on schema pph
Hinweis:Use DROP ... CASCADE to drop the dependent objects too.