process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
that show us the root of the problem. Also, it could be the kernel
trying to free up resources (aka OOM killer), a corrupted
ncluir se o hardware é
suficiente ou não.
[1] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-bugs mailing
> Mas busco orientações sobre ferramentas de modeladem de dados, com
> possibilidade de engenharia reserva que suporta o postgre.
>
Aconselho utilizar a lista da comunidade brasileira [1] para futuras
perguntas.
[1] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
--
ocale dependent (whereas '.' is not), so
> _theoretically_ a back patch would make sense I guess.
>
I would consider a documentation bug in back branches because fix it
means break apps.
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consu
sql.org/support/versioning
--
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
f another locale that would break if we apply such a
change in a stable branch. Are you want me to post a fix?
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-bugs mailing li
ption: ERROR: column reference "e_raci_obj" is
> ambiguous
>
You don't provide enough information. What is the query? Or is it a function
call? It could be useful to show us the table definition or function body.
I also advise you take a look at the release notes from 8.4
s and so needs an alternative path.
>
That's something that should be addressed, no?
> I think it would be better to have pg_clearxlogtail instead just
> silently pass any unrecognized files through without manipulation,
> rather than erroring out.
>
... or let people
by Hibernate? It seems it is casting the expression
to varchar like:
insert into my_table (gender_type) values ('male'::varchar);
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent
On 22-11-2012 04:27, Pavel Stehule wrote:
> 2012/11/21 Greg Sabino Mullane : Separately, what are
> the objections to raising the size limit to 128?
>
>> significantly larger catalog
>
Less than 5% of catalog columns? I don't buy your argument.
--
Euler Taveir
op () at postmaster.c:1367
#27 0x0061909c in PostmasterMain (argc=argc@entry=1,
argv=argv@entry=0x1371df0) at postmaster.c:1127
#28 0x00464b9d in main (argc=1, argv=0x1371df0) at main.c:199
[1]
http://git.postgresql.org/gitweb/?p=postgresql.git;a=snapshot;h=refs/heads/REL9_2_S
version 9.0 was OK with this database and query.
>
Could you provide additional details [1] and a reproducible test case?
[1] http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria,
tipo
> character varying(20)"
>
That message is coming from the postgres server and the details are available
to server and client.
> The column name is needed for best debug result.
>
Why don't you look at the postgres log? Or even better enable loglevel option
in the JDBC st
stgresql.org/docs/manuals/...
>
Works for me. It is a problem in your connection (proxy?).
--
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@pos
our download complete
successfully? What the exact size of the PDF file? Is it match with the
informed in [1]? Did you try again? Are you using a proxy?
[1] http://www.postgresql.org/docs/manuals/
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL:
tistics
collector before those ones? To solver your problem, you can remove the
pgstat.stat file that it will be created again next time server starts. Of
course, you will loose the statistics, hence remember to VACUUM ANALYZE your
cluster.
--
Euler Taveira de Oliveira - Timbira http://w
w.postgresql.org/docs/9.1/static/sql-createrole.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 changes to yo
Este erro pode acontecer também se a sequência de bytes não
> corresponde a codificação esperado pelo servidor, que é controlada por
> "client_encoding".
>
Isso não é um bug. Utilize a lista pgbr-geral [1] para perguntas em pt_BR.
[1] https://listas.postgresql.org.br/cgi-bi
Isso não é um erro do PostgreSQL. Faça o que a mensagem está lhe dizendo ou
procure ajuda sobre PHP.
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-bugs mailing l
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
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
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
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
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.
--
g
password? If you are not comfortable with this reasonable limit, look at
fe-connect.c -> PasswordFromFile() and change the LINELEN. More to the point,
AFAICS all of the PostgreSQL client prompts are limited to 100 bytes (look at
simple_prompt function); letting 220 bytes for host, port, datab
.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
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
/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
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
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
.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
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
.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
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
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/
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
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
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
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
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
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
[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
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
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:/
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
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
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
>> {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
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/
--
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
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 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
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
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:
Kajetan Abt escreveu:
> Amusingly, the counter on the lower right of the SQL-input window sometimes
> shows negative numbers counting up, probably some sort over overflow. No
> harm done though.
>
If you don't provide more details (test case) it's hard to say if it's
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
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
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
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
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
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
z.com');
email
─
foo@baz.com
(1 row)
euler=# select distinct token as email from ts_parse('default',
'foo+...@baz.com');
email
─
foo
+
b...@baz.com
(3 rows)
euler=# select distinct token as email from ts_parse('default'
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
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
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
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
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
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
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
.
--
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
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
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
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
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
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
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
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.
>
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.
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
[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
(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
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/
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
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
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
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/
-
[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
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
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)--
/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
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
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,
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://
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
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/
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
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
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
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
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/
1 - 100 of 114 matches
Mail list logo
