From: Bruno Wolff III <bruno@wolff.to>
To: Marek Lewczuk <newsy@lewczuk.com>
Cc: Lista dyskusyjna pgsql-sql <pgsql-sql@postgresql.org>
Cc: Lista dyskusyjna pgsql-general <pgsql-general@postgresql.org>
Subject: Re: [SQL] SQL query problem
Date: Thu, 9 Oct 2003 14:05:36 -0500
Message-ID: <20031009190536.GB14336@wolff.to> (raw)
In-Reply-To: <003401c38e9e$f1e74b70$f16b4cd5@marek>
References: <003401c38e9e$f1e74b70$f16b4cd5@marek>
On Thu, Oct 09, 2003 at 20:52:58 +0100,
Marek Lewczuk <newsy@lewczuk.com> wrote:
> Hello,
> I'm in the middle of the migration process from MySQL to PostgreSQL and
> I cannot understand why this query isn't working (in MySQL it's working
> fine). PG returns: ERROR: Relation "_con" does not exist
Probably you quoted the table name when you created it so that it is named
_CON. However when you don't quote the name in later references _CON
is converted to _con which is a different name that doesn't match any
existing table.
This behavior is contrary to the spec (lowercasing instead of uppercasing),
but isn't going to change since uppercase names look ugly.
A good general rule to follow is to either never quote names or always
quote names.
>
> This is my query:
>
> SELECT
> _CON.con_id,
> _MOD.mod_ty,
> _VER.version,
> _YEA.year,
> _CON.dri_id,
> _CON.man_cod,
> _ENG.eng_pow
> FROM
> db_data.mda_mod _MOD,
> db_data.mda_mod_con _CON,
> db_data.mda_mak_eng _ENG,
> db_data.set_mda_fue _FUE
> LEFT JOIN db_data.mda_mod_ver _VER ON _VER.ver_id = _CON.ver_id
> LEFT JOIN db_data.mda_mod_yea _YEA ON _YEA.yea_id = _CON.yea_id
> WHERE
> _MOD.mod_id = '283' AND
> _CON.mod_id = _MOD.mod_id AND
> _CON.psd <= NOW() AND
> _CON.ped > NOW() AND
> _ENG.eng_id = _CON.eng_id AND
> _ENG.eng_fue = _FUE.fue_id
>
>
> I will be appreciated for you help.
>
> ML
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, newsy@lewczuk.com, pgsql-general@postgresql.org
Subject: Re: [SQL] SQL query problem
In-Reply-To: <20031009190536.GB14336@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox