On 2013-03-13, Charl Roux <charl.roux@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general