Re: [BUGS] BUG #6519: Server doesn't listem

2012-03-05 Thread Euler Taveira de Oliveira
3]). [1] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral [2] http://www.postgresql.org/docs/9.1/static/runtime-config-connection.html [3] http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreS

Re: [BUGS] BUG #6444: Postgresql crash

2012-02-09 Thread Euler Taveira de Oliveira
her bug that was fixed in 8.4.10 (in this case, just get the patch [1] and build a custom version). [1] http://git.postgresql.org/pg/commitdiff/81f4e6cd27d538bc27e9714a9173e4df353a02e5 -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvol

Re: [BUGS] BUG #6412: psql & fe-connect truncate passwords

2012-01-28 Thread Euler Taveira de Oliveira
hen we reach that limit and (iii) fix the PasswordFromFile(). Looking at your patch, it seems to fix only (i). > require understanding of what the real password length limit in a > database is. > There is no such limit; it is stored in a text datatype. -- Euler Taveira de Oliveira - Timb

Re: [BUGS] BUG #6413: pg_relation_size wont work on table with upper case chars

2012-01-28 Thread Euler Taveira de Oliveira
On 28-01-2012 13:16, ja...@stev.org wrote: > pg_relation_size('Attempts') > and > pg_relation_size('attempts') > pg_relation_size('"Attempts"') -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Cons

Re: [BUGS] BUG #6412: psql & fe-connect truncate passwords

2012-01-28 Thread Euler Taveira de Oliveira
y to present the issue. I get Internal Server > Error messages when I attempt to subscribe to any of the pgsql mailing > lists, so this makes communication with the lists difficult. > Bugs are tracked here but when it is not a bug but an improvement, we just redirect this thread to -hackers. --

Re: [BUGS] BUG #6412: psql & fe-connect truncate passwords

2012-01-28 Thread Euler Taveira de Oliveira
ase, and user. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] One question about VACUUMDB command - please

2012-01-26 Thread Euler Taveira de Oliveira
.html [3] http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make c

Re: [BUGS] BUG #6386: PITR never find a consistent recovery point

2012-01-08 Thread Euler Taveira de Oliveira
is *after* you send a pg_stop_backup()? -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6353: If there is invalid line in pg_hba.conf, DB start fails without any nofice and no logs in pgstartup.

2011-12-22 Thread Euler Taveira de Oliveira
/pg_hba.conf" FATAL: could not load pg_hba.conf If you don't have logging_collector enabled, you should get the above message in your terminal. Problem is: instead of local you should use host. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Cons

Re: [BUGS] BUG #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-05 Thread Euler Taveira de Oliveira
l address user names, and perhaps improve URL parsing Search for "url text search parser" in the archives. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pg

Re: [BUGS] BUG #6327: Prefix full-text-search fails for hosts with complicated names

2011-12-05 Thread Euler Taveira de Oliveira
On 05-12-2011 09:40, marcin.kasper...@mekk.waw.pl wrote: > 'goog:*' matches google.com > but > 'e-goog:*' does not match e-google.com > It is a known limitation. The text search parser ignores some uncommon cases. See TODO and archives. -- Euler Taveira

Re: [BUGS] BUG #6258: Lock Sequence

2011-10-17 Thread Euler Taveira de Oliveira
.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=21538377ee6a0ee91f756726bd8b3de6d19fd20a -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org

Re: [BUGS] Timezone issues with Postrres

2011-09-21 Thread Euler Taveira de Oliveira
T| -06:00:00 | t America/Inuvik | MDT| -06:00:00 | t MST7MDT | MDT| -06:00:00 | t Navajo | MDT| -06:00:00 | t Etc/GMT+6| GMT+6 | -06:00:00 | f (27 registros) ... and I suspect the is_dst is true. [1] ht

Re: [BUGS] Timezone issues with Postrres

2011-09-16 Thread Euler Taveira de Oliveira
.4.8) else update your OS tzdata and restart the PostgreSQL. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make c

