[BUGS] BUG #8106: Redundant function definition in contrib/cube/cube.c
The following bug has been logged on the website: Bug reference: 8106 Logged by: Adrian Schreyer Email address: ams...@cam.ac.uk PostgreSQL version: 9.2.4 Operating system: Ubuntu 12.04 LTS Description: The cube.c file in the cube contrib module contains a prototype for the function Datum cube(PG_FUNCTION_ARGS). The prototype seems to be an artifact from an older version because the function is never defined and also never used in the code. http://doxygen.postgresql.org/cube_8c_source.html#l00052 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8106: Redundant function definition in contrib/cube/cube.c
On 23.04.2013 10:54, ams...@cam.ac.uk wrote: The following bug has been logged on the website: Bug reference: 8106 Logged by: Adrian Schreyer Email address: ams...@cam.ac.uk PostgreSQL version: 9.2.4 Operating system: Ubuntu 12.04 LTS Description: The cube.c file in the cube contrib module contains a prototype for the function Datum cube(PG_FUNCTION_ARGS). The prototype seems to be an artifact from an older version because the function is never defined and also never used in the code. Thanks, removed. - Heikki -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8107: How to downgrade database from 9.2.3 to 8.4 ?
The following bug has been logged on the website: Bug reference: 8107 Logged by: Roberto Email address: roberto.menon...@netspa.it PostgreSQL version: 9.2.3 Operating system: CentOS 5.6 (Final) Description: Hy. This is not a bug but a simple request ! Is there a way to downgrade a database from version 9.2.3 to 8.4.x ? I tried a pg_dump from 9.2.3 and a pg_restore from 9.2.3 TO a 8.4.7 server. but I receive several errors. Does it exist another way ? Thank you. Roby -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Fw: [pgadmin-support] (Bug) Numeric fault calculation
Kanitchet Vaiassava wrote:
> [division and some math functions using the numeric type can
> sometimes have a result which the numeric type cannot represent
> exactly]
Yeah, you can use a simpler example:
test=# select '1'::numeric / '3'::numeric;
?column?
0.
(1 row)
test=# select '3'::numeric * ('1'::numeric / '3'::numeric);
?column?
0.
(1 row)
> So I think this problem should be solve? or at least, it should
> be note in document for other developer to be more careful.
Yeah, there should probably be something in the docs to indicate
that not all rational numbers (and certainly no irrational or
imaginary numbers) can be stored as a single numeric value without
loss of precision.
It might be interesting to create a "rational" type which would
internally hold two numeric values, and which would be capable of
doing what you want. I'm not sure that the demand is sufficient to
back the development of it, though. (Is there a convention for how
to indicate the repeating part of a decimal fraction when you can't
draw a line over those digits?)
In the absence of such a type, you might want to arrange your
calculations such that any division or square root calculations
are done last. That way the effect of the truncation of the
repeating (or not) infinite decimal fraction won't be multiplied by
a later phase of the calculation.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Re: [BUGS] BUG #8107: How to downgrade database from 9.2.3 to 8.4 ?
On Tue, Apr 23, 2013 at 04:18:17PM +, roberto.menon...@netspa.it wrote: > The following bug has been logged on the website: > > Bug reference: 8107 > Logged by: Roberto > Email address: roberto.menon...@netspa.it > PostgreSQL version: 9.2.3 > Operating system: CentOS 5.6 (Final) > Description: > > Hy. > > This is not a bug but a simple request ! > > Is there a way to downgrade a database from version 9.2.3 to 8.4.x ? > > I tried a pg_dump from 9.2.3 and a pg_restore from 9.2.3 TO a 8.4.7 server. > > but I receive several errors. > > Does it exist another way ? I recommend doing a schema dump, adjusting the output file until it generates no errors, then restore that, and then restore the data. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8091: No permissions on the table file causing recovery failure
As the following raised bug is not received by the bugs mailing list. Forwarding the same to mailing list. http://www.postgresql.org/message-id/E1USmqv-0006X0-5X@wrigleys.postgresql.o rg Please check the above defect needs any handling? Regards, Hari babu. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
