Re: [GENERAL] parser

I had this problem a couple years ago. I changed the column name
before the upgrade by renaming the table to table_old, creating a
new table with the original table name by selecting from table_old.
For the column I needed to rename, I selected offset as
'x_offset'. I made sure everything was there, then dropped
table_old and exported the database prior to the upgrade. It's a
bit of trouble to find all the queries in the software and replace
the column name, but for my application it was workable. Or maybe
you already know how to do this but don't think you should have to?

I hope this helps.

Sarah Officer
officers

Jeff MacDonald wrote:
>
> hi, got this question from a user, anyone up for some discussion on it
>
> 1) I have been using 6.3 and recently tried to
> move to 6.5. I found that the word "offset" is now a reserved word and I have used it as a field name in
> a table. 6.5 reports this as an error. I wonder if the parser should do this since the context is as a
> field name.
>
> ======================================================
> Jeff MacDonald
> jeff(at)pgsql(dot)com irc: bignose on EFnet
> ======================================================
>
> ************