Re: [BUGS] BUG #6041: Unlogged table was created bad in slave node

2011-05-26 Thread Euler Taveira de Oliveira
o I think we should emit the real cause in those cases, if possible (not too much overhead). The message would be "Unlogged table content is not available in standby server". [1] http://www.postgresql.org/docs/9.1/static/sql-createtable.html -- Euler Taveira de Oliveira

Re: [BUGS] BUG #6017: COPY from CSV file, WITH CSV HEADER fields order not respected

2011-05-09 Thread Euler Taveira de Oliveira
Em 09-05-2011 15:07, pedro mg escreveu: # COPY test1 FROM '/tmp/test1.csv' WITH CSV HEADER Why don't you specify the columns? COPY test1 (key, c2, c1) FROM '/tmp/test1.csv' WITH CSV HEADER -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/

Re: [BUGS] BUG #6009: Duvida

2011-05-07 Thread Euler Taveira de Oliveira
o comando 'net user postgres /delete' no prompt do DOS e tente instalar novamente. [1] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suport

Re: [BUGS] BUG #6013: PostgreSql Lento

2011-05-07 Thread Euler Taveira de Oliveira
consultoria para executar a manutenção adequada do SGBD; ou, se quiser, pode utilizar a lista de discussão brasileira pgbr-geral [1] como fonte de informação sobre o seu problema. [1] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral -- Euler Taveira de Oliveira - Timbira

Re: [BUGS] BUG #5951: ERRO NO INICIO DA INSTALACAO

2011-03-27 Thread Euler Taveira de Oliveira
E depois, executar o instalador novamente. O nome do software não é postgree e sim postgres ou postgresql. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5934: postgresql.conf: optional equal sign

2011-03-16 Thread Euler Taveira de Oliveira
ian bugs...] It seems you already reported the bug [1] for Debian guys. [1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=618583 -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://ww

Re: [BUGS] CREATEROLE does not permit commenting on newly-created roles

2011-03-07 Thread Euler Taveira de Oliveira
ts. [1] http://www.postgresql.org/docs/9.0/static/sql-comment.html -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5878: BTREE_BUILD_STATS causes 'make check' to fail

2011-02-18 Thread Euler Taveira de Oliveira
one reorganizes the header files. Those debug macros deserve a refactor but nobody bothers to do it yet. -- Euler Taveira de Oliveira http://www.timbira.com/ diff --git a/src/backend/access/nbtree/nbtree.c b/src/backend/access/nbtree/nbtree.c index 558ace1..ba01874 100644 *** a/src/backen

Re: [BUGS] BUG #5819: Translation Error of initdb's zh_CN.po

2011-01-07 Thread Euler Taveira de Oliveira
[2]. [1] http://babel.postgresql.org/ [2] http://pgfoundry.org/tracker/?group_id=164 -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Problems with max_connections parameter

2010-12-06 Thread Euler Taveira de Oliveira
ther one? I would be a good idea, specially if you're restarting the PostgreSQL between tests. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Problems with max_connections parameter

2010-12-03 Thread Euler Taveira de Oliveira
Jorge Augusto Meira escreveu: > This is a bug? > You don't provide sufficient information. PostgreSQL version? Error message? Talking about your problem, are you sure you're not reaching max_connections? Did you check the logs? -- Euler Taveira de Oliveira http:/

Re: [BUGS] BUG #5778: pgAdminIII 1.12.1 Japanese Translation File

2010-12-01 Thread Euler Taveira de Oliveira
min3.git;a=commit;h=6c0bbd89869939e1b48e9235c30d9601347316b8 -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5656: parameter 'client_min_messages' accept values not listed in enumvals

2010-09-14 Thread Euler Taveira de Oliveira
e/false, 0/1, yes/no). My point is if they are not useful let's rip them to not confuse people. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5656: parameter 'client_min_messages' accept values not listed in enumvals

