Skip site navigation (1) Skip section navigation (2)

Re: LinuxTag wrapup

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LinuxTag wrapup
Date: 2004-07-03 17:31:05
Message-ID: 40E6ED59.4060908@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:

>Andreas Pflug <pgadmin(at)pse-consulting(dot)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


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-07-03 17:50:30
Subject: Re: LinuxTag wrapup
Previous:From: Andreas PflugDate: 2004-07-03 17:15:55
Subject: Re: LinuxTag wrapup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group