[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: 1.3.2 -> 1.3.3 upgrade issue



Hi Chris,

Actually, I used the manual route, but through that route, the
database doesn't contain the right schema number (1.3.0 vs 1.3.3).
Should we extend the instructions in the UPGRADE document?

Bye,

Erik.

On Sun, Nov 6, 2011 at 9:25 PM, Erik Huelsmann <..hidden..> wrote:
> Hi Chris,
>
> My 1.3.3 upgrade (from 1.3.0) ends with the following error:
>
>
> psql:Files.sql:180: ERROR:  cannot drop view file_order_links because
> other objects depend on it
> DETAIL:  view file_links depends on view file_order_links
> function file__list_links(integer,integer) depends on type file_links
> HINT:  Use DROP ... CASCADE to drop the dependent objects too.
> psql:Files.sql:181: ERROR:  cannot drop view file_tx_links because
> other objects depend on it
> DETAIL:  view file_links depends on view file_tx_links
> function file__list_links(integer,integer) depends on type file_links
> HINT:  Use DROP ... CASCADE to drop the dependent objects too.
> psql:Files.sql:182: ERROR:  cannot drop view file_links because other
> objects depend on it
> DETAIL:  function file__list_links(integer,integer) depends on type file_links
> HINT:  Use DROP ... CASCADE to drop the dependent objects too.
> DELETE 2
> CREATE VIEW
> INSERT 0 1
> CREATE VIEW
> INSERT 0 1
> CREATE FUNCTION
>  file_links_vrebuild
> ---------------------
>  t
> (1 row)
>
>
> I used the reload_modules approach to this upgrade. I'm not sure other
> users see this as well, but should we use DROP CASCADE in the
> Files.sql file, or do I have incorrectly upgraded some intermediate
> state of file attachment functionality?
>
>
> Bye,
>
>
> Erik.
>
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Save $700 by Nov 18
> Register now
> http://p.sf.net/sfu/rsa-sfdev2dev1
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>