Re: [GENERAL] table versioning approach (not auditing)

2014-09-29 Thread Nick Guenther
On September 29, 2014 11:08:55 AM EDT, Jonathan Vanasco postg...@2xlp.com wrote: - use a transaction log. every write session gets logged into the transaction table (serial, timestamp, user_id). all updates to the recorded tables include the transaction's serial. then there is a

Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

2014-09-23 Thread Nick Guenther
/postgresql/plpython2.so) = 4dd79641cbad3f71466648559d74e6b0c4f174a3 Any other OpenBSD users that have run into this, here? -- Nick Guenther 4B Stats/CS University of Waterloo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Fwd: Re: [GENERAL] Where art thou, plpython2.dll? (EDB installer)

2014-09-23 Thread Nick Guenther
On September 23, 2014 2:27:29 PM EDT, Adrian Klaver adrian.kla...@aklaver.com wrote: On 09/23/2014 11:05 AM, Nick Guenther wrote: Quoting Seref Arikan serefari...@gmail.com: On Tue, Sep 23, 2014 at 9:36 AM, Craig Ringer cr...@2ndquadrant.com wrote: Hi all I've had some issues

Re: [GENERAL] Watching Views

2014-09-18 Thread Nick Guenther
Ah! Your reply was excellent, David. I only found it now, cleaning out my inbox. Comments inline! Quoting David G Johnston david.g.johns...@gmail.com: Nick Guenther wrote As you said, attaching the trigger to a view is useless (for BEFORE/AFTER, which I'm interested in, also only works

Re: [GENERAL] Feature request: temporary schemas

2014-09-14 Thread Nick Guenther
On September 14, 2014 5:01:54 PM EDT, cowwoc cow...@bbs.darktech.org wrote: Hi, I'd like to propose the ability to create temporary schemas. This would facilitate running unit tests, where developers would like to run the same creation script for unit tests and production code but do not What

Re: [GENERAL] Feature request: temporary schemas

2014-09-14 Thread Nick Guenther
On September 14, 2014 6:01:15 PM EDT, cowwoc cow...@bbs.darktech.org wrote: On 14/09/2014 5:52 PM, Nick Guenther [via PostgreSQL] wrote: On September 14, 2014 5:01:54 PM EDT, cowwoc [hidden email] /user/SendEmail.jtp?type=nodenode=5819003i=0 wrote: Hi, I'd like to propose the ability

Re: [GENERAL] change the value of unix_socket_directories , must used -h /xx/xx to use the Unix domain socket

2014-08-16 Thread Nick Guenther
On August 16, 2014 11:41:02 AM EDT, lin jlu...@163.com wrote: Hi all, I change the value of unix_socket_directories in postgresql.conf , then restart the database, but it cannot connect the database used like this psql -d postgres -p 5432 , it must given the parameter -h /xx/xx to use the

Re: [GENERAL] Watching Views

2014-07-23 Thread Nick Guenther
Quoting David G Johnston david.g.johns...@gmail.com: Nick Guenther wrote Dear List, In principle, I am looking for some way to say ``` CREATE VIEW view13131 AS select (id, name, bank_account) from actors where age 22; WATCH view13131; ``` and get output to stdout like ``` INSERT

[GENERAL] Watching Views

2014-07-17 Thread Nick Guenther
I even set triggers on views? Thanks in advance -Nick Guenther 4B Stats/CS University of Waterloo [1] Cubes http://cubes.databrewery.org/ [2] CouchDB. Filtered Replication. http://couchdb.readthedocs.org/en/latest/replication/protocol.html#filter-replication [3] https://github.com/maxogden