[7.3-devl] alter_table test

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