Re: How to watch for schema changes
| От | Igor Korot |
|---|---|
| Тема | Re: How to watch for schema changes |
| Дата | |
| Msg-id | CA+FnnTzc8pfdj=1Zn-FWb+Y8ioC3gZZZNEfy+enHc3uX+00Xjw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to watch for schema changes ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: How to watch for schema changes
|
| Список | pgsql-general |
Hi, On Thu, Jul 12, 2018 at 12:16 PM, David G. Johnston <david.g.johnston@gmail.com> wrote: > On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot <ikorot01@gmail.com> 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.
В списке pgsql-general по дате отправления: