Lee Kindness <[EMAIL PROTECTED]> writes: > Obviously a new column name will have to be used, however is there a > definitive list of keywords to avoid so such an occurance wouldn't > happen in a production system?
There is an up-to-date list of keywords in the documentation: http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-keywords-appendix.html As for predicting what keywords might become reserved in future PG releases, my crystal ball is down at the moment ... but words that are reserved in SQL99 would be good things to avoid. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html