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 (
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 s
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
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
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 conversi
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 h
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 i
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 the
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
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 manual case
> and not whe
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,
>
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 pac
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 suppr
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
> t
On Tue, Aug 8, 2017 at 6:25 PM, Melvin Davidson
wrote:
>
> *Have 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.*
> *https://www.postgresql.org/docs/9.4/static/app-p
15 matches
Mail list logo
