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

2009-04-29 Thread Jasen Betts
On 2009-04-28, Carlo Stonebanks stonec.regis...@sympatico.ca 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

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

[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

Re: [GENERAL] triggers and execute...

2009-04-29 Thread Jasen Betts
On 2009-04-29, Scott Marlowe scott.marl...@gmail.com wrote: On Mon, Apr 27, 2009 at 3:24 PM, Richard Broersma richard.broer...@gmail.com wrote: On Mon, Apr 27, 2009 at 1:32 PM, Scott Marlowe scott.marl...@gmail.com wrote: OK, I'm hitting a wall here.  I've written this trigger for

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 scott.marl...@gmail.com wrote: On Mon, Apr 27, 2009 at 3:24 PM, Richard Broersma richard.broer...@gmail.com wrote: On Mon, Apr 27, 2009 at 1:32 PM, Scott Marlowe scott.marl...@gmail.com wrote: OK, I'm hitting a