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

Fri, 30 Aug 2002 15:52:52 -0400
Gordon Runkle <gar@integrated-dynamics.com>
[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

Fri, 30 Aug 2002 20:57:46 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [7.3-devl] alter_table test 
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



30 Aug 2002 21:26:01 -0400
Gordon Runkle <gar@integrated-dynamics.com>
Re: [7.3-devl] alter_table test