Re: LinuxTag wrapup

Tom Lane wrote:

>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.
>

Nice idea, but
- sources might not be accessible
- sources might not be easily readable (esp. if not embedded sql, 
example pgadmin) or created dynamically.
- probably too many non-ansi compliant servers (i.e. pre-9) still in use.

Regards,
Andreas