Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux) - Mailing list pgsql-general

From Tom Lane
Subject Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
Date
Msg-id 16915.975088072@sss.pgh.pa.us
Whole thread Raw
In response to Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)  ("George Armhold" <armhold@cs.rutgers.edu>)
List pgsql-general
"George Armhold" <armhold@cs.rutgers.edu> writes:
> The one other thing I had to do was rename
> a field "offset" to "my_offset" throughout all my tables.  Apparently this
> is a reserved word in the current version?

Yes, see LIMIT/OFFSET options in SELECT.  You could still use it with
double-quotes around the name, but changing the column name is probably
less annoying in the long run...

            regards, tom lane

pgsql-general by date:

Previous
From: "George Armhold"
Date:
Subject: Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
Next
From: Nelio Alves Pereira Filho
Date:
Subject: PL/Perl