[BUGS] LIKE 'bla%'

2000-09-02 Thread pgsql-bugs
Henrik Steffen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description LIKE 'bla%' Long Description I just wanted to delete a record from a table, using DELETE FROM MYTABLE WHERE NAME LIKE 'Ant%'; knowing that there existed only one

[BUGS] PG still fussy to compile on Solaris + GCC, may still need Sun ld

2000-09-02 Thread pgsql-bugs
Matt Benjamin ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PG still fussy to compile on Solaris + GCC, may still need Sun ld Long Description I found that on my Solaris 8, Sparc system with GCC and GNU Binutils, there was o

Re: [BUGS] LIKE 'bla%'

2000-09-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > DELETE FROM MYTABLE WHERE NAME LIKE 'Ant%'; > knowing that there existed only one record with 'Anton' as name. > However, the code above delivered 'DELETE 0' > DELETE FROM MYTABLE WHERE NAME LIKE 'Anto%'; > which gave 'DELETE 1' > Isn't this strange? Yup. What PG ve

Re: [BUGS] PG still fussy to compile on Solaris + GCC, may still need Sun ld

2000-09-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > 2. PG Perl interface Makefile.PL produced Sun compiler options for > compiling PG.c, e.g., "-KPIC", etc. We deliberately try to build the Perl interface with the same compiler and options that the local Perl installation claims it was built with, regardless of what you

[BUGS] unique/references not honored when inheriting tables

2000-09-02 Thread pgsql-bugs
Helge Bahmann ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description unique/references not honored when inheriting tables Long Description If a table inherits fields carrying the "references" or "unique" constraint, they are not hono

Re: [BUGS] PG still fussy to compile on Solaris + GCC, may still need Sun ld

2000-09-02 Thread Tom Lane
Matt Benjamin <[EMAIL PROTECTED]> writes: > What do you mean, "do what it wanted?" The configure script produced a > setup that would not build a perl interface, and the error was related to > SunWS compiler options. > Sounds like half my problem was using the Perl5 that Sun provides with > So