[BUGS] Fwd: Re: 3412624: can not 'make' postgresql

2003-09-22 Thread Theodore Petrosky
Just to let you know... a few weeks ago I submitted to Apple the problem of not being able to 'make' postgresql. Here is the response from them... Ted --- [EMAIL PROTECTED] wrote: > Date: Mon, 22 Sep 2003 22:40:39 GMT > To: [EMAIL PROTECTED] > Subject: Re: 3412624: can not 'make' postgresql > Fro

Re: [BUGS] Table alias fun == incorrectly adding tables to join...

2003-09-22 Thread Stephan Szabo
On Mon, 22 Sep 2003, Sean Chittenden wrote: > > > Here's a fun one. > > > > > > test=# CREATE TABLE table_s1 (i int); > > > test=# CREATE TABLE table_s2 (j int); > > > test=# EXPLAIN ANALYZE SELECT table_s1.i, table_s2.j FROM table_s1 AS s1, > > > table_s2 AS s2 WHERE s1.i = s2.j; > > > NOTICE:

Re: [BUGS] Table alias fun == incorrectly adding tables to join...

2003-09-22 Thread Sean Chittenden
> > Here's a fun one. > > > > test=# CREATE TABLE table_s1 (i int); > > test=# CREATE TABLE table_s2 (j int); > > test=# EXPLAIN ANALYZE SELECT table_s1.i, table_s2.j FROM table_s1 AS s1, table_s2 > > AS s2 WHERE s1.i = s2.j; > > NOTICE: adding missing FROM-clause entry for table "table_s1" > > N

Re: [BUGS] Table alias fun == incorrectly adding tables to join...

2003-09-22 Thread Rod Taylor
> NOTICE: adding missing FROM-clause entry for table "table_s1" > NOTICE: adding missing FROM-clause entry for table "table_s2" > and execution times explode, naturally. I don't know if the spec says > this is the correct behavior or not, but I have a feeling its not and > this is a bug. This

Re: [BUGS] Table alias fun == incorrectly adding tables to join...

2003-09-22 Thread Stephan Szabo
On Mon, 22 Sep 2003, Sean Chittenden wrote: > Here's a fun one. > > test=# CREATE TABLE table_s1 (i int); > test=# CREATE TABLE table_s2 (j int); > test=# EXPLAIN ANALYZE SELECT table_s1.i, table_s2.j FROM table_s1 AS s1, table_s2 > AS s2 WHERE s1.i = s2.j; > NOTICE: adding missing FROM-clause e

[BUGS] Table alias fun == incorrectly adding tables to join...

2003-09-22 Thread Sean Chittenden
Here's a fun one. test=# CREATE TABLE table_s1 (i int); test=# CREATE TABLE table_s2 (j int); test=# EXPLAIN ANALYZE SELECT table_s1.i, table_s2.j FROM table_s1 AS s1, table_s2 AS s2 WHERE s1.i = s2.j; NOTICE: adding missing FROM-clause entry for table "table_s1" NOTICE: adding missing FROM-cla

[BUGS] bug in clusterdb script

2003-09-22 Thread washingtonirving
Hi There's a bug in the clusterdb script where it looks like the arguments to the psql command are being passed in the wrong order, so it fails when you run it on a database that is not on localhost. Here's the output from the command: 133 anands-Computer:bin/scripts> clusterdb -h wooster -U rr gr

[BUGS] dbf2pg international characters handling incomplete

2003-09-22 Thread Márcio Dick Smiderle
Your name: Márcio Dick Smiderle Your email address: [EMAIL PROTECTED] System Configuration - Architecture : k62 300 Operating System : Linux 2.4.21 elf PostgreSQL version : PostgreSQL-7.2.1 and CVS(just dbf2pg) Compiler used : gcc-3.3 and gcc-2.95 Please enter a FULL

Re: [BUGS] select where id=random()*something returns two results

2003-09-22 Thread Rod Taylor
On Sun, 2003-09-21 at 08:21, Ulrich Meis wrote: > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:pgsql-bugs- > > [EMAIL PROTECTED] On Behalf Of Jean-Luc Lachance > > Sent: Friday, September 19, 2003 4:44 PM > > To: Rod Taylor > > Cc: Ulrich Meis; [EMAIL PROTECTED] > > Subject: Re: