Re: LinuxTag wrapup

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2004-07-03T17:04:25Z
Lists: pgsql-hackers
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> - what about Oracle portability.

> IMHO we should rethink if we could make those people happy. How about a 
> loadable personality (IIRC SAPDB has something like that), to exchange 
> the parser in use with a custom one (by a SET command)? This way we have 
> a pure ansi default, while enabling a way so someone could contribute an 
> oracle style parser.

How about an external tool that helps in translating apps to
SQL-standard syntax?  Oracle does accept the standard syntax after all.
That way we are truly helping people liberate themselves: they can
switch to any SQL-compliant database, not only Postgres.

			regards, tom lane