Nikhil G. Daddikar wrote:
> Hi Craig,
>
> I have a call with EDB folks in an hour. I will post when I have
> something concrete. Meanwhile, if you need anything specific about the
> system, please let me know.
>
> I have Vista Business x64
Hmm. Your setup is the same as mine except that all the
I have tried earlier versions of 8.4 installer on Vista x32 and they'd
failed too. But let me try the latest installer again. I will let you know.
-n.
On 06-04-2010 10:09, Craig Ringer wrote:
Nikhil G. Daddikar wrote:
Hi Craig,
I have a call with EDB folks in an hour. I will post wh
Hi Craig,
I have a call with EDB folks in an hour. I will post when I have
something concrete. Meanwhile, if you need anything specific about the
system, please let me know.
I have Vista Business x64 with Microsoft Security Essentials and UAC
turned ON. I have tried (at least) the following:
Nikhil,
Any movement on collecting some system comparision information so we can
start to figure out why the installer works on my systems, but not on yours?
I've just tested on a couple of other Vista systems (at work) without
problems, so there must be something different about your systems and
On Mon, Apr 5, 2010 at 2:36 PM, David Kerr wrote:
> My app will have over 10k concurrent users. I have huge servers 32 cores
> (64bit), 64GB ram. RedHat linux.
>
> Those 10k users will all be logging in as one of 5 application users.
You should probably also look into memcached to take a lot of
On Mon, Apr 5, 2010 at 4:36 PM, David Kerr wrote:
> On Sat, Apr 03, 2010 at 09:32:25PM -0400, Merlin Moncure wrote:
> -
> - I have a lot of respect for pgbouncer (haven't used pgpool). One
> - possible way to do what you're thinking is to rotate the pool on user.
> - In bouncer each database rol
On 4/5/10, John R Pierce wrote:
> John R Pierce wrote:
>> Garry Saddington wrote:
>>> I had a problem installing my software (which includes Postgresql) on
>>> a Windows 7 demo laptop last week. It turned out that accounts that
>>> are designated as administrator do not have enough privileges to
>
Magnus Hagander wrote:
No, there's a problem with the Desktop Heap getting exhausted because
of system DLLs that allocate from it whenever they are loaded into a
process. It's in the Windows FAQ on wiki.postgresql.org - IIRC it's
right at the bottom.
And yes, we still have the problem - it's a W
On Mon, Apr 5, 2010 at 22:33, John R Pierce wrote:
> Heine Ferreira wrote:
>>
>> Hi
>>
>> In the latest release 8.4.3 is the desktop heap still a problem in
>> Windows?
>> I found some articles on the web that said on Windows xp the desktop heap
>> is rather small.
>> Apparantly under xp it's limi
Thank you. That got it. It gave the expected result of false for the
inequality check. I took a second look at the output of the query and
saw the extra space in front of 'Anneal' in the alarm_history table's
field.
RobR
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
Greetings!
I have the following query:
select charge.charge, alarm_history.area || '!', bases.area || '!',
alarm_history.area::character varying(32) = bases.area::character
varying(32), alarm_history.area <> bases.area, alarm_history.*
from charge
JOIN bases ON charge.base::text = bases.base::t
On Sat, Apr 03, 2010 at 09:32:25PM -0400, Merlin Moncure wrote:
- On Fri, Mar 26, 2010 at 5:17 PM, David Kerr wrote:
- > Howdy all,
- >
- > I have some apps that are connecting to my DB via direct JDBC and I'd like
to pool their connections.
- >
- > I've been looking at poolers for a while, and p
Heine Ferreira wrote:
Hi
In the latest release 8.4.3 is the desktop heap still a problem in
Windows?
I found some articles on the web that said on Windows xp the desktop
heap is rather small.
Apparantly under xp it's limited to 45 connections.
what does the desktop heap (a GUI thing used to
John R Pierce wrote:
Garry Saddington wrote:
I had a problem installing my software (which includes Postgresql) on
a Windows 7 demo laptop last week. It turned out that accounts that
are designated as administrator do not have enough privileges to
install as a service. Without wishing to go de
On Monday 5. April 2010 22.00.41 Peter Geoghegan wrote:
> similar they sound. How can that actually be applied to get the
> functionality that I've described?
I've got a similar problem in my 18th century research, when clerks usually
took pride in being able to spell a name in any number of ways
In response to Peter Geoghegan :
> > http://www.postgresql.org/docs/8.4/static/fuzzystrmatch.html
> >
> > --
> > Bill Moran
> > http://www.potentialtech.com
> > http://people.collaborativefusion.com/~wmoran/
>
> Fuzzystrmatch is generally used to compare two single words for how
> similar they so
Garry Saddington wrote:
I had a problem installing my software (which includes Postgresql) on
a Windows 7 demo laptop last week. It turned out that accounts that
are designated as administrator do not have enough privileges to
install as a service. Without wishing to go delving into the config
> http://www.postgresql.org/docs/8.4/static/fuzzystrmatch.html
>
> --
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/
Fuzzystrmatch is generally used to compare two single words for how
similar they sound. How can that actually be applied to get the
fun
The above is true. For geocoding the same idea is used: the metaphone
function is used against street names, and searched to a simples column,
filled with the results of the metaphone function. It works quite well.
George
On Mon, Apr 5, 2010 at 4:23 PM, Brian Modra wrote:
> On 05/04/2010, Peter
Frank Heikens wrote:
Hi
I recently bought Windows 7 32 bit professional.
Unfortunately Postgresql 8.4.3 did not install or work.
Tell us about your problems, error messages and logs, then we can help
you to get it working.
I started searching Google and found that a lot of other people ha
On 05/04/2010, Peter Geoghegan wrote:
> Hello,
>
> At the moment, users of my application, which runs on 8.4.3, may
> search for products in a way that is implemented roughly like this:
>
> SELECT * FROM products WHERE description ILIKE '%%usr_string%%';
>
> This works reasonably well. However, I
In response to Peter Geoghegan :
> Hello,
>
> At the moment, users of my application, which runs on 8.4.3, may
> search for products in a way that is implemented roughly like this:
>
> SELECT * FROM products WHERE description ILIKE '%%usr_string%%';
>
> This works reasonably well. However, I th
Hello,
At the moment, users of my application, which runs on 8.4.3, may
search for products in a way that is implemented roughly like this:
SELECT * FROM products WHERE description ILIKE '%%usr_string%%';
This works reasonably well. However, I thought it would be a nice
touch to give my users le
Hi
I recently bought Windows 7 32 bit professional.
Unfortunately Postgresql 8.4.3 did not install or work.
Tell us about your problems, error messages and logs, then we can help
you to get it working.
I started searching Google and found that a lot of other people have
the same problem
Hi
In the latest release 8.4.3 is the desktop heap still a problem in Windows?
I found some articles on the web that said on Windows xp the desktop heap is
rather small.
Apparantly under xp it's limited to 45 connections.
They also said that the desktop heap is larger on windows servers and that
g
Hello
2010/4/5 Heine Ferreira :
> Hi
>
> I recently bought Windows 7 32 bit professional.
> Unfortunately Postgresql 8.4.3 did not install or work.
> I started searching Google and found that a lot of other people have the
> same problem.
> Will there be a minor release to fix the problem?
> Will
Hi
I recently bought Windows 7 32 bit professional.
Unfortunately Postgresql 8.4.3 did not install or work.
I started searching Google and found that a lot of other people have the
same problem.
Will there be a minor release to fix the problem?
Will it be fixed in the upcoming version 9.0?
Thanks
Merlin Moncure writes:
> On Sat, Apr 3, 2010 at 3:02 PM, Scott Bailey wrote:
>> SELECT COUNT( DISTINCT row(col1, col2, col3) ) FROM foo
> very clever! This is similar to how I use rowtypes to get around the
> single column restrictions on function calls in the select field list.
Cute, but note
On Sat, Apr 3, 2010 at 3:02 PM, Scott Bailey wrote:
> junaid malik wrote:
>>
>> Is there any alternative of mysql function COUNT(DISTINCT expr,
>> [expr...]) in postgres. We get error if we
>>
>> write count like this count(distinct profile.id, profile.name,
>> profile.age) but it works well in my
On 5 Apr 2010, at 16:33, Andrus wrote:
> Than you.
>
>> remove begin and end from above function.
>
> I tried code belwo in 8.3 but got error
> ERROR: column "line" does not exist
> LINE 29: select * from wordwrap(line,linelen);
>
> Andrus.
Yes of course, you don't specify where to take line
Hello,
I have person to group mapping in which I want to store the time, when this
mapping is valid. I can store the valid time in an array or in seperate rows.
in rows:
create table group_mapping (
group name not null,
person integer not null,
valid_since timestamptz not null,
valid_unt
Peter Hunsberger wrote:
>>> I still don't get it. I do want a zero for the subversion_flags to be
>>> stored in the table. But it returned an error because it didn't like
>>> subversion_flags='' in the UPDATE SQL statement.
>>> subversion_flags | integer | not null default 0
>> Right.
Osvaldo,
CREATE OR REPLACE FUNCTION wordwrap83(line text, linelen integer)
RETURNS SETOF text as $$
select * from wordwrap($1,$2);
$$ LANGUAGE sql;
Thank you. It works.
select * FROM wordwrap83('fdgdf',10)
If you have a "RETURN SETOF" function you must call it with "SELECT *
FROM your_functi
Than you.
remove begin and end from above function.
I tried code belwo in 8.3 but got error
ERROR: column "line" does not exist
LINE 29: select * from wordwrap(line,linelen);
Andrus.
CREATE OR REPLACE FUNCTION wordwrap(line text, linelen integer)
RETURNS SETOF text as $$
DECLARE
words t
On Mon, Apr 05, 2010 at 05:26:39PM +0300, Andrus wrote:
> Thank you.
>
>> another workaround is to wrap the pl/pgsql function in sql function.
>> it's not always easy to re-work the function all into a 'from'
>> expression.
>
> I tried code below in 8.3 but got error
> CREATE OR REPLACE FUNCTION wo
Thank you.
another workaround is to wrap the pl/pgsql function in sql function.
it's not always easy to re-work the function all into a 'from'
expression.
I tried code below in 8.3 but got error
ERROR: syntax error at or near "select"
LINE 30: select * from wordwrap(line,linelen);
Andrus.
Dino,
Not trying to be a "database purist" here, but...
If table A has no key, then why X,Y, and Z belong in one table?
And, table B has no key, then why P,Q, and R belong in one table?
And even more so, why are you trying to put X,Y,Z,P,Q,R into one table?
May be, if you tell us, what business
On Mon, Apr 5, 2010 at 7:28 AM, hubert depesz lubaczewski
wrote:
> On Mon, Apr 05, 2010 at 02:14:33PM +0300, Andrus wrote:
>> select wordwrap('fdgdf',10)
>
> select * from wordwrap('...', ...);
another workaround is to wrap the pl/pgsql function in sql function.
it's not always easy to re-work th
Hello, Andrus
I tested this reproduce case.
8.3.9 return exception
8.3.10 return exception
8.4.0 Crash Server!!
8.4.1 OK
8.4.2 OK
8.4.3 OK
Just for your information,
8.4.0's clash made this call stack(I analyzed core file)
#0 DirectFunctionCall1 (func=0x8095a70 , arg1=16421) at
fmg
On Mon, Apr 05, 2010 at 02:14:33PM +0300, Andrus wrote:
> select wordwrap('fdgdf',10)
select * from wordwrap('...', ...);
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
--
Sen
In 8.3 code below causes exception
ERROR: set-valued function called in context that cannot accept a set
CONTEXT: PL/pgSQL function "wordwrap" line 21 at RETURN NEXT
How to fix this so that wordwrap works in any PostgreSql 8.x version or at
least in
8.3 and 8.4 ?
Andrus
CREATE OR REPLACE F
Hello all,
I'm probably missing something obvious here I have the pl/pgsql
debugger installed in template1 on my laptop so that it gets installed
automatically in development databases; however, sometimes I need to
remove it from a specific database.
I can't find an uninstall script for it in
2010/4/4 Björn Lindqvist :
> Subject: Completely wrong row estimates
>
> Hello everybody,
>
> Here is the EXPLAIN ANALYZE output for a simple query in my database
> running on postgres 8.3.9:
>
> EXPLAIN ANALYZE
> SELECT * FROM word w JOIN video_words vw ON w.id = vw.word_id
> WHERE w.word = 'tagt
43 matches
Mail list logo
