Hi Noel,

I have now implemented support for table and view synonyms. The most 
important classes are:
https://github.com/NiklasMehner/h2database/blob/master/h2/src/main/org/h2/command/ddl/CreateSynonym.java
https://github.com/NiklasMehner/h2database/blob/master/h2/src/main/org/h2/table/TableSynonym.java
and the tests can be found in:
https://github.com/NiklasMehner/h2database/blob/master/h2/src/test/org/h2/test/db/TestSynonymForTable.java

Perhaps you can take a look at it and tell me if you see any obvious 
problems.

Two questions I have are:

   - I am locking the meta data in CreateSynonym, but haven't found out, 
   when it is actually unlocked. Is there anything I have to do or does this 
   happen automatically?
   - Are names unique across all schema objects? Can there be a 
   function/sequence with the same name as a table? If yes the syntax "create 
   synonym x for y" would be ambiguous.

Best regards,

  Niklas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to