Skip site navigation (1) Skip section navigation (2)

Re: alter table rename missing numeric type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: vev(at)hub(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: alter table rename missing numeric type
Date: 2000-12-03 23:04:25
Message-ID: 22887.975884665@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
> template1=> insert into n2 values(154.23);
> INSERT 360703 1
> template1=> alter table n1 rename to oldn1;
> RENAME
> template1=> alter table n2 rename to n1;
> RENAME
> template1=> insert into n1 values(154.23);
> ERROR:  overflow on numeric ABS(value) >= 10^2 for field with precision 4 scale 2

I can't duplicate either part of this bug report, using either 7.0.2
or current sources.  Something's pretty whacked out about your
installation I think... what version are you running, anyway?

BTW, you didn't actually show us the command you used to create n2.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-12-04 10:58:26
Subject: Outer joins in views
Previous:From: pgsql-bugsDate: 2000-12-03 18:55:49
Subject: alter table rename missing numeric type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group