[BUGS] BUG #6529: Invalid numeric input syntax for 'select into' queries

2012-03-13 Thread nehxby
The following bug has been logged on the website: Bug reference: 6529 Logged by: Maxim Turchin Email address: neh...@gmail.com PostgreSQL version: 9.1.3 Operating system: Ubuntu 11.10 Description: CREATE TYPE test_bug_type AS (value numeric(15,2), curr

[BUGS] BUG #6530: intarray documentation could do with a warning about operators

2012-03-13 Thread kontakt
The following bug has been logged on the website: Bug reference: 6530 Logged by: Kasper Sandberg Email address: kont...@sandberg-consult.dk PostgreSQL version: 9.1.3 Operating system: Debian squeeze Description: Hello. I recently had a problem with array operators &&

Re: [BUGS] BUG #6489: Alter table with composite type/table

2012-03-13 Thread Merlin Moncure
On Sat, Feb 25, 2012 at 7:23 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6489 > Logged by:          Rikard Pavelic > Email address:      rikard.pave...@zg.htnet.hr > PostgreSQL version: 9.1.2 > Operating system:   Windows 7 > Description: > > I'm trying

Re: [BUGS] BUG #6489: Alter table with composite type/table

2012-03-13 Thread Bruce Momjian
On Wed, Feb 29, 2012 at 11:40:31AM -0300, Alvaro Herrera wrote: > > Excerpts from rikard.pavelic's message of sáb feb 25 10:23:18 -0300 2012: > > > But I would expect second alter to pass and enforcing not null and default > > when adding this column in table and not enforcing not null and defaul

[BUGS] BUG #6528: pglesslog still referenced in docs, but no 9.1 support

2012-03-13 Thread stuart . bishop
The following bug has been logged on the website: Bug reference: 6528 Logged by: Stuart Bishop Email address: stuart.bis...@canonical.com PostgreSQL version: 9.1.3 Operating system: Ubuntu Description: In section 24.3.5.1 of the docs on setting up continuous archiving

Re: [BUGS] BUG #6527: Error in COPY documentation syntax

2012-03-13 Thread Guillaume Lelarge
On Mon, 2012-03-12 at 19:34 +, samuel.gilb...@ec.gc.ca wrote: > The following bug has been logged on the website: > > Bug reference: 6527 > Logged by: Samuel Gilbert > Email address: samuel.gilb...@ec.gc.ca > PostgreSQL version: 9.0.4 > Operating system: Linux > Descriptio

[BUGS] BUG #6527: Error in COPY documentation syntax

2012-03-13 Thread samuel . gilbert
The following bug has been logged on the website: Bug reference: 6527 Logged by: Samuel Gilbert Email address: samuel.gilb...@ec.gc.ca PostgreSQL version: 9.0.4 Operating system: Linux Description: There is an error in the syntax of the COPY statement in the documenta

Re: [BUGS] BUG #6512: Bug with prepared statement and timestamp + interval

2012-03-13 Thread Stefano Baccianella
I think that the problem is on the type inference algorithm. Starting from: typeof(X) = timestamp typeof(Y) = ? typeof(Z) = interval typeof(Y op Z) = ? [timestamp/interval] The inference algorithm starts from the right X > Y + Z => X > ? + interval [here the algorithm has two choices, timestamp