Hello,
I was unable to install PostgreSQL 8.4.4 successfully. The error I received
was "Database Cluster Initialisation Failed" error during PostgreSQL install".
I selected the windows version from the link
http://www.enterprisedb.com/products/pgdownload.do#windows . on running the
.exe file
Sorry, Gmail made med confused, my biggest "thank you" was to Richard
Huxton, who showed me code that worked.
2010/9/26 A B :
> 2010/9/25 Tom Lane :
>> Jeff Davis writes:
>>> There's no reason that there couldn't be a point <@ box operator in the
>>> opclass, but nobody really uses these geometri
Le 27/09/2010 02:20, Fujii Masao a écrit :
> On Mon, Sep 27, 2010 at 9:09 AM, Gurjeet Singh
> wrote:
>> See the nuggets hidden in section 25.2.5.2. "Monitoring" at
>> http://www.postgresql.org/docs/9.0/static/warm-standby.html#STREAMING-REPLICATION
>>
>> After an UPDATE, your application can cach
As far as I can see there is no pre-built pg_filedump binary for the
PDGD yum repository (8.3.11 for RHEL5). Before I embark on building it
from source I figured I'd ask here if I'm correct that there is no
binary hidden somewhere in the packages.
Thanks.
--
Sent via pgsql-general mailing
On 25/09/2010, at 1:11 AM, Craig Ringer wrote:
On 24/09/2010 8:40 PM, Raymond O'Donnell wrote:
On 24/09/2010 13:21, kongs...@stud.ntnu.no wrote:
What version of PG was it?
The "PG_VERSION" file = 8.3
OK, well at least it's not an ancient version that's not available
any
more. :-)
As Cra
On Mon, Sep 27, 2010 at 9:09 AM, Gurjeet Singh wrote:
> See the nuggets hidden in section 25.2.5.2. "Monitoring" at
> http://www.postgresql.org/docs/9.0/static/warm-standby.html#STREAMING-REPLICATION
>
> After an UPDATE, your application can cache the info from
> 'pg_current_xlog_location()' resul
On Mon, Sep 27, 2010 at 1:51 AM, Yang Zhang wrote:
> Say you have an application using PG asynchronous streaming
> replication to some hot standbys, to distribute the read load. The
> application itself is a typical web application consisting of multiple
> servers, serving a number of sessions (p
Say you have an application using PG asynchronous streaming
replication to some hot standbys, to distribute the read load. The
application itself is a typical web application consisting of multiple
servers, serving a number of sessions (perhaps belonging to different
users), and the workload is OLT
Hi
Does Postgresql 9.0 still have the problem with the desktop heap on windows?
I know you can extend the desktop heap on windows but Microsoft says on
their web site you musn't extend it beyond 20K.
That allows for about 300 connections on a windows server.
I see there is now also a 64 bit window
On Sun, Sep 26, 2010 at 07:32:01PM +, Kevin Jardine wrote:
> Hi Pavel,
>
> I'm not really interested in a "my database is better than your database"
> discussion.
Pavel did not say that his database is better than yours.
What he said was that your query is wrong (with respect to
what you s
OK, then.
The sub-select needs to go.
Thanks for helpful advice.
Kevin
--- On Sun, 9/26/10, Tom Lane wrote:
> From: Tom Lane
> Subject: Re: [GENERAL] Preserving order through an inner join
> To: "Kevin Jardine"
> Cc: pgsql-general@postgresql.org
> Date: Sunday, September 26, 2010, 9:37 PM
>
Kevin Jardine writes:
> I have a query structured like this:
> SELECT stuff FROM
> (SELECT more stuff FROM
> table1
> ORDER BY field1) AS q1
> INNER JOIN table2 ON ( ... )
> and have found that the INNER JOIN is ignoring the order set for q1.
> The final results are not ordered by field1.
Indee
Hi Pavel,
I'm not really interested in a "my database is better than your database"
discussion.
I want to know how to preserve the order. As I said, moving the ORDER BY out of
the subquery would be a lot of work.
I am trying to find another solution.
Any suggestions from anyone?
Kevin
--- O
Hello
2010/9/26 Kevin Jardine :
> I have a query structured like this:
>
> SELECT stuff FROM
> (SELECT more stuff FROM
> table1
> ORDER BY field1) AS q1
> INNER JOIN table2 ON ( ... )
>
> and have found that the INNER JOIN is ignoring the order set for q1.
>
you can block a hash join that cannot
I have a query structured like this:
SELECT stuff FROM
(SELECT more stuff FROM
table1
ORDER BY field1) AS q1
INNER JOIN table2 ON ( ... )
and have found that the INNER JOIN is ignoring the order set for q1.
The final results are not ordered by field1.
This works for other databases (eg. MySQL a
We never expected gevel will be used by users :-)
We'll fix.
Oleg
On Thu, 23 Sep 2010, Tom Lane wrote:
Andrew Hunter writes:
Here is the content of the gevel Makefile
subdir = contrib/gevel
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
MODULES = gevel
DATA_built = ge
On Sun, Sep 26, 2010 at 10:15:00AM -0400, Tom Lane wrote:
> David Fetter writes:
> > On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote:
> >> period() might be immutable, but those casts from date to
> >> timestamptz are not, because they depend on the TimeZone
> >> parameter.
>
> > How har
David Fetter writes:
> On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote:
>> period() might be immutable, but those casts from date to
>> timestamptz are not, because they depend on the TimeZone parameter.
> How hard would it be to point out the first expression found to be
> mutable?
I l
"Andrus" writes:
>> Here's the patch if it helps.
> Thank you.
> When 9.1 will released ?
This will be in 9.0.1, not 9.1. Probably next week.
> Is it possible to remove 9.0 from downloads so that this issue will not
> propagated?
No, we won't do that. TBH, if this is the worst bug in 9.0.0,
Romain Billoir writes:
> Hi, i'm trying to request a database using data type "point" using keyword
> "IN" with a list of point generated by PHP, like this:
> 'SELECT * FROM map WHERE position IN ((point(-1,-1), (point(1,-1),
> point(1,1), point(-1,1))'
> but this request returns me an error: oper
On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote:
> Eric McKeeth writes:
> > why would I get the following error, since the period() function
> > is in fact declared as immutable?
>
> > test=# ALTER TABLE test3 ADD exclude using
> > gist(period(effect_date::timestamptz, expire_date::times
On Sat, Sep 25, 2010 at 10:50:25AM +0100, Andre Lopes wrote:
> Hi,
>
> I need to generate the dump of a PostgreSQL database only with the
> data with INSERT's. It is possible to do this?
Yes, but are you sure you need to do this? It's *very* slow. What
are you using this for?
Cheers,
David.
--
2010/9/25 Tom Lane :
> Jeff Davis writes:
>> There's no reason that there couldn't be a point <@ box operator in the
>> opclass, but nobody really uses these geometric types that come with
>> core postgres (at least, not that I can tell).
>
> Actually, as of 9.0 there is a point_ops opclass for GI
On Sat, Sep 25, 2010 at 3:12 PM, rey wrote:
> On 09/25/2010 10:03 AM, Tom Lane wrote:
>>
>> rey writes:
>>
>>>
>>> Why limit this to a single character?
>>>
>>
>> Performance. Believe it or not, breaking fields at the delimiter is
>> a significant factor in COPY speed.
>>
>>
Hi Romain,
Assuming you have PostGIS installed and position is defined as a point or
multpoint ADT then you could use the ST_Intersect operator
SELECT *
FROM map
WHERE ST_Intersects(position, 'MULTIPOINT(-1 -1,1 -1,1 1,-1 1)');
Regards
Andrew
On 2010-09-26, at 12:27 PM, Romain Billoir wrote:
2010/9/26 Andrus
> Here's the patch if it helps.
>>
>
> Thank you.
> When 9.1 will released ?
> Is it possible to remove 9.0 from downloads so that this issue will not
> propagated?
>
>
>
If committed, this fix will be available in release 9.0.1. I cannot comment
on when it will be available tho
2010/9/26 Andrus
> Here's the patch if it helps.
>>
>
> Thank you.
> When 9.1 will released ?
> Is it possible to remove 9.0 from downloads so that this issue will not
> propagated?
>
>
If committed, this fix will be available in 9.0.1.
Thanks for the bug report and the reproducible test case.
Hi, i'm trying to request a database using data type "point" using keyword
"IN" with a list of point generated by PHP, like this:
'SELECT * FROM map WHERE position IN ((point(-1,-1), (point(1,-1),
point(1,1), point(-1,1))'
but this request returns me an error: operator doesn't exist point = point.
Here's the patch if it helps.
Thank you.
When 9.1 will released ?
Is it possible to remove 9.0 from downloads so that this issue will not
propagated?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.o
29 matches
Mail list logo
