Re: [GENERAL] triggers and execute...

2009-04-29 Thread Erik Jones
On Apr 29, 2009, at 4:14 AM, Jasen Betts wrote: On 2009-04-29, Scott Marlowe wrote: On Mon, Apr 27, 2009 at 3:24 PM, Richard Broersma wrote: On Mon, Apr 27, 2009 at 1:32 PM, Scott Marlowe > wrote: OK, I'm hitting a wall here. I've written this trigger for partitioning: create or replace

Re: [GENERAL] triggers and execute...

2009-04-29 Thread Jasen Betts
On 2009-04-29, Scott Marlowe wrote: > On Mon, Apr 27, 2009 at 3:24 PM, Richard Broersma > wrote: >> On Mon, Apr 27, 2009 at 1:32 PM, Scott Marlowe >> wrote: >>> OK, I'm hitting a wall here.  I've written this trigger for partitioning: >>> >>> create or replace function page_access_insert_trigger

[GENERAL] pg_dump and pg_restore problem

2009-04-29 Thread Michele Petrazzo - Unipex
Hi all, I had a big problem that made me crazy... I want to simple backup some tables from a my db and restore them to another. My db: table_two( id serial PRIMARY KEY, ... ) table_one ( id serial PRIMARY KEY, real_name text NOT NULL, username text NOT NULL, id_table_two i

Re: [GENERAL] [Slony1-general] pgpass.conf for Windows Vista

2009-04-29 Thread Raymond O'Donnell
On 29/04/2009 16:46, Anamika Saini wrote: > I have got the problem while using the the pg_restore in Vista. It absolutely > woking fine in windows XP. I placed the file pgpass.conf in > %APPDATA%/postgresql having the password and it actaully restores the dump in > XP and its not working in Vi

Re: [GENERAL] UPDATE... FROM - will ORDER BY not respected?

2009-04-29 Thread Jasen Betts
On 2009-04-28, Carlo Stonebanks wrote: > (FOR PG VERSION 8.3.6 running on Windows 2003 Server x64) > > We have a function that assigns unique ID's (to use as row identifiers) to a > table via an UPDATE using nextval(). This table is imported from another > source, and there is a "sequencing" fie