Re: [GENERAL] WAL Archive Log

2010-08-28 Thread Simon Riggs
On Fri, 2010-08-27 at 09:56 -0600, Sam Nelson wrote: Alright, well, we'll probably do something with the archive command, then, like either echoing %f to a log file or sending that to syslog (and then, after the echo, doing the actual cp or scp or rsync or whatever). That way, we should be

[GENERAL] two different posgres t for Rails development?

2010-08-28 Thread bitur mail
Hello, I was wondering if there would be a problem using Postgres 8.4 for my Rails development database and Postgres 8.1 for my production database. 8.1 is what is available with my shared web hosting provider, but 8.4 is the support (repo) version for my local Ubuntu machine. I tried

Re: [GENERAL] two different posgres t for Rails development?

2010-08-28 Thread Tom Lane
bitur mail biturm...@gmail.com writes: I was wondering if there would be a problem using Postgres 8.4 for my Rails development database and Postgres 8.1 for my production database. You can do it, if you're into pain ;-). In the first place, there are quite a lot of features in 8.4 that aren't

Re: [GENERAL] two different posgres t for Rails development?

2010-08-28 Thread John R Pierce
On 08/28/10 10:59 AM, Tom Lane wrote: bitur mailbiturm...@gmail.com writes: I was wondering if there would be a problem using Postgres 8.4 for my Rails development database and Postgres 8.1 for my production database. You can do it, if you're into pain ;-). does Rails even let you near the

Re: [GENERAL] two different posgres t for Rails development?

2010-08-28 Thread Rich Shepard
On Sat, 28 Aug 2010, John R Pierce wrote: does Rails even let you near the SQL? I thought it had a total ORM abstraction layer that assumes all databases are more or less MySQL, and it didn't let you anywhere near the actual relational aspects. According to my software engineer partner,

Re: [GENERAL] 3rd time is a charm.....right sibling is not next child crash.

2010-08-28 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Jeff Amiel's message of mar jun 08 09:26:25 -0400 2010: Jun 7 15:05:01 db-1 postgres[9334]: [ID 748848 local0.crit] [3989781-1] 2010-06-07 15:05:01.087 CDT9334PANIC: right sibling 169 of block 168 is not next child of 249

Re: [GENERAL] two different posgres t for Rails development?

2010-08-28 Thread Adrian Klaver
On Saturday 28 August 2010 12:50:32 pm Rich Shepard wrote: On Sat, 28 Aug 2010, John R Pierce wrote: does Rails even let you near the SQL? I thought it had a total ORM abstraction layer that assumes all databases are more or less MySQL, and it didn't let you anywhere near the actual

Re: [GENERAL] looping on NEW and OLD in a trigger

2010-08-28 Thread Dmitriy Igrishin
Hey Michael, As of PostgreSQL 9.0 you can do it from PL/pgSQL by using hstore module (http://www.postgresql.org/docs/9.0/static/hstore.html) I wrote an example for you: CREATE TABLE person(id integer, fname text, lname text, birthday date); CREATE TRIGGER person_test_trigger BEFORE INSERT ON

Re: [GENERAL] looping on NEW and OLD in a trigger

2010-08-28 Thread Fabrízio de Royes Mello
2010/8/28 Dmitriy Igrishin dmit...@gmail.com Hey Michael, As of PostgreSQL 9.0 you can do it from PL/pgSQL by using hstore module (http://www.postgresql.org/docs/9.0/static/hstore.html) I wrote an example for you: cut Another way to do that is create a temp table from NEW or OLD

Re: [GENERAL] looping on NEW and OLD in a trigger

2010-08-28 Thread Merlin Moncure
On Sat, Aug 28, 2010 at 6:23 PM, Fabrízio de Royes Mello fabriziome...@gmail.com wrote: 2010/8/28 Dmitriy Igrishin dmit...@gmail.com Hey Michael, As of PostgreSQL 9.0 you can do it from PL/pgSQL by using hstore module (http://www.postgresql.org/docs/9.0/static/hstore.html) I wrote an