On Wed, Feb 16, 2011 at 6:18 AM, Tom Lane wrote:
> Maxim Boguk writes:
> > Test case look like:
>
> > create table "references" ( attr_id integer, reference integer,
> > object_id integer );
> > insert into "references" select *100**(random()),
> > *10**(random()^*10*), *100**(random())
The following bug has been logged online:
Bug reference: 5889
Logged by: Konrad Garus
Email address: konrad.ga...@gmail.com
PostgreSQL version: 8.4
Operating system: Linux
Description:"Intersects" for polygons broken
Details:
&& operator seems to be broken for polyg
Jeff Davis wrote:
> On Wed, 2011-02-09 at 22:58 -0500, Tom Lane wrote:
> > It's intentional ... not that other people haven't complained about it
> > before. Remember that what you have done is forced a crash, and
> > recovery from it is crash recovery. If we proactively removed such
> > files we
"Konrad Garus" writes:
> && operator seems to be broken for polygons whose bounding boxes intersect:
> select polygon'((0,0), (1,2), (0,2))' && polygon'((0.5, 0), (1,0), (1,1))';
> ?column?
> --
> t
> (1 row)
This is fixed as of 9.0; see the release notes at
http://www.postgresql.org/
2011/2/16 Tom Lane :
> "Konrad Garus" writes:
>> && operator seems to be broken for polygons whose bounding boxes intersect:
>
>> select polygon'((0,0), (1,2), (0,2))' && polygon'((0.5, 0), (1,0), (1,1))';
>> ?column?
>> --
>> t
>> (1 row)
>
> This is fixed as of 9.0; see the release not
The following bug has been logged online:
Bug reference: 5890
Logged by: Emmanuel
Email address: t...@pasteur.fr
PostgreSQL version: 8.4.1
Operating system: Mac OSX 10.6.6
Description:malloc error
Details:
When I type a select query and then push the 'tab' key for t
"Emmanuel" writes:
> Operating system: Mac OSX 10.6.6
> When I type a select query and then push the 'tab' key for table name
> completion (without) schema name, if there more than one table starting with
> the same prefix, I get this error:
> legiobiblio=# select pmid from pub
> psql(41402) m
On Tue, Feb 15, 2011 at 2:43 AM, Vegard Bønes wrote:
> Ok, I tried to modify the example functions get_data_alternative_a() and
> get_data_alternative_b(), so that they start with SPI_connect, and end with
> SPI_finish. Also I removed SPI_connect and SPI_finish from the main function.
> As I un
I want to configure Bidirectional replication in postgres 9 ( streaming ).
any one knows solution for Bidirectional replication in postgres.
Regards,
Sharad K
Dear PostgreSQL bug-squasher-team,
I was trying to build postgresql-9.0.2 with the following ./configure:
$ ./configure --enable-cassert --enable-debug --with-python --with-ossp-uuid
and got the following message:
checking uuid.h presence... yes
configure: WARNING: uuid.h: present but cannot be
Hi,
We are a current user of Postgres on a 32-bit Windows 2003 server. We need to
run this application on a 64-bit Windows 2008 server... I read there is a
64-bit installer available (9.0.3) but have yet to find it on the Postgres
site. Can you point me to this download if it's available?
Th
On ons, 2011-02-16 at 17:15 +, Khadtare, Sharad wrote:
> I want to configure Bidirectional replication in postgres 9 ( streaming ).
>
> any one knows solution for Bidirectional replication in postgres.
This is not a bug, and is hence inappropriate for this forum. But what
you are looking for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Swiderek, Sunny wrote:
> Hi,
>
> We are a current user of Postgres on a 32-bit Windows 2003 server. We
> need to run this application on a 64-bit Windows 2008 server… I read
> there is a 64-bit installer available (9.0.3) but have yet to find it
> o
Hello all,
I am running PostgreSQL 9.0.2 on Mac (10.6.6)
This is what I get in the psql terminal:
postgres=# SELECT version();
version
---
On 17.02.2011 08:06, Sachin Srivastava wrote:
postgres=# SELECT now() + '7 days' AS week_ahead;
week_ahead
--
2011-02-24 10:39:29.951931+05:30
(1 row)
postgres=# SELECT now() - '7 days' AS week_behind;
ERROR: invalid input syntax for type timestamp
The updated example is pasted in below.
The given example will cause an error. You may (for example) change the code in
the stwitch statement like this, and it will work like a charm:
from:
case 1:
SRF_RETURN_NEXT(funcctx, get_data_alternative_b());
//get
16 matches
Mail list logo
