I am porting from 7.4 to 8.1 and i turned off the option to add missing
from clause.
Is there a way to know How postgres rewritte the queries or add the
missing from clause on the postgres log?
thank you
Vivian
---(end of broadcast)---
TIP 3:
[EMAIL PROTECTED] (C G) writes:
Dear All,
I have a simple join query
SELECT c1 FROM t1
INNER JOIN
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
Which gives the expected result but I get the message
NOTICE: adding missing FROM-clause entry for table t3
How do I get rid of this NOTICE,
On Sat, 30 Oct 2004 01:42 am, C G wrote:
Dear All,
I have a simple join query
SELECT c1 FROM t1
INNER JOIN
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
Instead
SELECT c1 FROM t2, t1 INNER JOIN t2 ON t2.c2 = t1.c2 WHERE t3.c3=t2.c3
OR
SELECT c1 FROM t1 INNER JOIN t2 ON t2.c2 = t1.c2 JOIN
Dear All,
I have a simple join query
SELECT c1 FROM t1
INNER JOIN
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
Which gives the expected result but I get the message
NOTICE: adding missing FROM-clause entry for table t3
How do I get rid of this NOTICE, i.e. how should I construct my select
query.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 29 October 2004 08:42 am, C G wrote:
Dear All,
I have a simple join query
SELECT c1 FROM t1
INNER JOIN
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
^
Your join doesn't alias anything as t3
Hi,
what does that line from my logfile mean?
Adding missing FROM-clause entry for table customer
Would pg change my SQL queries on the fly?
TIA
/Ulrich
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if
I run the following script to export some data from my development
database and then update or insert the records into to the quality
assurance testing database, but I get a warning notice that I don't
understand. Aside from that notice, the script appears to work as
intended, i.e., updating