2010-09-14 Thread Euler Taveira de Oliveira
Bruce Momjian escreveu: > We are basically reusing the same validation code for this and other > min_messages settings. > No, we have two enums ({client,server}_message_level_options); I don't understand why we should have these options in client_min_messages enum. -- Eu

Re: [BUGS] BUG #5656: parameter 'client_min_messages' accept values not listed in enumvals

2010-09-14 Thread Euler Taveira de Oliveira
>> {debug5,debug4,debug3,debug2,debug1,log,notice,warning,error} > > It's intentional that PANIC isn't listed there (nor is FATAL), > on the grounds that it's not really a useful setting. > Fine. But shouldn't we remove these options from

Re: [BUGS] BUG #5652: Optimizer does wrong thing with partitioned tables

2010-09-10 Thread Euler Taveira de Oliveira
le nor an optimizer artifact to know aggregate information before scanning all of the partitions. Maybe when we have a better support for table partitioning such optimizer artifact would be implemented but don't hold your breath. -- Euler Taveira de Oliveira http://www.timbira.com/ --

Re: [BUGS] Dúvida

2010-09-02 Thread Euler Taveira de Oliveira
ente a lista da comunidade brasileira em [1]. [1] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription

Re: [BUGS] BUG #5629: ALTER SEQUENCE foo START execute a RESTART

2010-09-01 Thread Euler Taveira de Oliveira
Tom Lane escreveu: > I'm not inclined to go and retroactively document that these spellings > are possible but deprecated in the old branches. I think that would > just confuse matters even more. > Is it worth preventing that sloppy implementation in the old branches? --

Re: [BUGS] help pleas

2010-07-31 Thread Euler Taveira de Oliveira
;re using <= 8.1.x. In this case, that option does not exist. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5342: Error

2010-02-23 Thread Euler Taveira de Oliveira
Shilpa.R escreveu: > select agegrp, cartype, risk, count(*) as count > from trset > group by risk, grouping sets ((agegrp,cartype)) > This is not a bug. If you had searched the fine manual, you would figure out that grouping sets is not supported by PostgreSQL yet. -- Eule

Re: [BUGS] Cache lookup failure for index during pg_dump

2010-02-19 Thread Euler Taveira de Oliveira
happen. > I did not see it documented anywhere. Should we at least add a comment at the top of pg_dump documenting this behavior? Attached is a proposed patch using your own words. -- Euler Taveira de Oliveira http://www.timbira.com/ *** src/bin/pg_dump/pg_dump.c.orig 2010-02-19 23:22:

Re: [BUGS] BUG #5331: Integer overflow in tmie counter

2010-02-17 Thread Euler Taveira de Oliveira
a bug or not. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error

2010-02-16 Thread Euler Taveira de Oliveira
74 of configuration file "/a/data/pg_hba.conf" FATAL: could not load pg_hba.conf -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Postgresql Relations disappear

2010-02-16 Thread Euler Taveira de Oliveira
sergio dominguez escreveu: > I started to work with postgresql but i find that all the relations I > create disappear when I quit (\q) > This is not a bug. I bet your tables are loaded into a schema that is not in the search_path. -- Euler Taveira de Oliveira http://www.ti

Re: [BUGS] Failed to run initdb - not resolved bug 5130

2010-01-26 Thread Euler Taveira de Oliveira
t; able to compile it. I don't know how to configure builders to launch > makefiles or what to do. > Take a look at [1][2]. [1] http://wiki.postgresql.org/wiki/Working_with_Eclipse [2] http://www.postgresql.org/docs/faqs.FAQ_MINGW.html -- Euler Taveira de Oliveira http://www.timb

Re: [BUGS] BUG #5295: Function OUT parameters names and data types skewed with IN parameters

2010-01-23 Thread Euler Taveira de Oliveira
ourceforge.net/?page=support -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5216: pgFouine 1.1 not working correctly, when LC_MESSAGES is "es_ES.UTF-8"

2009-11-29 Thread Euler Taveira de Oliveira
Guillaume Smet escreveu: > pgFouine doesn't support lc_message other than english. > What about adding a translation table in pgFouine to catch those cases too? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.o

