Re: [GENERAL] Checking for changes in other tables

2013-04-28 Thread CR Lender
Sorry for the late reply, I had to give this some time to digest. I'm still trying to wrap my head around the concept that triggers don't "belong" to a table... On 2013-04-26 17:15, Richard Huxton wrote: > On 26/04/13 10:01, CR Lender wrote: > I think this is more a problem of terminology rather t

Re: [GENERAL] Implementing DB2's "distinct" types

2013-04-28 Thread Simon Riggs
On 21 April 2013 12:17, Thomas Kellerer wrote: > DB2 lets you define your own types (just as Postgres) but with the added > benefit that you can mark them such that they are _not_ comparable, e.g. to > avoid comparing "apples to oranges". Sounds like an interesting feature we might want, but you

Re: [GENERAL] apt.postgresql.org broken dependency?

2013-04-28 Thread Martín Marqués
2013/4/26 Richard Huxton : > On 25/04/13 18:01, Martín Marqués wrote: >> >> Just tried upgrading and added the apt-postgresql.org repo to my >> Debian server (on testing now) and I got some backages like barman >> retained because some dependencies couldn't be satisfied. >> >> Los siguientes paquet

Re: [GENERAL] regex help wanted

2013-04-28 Thread matt
> On 2013-04-25, Karsten Hilbert wrote: >> On Thu, Apr 25, 2013 at 10:32:26AM -0400, Tom Lane wrote: >> >>> Karsten Hilbert writes: >>> > What I don't understand is: Why does the following return a >>> > substring ? >>> >>> > select substring ('junk $$ junk' from >>> '\$<[^<]+?::[^:]+?>\$'); >>

Re: [GENERAL] Missing WAL files - file-based replication

2013-04-28 Thread Tom Lane
Scott Briggs writes: > So we're using 8.3 with file-based replication using rsync to a warm backup > server. The problem is the backup server crashed and somehow WAL files got > lost so the backup server is continuously looking for WAL files that are no > longer available on the master. > My que

[GENERAL] Missing WAL files - file-based replication

2013-04-28 Thread Scott Briggs
So we're using 8.3 with file-based replication using rsync to a warm backup server. The problem is the backup server crashed and somehow WAL files got lost so the backup server is continuously looking for WAL files that are no longer available on the master. My question is, how can I skip to a se