Re: [GENERAL] PostgreSQL 9.5 and process REST calls enquiry

2016-03-05 Thread Stefan Keller
I'd like to extend (and complete) this thread by collecting programs/frameworks/applications that provide REST services over Postgres. I see following categories and open source web frameworks and/or libs: Those which * attach Postgres directly, like PostgREST (Haskell) or jsgrest (JavaScript serv

Re: [GENERAL] multiple UNIQUE indices for FK

2016-03-05 Thread Francisco Olarte
Hi Rafal: On Fri, Mar 4, 2016 at 11:46 PM, Rafal Pietrak wrote: > W dniu 04.03.2016 o 18:59, Francisco Olarte pisze: >> Make sender_person_id NOT NULL in messages if you want to insure every >> message ahs exactly ONE SENDER, leave it out if you want to allow >> senderless messages. An FK column

Re: [GENERAL] arrays returned in text format

2016-03-05 Thread Konstantin Izmailov
Tom, I was unable to reproduce the issue with standard libpq. Moreover, I found why it was returned as Text. It was actually a bug in passing resultFormats in the Bind message. Sorry for the false alert, my fault. Thank you for the help! Konstantin On Fri, Mar 4, 2016 at 10:52 PM, Tom Lane wrote

Re: [GENERAL] Custom column ordering

2016-03-05 Thread Emre Hasegeli
> - Why is PostgreSQL not using the functional index I created and why is it > not being ordered correctly? Your example works for me: > hasegeli=# CREATE TABLE device_port (port text); > CREATE TABLE > > hasegeli=# CREATE INDEX idx_device_port_port_proper ON device_port > (cast_to_port(port)

Re: [GENERAL] PLPythonu for production server

2016-03-05 Thread Rémi Cura
Thanks ! Cheers, Rémi-C 2016-03-05 0:38 GMT+01:00 Adrian Klaver : > On 03/04/2016 01:46 AM, Rémi Cura wrote: > >> Thanks for the answer guys. >> >> I should have mentionned that I had read the doc, >> and was looking for non explicit knowledge, >> like : >> - what is the reputation of plpython fo