Re: [GENERAL] Event Trigger question

Oh duh, I'm blind... Thanks! On 07/13/2017 07:29 PM, David G. Johnston wrote: On Thursday, July 13, 2017, ProPAAS DBA <d...@propaas.com <mailto:d...@propaas.com>> wrote: 2) where can I find a complete list of the tg_ variables? I see this list: https://www.postgre

[GENERAL] Event Trigger question

Hi All; we are creating an event trigger on ddl_command_end and I want the function to know the TABLE and COMMAND run, for example if the ddl command was an "ALTER TABLE ADD COLUMN X" then I want to pull the table and the actual alter command. We're running version 9.4 so the

Re: [GENERAL] psql only works with -h (even localhost)

On 01/25/2017 09:35 AM, Tom Lane wrote: Steve Crawford writes: Adrian asks the correct questions. Lacking the answers to those I'm going to venture a guess that a Unix-domain socket exists but access via Unix-domain sockets is somehow blocked, probably by

[GENERAL] psql only works with -h (even localhost)

Hi all; we have a client server where 'psql -h localhost' is the only way psql will connect when ssh'd onto the db server. Would like to be able to just run psql but not sure what the issue/fix is. Anyone have any insight hot to fix this? Thanks in advance -- Sent via pgsql-general

[GENERAL] raise notice question

Is it possible to execute a raise notice without the "Notice" keyword being part of the output, or is there another construct that allows writing to output as simple informational text (without any sort of NOTICE, WARNING, etc being part of the output? Thanks in advance -- Sent via