Re: [BUGS] /contrib/soundex doesn't work. Version 7.0.2

2000-09-29 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > The code in /contrib/soundex doesn't work. It does compile though. I > create the function in the database, but it always returns nothing > (blank)! Hmm, while I can confirm that the soundex algorithm is implemented incorrectly I never get blanks only. Check that you

Re: [BUGS] how to copy data from excel spreadsheet to postgresql database

2000-09-29 Thread Christof Petig
[EMAIL PROTECTED] wrote: > Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 1 > The lower the number the more severe it is. Bug? severe? But I will undertake to answer you though. > Short Description > how to copy data from excel spreadsheet to postgresql database > > Long Desc

Re: [BUGS] uniqueness not always correct

2000-09-29 Thread Bruce Momjian
I can confirm this is fixed in the current source tree, to be released as 7.1 in a few months: test=> create table test (zone int4, net cidr, unique(zone, net)); NOTICE: CREATE TABLE/UNIQUE will create implicit index 'test_zone_key' for table 'test' CREATE test=> insert into test (zone, net) va

Re: [BUGS] uniqueness not always correct

2000-09-29 Thread Bruce Momjian
Yes, I can confirm this is now fixed. > Frank Cusack wrote: > > > > Solaris 2.6/sparc; postgres 6.5.1 > > > > dns=> create table test (zone int4, net cidr, unique(zone, net)); > > NOTICE: CREATE TABLE/UNIQUE will create implicit index 'test_zone_key' for table >'test' > > CREATE > > dns=> in

Re: [BUGS] grant/revoke bug with delete/update

2000-09-29 Thread Bruce Momjian
OK, this was a good point. Were did we leave this, folks? > Hi, > > first I'm sorry to not fill the form, I'm too lazy, and it's not platform > nor version dependent AFAIK. > > I recently posted a question (on Feb 23rd) to pgsql-sql concerning the > fact that update and insert are considered

[BUGS] after trigger not working in begin-commit block

2000-09-29 Thread pgsql-bugs
Jonah E. Safar ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description after trigger not working in begin-commit block Long Description As part of a registration system, we use a couple of before insert or update triggers to check cer

Re: [HACKERS] Re: [BUGS] Join/table alias bug

2000-09-29 Thread Bruce Momjian
Yes, this is what was eventually done... only emit warnings for tables already in the RTE, as Tom mentioned. > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > ... The reason this behaves that way is because queries > > without from lists (SELECT my_tbl.a) are valid in PostgreSQL for > > histori