Re: [BUGS] BUG #5145: Complex query with lots of LEFT JOIN causes segfault

2009-10-29 Thread Euler Taveira de Oliveira
mydb $ gdb /path/to/postgres $PGDATA/core (gdb) bt . . . (gdb) quit -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2009-10-22 Thread Euler Taveira de Oliveira
, 'foo_...@baz.com'); email ─ foo b...@baz.com _ (3 rows) -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5075: Text Search parser does not identify xml tag when attribute name's contains underscore

2009-09-23 Thread Euler Taveira de Oliveira
on't have underscores in HTML attribute names. In this case, should it fail? I don't think so but... The problem exists in 8.3, 8.4 and HEAD. It is a trivial fix so I think there isn't a problem to back-patch it. [1] http://www.w3.org

Re: [BUGS] Requesting the Revision History

2009-09-22 Thread Euler Taveira de Oliveira
nymous repository. rsync -qavzCH --delete anoncvs.postgresql.org::pgsql-cvs /tmp/pgcvs/ You can also browse it. http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/ -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To mak

Re: [BUGS] fillfactor hides autovacuum parameters in 8.4.0

2009-08-18 Thread Euler Taveira de Oliveira
leave the default assignment to relation_needs_vacanalyze(). If nobody steps up I'll give it a stab later. [1] http://archives.postgresql.org/pgsql-hackers/2009-02/msg00303.php -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@post

Re: [BUGS] BUG #4927: psql does "spoil" the query before sending it to server

2009-07-17 Thread Euler Taveira de Oliveira
Tom Lane escreveu: > Euler Taveira de Oliveira writes: >> Why are we analysing the query there? One possible fix is to remove the '.' >> as >> delimiter in strtokx(). The trivial patch is attached. > > Surely that would break a lot of other cases. > Wh

Re: [BUGS] BUG #4927: psql does "spoil" the query before sending it to server

2009-07-17 Thread Euler Taveira de Oliveira
Why are we analysing the query there? One possible fix is to remove the '.' as delimiter in strtokx(). The trivial patch is attached. -- Euler Taveira de Oliveira http://www.timbira.com/ Index: copy.c === RCS file: /a

Re: [BUGS] BUG #4830: operator does not exists

2009-05-29 Thread Euler Taveira de Oliveira
o campo Like '1' /*FilterParam1*/ > Isto *não* é um bug. Utilize nome_do_campo like 1. Por que você está utilizando LIKE ao invés de um = ? PS> da próxima vez escreva em inglês porque nem todos nesta lista falam português. [1] http://www.postgresql.org/docs/8.3/static/release-8-3.html#AE

Re: [BUGS] BUG #4827: install

2009-05-28 Thread Euler Taveira de Oliveira
ave in mind that binary packages were only produced by PostgreSQL community until 8.1.11. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4755: lost graphical relationship between tables in DbVis w/ new PG release

2009-04-10 Thread Euler Taveira de Oliveira
. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-10 Thread Euler Taveira de Oliveira
you think are affected by it and can judge the difference? I don't know, and I don't wish to be forcing a decision about it on users. Why don't we follow Magnus suggestion? HINT: you could disable certificate verification by setting PGSSLVERIFY=none -- Euler Taveira de

Re: [BUGS] BUG #4749: trigonometric functions broken

2009-04-05 Thread Euler Taveira de Oliveira
Stefano Salvador escreveu: >select sin(pi()); > > returns: 1.2246 > euler=# select sin(pi()); sin -- 1.22460635382238e-16 ^ It works for me. You didn't pay attention at the precision. -- Euler Taveira d

Re: [BUGS] BUG #4718: "select +'8:00'::interval;" gives an error

2009-03-20 Thread Euler Taveira de Oliveira
thread [1], I agree that we could add + and @ unary operator for interval datatype. Unfortunately, such a patch has not been proposed yet. [1] http://archives.postgresql.org//pgsql-general/2003-09/msg00292.php -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mai

