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

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

Re: [HACKERS] Path separator

2009-03-18 Thread Dave Page
On Wed, Mar 18, 2009 at 9:24 AM, Magnus Hagander mag...@hagander.net 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\SNIP\Application Data/postgresql/root.crt

[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

[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\SNIP\Application Data/postgresql/root.crt does not exist. The issue being the mix of forward and backwards slashes.

[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

[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_mothdt=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

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

2009-03-18 Thread Tom Lane
Vlad Arkhipov arhi...@dc.baikal.ru 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

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 implemented ?

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 example.

[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: $

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 ana...@ig.com.br Hi all, I installed postgresql 8.3.5 with these commands: - ./configure --enable-thread-safety (I

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 zdenek.kot...@sun.com 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

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_mothdt=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

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] 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

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 zdenek.kot...@sun.com 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

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] 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

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 the

Re: [HACKERS] Path separator

2009-03-18 Thread Tom Lane
Magnus Hagander mag...@hagander.net 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\SNIP\Application Data/postgresql/root.crt does not exist. The issue being

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] Immediate shutdown and system(3)

2009-03-18 Thread Robert Haas
On Wed, Mar 18, 2009 at 4:40 PM, Bruce Momjian br...@momjian.us 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

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

2009-03-18 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Wed, Mar 18, 2009 at 4:40 PM, Bruce Momjian br...@momjian.us 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

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

2009-03-18 Thread Robert Haas
On Wed, Mar 18, 2009 at 5:12 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Wed, Mar 18, 2009 at 4:40 PM, Bruce Momjian br...@momjian.us wrote: The CVS commit message. Is there some reason we don't just put it in the release notes as *part* of the commit?

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

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
Alvaro Herrera alvhe...@commandprompt.com 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

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Alvaro Herrera
Sergey Burladyan escribió: Alvaro Herrera alvhe...@commandprompt.com 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

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
Alvaro Herrera alvhe...@commandprompt.com writes: Sergey Burladyan escribió: Alvaro Herrera alvhe...@commandprompt.com 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

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com 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

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, unsupported Oracle