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: H
[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
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
-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
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.
Ma
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 y
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 existi