Re: [BUGS] BUG #4658: copy problem

2009-02-16 Thread Euler Taveira de Oliveira
Brundle Fly escreveu: > This is ok in ubuntu, but in centos doesnt work?. > COPY query TO is only available in >= 8.2. Are you sure CentOS is using a 8.3 version too? If so, what is the error message? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bug

Re: [BUGS] BUG #4632: Duplicate

2009-01-27 Thread Euler Taveira de Oliveira
be a trigger function, for example. Also, do you regularly vacuum those tables? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Selecting from a Subquery Fails

2009-01-24 Thread Euler Taveira de Oliveira
both queries to pgsql-performance (this is not the right list for such a question). -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4402: Column expansion: date comes wthout a cast

2008-09-05 Thread Euler Taveira de Oliveira
27;(' > ||col_names(new_child_table) || ') VALUES ' || NEW; > RAISE NOTICE 'INSERT: %',ins_sql; > EXECUTE ins_sql; > [...] > Why aren't you expanding it yourself? Currently, PostgreSQL doesn't have a function that does the quoting-if-needed automagically.

Re: [BUGS] BUG #4397: crash in tab-complete.c

2008-09-03 Thread Euler Taveira de Oliveira
> Are you using libedit, right? What is the exact version? Looking at the backtrace, it seems to be a libedit problem. Try to update your version or use readline instead. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.

Re: [BUGS] BUG #4370: connectby method

2008-08-22 Thread Euler Taveira de Oliveira
tart_with as an array. A patch would be welcome. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Postgresql v8.3.3 + Perl v5.10

2008-08-21 Thread Euler Taveira de Oliveira
[EMAIL PROTECTED] escreveu: > Bug in that, that I install PG on server with perl 5.10 installed, but > PG fails to run any PLPERL code > How to fix? > Could you post some test case? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-05-22 Thread Euler Taveira de Oliveira
(VS.85).aspx [3] http://msdn.microsoft.com/en-us/library/ms776260.aspx -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-05-22 Thread Euler Taveira de Oliveira
t the archives for reference. [1] http://archives.postgresql.org/pgsql-patches/2008-04/msg00451.php -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [BUGS] BUG #4101: Fails to start when transaction log on another drive

2008-04-13 Thread Euler Taveira de Oliveira
Mikel Lindsaar wrote: linkd d:\PostgreSQL\8.3\data\pg_xlog "C:\Program Files\PostgreSQL\transaction_log\pg_xlog" The correct xlog path is $PGDATA\pg_xlog. Normally, it is 'C:\Program Files\PostgreSQL\X.X\data\pg_xlog'. -- Euler

Re: [BUGS] Redundant explicit field name/types description while select from function with return type of record

2008-03-28 Thread Euler Taveira de Oliveira
ou know the row structure before hand? Its structure can be changed on-the-fly. Are you agree with my suggestion? If so will you plan to fix this BUG? TODO? [1] http://www.postgresql.org/docs/8.3/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-RECORDS -- Euler Taveira de Oliveira

Re: [BUGS] FOR-IN-EXECUTE: FOR does not replanned on each entry to the FOR loop

2008-03-28 Thread Euler Taveira de Oliveira
nside the loop and not in the loop condition (that's why you're seeing another iteration). -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] ecpg produces code that won't compile

2008-03-01 Thread Euler Taveira de Oliveira
matches the given name and argument type(s). You might need to add explicit type casts. euler=# select '127.0.0.1/32'::varchar::inet = '127.0.0.1/32'::inet; ?column? -- t (1 registro) -- Euler Taveira de Oliveira http://www.timbira.com/ -

Re: [BUGS] help me plz with 2 postgres users

2008-02-26 Thread Euler Taveira de Oliveira
[EMAIL PROTECTED] wrote: How can I delete first postgres user. Ugh. How did you duplicate if there is an unique index in rolname ? pg_shadow is a view; you want to take a look at the real relation pg_authid. delete from pg_authid where ctid = '(0,1)' -- Euler Taveira d

