On 6/20/07, Robin Ericsson <[EMAIL PROTECTED]> wrote:
`-mcpu=' is deprecated. Use `-mtune=' or '-march=' instead.
Ok solved. This is what the configure-script barfs on. Hacking the
spec-file to change this flag removes this problem.
--
Hi,
I'm trying to recompile the SRPM with ldap support (maybe this should
be added as an option to the spec?) but it fails to check for ldap_r
due to problems finding my pthread flag in configure.
Snip from configure:
checking whether pthreads work with -pthread... no
...
checking for ldap_simpl
On 6/13/07, Ben <[EMAIL PROTECTED]> wrote:
Why would that be a problem if each is configured to listen on different
addresses?
But maybe a better question to ask would be how people are doing failover
in the case where you have two servers, each handling a seperate set of
data and acting as back
On 3/16/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Robin Ericsson" <[EMAIL PROTECTED]> writes:
> Yes, I've looked at those, I was thinking that point looked like a
> good type, but it's only 2d, so maybe I need a hint on how to use this
> in a 3d environ
On 3/15/07, Webb Sprague <[EMAIL PROTECTED]> wrote:
http://www.postgresql.org/docs/8.2/static/datatype-geometric.html
Have you looked at these yet? If not, you asked your question
prematurely and should have read the docs. If so, in what respect do
they not work for you?
Yes, I've looked at
On 3/15/07, Webb Sprague <[EMAIL PROTECTED]> wrote:
... planning a simple coordinate system, where objects are described
> as x, y and z. Are there any contribs or extensions available that can
> help me with datatypes, calculation of length between two points, etc?
google postgis. It is for ge
Hi,
I'm planning a simple coordinate system, where objects are described
as x, y and z. Are there any contribs or extensions available that can
help me with datatypes, calculation of length between two points, etc?
--
regards,
Robin
---(end of broadcast)---
On 10/19/06, DANTE Alexandra <[EMAIL PROTECTED]> wrote:
Hello Robin, hello List,
Can I use it on RHEL4-AS ? I also tried to find the rpm sources on the
Red Hat web site, without success...
Download the source and try. rpmbuild --rebuild *.src.rpm. If it
doesn't work at least you have .spec fi
On 10/19/06, DANTE Alexandra <[EMAIL PROTECTED]> wrote:
My problem is that I have not found any RPM for "perl-rrdtool" and
"rrdtool" for IA64 and RHEL4-AS (for the others, it's OK).
Does someone know where I can find them or tell me where I can find the
associated "tar.gz" archive ?
Download t
On 9/18/06, Najib Abi Fadel <[EMAIL PROTECTED]> wrote:
Hi,
i was searching for a load balancing solution for
postgres, I found some ready to use software like
PGCluster, Slony, pgpool and others.
It would really be nice if someone knows which one is
the best taking in consideration that i have
On 7/19/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
Both are in my pgsql-general maildir, message ids:
[EMAIL PROTECTED] [EMAIL PROTECTED]
I find those as well.
regards,
Robin
---(end of broadcast)---
TIP 3: Have you checked our e
Wen Guangcheng wrote:
Hi,
> TABLESPACE RAPIS;
> psql:/opt/rapisa/sql/TD_ACCESSCOUNT.sql:14: ERROR: syntax error at or near
> "(" at character 52
> I really don't know what is wrong with it and do appreciate it if anyone would
> point out it. The version of Postgresql
Wen Guangcheng wrote:
> Hi Gurus,
Hi!
> CREATE TABLE TD_ACCESSCOUNT(
> AC_YEAR NUMBER(4,0)NOT NULL,
> AC_MONTHNUMBER(2,0)NOT NULL,
> AC_DAYS NUMBER(2,0)NOT NULL,
> OFFICE_ID VARCHAR2(7)NOT NULL,
> AC_COUNTNUMBER(6
Martijn van Oosterhout wrote:
On Tue, Apr 05, 2005 at 11:17:48AM +0200, Robin Ericsson wrote:
Martijn van Oosterhout wrote:
I suppose the choice comes down to either PHP splitting the DB access
(like other languages) or PostgreSQL splitting out pl/PHP.
Most major distributions (Fedora Core, Debian
Martijn van Oosterhout wrote:
I suppose the choice comes down to either PHP splitting the DB access
(like other languages) or PostgreSQL splitting out pl/PHP.
Most major distributions (Fedora Core, Debian, Redhat) splits core php
and database-access in different packages. Might be that sqlite is c
itself? I.e, files will be at the same places if I upgrade from FC packages?
regards,
Robin
--
Robin Ericsson
http://robin.vill.ha.kuddkrig.nu/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
Christopher Browne wrote:
The poll isn't about "OSS"; it's a popularity contest for proprietary
software that runs on Linux.
It's interesting to see that MySQL is only third at the moment.
regards,
Robin
---(end of broadcast)---
TIP 1: subscri
and sort is well setup, but what about thread
caching? Knowing that will once in a while you will have a connection
burst you can tell mysql to cache thread so that it can save time next
time it needs them.
--
Robin Ericsson
http://robin.vill.ha.kuddkrig.nu/
---(end of
On Wed, 2004-11-24 at 08:30 -0800, Joshua D. Drake wrote:
> Peter Eisentraut wrote:
>
> >Joshua D. Drake wrote:
> >
> >
> >>Well you can't just "upgrade" 7.2.1 to 7.4.6. You have to dump and
> >>restore.
> >>
> >>
> >
> >The Debian package does that automatically. On some days...
> >
> >
Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> One's marked VOLATILE, the other is marked IMMUTABLE. This affects
> whether it's considered a constant, the planner estimates and hence
> whether it uses the index.
Is there even a way to solve it this way via a procedure?
I've tried different
After some discussion on performance list, I guess this is back to a
general question :)
This is very simplified query of my real problem, but it should show the
way of the problems.
CREATE OR REPLACE FUNCTION ago(interval) RETURNS timestamp AS
'SELECT (now() - $1)::timestamp without time zone'
Sorry, this should have been going to performance.
Regards,
Robin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Wed, 2004-10-13 at 18:01 +0200, Robin Ericsson wrote:
> Using exact timestamp makes the query go back as it should in speed (see
> explain below). However I still have the problem using a stored
> procedure or even using the "ago"-example from above.
Well, changing ago
On Fri, 2004-10-08 at 10:11 -0400, Tom Lane wrote:
> Robin Ericsson <[EMAIL PROTECTED]> writes:
> > -> Index Scan using idx_d_entered on data (cost=0.00..18024.04
> > rows=50360 width=16) (actual time=0.210..0.247 rows=1 loops=1)
> >
The query have been running ok for some time now, but this morning I
decided to run vacuum analyze (vacuumdb -a -z) on the cluster, and
suddenly the query isn't running very well at all. This query has only
one value in the "IN", if I add another id the query becomes really
really slow.
Query:
SEL
On Thu, 2004-06-17 at 11:38, Richard Huxton wrote:
> Robin Ericsson wrote:
> > Hi,
> >
> > I have a field in which I save the follow:
> > {{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}}
> >
> > The first field is a reference to an id in another ta
Hi,
I have a field in which I save the follow:
{{8,0.58},{9,972420},{10,239544},{6,0.49},{7,0.63}}
The first field is a reference to an id in another table and the second
field is a value.
Can these values be used somehow in a select query to join the other
table?
I don't mind getting them on d
Hi,
I want to create a stored procedure that can take a dynamic number of
in-parameters and base an inside-query based on those parameters.
My ideas was to use text[] as input parameters like this.
CREATE OR REPLACE FUNCTION get_table(text[])
RETURNS SETOF table AS
'
DECLARE
params AL
28 matches
Mail list logo
