On Sat, Jul 09, 2005 at 10:25:16AM +0100, Milos Babic wrote:
>
> When I try from psql to select:
>
> select 1024*1024*4500;
>
> it responses with:
> error integer out of range
>
> is it known bug or what is going on?
>From "Numeric Constants" in the "SQL Syntax" chapter of the
documentation:
On Fri, Jul 08, 2005 at 01:33:13PM -0300, Renato Gondim wrote:
> This select doesn't work:
>
> Select cast('' as int)
Any empty string isn't a valid integer, so PostgreSQL 7.3 and later
reject it.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)
The following bug has been logged online:
Bug reference: 1762
Logged by: Milos Babic
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: FreeBSD
Description:Integer multiplication error
Details:
When I try from psql to select:
select 1024*102
I'm not proposing it for 8.1 though ...
Well, why not? Arguably Mark's problem is a bug, and it's not too late
to address bugs.
FWIW, I'd be satisfied with a warning in the autovacuum docs about this
corner case.
I'm not sure about the idea of not vacuuming the toas
This select doesn’t work:
Select cast(‘’ as int)
Matthew T. O'Connor wrote:
Tom Lane wrote:
I think Mark is probably on to something. The activity in the toast
table will show as deletes *in the toast table* ... and that activity
fails to show at all in the pg_stat_activity view, because it shows
only plain relations! So unless autovacuum
