Re: [BUGS] small bug in ADD CONSTRAINT

Joseph Shraibman <[EMAIL PROTECTED]> writes: > This works: > ALTER TABLE segment ADD CONSTRAINT name unique(textfield, reseller); > This doesn't: > ALTER TABLE segment ADD CONSTRAINT name unique(lower(textfield), > reseller); I don't think this is a bug. The unique-constraint syntax is

[BUGS] postmaster ?????

Hi team, I Would like to install postgresql, I use a debian Distribution, afet installation by apt-get commande, I can not start postmaster and I have th e following error. /etc/init.d/postgresql start Starting PostgreSQL database server: postmaster(FAILED) ERROR: PostgreSQL postmaster did not

Re: [BUGS] small bug in ADD CONSTRAINT

On Wed, 10 Mar 2004, Joseph Shraibman wrote: > This works: > > ALTER TABLE segment ADD CONSTRAINT name unique(textfield, reseller); > > This doesn't: > ALTER TABLE segment ADD CONSTRAINT name unique(lower(textfield), > reseller); > > I had to create a unique index. I don't think this is a

Re: [BUGS] buglet in 7.1.4

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Mike Mascari) wrote: > Lamar Owen wrote: > >> On Tuesday 09 March 2004 10:46 am, Tom Lane wrote: >> >>>Neil Conway <[EMAIL PROTECTED]> writes: >>> BTW, I can't really see the harm in putting out 7.1.x and 7.2.x releases to fix c

[BUGS] small bug in ADD CONSTRAINT

This works: ALTER TABLE segment ADD CONSTRAINT name unique(textfield, reseller); This doesn't: ALTER TABLE segment ADD CONSTRAINT name unique(lower(textfield), reseller); I had to create a unique index. ---(end of broadcast)--- TIP 7: don't