2012/3/14 Pavel Stehule <pavel.steh...@gmail.com>: > 2012/3/14 Dimitri Fontaine <dimi...@2ndquadrant.fr>: >> Hi, >> >> A colleague came to me to express his surprise about this quite simple >> use case: >> >> =# alter table toto add column user text; >> ERROR: syntax error at or near "user" >> LINE 1: alter table toto add column user text; >> >> Is there a reason for us not to add an HINT: "user" is a reserved >> keyword or something like that, other than nobody having been interested >> in doing the work? > > Probably nobody did this work. I am thinking so on current code, this > request is relatively simple implemented - and I agree so this can be > really nice feature. >
but it is not too simple as I though this message coming from scanner_yyerror - and forwarding hint into this "callback" routine is not trivial - more - this message is used when word is reserved keyword and must not be and when word is just wrong reserved keyword. Regards Pavel > Regards > > Pavel > >> >> Regards, >> -- >> Dimitri Fontaine >> http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support >> >> -- >> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers