Re: [BUGS] overlapping rules can let you break referential integrity

2006-02-11 Thread Denis de Bernardy
Pardon if I insist, but accepting data that contradicts an external key contraint without raising an error is a bug and by no means a feature. Denis > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 11:35 PM > To: Denis de Bernardy > Cc: p

Re: [BUGS] BUG #2244: silent installation to set password never expires

2006-02-11 Thread John R Pierce
Can someone help to provide some guideline how to do the silent installation WITH setting the services account password never expires. There's no such functionality. You'll need to create the account prior to installing PostgreSQL, and set the flags then. it could be created with a command l

Re: [BUGS] BUG #2244: silent installation to set password never expires

2006-02-11 Thread Magnus Hagander
> Bug reference: 2244 > Logged by: KF Tai > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: windows XP > Description:silent installation to set password never expires > Details: > > Hi there: > > Can someone help to provide some guideli

Re: [BUGS] BUG #2251: NOT IN clause is not working correctly

2006-02-11 Thread Stephan Szabo
On Fri, 10 Feb 2006, Sergei Dubov wrote: > I have two tables, let's say A and B. > > B is a child of a in one to many relationship. A contains records that are > not referenced by B. > > I am running a query: > > select * from A t1 where t1.id not in (select t2.A_id from B t2); > > It returns 0 ro