[GENERAL] sslmode verify-ca and verify-full: essentialy the same?

Hi, there. Firstly, as this is my first post on a PgSQL ML, I hope this ML is the good one for my question. I'm trying to secure further some PgSQL servers and am reading documentation about libpq sslmode option. I have a question about that: as I understand the internals of this option, the

Re: [GENERAL] sslmode verify-ca and verify-full: essentialy the same?

On Tue, Jan 27, 2015 at 2:29 PM, David Guyot david.gu...@europecamions-interactive.com wrote: Hi, there. Firstly, as this is my first post on a PgSQL ML, I hope this ML is the good one for my question. I'm trying to secure further some PgSQL servers and am reading documentation about

Re: [GENERAL] sslmode verify-ca and verify-full: essentialy the same?

Ah! So there was my error! Should be good to explain this in the official libpq documentation, don't you think? If I correctly read, the connection string as source of the hostname isn't explicit, there is only the mention that libpq will check that the responding server is “the one I specify”.

Re: [GENERAL] Versioning Schema SQL ideas needed

DISTINCT ON is my favorite lesser-known Postgres feature. You said it ! There I was, trying and failing to make DISTINCT work for me, little did I know that the little word ON was missing from my Postgresql vocabulary ! Thanks ! On 27 January 2015 at 02:24, Maciek Sakrejda mac...@heroku.com

Re: [GENERAL] In need of some JSONB examples ?

Thanks for the extra feedback Merlin. I'll look into it a bit more, JSONB obviously needs a bit of experimentation in the lab to get my query syntax right ! On 27 January 2015 at 00:13, Merlin Moncure mmonc...@gmail.com wrote: On Sun, Jan 25, 2015 at 6:50 AM, Tim Smith

Re: [GENERAL] multiple parameters to an AGGREGATE function

Hi, maybe this will help: CREATE OR REPLACE FUNCTION _final_nth( anyarray, integer ) RETURNS anyelement AS $BODY$ SELECT a FROM unnest( $1 ) a ORDER BY a offset $2 LIMIT 1; $BODY$ USE it without an extra aggregate-function. SELECT _final_nth(array_agg(someelement),n) AS someelement FROM

Re: [GENERAL] SSO Windows-to-unix

Sorry to ask again, but I still have not got any reply to this. Maybe this indicates it’s a bad option? On Tue, Jan 13, 2015 at 5:15 AM, Jeremy Palmer jpal...@linz.govt.nzmailto:jpal...@linz.govt.nz wrote: Hi All, I'm just investigating the option for configuring SSO for windows clients

Re: [GENERAL]

Oliver Dizon johnoli...@rtzassociates.com writes: Hi Guys, I hope I'm in the right place to throw this. I just want to ask the reason behind this weird scenario. All records were deleted in a table even if the subquery in the where clause has a missing a column. --from a certain script

Re: [GENERAL] (unknown)

Oliver Dizon schrieb am 27.01.2015 um 11:46: I hope I'm in the right place to throw this. I just want to ask the reason behind this weird scenario. All records were deleted in a table even if the subquery in the where clause has a missing a column. --from a certain script where table_id

Re: [GENERAL]

Oliver Dizon johnoli...@rtzassociates.com writes: Hi Guys, I hope I'm in the right place to throw this. I just want to ask the reason behind this weird scenario. All records were deleted in a table even if the subquery in the where clause has a missing a column. --from a certain script

Re: [GENERAL] Postgres seems to use indexes in the wrong order

Thanks for the tips. I'll make some adjustments On Tue, Jan 27, 2015 at 8:38 PM, Sameer Kumar sameer.ku...@ashnik.com wrote: On Tue, Jan 27, 2015 at 6:59 AM, Tim Uckun timuc...@gmail.com wrote: The query seems to first use the timestamp column which results in a huge number of records and

[GENERAL]

Hi Guys, I hope I'm in the right place to throw this. I just want to ask the reason behind this weird scenario. All records were deleted in a table even if the subquery in the where clause has a missing a column. --from a certain script where table_id is not yet existing on table_sample

[GENERAL] cannot start 9.3 after system crash

Hi list, the system HDD of a server running postgresql 9.3 died (sudden electronical death) during a pg_dump. The database is located on a hardware raid system (another HDD). I installed a new ubuntu 14.04 with postgresql 9.3 postgis 2.1. But i cannot start the server. First i got the error:

Re: [GENERAL] (unknown)

Oliver Dizon schrieb am 27.01.2015 um 11:46: I hope I'm in the right place to throw this. I just want to ask the reason behind this weird scenario. All records were deleted in a table even if the subquery in the where clause has a missing a column. --from a certain script where table_id

Re: [GENERAL]

Oliver Dizon wrote: I hope I'm in the right place to throw this. I just want to ask the reason behind this weird scenario. All records were deleted in a table even if the subquery in the where clause has a missing a column. --from a certain script where table_id is not yet existing on

[GENERAL] Conflicting function name in dynamically-loaded shared library

Hi: I am wanting to define some functions as described in section 35.9 of the manual, C-Language Functions. I am compiling pre-existing files of c-code from another project into object files, and then linking those object files into a shared library along with my own functions that follow the