GDA: Status

Nathan Buchanan nbinont at
Mon May 26 19:07:41 EDT 2008

On Mon, May 26, 2008 at 6:38 PM, Derek Atkins <warlord at> wrote:

> Quoting Nathan Buchanan <nbinont at>:
>  On Mon, May 26, 2008 at 5:04 PM, Derek Atkins <warlord at> wrote:
>>  Can't you just use "CREATE IF NOT EXIST" ?  Or is that not portable
>>> enough
>>> across various SQL implementations?
>> This is definately not portable. IIRC, it's a MySQL extension.
> What makes you say that?

Because it's not part of the SQL standard. ISO/IEC 9075-2:2003, section 11.3
<table definition> specifies the CREATE TABLE statement, and there's no
reference to an "IF NOT EXISTS" clause.

A while back Postgres debated the issue, determined that is wasn't in the
standard, and thus Postgres does not support least not without

> SQLite supports it.

Postgres does not support it (8.1)
Oracle does not support it (9.2)

(Not trying to be a pain here, I'd just rather we don't lock ourselves out
of many databases)


> -derek
> --
>      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>      Member, MIT Student Information Processing Board  (SIPB)
>      URL:    PP-ASEL-IA     N1NWH
>      warlord at MIT.EDU                        PGP key available

"Even if you are on the right track, you'll get run over if you just sit
there" - Will Rogers

More information about the gnucash-devel mailing list