Question: We all have our favourite database. If you look objectively at your chosen database, what drawbacks does it have and what could be improved?

The rules:

* One reply per drawback with;
* a short description of the limitation, followed by;
* a more detailed description, an explanation of how it could be done better or an example of another technology that does not have the same limitation.
* Do not diss any database that you haven't used extensively. It is easy to take potshots at other technologies but we want to learn form your experience, not your prejudice.

Answer: 
**Database** Oracle

**Defect** Did not handle long datatype well for too long

**Description**

Oracle only had the long datatype until 9i (I believe) at which point it was deprecated in favor of the LOBs. There is a ton of code out there, however, which still has longs and all of the related restrictions. The biggest of which was that each table could only have one long column and it had to be at the end of the columns. See [here](http://arjudba.blogspot.com/2008/06/long-datatype-in-oracle.html) for a more exhaustive list of restricitons on the long.
**Database : PostgreSQL**

\*\*Problem : \*\* is that connector for C# for example are not really up-to-date and crash with advanced feature.