Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Greg Stark
If the "(n rows)" is the *only* message that needs it then I think it would be simpler to just make it "(Rows: n)" instead. But I wouldn't be surprised if there were other messages with similar issues. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

2009-03-18 Thread David Fetter
On Tue, Mar 17, 2009 at 11:27:54AM +0100, Albe Laurenz wrote: > Tom Lane wrote: > > > The solution to this is to change the following line in > > > src/backend/postmaster/postmaster.c: > > > > We're not going to break a bunch of other applications in order to make > > some undocumented, unsupporte

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Tom Lane
Alvaro Herrera writes: > Sergey Burladyan escribió: >> maybe build farm can help to test it ? > Yes, I think we should implement it and see what happens with the > buildfarm. If we stand still and do nothing, we won't be any wiser. The buildfarm is irrelevant to the fact that some platforms don

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
Alvaro Herrera writes: > Sergey Burladyan escribió: > > Alvaro Herrera writes: > > > > Yes, the main reason is that it is not clear whether this is supported on > > > all > > > OS, or moreover that I believe it is not. So some allowances for that > > > will > > > probably have to be made.

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Alvaro Herrera
Sergey Burladyan escribió: > Alvaro Herrera writes: > > Yes, the main reason is that it is not clear whether this is supported on > > all > > OS, or moreover that I believe it is not. So some allowances for that will > > probably have to be made. > > maybe build farm can help to test it ? Y

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
Alvaro Herrera writes: > Sergey Burladyan escribió: > > gnu gettext have support for correct plural form translation > > (http://www.gnu.org/software/gettext/manual/html_node/Plural-forms.html), > > but postgresql does not use it. why not ? > > maybe it have some problem in some supported OS ? if

Re: [HACKERS] Immediate shutdown and system(3)

2009-03-18 Thread Andrew Dunstan
Heikki Linnakangas wrote: Ok, I've committed a minimal patch to pg_standby in CVS HEAD and REL8_3_STABLE to not interpret SIGQUIT as a signal for failover. I added a signal handler for SIGUSR1 to trigger failover; that should be considered the preferred signal for that, even though SIGINT sti

Re: [HACKERS] Immediate shutdown and system(3)

2009-03-18 Thread Robert Haas
On Wed, Mar 18, 2009 at 5:12 PM, Tom Lane wrote: > Robert Haas writes: >> On Wed, Mar 18, 2009 at 4:40 PM, Bruce Momjian wrote: >>> The CVS commit message. > >> Is there some reason we don't just put it in the release notes as >> *part* of the commit?  Someone can always go back and edit it late

Re: [HACKERS] Immediate shutdown and system(3)

2009-03-18 Thread Tom Lane
Robert Haas writes: > On Wed, Mar 18, 2009 at 4:40 PM, Bruce Momjian wrote: >> The CVS commit message. > Is there some reason we don't just put it in the release notes as > *part* of the commit? Someone can always go back and edit it later. That was suggested before, and I think we actually tr

Re: [HACKERS] Immediate shutdown and system(3)

2009-03-18 Thread Robert Haas
On Wed, Mar 18, 2009 at 4:40 PM, Bruce Momjian wrote: > Heikki Linnakangas wrote: >> This should be mentioned in release notes, as any script that might be >> using SIGQUIT at the moment needs to be changed to use SIGUSR1 or SIGINT >> instead. Where should I make a note of that so that we don't fo

Re: [HACKERS] Immediate shutdown and system(3)

2009-03-18 Thread Bruce Momjian
Heikki Linnakangas wrote: > This should be mentioned in release notes, as any script that might be > using SIGQUIT at the moment needs to be changed to use SIGUSR1 or SIGINT > instead. Where should I make a note of that so that we don't forget? The CVS commit message. -- Bruce Momjian

Re: [HACKERS] Path separator

2009-03-18 Thread Tom Lane
Magnus Hagander writes: > I've seen a couple of reports that the new SSL error messages on windows > look strange with paths the wrong way. For example: > root certificate file "C:\Documents and Settings\\Application > Data/postgresql/root.crt" does not exist. > The issue being the mix of forwar

Re: [HACKERS] small but useful patches for text search

2009-03-18 Thread Peter Eisentraut
On Tuesday 17 March 2009 18:00:57 Robert Haas wrote: > Basically, for the project to grow, it needs more committers, and the > precondition for being added as a committer should be a promise to > spend a certain amount of time reviewing and committing patches other > than your own. According to th

Re: [HACKERS] Immediate shutdown and system(3)

2009-03-18 Thread Heikki Linnakangas
Andrew Dunstan wrote: Heikki Linnakangas wrote: This should be mentioned in release notes, as any script that might be using SIGQUIT at the moment needs to be changed to use SIGUSR1 or SIGINT instead. Where should I make a note of that so that we don't forget? Unless I'm missing it the use o

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Peter Eisentraut
On Wednesday 18 March 2009 11:21:03 Sergey Burladyan wrote: > gnu gettext have support for correct plural form translation > (http://www.gnu.org/software/gettext/manual/html_node/Plural-forms.html), > but postgresql does not use it. why not ? > maybe it have some problem in some supported OS ? Yes

Re: [HACKERS] Solaris getopt_long and PostgreSQL

2009-03-18 Thread Peter Eisentraut
On Tuesday 17 March 2009 20:02:14 Tom Lane wrote: > Zdenek Kotala writes: > > [ use Solaris' version of getopt_long ] > > The reason not to do that was discussed in this thread: > > http://archives.postgresql.org//pgsql-patches/2008-02/msg00075.php That discussion was about option parsing in post

Re: [HACKERS] Immediate shutdown and system(3)

2009-03-18 Thread Heikki Linnakangas
Ok, I've committed a minimal patch to pg_standby in CVS HEAD and REL8_3_STABLE to not interpret SIGQUIT as a signal for failover. I added a signal handler for SIGUSR1 to trigger failover; that should be considered the preferred signal for that, even though SIGINT still works too. SIGQUIT is t

Re: [HACKERS] Review: B-Tree emulation for GIN

2009-03-18 Thread Teodor Sigaev
It's easy to un-dirty that hack, but before I'd like to see your comments about thoughts above. Yeah, please revert that hack. Done. Also, I changed void *extra_data to Pointer extra_data and corresponding **extra_data and ***extra_data to simplify understanding. -- Teodor Sigaev

Re: [HACKERS] cs_CZ vs regression tests, part N

2009-03-18 Thread Zdenek Kotala
Dne 18.03.09 13:35, Tom Lane napsal(a): It's still broken: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=gothic_moth&dt=2009-03-17%2021:06:01 Yes, it is. But it is PL test now ;-). I remain of the opinion that supporting the regression tests in a locale that works like this is more troubl

Re: [HACKERS] DTrace probes broken in HEAD on Solaris?

2009-03-18 Thread Zdenek Kotala
Dne 17.03.09 19:49, Tom Lane napsal(a): Zdenek Kotala writes: Answer why it happens when probes are disabled is, that for user application there are piece of code which prepare DTrace probes arguments which will be passed into kernel DTrace modul. This code has performance penalty which depen

Re: [HACKERS] could not bind IPv4 socket

2009-03-18 Thread Ana Carolina Brito de Almeida
Hi all, I resolved this problem. I had another postgresql installed and it started automatically when I restarted my computer. Thanks. 2009/3/18 Ana Carolina Brito de Almeida > Hi all, > > I installed postgresql 8.3.5 with these commands: > - ./configure --enable-thread-safety (I need this bec

[HACKERS] could not bind IPv4 socket

2009-03-18 Thread Ana Carolina Brito de Almeida
Hi all, I installed postgresql 8.3.5 with these commands: - ./configure --enable-thread-safety (I need this because of dbt2) - make - make install I executed initdb. It's ok. I changed "postgresql.conf" file: listen_addresses = '*'. So, when I started postgresql, I receive these messages: $ pg_c

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Alvaro Herrera
Alvaro Herrera escribió: > Sergey Burladyan escribió: > > Hi, all. > > > > gnu gettext have support for correct plural form translation > > (http://www.gnu.org/software/gettext/manual/html_node/Plural-forms.html), > > but postgresql does not use it. why not ? > You don't need plural forms in this

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Alvaro Herrera
Sergey Burladyan escribió: > Hi, all. > > gnu gettext have support for correct plural form translation > (http://www.gnu.org/software/gettext/manual/html_node/Plural-forms.html), > but postgresql does not use it. why not ? > maybe it have some problem in some supported OS ? if not, can it implemen

Re: [HACKERS] DDL+SQL in PL/pgSQL EXECUTE

2009-03-18 Thread Tom Lane
Vlad Arkhipov writes: > 3. ERROR: relation "t" does not exist > SELECT _EXEC('CREATE TABLE T(ID INTEGER); INSERT INTO T(ID) VALUES (1)'); > 4. Inserts NULL value into ID column instead of default 10. > BEGIN WORK; > CREATE TABLE T(ID INTEGER); > SELECT _EXEC('ALTER TABLE T ALTER COLUMN ID SET DE

[HACKERS] cs_CZ vs regression tests, part N

2009-03-18 Thread Tom Lane
It's still broken: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=gothic_moth&dt=2009-03-17%2021:06:01 I remain of the opinion that supporting the regression tests in a locale that works like this is more trouble than it's worth. regards, tom lane - -- Sent via pgsql-h

[HACKERS] DDL+SQL in PL/pgSQL EXECUTE

2009-03-18 Thread Vlad Arkhipov
Is it a bug or by design? I could not find what behaviour is correct for these statements in PL/pgSQL: This function just executes a string. CREATE OR REPLACE FUNCTION _EXEC(query VARCHAR) RETURNS VOID AS $$ BEGIN EXECUTE query; END; $$ LANGUAGE 'plpgsql'; 1. Works ok. BEGIN WORK; SELECT _EXEC

Re: [HACKERS] Path separator

2009-03-18 Thread Dave Page
On Wed, Mar 18, 2009 at 9:24 AM, Magnus Hagander wrote: > I've seen a couple of reports that the new SSL error messages on windows > look strange with paths the wrong way. For example: > > root certificate file "C:\Documents and Settings\\Application > Data/postgresql/root.crt" does not exist. > >

[HACKERS] Path separator

2009-03-18 Thread Magnus Hagander
I've seen a couple of reports that the new SSL error messages on windows look strange with paths the wrong way. For example: root certificate file "C:\Documents and Settings\\Application Data/postgresql/root.crt" does not exist. The issue being the mix of forward and backwards slashes. Attached p

[HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
Hi, all. gnu gettext have support for correct plural form translation (http://www.gnu.org/software/gettext/manual/html_node/Plural-forms.html), but postgresql does not use it. why not ? maybe it have some problem in some supported OS ? if not, can it implemented ? maybe someone already doing this

Re: [HACKERS] [BUGS] log : bad file dscriptor????

2009-03-18 Thread Heikki Linnakangas
Gurjeet Singh wrote: On Windows, the write to log file is done by a thread (whose main function is pipeThread() ), and since it works completely independent of the SysLoggerMain() ( which is responsible for calling logfile_rotate() periodically, which in turn changes the global variable syslo

Re: [HACKERS] Solaris getopt_long and PostgreSQL

2009-03-18 Thread Zdenek Kotala
Dne 17.03.09 19:48, Chuck McDevitt napsal(a): Any obviously, we don't just use ours for platforms with no or broken getopt_long, > since we are talking Solaris (which has a bug in getopt, but getopt_long works fine) Just for clarification: It is not bug in Solaris. It is Solaris' getopt exte