Re: [GENERAL] Any thoughts on making a psql meta-command "hide (or show alt text) if no results"?

On Tue, Aug 8, 2017 at 6:25 PM, Melvin Davidson wrote: > > *​H​ave you looked at the TUPLES ONLY option?* > > *-t* *--tuples-only* > > *Turn off printing of column names and result row count footers, etc. This > is equivalent to the \t command.* >

Re: [GENERAL] Any thoughts on making a psql meta-command "hide (or show alt text) if no results"?

On Tue, Aug 8, 2017 at 9:16 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > Hey all, looking for thoughts on a feature request: > > I run quite a few queries, using psql, that are intended for exceptional > situations. When there are no results, which is expected, I still get the >

[GENERAL] Any thoughts on making a psql meta-command "hide (or show alt text) if no results"?

Hey all, looking for thoughts on a feature request: I run quite a few queries, using psql, that are intended for exceptional situations. When there are no results, which is expected, I still get the table header and basic frame showing up in the output. The option I'd like is to be able to

Re: [GENERAL] Compiling libpq only on Linux

On 8/8/17 14:49, Igor Korot wrote: > Quick question - what is the best way to compile libpq only on Linux? > Should I grab it, unpack it and do configure and then make inside > libpq directory > manually? Pretty much yes. > Or there is some other way? You could look for updated distribution

Re: [GENERAL] Audit based on role

On 08/07/2017 06:59 PM, Melvin Davidson wrote: > *You can tweak the following query to help you determine if your user is > a member of role/group 'module_dml'. > * > *Then you can use it in a trigger function that does the logging. > > SELECT g.rolname as group, >u.rolname as user, >

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

On Tue, Aug 8, 2017 at 12:36 PM, Tom Lane wrote: > Hmmm ... > > > SHELL=/bin/tcsh > > Mine's bash ... I wonder whether that could make a difference here? > I'm pretty sure the PG makefiles aren't set up for csh syntax. > But I can't see how that would make it work in the

[GENERAL] Compiling libpq only on Linux

Hi, ALL, Quick question - what is the best way to compile libpq only on Linux? I just checked and currently my distro (I didn't updated in a long time) has 9.5 version as current. Should I grab it, unpack it and do configure and then make inside libpq directory manually? Or there is some other

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

r...@bb-c.de (Rainer J.H. Brandt) writes: > Tom Lane writes: >> I bet not. We've seen problems with macOS unexpectedly deciding to >> filter away inherited environment variables in some situations. >> It might be useful to put "env >somefile" into the PG makefile and >> compare results between

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

Tom Lane writes: > r...@bb-c.de (Rainer J.H. Brandt) writes: > > This 32/64 business isn't the problem, though. > > > I've found out that everything works if I type the configure/make commands > > in my shell (which isn't what I said before, sorry about that), but stops > > working if I put them

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

r...@bb-c.de (Rainer J.H. Brandt) writes: > This 32/64 business isn't the problem, though. > I've found out that everything works if I type the configure/make commands > in my shell (which isn't what I said before, sorry about that), but stops > working if I put them into a Perl script (which is

Re: [GENERAL] 64bit initdb failure on macOS 10.11 and 10.12

Hi, I'm coming back to an old thread. My original issue isn't resolved yet; this is just to answer your questions below. Adrian Klaver writes: > [...] > I do not build on OS X so this is a bit of a reach for me, still here it > goes. From your original post the error was: > > "reating

[GENERAL] ZeosLib database components - uuid inserts using libpq

Hello, I recently found a bug on open source ZeosLib Database components for Lazarus (Object Pascal) which is when ZeosLib is used with PostgreSQL database server. Bug was that library simply removes any uuid column from select result set. Problem is now solved and current SVN includes fixes (fix

Re: [GENERAL] Audit based on role

Hello, On Mon, Aug 07, 2017 at 04:33:21PM -0700, anand086 wrote: > Hi, > > I am postgres newbie. > > We are running Postgres 9.6.3 version and have requirement, where we want to > audit any DML action performed by a user whose has module_dml role granted. > > What would be the best way to do

Re: [GENERAL] Audit based on role

Hi, I personally don't like the solution from https://wiki.postgresql.org/wiki/Audit_trigger and here are the reasons why: * it produces a large table where all the changes, from all tables and schemas go - audit.logged_actions. So when you would like to read it to check anything it will be super

[GENERAL] About using IMCS module

Hi, I'm trying to use imcs module to store table space in memory. But, It dose not work with 9.6 version anymore. Releasing 9.6, lwlockassign() function has been deleted, cause of some issues. So, What I want to ask you something is that postgresql decide not to support to imcs module officially