Re: [BUGS] BUG #3774: create table like including index doesn't update pg_constraints with primary key

2007-11-29 Thread NikhilS
Hi, > > The following bug has been logged online: > > Bug reference: 3774 > Logged by: guillaume (ioguix) de Rorthais > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 beta3 > Operating system: mac os x 10.4.10 > Description:create table like including inde

Re: [BUGS] BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern

2007-11-29 Thread Tom Lane
"Vitaly" <[EMAIL PROTECTED]> writes: > SELECT author, type > FROM books WHERE "type" ~ '(?!novel)'; > This select work incorrect. It returns all types. Certainly. That's a negative-lookahead pattern and is therefore guaranteed to match somewhere in every string (at the end, if nowhere else).

[BUGS] BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern

2007-11-29 Thread Vitaly
The following bug has been logged online: Bug reference: 3788 Logged by: Vitaly Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3-beta3 Operating system: WinXP Description:POSIX regexp seems doesn't work for '(?!re) ' pattern Details: SELECT author, type FR

Re: [BUGS] BUG #3787: configure: error: readline library not found

2007-11-29 Thread Usama Dar
or if your distro is a newer one, they generally come with an alternative called libedit, link that one if readline is not available for your distribution. i had the same problem with new Ubuntu releases. / Usama On Nov 29, 2007 2:23 PM, Marc Schablewski <[EMAIL PROTECTED]> wrote: > You probably

Re: [BUGS] BUG #3787: configure: error: readline library not found

2007-11-29 Thread Marc Schablewski
You probably don't have readline's header files installed. They are usually part of your linux distro, but not installed by default. Install the files and rerun configure. Marc paulo wrote: > The following bug has been logged online: > > Bug reference: 3787 > Logged by: paulo > Emai