[GENERAL] how to compile postgresql with other version of openssl?

2015-07-25 Thread krz...@gmail.com
Postgresql is first linux program based on automake I've ever seen (and i've been compiling linux stuff nice 1999) that does not allow specyfying lib locations on ./configure like (like --with-openssl=/path/to/openssl) So how do I link it to other version of openssl than one that is present in os

[GENERAL] ts_rank and ts_rank_cd with multiple search terms

2015-07-25 Thread Robert Nikander
Hi, I’m reading about the ranking functions [1], and I have a couple questions… 1. Is ts_rank taking proximity of terms into account? It seems like it is, but the docs suggest that only ts_rank_cd does that. 2. Is there a way to search multiple terms like ‘a | b | c …’ but score higher when mu

Re: [GENERAL] Using the database to validate data

2015-07-25 Thread rob stone
On Thu, 2015-07-23 at 15:34 -0700, JPLapham wrote: > Tim Clarke wrote > > Shouldn't be too difficult to import those new rows into one table, > > write a procedure that inserts them into the real table one by one > > and > > logs the validation failure if any - committing good rows and > > rollin

Re: [GENERAL] Using the database to validate data

2015-07-25 Thread Jon Lapham
On 07/23/2015 03:02 PM, Adrian Klaver wrote: http://pgloader.io/ Ok, thanks, I'll look into pgloader's data validation abilities. However, my naive understanding of pgloader is that it is used to quickly load data into a database, which is not what I am looking to do. I want to validate data

Re: [GENERAL] Using the database to validate data

2015-07-25 Thread JPLapham
Tim Clarke wrote > Shouldn't be too difficult to import those new rows into one table, > write a procedure that inserts them into the real table one by one and > logs the validation failure if any - committing good rows and rolling > back bad. In fact if you could then write the failures to a third