Re: Re: MySQL has transactions

El Mié 24 Ene 2001 08:06, Zak McGregor escribió:
>
> Other irritations I've found with MySQL are (briefly):
> - no subselects (makes for ugly hacks in code)
> - no views
> - no foreign keys

Didn't know they didn't have foreign keys. :-(

> - no constraint support
> - completely lacking date integrity checking (eg will accept '2001-15-45'
> as a valid date).

That is pretty ugly.

- no rules
> - no triggers
> - no intersects or unions
> - table-level locking only
> - inability to go beyond FS limits of filesize for databases
> All in all, about the only thing MySQL has going for it is the replication.
>
> The only issues I've had with PostGres are:
> - this doesn't work: select a from b where a.fld in (select c from d where
> e = f intersect select c from d where e=g) but I believe that will be
> working in 7.1
> - 8k row limit
> pretty severe, but can be fixed at copmpile-time to 32k. Completely
> removed for 7.1

Both (AFAIK) are added in 7.1

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------