nt(*) from ... " will return _one_ line.
[1] http://www.postgresql.org/docs/current/static/queries-limit.html
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://www.rnp.br/keyserver/pks/lookup?search=0x8F3E3C06D428D10A
onnect?
The server was running?
The remote port (5432 by default) was listening?
You change any variable in postgresql.conf?
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://www.rnp.br/keyserver/pks/lookup?search=0x8F
nd it works fine. But sometimes
> postgres would give me errors such as:
>
> type "hstore" does not exist
Did you check search_path? Compare search_path between sessions that
are getting error and see if hstore type/functions are reached through
it.
[]s
--
Dickson S. Guedes
mail/xm
5f7efa5deddbb388
[]s
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Join Filter: (_bug_line.h_n = _bug_header.h_n)
Filter: (lower((COALESCE(((_bug_header.h_n)::text || '/'::text),
''::text) || (_bug_line.l_n)::text)) = '1'::text)
-> Seq Scan on _bug_line (cost=100.00..1000001.02
rows=2 width=8)
-> Materiali
did a make distclean before build, then init a new $PGDATA?
--
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.po
ows xp sp3
> Description: error de instalacion
> Details:
>
> al ejecutar el instalador postgresql-9.0.4-1-windows, se produce un error
> que dice: Unable to write inside TEMP enviroment variable path.
¿Ha revisado el contenido de la variable TEMP? Es válido? ¿Hay espacio
disponible
ostgresql.org//pgsql-novice/2009-04/msg00090.php
Att.
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://planeta.postgresql.org.br
signature.asc
Description: Esta é uma parte de mensagem assinada digitalmente
---+-+---+-
0 | 30 days | 0 | 30 days
0 | 30 days | 1 | 1 mon
1 | 1 mon | 0 | 30 days
1 | 1 mon | 1 | 1 mon
(4 registros)
# ANALYZE ;
ANALYZE
# select * from tt_01 as a, tt_01 as b where a.i=b.i;
s |i| s |i
---+-+---+-
0 | 30 days | 0 | 30