Re: [BUGS] BUG #3986: Error ts_vector with UTF8 WS2003

2008-02-25 Thread Euler Taveira de Oliveira
ng and the terminal or application encoding. -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [BUGS] BUG #3975: tsearch2 index should not bomb out of 1Mb limit

2008-02-21 Thread Euler Taveira de Oliveira
ow big the message it failed on was... Maybe we should change the "string is too long for tsvector" to "string is too long (%ld bytes, max %ld bytes) for tsvector". -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--

Re: [BUGS] BUG #3891: Multiple UPDATE doesn't handle UNIQUE constraint correctly

2008-01-21 Thread Euler Taveira de Oliveira
/greg/index.php?/archives/2006/06/10.html -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] unable to see other schemas besides public

2007-11-25 Thread Euler Taveira de Oliveira
in the search_path [1]. [1] http://www.postgresql.org/docs/8.3/static/ddl-schemas.html#DDL-SCHEMAS-PATH -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desir

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-22 Thread Euler Taveira de Oliveira
e XML attributes output. -- Euler Taveira de Oliveira http://www.timbira.com/ *** ./src/backend/utils/adt/xml.c.orig 2007-11-23 01:55:00.0 -0200 --- ./src/backend/utils/adt/xml.c 2007-11-23 02:01:24.0 -0200 *** *** 2641,2658 appendStringInfo(&result,

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-12 Thread Euler Taveira de Oliveira
Peter Eisentraut wrote: > Having a space before /> appears to be common practice, including in the > examples in the SQL/XML spec. > Agreed. Feel free to add whitespace before every /> of simple xml elements. -- Euler Taveira de Oliveira http://

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-09 Thread Euler Taveira de Oliveira
small patch to strip some space and be consistent with other xml tags. -- Euler Taveira de Oliveira http://www.timbira.com/ *** src/backend/utils/adt/xml.c.orig 2007-11-09 16:33:56.0 -0200 --- src/backend/utils/adt/xml.c 2007-11-09 16:37:30.0 -0200 *** *** 298

Re: [BUGS] Provide a way to not ask for a password in psql

2007-10-09 Thread Euler Taveira de Oliveira
Martin Pitt wrote: > For example, "psql -l" is a convenient > method to check whether the postmaster is running at all, > finished with startup and ready for connections. > Why not just "pg_ctl status"? -- Euler Taveira de Oliveira http://www.timbira.com/

[BUGS] reindexdb in Windows

2007-08-18 Thread Euler Taveira de Oliveira
Hi, reindexdb.exe is not installed with PostgreSQL in Windows. Is it intentional or a bug? -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [BUGS] BUG #3323: Wrong charset for the lower and upper functions

2007-05-30 Thread Euler Taveira de Oliveira
7;t reproduce your problem here. [1] http://www.postgresql.org/docs/8.2/static/app-psql.html -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[BUGS] pg_stat_activity feature or bug?

2007-04-13 Thread Euler Taveira de Oliveira
istro) regression=> -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [BUGS] BUG #2870: incorrect man page for postgres

2007-01-03 Thread Euler Taveira de Oliveira
Peter)" in release notes [1]. [1] http://www.postgresql.org/docs/8.2/static/release-8-2.html -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [BUGS] wrong behavior using to_char()

2006-09-14 Thread Euler Taveira de Oliveira
Jorge Godoy wrote: > > In the pt_BR locale, the thousand separator is "". So it should return > > The thousands separator in pt_BR is ".". > Oh, good catch. There is so much hack in my glibc. :-) -- Euler Taveira de Oliveira http://www.timbira.com/

[BUGS] wrong behavior using to_char()

2006-09-14 Thread Euler Taveira de Oliveira
patch that fixes it using the second option. -- Euler Taveira de Oliveira http://www.timbira.com/ x Description: Binary data ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] BUG #2605: Log de ERRO

