Forum OpenACS Improvement Proposals (TIPs): Re: TIP 64: (proposed) Restrictions on upgrade scripts ...

Collapse
3: Re: TIP 64: (proposed) Restrictions on upgrade scripts ... (response to 1)
Posted by Don Baccus on 05/25/04 05:32 PM
Upgrade scripts *already* need to do this, Dave.

The restriction is that instead of writing something like 

CREATE OR REPLACE PACKAGE FOO ...;
CREATE OR REPLACE PACKAGE BODY FOO ...;

CREATE OR REPLACE PACKAGE BAR ...;
CREATE OR REPLACE PAKCAGE BODY BAR ...;

You must write: 

CREATE OR REPLACE PACKAGE FOO ...;
CREATE OR REPLACE PACKAGE BAR ...;

CREATE OR REPLACE PACKAGE BODY FOO ...;
CREATE OR REPLACE PAKCAGE BODY BAR ...;

The first example can lead to dependency errors (as Andrew so painfully learned), the second can't.