error creating table for postgres

[Dr. Hawkins]

On Sun, Apr 21, 2013 at 9:18 PM, Igor de Oliveira Couto
<igor at semperuna.com> wrote:
> On 22/04/2013, at 10:54 AM, Dr. Hawkins <dochawk at gmail.com> wrote:
>
>> I think the following had been working for some time, but now it creates an
>> error:
>>
>> CREATE TABLE plumber_joe_the__001_sofa  (uniq_sfky INTEGER PRIMARY KEY ,
>> subq CHAR(3) , a TEXT, b TEXT, c TEXT, d TEXT, ordr INTEGER, user CHAR(20),
>> tstmp TIMESTAMP WITH TIMEZONE )
>> produces
>>
>> Error:  syntax error at or near "user" at character 135
>
> AFAIK, "USER" is a reserved word in SQL - since SQL-92:
>
> http://developer.mimer.com/validator/sql-reserved-words.tml

*d'oh* !

The possibility occurred to me later.  SQLite was perfectly happy with
that column . . .


> There are some online SQL validators which you may find useful, if you run into issues
>like this. The site above has 3 validators, which validate your syntax against the SQL
>standard, rather than trying to validate it against syntax specific to a certain product - ie.,
>MySQL, PostgreSQL, or SQLite. The address for the validators are:

Thank you!


I need the sqlite for the local cache & synchronization; offsite lag
is just too much sometimes.  But that also means silly arrays for the
write values of booleans, and a few other quirks.

*sigh*

> I hope this helps!

Very much so.

 I'm trying to keep it speaking postgres, sqlite, and mysql (in about
that order)--I guess the standard should be there two (but pages and
pages of, "this is the part of the standard we ignore . . .)



-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462