On 2012-02-23 20:28, Tom Lane wrote:
Hmmm ... I'd be happier with this patch if it reversed the order of the
library probes (ie, try the nonstandard names first), as then it would
obviously not break any configurations that worked before. Would that
be OK from your point of view, or not?
It w
On 2012-02-23 19:51, tomet...@batory.org.pl wrote:
I've attached a proposed patch for configure.in
The bug reporting form has word-wrapped my patch - I'm attaching a
correct version.
4. Run using "System Tools\Terminal":
su -c 'yum -y install mingw32-gcc mingw32-openssl gcc'
Sorr
On 2008-11-12 19:07, Chris Wood wrote:
> here is where it works in 8.3.1:
> CONSTRAINT public_phone_ch CHECK (((public_phone = ''::text) OR
> ("substring"(public_phone, '^[0-9]{10}(,[0-9]{10})*$'::text) IS NOT NULL;
> protocalte=> insert into locn values(10, '1231231234') ;
8.3.1 had a bu
On 2008-11-06 07:56, Traci Sumpter wrote:
> Equation (315-0)/180*pi
> PostgreSQL 3.14159265358979
You equation in SQL looks like this:
=> select (315-0)/180*pi from (select 3.14159265358979 as pi) as a;
Which is an equivalent of:
=> select (315/180)*pi from (select 3.14159265358979 as pi) as
On 2008-07-23 11:48, valgog wrote:
> Another question. Is it possible to change the current Database
> LC_CTYPE on the database without recreating it with initdb and
> reimporting all the data.
No.
> I would rather prefer my indexes recreated, rather then reimporting
> database (cannot afford su
On 2008-03-26 09:41, [EMAIL PROTECTED] wrote:
> 5. explain select count(*) from akh_testing_result
> Aggregate (cost=206372.95..206372.95 rows=1 width=0)
> -> Seq Scan on akh_testing_result (cost=0.00..184804.56 rows=8627356
> width=0)
You will always get seq scan when you select count(*) w
On Tue, 22 Jan 2008, Michael Akinde wrote:
>> What I *do* see is that the process size as reported by "top"
>> quickly jumps to 900MB plus and then sits there. This is not a
>> memory leak though, it is just a side effect of the way "top"
>> reports usage of shared memory.
>
> Also, since the blo
On Mon, 14 Jan 2008, David Gradwell wrote:
> Description:backslash_quote = off doesn't work any more
I think you need to
set standard_conforming_strings=on;
instead.
Then:
select '\''012'::text;
text
---
\'012
(1 row)
sele
On Tue, 04 Jul 2006, Tom Lane wrote:
> Tomasz Ostrowski <[EMAIL PROTECTED]> writes:
> > So why estimate regex expressions if there is no estimation possible?
> > Let's set this estimate to be pessimistic (match everything or
> > everything not null) and it will
On Tue, 04 Jul 2006, Tom Lane wrote:
> I think the real problem here is that regex matching is the wrong
> tool for the job. Have you looked into a full-text index
> (tsearch2)?
So much to do with so little time...
I've briefly looked into it but:
- it's complicated;
- it is not needed - basi
On Mon, 03 Jul 2006, Tom Lane wrote:
> > -> Seq Scan on organization (cost=0.00..480.95 rows=1 width=4) (actual
> > time=0.071..69.702 rows=1892 loops=1)
> > Filter: ((organization_location)::text ~* 'warszawa'::text)
>
> How many rows are there in the organization table?
About 9000. And
I have a very slow query when enable_seqscan=on and very fast when
enable_seqscan=off. My schema looks like this (relevant columns
only):
create table organizations (
organization_id serial primary key,
organization varchar(200) not null,
organization_location varchar(55) n
On Thu, 11 May 2006, Richard Yen wrote:
> I'm experiencing signal 11 (segmentation fault) failures on the
> master node of a 3-node Slony-I cluster. In the past week, we've
> averaged a little more than one segfault per day (11 times in the
> past 10, including today). Any ideas what's goi
The following bug has been logged online:
Bug reference: 2362
Logged by: Tomasz Ostrowski
Email address: [EMAIL PROTECTED]
PostgreSQL version: not applicable
Operating system: not applicable
Description:bug reporting form: "submit" shows only "&i
The following bug has been logged online:
Bug reference: 2361
Logged by: Tomasz Ostrowski
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Windows XP
Description:windows installer: pg_config not installed when
"Database Server"
Using "char*" as an argument type instead of "const char*" in ecpglib.h
causes that for example the following sample program, basically
copied from docmentation
http://www.postgresql.org/docs/8.1/interactive/ecpg-dynamic.html ,
does not compile using "gcc-4.0.1":
test.pgc
#include
16 matches
Mail list logo
