On Thu, 2005-02-24 at 07:56, Charl Gerber wrote:
> Hi,
>
> We have a production environment running postgre 7.3.4
> under linux. We are thinking about setting up a
> windows only development environment, which would mean
> we have to run postgre 8.0 on a windows machine.
>
> Question is, will the code developed under 8.0 run
> without problems under 7.3.4? We're only concerned
> about the actual SQL syntax, SP and trigger
> definitions, FK constraints, etc. Ie, are the syntaxes
> for the two versions the same or what do we need to
> take into consideration here?
Can yo do the development in 7.3 and then port to 8.0? That's more
likely to work, as there are plenty of features in 8.0 that don't exist
in 7.3 but not much that's the other way around.