Thread: parser

parser

From
"Jeff MacDonald "
Date:
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@pgsql.com    irc: bignose on EFnet
======================================================


Re: [GENERAL] parser

From
Sarah Officer
Date:
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@pgsql.com  irc: bignose on EFnet
> ======================================================
>
> ************