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.
--
regards,
Robin
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
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
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/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 environment.
Yeah, the built-in geometric types are all 2D
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
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
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 the
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...
/index.php3/stat/3/srodzaj/2/search/rrdtool-1.2.13-1.fc3.rf.src.rpm
Download the source and try. rpmbuild
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
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,0)
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 is
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
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
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:
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
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...
Really? WOW! I wonder if
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'
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
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() to use timestamp without
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 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)
Index Cond: 'now'::text)::timestamp(6
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:
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
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 table and the second
field is a value.
Can
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
28 matches
Mail list logo
