The following bug has been logged on the website:
Bug reference: 8214
Logged by: Miron Cuperman
Email address: m+p...@tradehill.com
PostgreSQL version: 9.2.4
Operating system: Debian 6.0 (squeeze)
Description:
This is an intermittent crash during a ~5 minute unit test
eric-postgre...@soroos.net writes:
> -- this fails. I'd expect it to succeed.
> select id, dt from
>(select 1 as id, generate_series(now()::date, now()::date + '1
> month'::interval, '1 day')::date as dt
> union
> select 2, now()::date
> ) as foo
> where dt < now()+'15 days'::interva
The following bug has been logged on the website:
Bug reference: 8213
Logged by: Eric Soroos
Email address: eric-postgre...@soroos.net
PostgreSQL version: 9.0.13
Operating system: Ubuntu 10.04, 32bit
Description:
This has been replicated on 9.2.4 and HEAD by ilmari_ a
bricklen wrote
> expression
>
> An expression based on one or more columns of the table. The expression
> usually must be written with surrounding parentheses, as shown in the
> syntax. However, the parentheses can be omitted if the expression has the
> form of a function call.
So in fact the exa
The following bug has been logged on the website:
Bug reference: 8212
Logged by: Geoff Montee
Email address: geoff.mon...@gmail.com
PostgreSQL version: 9.2.4
Operating system: Linux
Description:
When a user calls a function that has SECURITY DEFINER set, the value of
aci...@gmail.com writes:
> CREATE INDEX heuristic ON foos (1 / (a + b))
> causes:
> ERROR: syntax error at or near "1"
This is not a bug. You need an extra pair of parentheses around
the expression, ie
CREATE INDEX heuristic ON foos ((1 / (a + b)))
http://www.postgresql.org/docs/9.2/static/sq
On Wed, Jun 5, 2013 at 8:24 AM, wrote:
>
> Bug reference: 8211
> Logged by: Andrey Cizov
> Email address: aci...@gmail.com
> PostgreSQL version: 9.2.3
> Operating system: Windows
> Description:
>
> CREATE INDEX heuristic ON foos (1 / (a + b))
>
> causes:
>
> ERROR: syntax err
The following bug has been logged on the website:
Bug reference: 8211
Logged by: Andrey Cizov
Email address: aci...@gmail.com
PostgreSQL version: 9.2.3
Operating system: Windows
Description:
CREATE INDEX heuristic ON foos (1 / (a + b))
causes:
ERROR: syntax error