2006-09-03 Thread Euler Taveira de Oliveira
nte uma de nossas listas regionais (brasil-usuarios at pgfoundry.org). -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail co

Re: [BUGS] reindexdb command utlility

2006-06-07 Thread Euler Taveira de Oliveira
ould be a better one. But > not INFO. > LOG would be a good option, but maybe a small hack in reindexdb is better. -- Euler Taveira de Oliveira http://www.timbira.com/ Index: src/bin/scripts/reindexdb.c === RCS file: /project

Re: [BUGS] stopping server does not remove external_pid_file

2006-06-07 Thread Euler Taveira de Oliveira
27;feature' was proposed to permit another home to postmaster.pid file. Am I wrong? But seems to duplicate the pid file information. [1] http://archives.postgresql.org/pgsql-patches/2004-06/msg00006.php -- Euler Taveira de Oliveira http://www.timbira.com/ ---

Re: [BUGS] stopping server does not remove external_pid_file

2006-06-06 Thread Euler Taveira de Oliveira
e remove the pid file on postmaster exit? */ IMHO, yes. It's not useful anymore. Maybe some simple test in pmdie(). I'm too tired to code something now. :( -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)-

Re: [BUGS] reindexdb command utlility

2006-05-31 Thread Euler Taveira de Oliveira
ho) is used to print command to stdout. Like I said, you need to "| grep -v" your stderr output. -- Euler Taveira de Oliveira http://www.timbira.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] reindexdb command utlility

2006-05-30 Thread Euler Taveira de Oliveira
your friend. :-) Looking at the code, IMHO we could raise the ereport from NOTICE to INFO (see the patch attached). None of the scripts actually raise NOTICEs if it succeeds. Comments? -- Euler Taveira de Oliveira http://www

Re: [BUGS] BUG #2456: How to write user defined functions in Postgress sql

2006-05-27 Thread Euler Taveira de Oliveira
Vivekananda wrote: > I have good knowledge in Oracle-Pl/sql.But,now my client wants to use > PGSQL.Now i am sending function as below. > This is *not* a bug. Consider posting in the correct list pgsql-general. -- Euler Taveira de Oliveira http://www.ti

Re: [BUGS] syntax error

2006-04-17 Thread Euler Taveira de Oliveira
). -- Euler Taveira de Oliveira ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: NLS vs error processing, again (was Re: [BUGS] Composite Type

2006-04-04 Thread Euler Taveira de Oliveira
ndly would be to refuse the attempt to set client_encoding to something that can't handle our error message encoding, but I don't know what a reasonable set of restrictions would be. Maybe it's the time to convert all PO files to UTF-8. I'm in process to convert pt_B

Re: [BUGS] BUG #2166: attempted to update invisible tuple

2006-01-12 Thread Euler Taveira de Oliveira
--- Tom Lane <[EMAIL PROTECTED]> escreveu: > "Euler Taveira de Oliveira" <[EMAIL PROTECTED]> writes: > > I just execute the same transaction in 2 different backends and I > got the > > message: 'attempted to update invisible tuple'. > > If

[BUGS] BUG #2166: attempted to update invisible tuple

2006-01-11 Thread Euler Taveira de Oliveira
The following bug has been logged online: Bug reference: 2166 Logged by: Euler Taveira de Oliveira Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1+ Operating system: Slackware 10.1 Description:attempted to update invisible tuple Details: I just execute the

Re: [BUGS] BUG #2077: Hiding databases which I am not owner

2005-11-30 Thread Euler Taveira de Oliveira
one thing, access is another thing. We never hid databases and other catalog objects. Instead we allow and deny access to this databases. See pg_hba.conf documentation for information. Euler Taveira

Re: [BUGS] BUG #1662: Table constrains are not properly inherited.

2005-05-13 Thread Euler Taveira de Oliveira
and foreign key constraints only apply to single tables, not to their inheritance children." Euler Taveira de Oliveira euler[at]yahoo_com_br Yahoo! Mail, cada vez melhor: agora com 1GB de esp