On 07/12/2018 05:28 PM, Igor Korot wrote:
Hi,
On Thu, Jul 12, 2018 at 12:16 PM, David G. Johnston
<david.g.johnston@xxxxxxxxx> wrote:
On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot <ikorot01@xxxxxxxxx> wrote:
No, see:
https://www.postgresql.org/docs/10/static/sql-createtrigger.html
AFTER trigger on views are STATEMENT level only.
But I do have access to the STATEMENT right?
Yes, except nothing in the system actually attempts to directly target
information_schema views with updates so there will never be a triggering
event.
A normal trigger will not work - which is a large reason why event triggers
were implemented.
All of the alternative ideas (which I think was just log file parsing)
you've decided are not viable for your need. Thus you've seemingly
eliminated all viable options and you now need to make a business decision.
[code]
MyMac:/ igorkorot$ find . -name postgresql.conf
find: ./.DocumentRevisions-V100: Permission denied
find: ./.fseventsd: Permission denied
find: ./.Spotlight-V100: Permission denied
find: ./.Trashes: Permission denied
find: ./dev/fd/3: Not a directory
find: ./dev/fd/4: Not a directory
find: ./Library/Application Support/Apple/ParentalControls/Users:
Permission denied
find: ./Library/Caches/com.apple.Spotlight/schema.501.plist: Permission denied
find: ./Library/Caches/com.apple.Spotlight/schema.502.plist: Permission denied
find: ./Library/Caches/com.apple.Spotlight/schema.89.plist: Permission denied
find: ./Library/Caches/com.apple.Spotlight: Permission denied
find: ./Library/PostgreSQL/9.1/data: Permission denied
find: ./private/etc/cups/certs: Permission denied
find: ./private/etc/raddb/certs: Permission denied
find: ./private/etc/raddb/modules: Permission denied
find: ./private/etc/raddb/sites-available: Permission denied
find: ./private/etc/raddb/sites-enabled: Permission denied
find: ./private/etc/raddb/sql: Permission denied
find: ./private/tmp/launchd-158.ac7XMn: Permission denied
find: ./private/tmp/launchd-47725.RroMYY: Permission denied
find: ./private/tmp/launchd-49727.qQpnIz: Permission denied
find: ./private/var/agentx: Permission denied
find: ./private/var/at/tabs: Permission denied
find: ./private/var/at/tmp: Permission denied
find: ./private/var/audit: Permission denied
find: ./private/var/backups: Permission denied
find: ./private/var/db/ConfigurationProfiles/Setup: Permission denied
find: ./private/var/db/dhcpclient: Permission denied
find: ./private/var/db/dslocal/nodes/Default: Permission denied
find: ./private/var/db/geod: Permission denied
find: ./private/var/db/krb5kdc: Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.0: Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.200:
Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.202:
Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.212:
Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.502:
Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.88:
Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.89:
Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.92:
Permission denied
find: ./private/var/db/launchd.db/com.apple.launchd.peruser.97:
Permission denied
find: ./private/var/db/locationd: Permission denied
find: ./private/var/db/Spotlight: Permission denied
find: ./private/var/db/sudo: Permission denied
find: ./private/var/folders/r9/_xhmtynj7xj22mwt_dcfbxqr0000gp/C:
Permission denied
find: ./private/var/folders/r9/_xhmtynj7xj22mwt_dcfbxqr0000gp/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/0/com.apple.revisiond.temp:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/Cleanup
At Startup: Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n000003000000r/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000084000021/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n0000084000021/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n000008w000027/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n000008w000027/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000b000002r/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000b400002s/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000b400002s/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000bh00002w/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000bh00002w/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000c4000031/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000c4000031/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s0000068/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s0000068/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s800006_/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000s800006_/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000sm00006d/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000sm00006d/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000th00006m/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000th00006m/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000tm00006n/T:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000vr00006y/C:
Permission denied
find: ./private/var/folders/zz/zyxvpxvq6csfxvn_n00000vr00006y/T:
Permission denied
find: ./private/var/jabberd: Permission denied
find: ./private/var/lib/postfix: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.0: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.200: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.202: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.212: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.502: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.88: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.89: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.92: Permission denied
find: ./private/var/log/com.apple.launchd.peruser.97: Permission denied
find: ./private/var/log/krb5kdc: Permission denied
find: ./private/var/log/radius: Permission denied
find: ./private/var/pgsql_socket_alt: Permission denied
find: ./private/var/root: Permission denied
find: ./private/var/run/mds: Permission denied
find: ./private/var/spool/cups: Permission denied
find: ./private/var/spool/fax: Permission denied
find: ./private/var/spool/mqueue: Permission denied
find: ./private/var/spool/postfix/active: Permission denied
find: ./private/var/spool/postfix/bounce: Permission denied
find: ./private/var/spool/postfix/corrupt: Permission denied
find: ./private/var/spool/postfix/defer: Permission denied
find: ./private/var/spool/postfix/deferred: Permission denied
find: ./private/var/spool/postfix/flush: Permission denied
find: ./private/var/spool/postfix/hold: Permission denied
find: ./private/var/spool/postfix/incoming: Permission denied
find: ./private/var/spool/postfix/maildrop: Permission denied
find: ./private/var/spool/postfix/private: Permission denied
find: ./private/var/spool/postfix/public: Permission denied
find: ./private/var/spool/postfix/saved: Permission denied
find: ./private/var/spool/postfix/trace: Permission denied
find: ./private/var/tmp/launchd: Permission denied
find: ./System/Library/Caches/com.apple.coresymbolicationd: Permission denied
find: ./System/Library/DirectoryServices/DefaultLocalDB/Default:
Permission denied
find: ./System/Library/User Template: Permission denied
find: ./Users/igorkorot/Library/Saved Application
State/com.adobe.flashplayer.installmanager.savedState: Permission
denied
find: ./Users/igorkorot/Library/Saved Application
State/com.bitrock.appinstaller.savedState: Permission denied
find: ./usr/sbin/authserver: Permission denied
[/code]
It looks like I dont have a configuration file.
Where I should create one? This is on OSX 10.8.
Thank you.
David J.
p.s. Please remove the excess quoted material before hitting send. At
minimum anything after the last text that you write.
Can you try that again as root? Or with sudo?
