Re: Compilation fails with Solaris Studio 12.6

2019-04-14 Thread Tom Lane
Igor Korot writes: > igor@solaris:~/dbhandlerSol/postgresql/src/interfaces/libpq$ dmake > dmake: Fatal error in reader: ../../../src/Makefile.global, line 45: > Unexpected end of line seen > What do I do? Use gmake. regards, tom lane

Compilation fails with Solaris Studio 12.6

2019-04-14 Thread Igor Korot
Hi, [quote] igor@solaris:~/dbhandlerSol/postgresql$ ./configure checking build system type... i386-pc-solaris2.11 checking host system type... i386-pc-solaris2.11 checking which template to use... solaris checking whether to build with 64-bit integer date/time support... yes checking whether NLS is

SQLSTATE when PostgreSQL crashes during COMMIT statement

2019-04-14 Thread Takahashi, Ryohei
Hi, If application executes COMMIT statement and COMMIT failes because of PostgreSQL crash, it is unknown whether the transaction is really committed. Therefore, I think application should check the transaction is really committed after a while when certain SQLSTATE is returned. Which SQLSTATE

Re: Where to find postgresql libs in the APT repo ?

2019-04-14 Thread Laura Smith
Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Sunday, April 14, 2019 8:34 PM, Adrian Klaver wrote: > On 4/14/19 12:09 PM, Laura Smith wrote: > > > Hi, > > Am looking to compile some software that will make use of Postgresql > > libraries. > > However doing "apt-cac

Re: Where to find postgresql libs in the APT repo ?

2019-04-14 Thread Adrian Klaver
On 4/14/19 12:09 PM, Laura Smith wrote: Hi, Am looking to compile some software that will make use of Postgresql libraries. However doing "apt-cache search postgresql-11-*" I can't see any libs or dev package ? postgresql-server-dev-11 - development files for PostgreSQL 11 server-side progr

Where to find postgresql libs in the APT repo ?

2019-04-14 Thread Laura Smith
Hi, Am looking to compile some software that will make use of Postgresql libraries. However doing "apt-cache search postgresql-11-*" I can't see any libs or dev package ? Would installing "postgresql-client-11" be sufficient ?   I don't really want to go installing the whole shebang. Thanks !

Re: Trigger when user logs in

2019-04-14 Thread Michael Nolan
On Sun, Apr 14, 2019 at 4:06 AM Peter J. Holzer wrote: > > If you want to prevent a user from logging in (which is functionally > equivalent but a bit stronger than "instantly kick off"), then this is > definitely something that could and should be implemented via PAM (I'm > not sure what informa

Re: Planner can't seem to use partial function indexes with parameter from join

2019-04-14 Thread Alastair McKinley
Hi David, Thanks for having a look at this. You are right about the normalisation of record, unfortunately there are other constraints with the application that suit the denormalised approach for this table very well. Although my test case is quite simple compared to the real application (the

Re: Planner can't seem to use partial function indexes with parameter from join

2019-04-14 Thread David Rowley
On Sun, 14 Apr 2019 at 21:55, Alastair McKinley wrote: > I have reduced my scenario to a minimal test case with inline comments to > illustrate the issue here > https://gist.github.com/a-mckinley/1b0e95142789cbc09121b71a83d03f45 > > Is there something that I am missing to allow the planner to us

Re: Trigger when user logs in

2019-04-14 Thread Ron
On 4/14/19 4:05 AM, Peter J. Holzer wrote: On 2019-04-13 22:22:16 -0500, Ron wrote: In our case, another looming Auditor requirement is to be able to instantly kick off -- or at least send a warning email -- when certain roles log in from unapproved IP addresses or programs.  For example, servic

Planner can't seem to use partial function indexes with parameter from join

2019-04-14 Thread Alastair McKinley
Hello all, I am having quite an interesting problem trying to get the planner to use my indexes as intended in my setup. I am using partial functional indexes that have a different function parameter based on the record type. A dynamically generated query using unions that are more explicit abo

Re: Trigger when user logs in

2019-04-14 Thread Peter J. Holzer
On 2019-04-13 22:22:16 -0500, Ron wrote: > In our case, another looming Auditor requirement is to be able to instantly > kick off -- or at least send a warning email -- when certain roles log in > from unapproved IP addresses or programs.  For example, service accounts > should only be able to log