Search Postgresql Archives

Re: How to watch for schema changes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux