PostgreSQL vs. MySQL

[arnost]

 >
 >> arnost wrote:
 >> : >muzu jmenovat triggery, sub-selecty (UPDATE ... SELECT nebo 
 >> : >INSERT ... SELECT, pripadne SELECT INTO tabulka), UPDATE pres
 >> : 
 >> : zrovna INSERT ... SELECT mysql umi %)
 >> 
 >> 	Jo, ale ne nad tou samou tabulkou.
 >> 
 >> 	Jeste by se nekdo mohl vyjadrit k systemu pristupovych prav
 >> v PostgreSQL. MySQL je ma celkem propracovane (je mozno jit az na
 >
 >Me ale prijde , ze resene dost nestandardne, ale nezam nejnovejsi verze.
 >Mozna se to zmenilo.

Esi myslite GRANT tak:

19.3.5 Changes in release 3.22.11

     IMPORTANT: You must run the mysql_fix_privilege_tables script when you
     upgrade to this version! This is needed because of the new GRANT system. If you don't do
     this, you will get Access denied when you try to use ALTER TABLE, CREATE INDEX
     or DROP INDEX. 
     GRANT to allow/deny users table and column access. 


arnost