Re: C++Builder table exist
От
Charl Roux
Тема
Re: C++Builder table exist
Дата
Msg-id
DUB103-W6120959E8F0C849FB04BFA85E80@phx.gbl
Ответ на
Re: C++Builder table exist (Jasen Betts)
Список
Дерево обсуждения
Re: C++Builder table exist Jasen Betts <jasen@xnet.co.nz>
Re: C++Builder table exist Charl Roux <charl.roux@hotmail.com>
Re: C++Builder table exist Adrian Klaver <adrian.klaver@gmail.com>
Re: C++Builder table exist Albe Laurenz <laurenz.albe@wien.gv.at>
Thanks. Case-folding was my problem.
Is there any way of getting PostgreSQL to work according to the SQL standard (The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard, which says that unquoted names should be folded to upper case.), so there is no need for me to add quotes to all names?
Is there any way of getting PostgreSQL to work according to the SQL standard (The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard, which says that unquoted names should be folded to upper case.), so there is no need for me to add quotes to all names?
> To: pgsql-general@postgresql.org
> From: jasen@xnet.co.nz
> Subject: Re: [GENERAL] C++Builder table exist
> Date: Sat, 16 Mar 2013 06:16:33 +0000
>
> On 2013-03-13, Charl Roux <charl.roux@hotmail.com> wrote:
> > --_51d77859-0e03-4afa-bde6-853bee9c0a11_
> > Content-Type: text/plain; charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
>
> appologies for the formatting, gmane did something to your email that
> SLRN didn't like.
>
> > void __fastcall TfrmMain::FormCreate(TObject *Sender)
> > {
> > int errorCode;
> > TStringList *tableList = new TStringList;
> > frmDataModule->eyeConnection->GetTableNames(tableList);
> >
> > // create queryBackup table if does not exist
> > AnsiString SQL = "CREATE TABLE queryBackup( queryName VARCHAR(30) PRIMARY KEY ,query VARCHAR(10000))";
> > if( tableList->IndexOf("queryBackup") < 0 )
> > errorCode = frmDataModule->eyeConnection->ExecuteDirect(SQL);
> > }
>
> > ERROR: relation "querybackup" already exists.
>
> The problem is you're checking for queryBackup and then creating
> querybackup when it doesn't exist. (note: capitalisation)
>
> http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html
>
> This case-folding is one of the few places where postgres deliberately
> breaks the sql standard (AIUI standard wants case folded upwards).
>
> --
> ⚂⚃ 100% natural
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> From: jasen@xnet.co.nz
> Subject: Re: [GENERAL] C++Builder table exist
> Date: Sat, 16 Mar 2013 06:16:33 +0000
>
> On 2013-03-13, Charl Roux <charl.roux@hotmail.com> wrote:
> > --_51d77859-0e03-4afa-bde6-853bee9c0a11_
> > Content-Type: text/plain; charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
>
> appologies for the formatting, gmane did something to your email that
> SLRN didn't like.
>
> > void __fastcall TfrmMain::FormCreate(TObject *Sender)
> > {
> > int errorCode;
> > TStringList *tableList = new TStringList;
> > frmDataModule->eyeConnection->GetTableNames(tableList);
> >
> > // create queryBackup table if does not exist
> > AnsiString SQL = "CREATE TABLE queryBackup( queryName VARCHAR(30) PRIMARY KEY ,query VARCHAR(10000))";
> > if( tableList->IndexOf("queryBackup") < 0 )
> > errorCode = frmDataModule->eyeConnection->ExecuteDirect(SQL);
> > }
>
> > ERROR: relation "querybackup" already exists.
>
> The problem is you're checking for queryBackup and then creating
> querybackup when it doesn't exist. (note: capitalisation)
>
> http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html
>
> This case-folding is one of the few places where postgres deliberately
> breaks the sql standard (AIUI standard wants case folded upwards).
>
> --
> ⚂⚃ 100% natural
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления
От: Craig Ringer
Дата:
