Re: [BUGS] Fwd: Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)

2006-08-11 Thread Nikolay Samokhvalov
yes, I've found some words about similar sutuation on Varlena: "... The SERIAL column NEW.job_id is effectively replaced by nextval(...) and the nextval() function is called twice--once for the original row and once for that traced row." (http://www.varlena.com/GeneralBits/101.php) What am I doi

Re: [BUGS] Restoring 7.4.2 pg_dumpall output in 8.1.4 fails

2006-08-11 Thread Jie Liang
Oh, got it. Thanks. -Original Message- From: David Fetter [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 6:31 PM To: Jie Liang Cc: Tom Lane; pgsql-bugs@postgresql.org Subject: Re: [BUGS] Restoring 7.4.2 pg_dumpall output in 8.1.4 fails On Thu, Aug 10, 2006 at 11:44:31AM -0700