Thread: [7.3-devl] alter_table test

The alter_table regression test is now failing for me (RH Null).

It appears that the problem is that the backend is giving back a
different error message than expected when dropping a column from a
non-existent table:

-- try altering non-existent table, should fail
alter table foo drop column bar;
ERROR:  Relation "foo" has no column "bar"


What is expected is:

-- try altering non-existent table, should fail
alter table foo drop column bar;
ERROR:  Relation "foo" does not exist


It seems to me that the expected behaviour is best, FWIW...

Thanks,

Gordon.
-- 
"Far and away the best prize that life has to offer is the chance to work hard at work worth doing."      -- Theodore
Roosevelt

Gordon Runkle <gar@integrated-dynamics.com> writes:
> The alter_table regression test is now failing for me (RH Null).
> It appears that the problem is that the backend is giving back a
> different error message than expected when dropping a column from a
> non-existent table:

> -- try altering non-existent table, should fail
> alter table foo drop column bar;
> ERROR:  Relation "foo" has no column "bar"

Hmm, I don't get that here.  In CVS tip the regression tests pass,
and a manual trial gives:

test73=# alter table foo drop column bar;
ERROR:  Relation "foo" does not exist

Would you try a full rebuild and see if things are still flaky?
        regards, tom lane

Looks good now, all three environments (RH 7.2, RH 7.3, RH Null).

G.

On Fri, 2002-08-30 at 20:57, Tom Lane wrote:
> Hmm, I don't get that here.  In CVS tip the regression tests pass,
> and a manual trial gives:
> 
> test73=# alter table foo drop column bar;
> ERROR:  Relation "foo" does not exist
> 
> Would you try a full rebuild and see if things are still flaky?
> 
>             regards, tom lane
-- 
"Far and away the best prize that life has to offer is the chance to work hard at work worth doing."      -- Theodore
Roosevelt