4,630 reputation
1423
bio website manitou-mail.org/about-dv.php
location Paris, France
age
visits member for 2 years, 10 months
seen 3 hours ago

Let's try to share the bits of knowledge gained during those innumerable hours of programming... Nowadays I use mostly PostgreSQL, C++/Qt, Perl, php on Unix servers.


17h
awarded  Nice Answer
Dec
16
reviewed Approve Delete back ups more than 2 weeks in sql server
Dec
12
awarded  Fanatic
Dec
11
revised Getting wrong results from fulltext search in PostgreSQL
fixed typo in tile
Dec
11
comment Getting wrong results from fulltext search in PostgreSQL
I also suspect that the GIN functional index won't be used if the to_tsvector(..) call is not exactly the same as in the query, another reason to use the 2-arguments form of to_tsvector
Dec
11
comment Getting wrong results from fulltext search in PostgreSQL
To reproduce this, we'd need to use the same default_text_search_config parameter but it's not mentioned in the question. Alternatively, in the problematic query, the variants of to_tsvector and to_tsquery taking an explicit reconfig as the first argument should be used.
Dec
11
comment How to update values from bytea to varchar in Greenplum?
@WilliamR: no. Does that product have an online manual?
Dec
11
answered How to update values from bytea to varchar in Greenplum?
Dec
10
comment How to make pg_dump skip extension?
FWIW, this has been reported last year and discussed as bug #8695.
Dec
9
answered postgres function extract from date returns double precision value
Dec
9
comment How to copy remote database to local cluster using pgAdmin over SSH tunneling with Postgres 9.x?
On the local command line: createdb localdb && pg_dump $options-for-distant-server | psql -d localdb. pgAdmin is not involved.
Dec
5
comment “explain analyze” cannot get detailed analyzed results for queries in a plpgsql function
auto_explain.log_nested_statements might help. See postgresql.org/docs/9.3/static/auto-explain.html
Dec
5
reviewed Approve Mongos - Query error
Dec
4
answered Do PostgreSQL toasted fields use any per row, in-table space?
Nov
27
comment PostgreSQL, UPDATE CASE statement uses huge amount of space
Can you add the result of select * from pg_stat_all_tables where relid='osmm.topographicarea'::regclass; ?
Nov
26
answered Dump all binary columns from a table as files
Nov
21
comment SQL Statements truncated in log files
Can you add your OS and the result of select name,setting from pg_settings where name like 'log%'? (pre-answer: no, it doesn't cut the statement based on the query contents)
Nov
20
revised Oracle Import problem caused by different character sets
fixed typo in title and minor formatting changes
Nov
19
answered After upgrade from 9.1 to 9.3, commands still point to 9.1
Nov
19
revised pgbench-tools failed authentication
minor typo fix and formatting