| Christopher Browne 2005-06-22, 1:25 pm |
| Jacob Smullyan wrote:
>Hi --
>
>I'm getting an error attempting to apply some DDL with execute script.
>(Jan, Christopher -- this is the error I promised to post Monday.)
>
>Because the error message, ddl file, and schema are lengthy, I've
>posted them at this url:
>
> http://www.smullyan.org/smulloni/executescript.tar.gz
>
>In short, I drop a view, alter a table by adding a column, and then
>try to recreate the view using the column; the error message says that
>the new column does not exist.
>
>The ddl works fine at psql.
>
>The tarfile contains an empty schema, ddl for the change, the script I
>ran that invoked execute script, and the error message that resulted.
>
>
Nothing leaps out to me from the script, but as you say, it's pretty
lengthy, so there's "a lot of there" there (to say it in the Clintonian
way :-)).
What I'd suggest first is that you seek to solve the "because the error
message, ddl file, and schema are lengthy" problem.
Try doing it in pieces; I'd try doing everything up to (but not
including) the alteration to segmentversions.
That means needing to lock the set multiple times, which is pretty evil,
but hopefully it does two things:
1. It should get you to the point where *some* of the changes are
getting through, and
2. It should allow narrowing the possible sources of the problem.
|