Hi All,
At system crash or poweroff the autovacuum statistics will be lost,
because this statistics only stored in RAM and saved/restored at
service shutdown/startup.
I think it should be saved periodically and not to be deleted after
crash.
I was found a bug in PostgreSQL 8.0.0beta3.
It isn't in PostgreSQL 7.4.5.
$ createdb test
$ psql test
test=# SELECT version ();
version
-
PostgreSQL 8.0.0beta3 on i686-pc-linux-gnu, co
Hi all,
I was implement the "transaction idle timeout" function in PostgreSQL
(version 7.4.5 and 8.0.0beta2)
test=# SET trans_idle_timeout=10;
SET
test=# BEGIN;
BEGIN
(ps)
...
postgres: sygma test [local] idle in transaction (3)
postgres: sygma test [local] idle in transaction (2)
postgres: syg
On Mon, 2 Dec 2002, Rod Taylor wrote:
> double precision | pg_catalog | round | double precision
> numeric | pg_catalog | round | numeric
> numeric | pg_catalog | round | numeric, integer
>
> Looks like round still exists to me.
Rod, you don't unde
On Mon, 2 Dec 2002, Joel Burton wrote:
> joel@joel=# select round('2.000'::numeric);
> round
> ---
> 2
> (1 row)
>
> joel@joel=# select round('2.000'::numeric,2);
> round
> ---
>2.00
> (1 row)
OK, but:
template1=# select round('2.001'::numeric);
round
---
2
(1 row)
Hello
In PostgreSQL 7.2/7.1:
template1=# select text(2.000::numeric);
text
--
2
(1 row)
In 7.3:
template1=# select text(2.000::numeric);
text
---
2.000
(1 row)
The text(numeric) function doesn't round numbers. :(
This is bug or feature? :)
