[GENERAL] Partitionning by trigger

2013-02-26 Thread Ali Pouya
Hi all, I sent the following mail yesterday but I do not see it in the list. So I retry == Hi, I have created a partitionned table and a Pl/PgSQL trigger exactly as explained herehttp://www.postgresql.org/docs/9.2/static/ddl-partitioning.htmlin the documentation. It works fine but

Re: [GENERAL] Partitionning by trigger

2013-02-26 Thread Albe Laurenz
Ali Pouya wrote: I sent the following mail yesterday but I do not see it in the list. So I retry It is there all right: http://www.postgresql.org/message-id/CAEEEPmwq_3=hGEC69-2EkCWTiwq0dme==8sou29e9k2dccg...@mail.gmail.com I have created a partitionned table and a Pl/PgSQL trigger exactly as

Re: [GENERAL] JDBC not returning update count from updateable view

2013-02-26 Thread Dave Cramer
As far as I remember this is an artifact of using rules to update a table. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Mon, Feb 25, 2013 at 2:52 PM, Russell Keane russell.ke...@inps.co.ukwrote: Hi, ** ** We have a table which is inserted to and update via a

Re: [GENERAL] JDBC not returning update count from updateable view

2013-02-26 Thread Russell Keane
But this works just fine when using libpq via c++. From: davecra...@gmail.com [mailto:davecra...@gmail.com] On Behalf Of Dave Cramer Sent: 26 February 2013 12:23 To: Russell Keane Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] JDBC not returning update count from updateable view As

Re: [GENERAL] JDBC not returning update count from updateable view

2013-02-26 Thread Dean Rasheed
On 25 February 2013 19:52, Russell Keane russell.ke...@inps.co.uk wrote: Hi, We have a table which is inserted to and update via a view (using rules / functions). In PG 9.1 and later, the recommended way to do this is using INSTEAD OF triggers on the view. See the Notes section here:

[GENERAL] PosgreSQL Konfigürasyonu

2013-02-26 Thread Melik Yücel
Herkese merhaba, Saniyede 10 bin kayıt alacak bir sistem kurmam gerekiyor. Bunu PostgreSQL ile nasıl yapabilirim? Donanım konfigürasyonu, postgresql yapılandırması nasıl olmaldır? Devrim Bey'in postgresql konferansında saniyede 200.000 gibi bir rakamdan bahsettiğini

[GENERAL] broke postgres, how to fix??

2013-02-26 Thread JD Wong
I tried copying postgres over to a new directory. it was working until I deleted a bunch of databases from the old postgres. Lo and behold this somehow broke the new copy too. Now when I start with pg_ctl 2013-02-22 18:36:13 EST DETAIL: The database subdirectory base/1066060 is missing.

Re: [GENERAL] PosgreSQL Konfigürasyonu

2013-02-26 Thread Devrim GÜNDÜZ
Hi, I asked OP to send this email to pgsql-tr-general mailing list. Regards, Devrim On Mon, 2013-02-25 at 20:42 +0200, Melik Yücel wrote: Herkese merhaba, Saniyede 10 bin kayıt alacak bir sistem kurmam gerekiyor. Bunu PostgreSQL ile nasıl yapabilirim? Donanım konfigürasyonu, postgresql

Re: [GENERAL] broke postgres, how to fix??

2013-02-26 Thread Lonni J Friedman
Did you shut down the 'old' postgres before copying these files? Did you (re)configure the 'new' postgres to set its $PGDATA directory to the location of the 'new' files? On Fri, Feb 22, 2013 at 3:46 PM, JD Wong jdmsw...@gmail.com wrote: I tried copying postgres over to a new directory. it was

Re: [GENERAL] broke postgres, how to fix??

2013-02-26 Thread Adrian Klaver
On 02/22/2013 03:46 PM, JD Wong wrote: I tried copying postgres over to a new directory. it was working until I deleted a bunch of databases from the old postgres. Lo and behold this somehow broke the new copy too. Did you actually copy or symlink? Now when I start with pg_ctl 2013-02-22

Re: [GENERAL] broke postgres, how to fix??

2013-02-26 Thread Lonni J Friedman
On Tue, Feb 26, 2013 at 4:02 PM, JD Wong jdmsw...@gmail.com wrote: Hi Adrian, yes I completely copied the config-file and data directories over. Lonnie, I don't remember. I might not have shut down the old postgres, yes I set PGDATA accordingly. That's guaranteed to break everything badly.

Re: [GENERAL] broke postgres, how to fix??

2013-02-26 Thread Lonni J Friedman
On Tue, Feb 26, 2013 at 4:10 PM, JD Wong jdmsw...@gmail.com wrote: Hi Adrian, That's guaranteed to break everything badly. Even if I read only style copied the files? Do you mind elaborating on why this happens? ( or point me to relevant documentation ) What is read only style, and how

Re: [GENERAL] broke postgres, how to fix??

2013-02-26 Thread Adrian Klaver
On 02/26/2013 04:12 PM, Lonni J Friedman wrote: On Tue, Feb 26, 2013 at 4:10 PM, JD Wong jdmsw...@gmail.com wrote: Hi Adrian, That's guaranteed to break everything badly. Even if I read only style copied the files? Do you mind elaborating on why this happens? ( or point me to relevant