Re: [GENERAL] about RPM build options

2010-10-24 Thread Devrim GÜNDÜZ
On Wed, 2010-10-13 at 10:28 -0400, Ray Stell wrote: > > > 1. enable thread safety? > > > "--disable-thread-safety" is given. > > > Where is the flag "given?" It is in the RPM spec file. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: ht

[GENERAL] Full text search in Chinese

2010-10-24 Thread Mike Chamberlain
Has anyone implemented FTS in Chinese on PG? I guess I need a Chinese ispell dictionary and parser, neither of which I can find after a lot of googling. I have a bounty on this question on Stackoverflow if anyone wants to claim it: http://stackoverflow.com/questions/3994504/how-do-i-implement-fu

Re: [GENERAL] Performance implications of creating many, many sequences

2010-10-24 Thread Craig Ringer
On 10/24/2010 12:42 AM, Michael Gardner wrote: On Oct 22, 2010, at 11:03 PM, Craig Ringer wrote: Instead, maintain a counter, either in the main customer record or in an associated (customer_id, counter) side table if you want to reduce potential lock contention. Write a simple SQL function t

Re: [GENERAL] Getting ROW_COUNT from MOVE in 8.3

2010-10-24 Thread Reuven M. Lerner
Hi, Peter. You wrote: But is there any way for me to get, in 8.3, the number of rows over which a cursor has skipped? Keep in mind that after this count has executed, we're then going to rewind the cursor, chunking through the result set with a separate function. You could store the query res

Re: [GENERAL] Windows 2008/IIS cannot connect to Postgres 9.0

2010-10-24 Thread Francisco Figueiredo Jr.
On Thu, Oct 7, 2010 at 00:00, Craig Ringer wrote: > On 05/10/10 16:08, Mike Christensen wrote: > >>    at Npgsql.NpgsqlCommand.CheckConnectionState() at >> Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) at > > It looks like nobody reading -GENERAL really speaks npgsql/.NET/C#. > Perhaps you sh

Re: [GENERAL] Getting ROW_COUNT from MOVE in 8.3

2010-10-24 Thread Peter Eisentraut
On sön, 2010-10-24 at 15:41 +0200, Reuven M. Lerner wrote: > But is there any way for me to get, in 8.3, the > number of rows over which a cursor has skipped? Keep in mind that > after > this count has executed, we're then going to rewind the cursor, > chunking > through the result set with a s

Re: [GENERAL] What is "return code" for WAL send command

2010-10-24 Thread Tom Lane
zhong ming wu writes: > postgres user has both rsync and ssh in its path but is it possible > that it is not using $PATH ? > One other thing is that just before the error the postgres was > restarted by other admin with rc.d/postgresql command > instead of pg_ctl which is what I normally use. Pe

Re: [GENERAL] Advice needed on application/database authentication/authorization/auditing model

2010-10-24 Thread Harald Fuchs
In article <20101022161331.gd9...@frohike.homeunix.org>, Peter Bex writes: > As far as I can see, this would imply either creating views on the > for every user (or company?), or manually crafting queries > to do the same. Not necessarily. Consider this: CREATE TABLE t1 ( id serial NOT N

Re: [GENERAL] What is "return code" for WAL send command

2010-10-24 Thread zhong ming wu
On Sat, Oct 23, 2010 at 11:48 AM, Tom Lane wrote: > > A more recent version of Postgres would break that down for you: it > means the subprocess exited with exit(127).  A look in the shell > man page suggests this is a "command not found" failure.  Maybe > there's something flaky about where you h

[GENERAL] Getting ROW_COUNT from MOVE in 8.3

2010-10-24 Thread Reuven M. Lerner
Hi, everyone. I'm working on an application that needs to perform a query twice -- once to retrieve the total number of rows in a table, and a second that then retrieves chunks of rows. The current implementation executes the query twice, once with COUNT(*) and another with OFFSET and LIMIT b

Re: [GENERAL] createlang plpythonu fails on 64bit windows

2010-10-24 Thread Massa, Harald Armin
For the record: > Should'nt plplython.dll be a valid win32_x64 application when being loaded > > into PostgreSQL 64bit? Could this be the source of the error? (as in: > > "plpython.dll is 32 bit, PostgreSQL is 64bit, so no loading of > 32-bit-module > > into 64-bit-process?) > > plpython.dll is un

Re: [GENERAL] createlang plpythonu fails on 64bit windows

2010-10-24 Thread Dave Page
On Sun, Oct 24, 2010 at 10:02 AM, Massa, Harald Armin wrote: > (which translated to english is roughly: > createlang: Installation of language failed: ERROR:  could not load library > »C:/Program Files/PostgreSQL/9.0/lib/plpython.dll« : %1 is not a valid > Win32 application. > Should'nt plplytho

[GENERAL] createlang plpythonu fails on 64bit windows

2010-10-24 Thread Massa, Harald Armin
Hello, I am using PostgreSQL 9.0.1 on Windows 7.0 Ultimate 64bit. I tried to use plpython within one of my databases, but installing the language fails with: C:\Program Files\PostgreSQL\9.0\lib>createlang --dbname=ibox --echo -U postgres plpythonu SELECT oid FROM pg_catalog.pg_language WHERE lan