Re: [GENERAL] deletion of the thread posted by me

Policy [2] http://www.postgresql.org/list/ -- 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-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] get first and last row in one sql as two columns

g like: SELECT first_value(col1) over (order by col1), last_value(col1) over (order by col1) FROM table; It should be as simple as that, or I miss your point. [1] http://www.postgresql.org/docs/current/static/functions-window.html []s -- Dickson S. Guedes @guediz - http://gi

Re: [GENERAL] MongoDB FDW Problem.

om/EnterpriseDB/mongo_fdw/issues/32 [2] https://github.com/EnterpriseDB/mongo_fdw/commit/632e78c303024d3a3cbd1a1c1fc5c27784260836 [3] https://github.com/EnterpriseDB/mongo_fdw#contributing []s -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://github.com/guedes - http:

Re: [GENERAL] postgresql not updating the sequence

t; thanks and regards, > kosna. Could you send us the result of \d your_table ? The column has a 'nextval' ? -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br -- Sent via pgsql-general mailing list (pgsql-gener

Re: [GENERAL] postgresql not updating the sequence

2011/5/4 Kosna Sridhar : > > actually i resolved the problem thanks for quick response Great! For history and reference of this list could you tell us how with a "Reply all"? regards -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://gued

Re: [GENERAL] How to handle bogus nulls from ActiveRecord

be override in 'postgresql_adapter.rb'. [1] https://github.com/rails/rails/blob/master/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb#L85-86 [2] https://github.com/rails/rails/blob/master/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb#L117-118

Re: [GENERAL] how to install 9.1 on non-graphical server?

DB installer command line? There is a text-mode AFAIR. Regards, -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Restoring 2 Tables From All Databases Backup

urrent/interactive/app-pgrestore.html#APP-PGRESTORE-OPTIONS -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://

Re: [GENERAL] Tuning Variables For PostgreSQL

have no had any issues but I was wondering if there was > anything out there more suited to perform better on PostgreSQL. I suggest you to read the wiki [1]. It contains many useful information. [1] http://wiki.postgresql.org/wiki/Performance_Optimization -- Dickson S. Gue

Re: [GENERAL] Segmentation Fault

configured (or at least as much as we could > ensure) Did you compiled it from scratch e.g. make clean && make && make install? []s -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br -- Sent via pgsql-gener

Re: [GENERAL] Dtrace for tracing PostgreSQL link not working

http://blogs.sun.com/robertlor/entry/user_level_dtrace_probes_in. > > Can anyone point me to right probes usage link for Tracing PostgreSQL ?. Try https://blogs.oracle.com/robertlor/entry/user_level_dtrace_probes_in []s -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://g

Re: [GENERAL] pgstat wait timeout : permission denied

ics >> file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": Permission >> denied > > That looks like anti-virus software getting in the way. Or the Windows Firewall. regards -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://gu

Re: [GENERAL] Output of query_to_xml

w. That extra line only is printed when 'tableforest' is set to true, so if you use: select query_to_xml('select * from table12', true, false, '') the extra line and the 'xmlns:xsi=' for tag goes always. [1] http://git.postgresql.org/gitweb/?p=postgres