[Opensource] Table Renaming Heads Up

Michael Rimov rimovm at centercomp.com
Wed Jul 3 15:26:09 PDT 2002


At 09:35 AM 7/3/2002 -0600, you wrote:


>Michael Rimov wrote:
>
>>Hey All,
>>
>>I've been really working to focus on compatibility with various databases 
>>and Application servers for this next ea release.  To that end, I've 
>>spent the last day getting things up and running with SAP DB.
>>
>>To make it work I had to perform two table renames.  I've included below 
>>the SQL I executed to an existing postgres database to reflect the new names:
>>
>>ALTER TABLE USERS RENAME TO USERSTABLE;
>>ALTER TABLE USERGROUP RENAME TO USERROLES;


Well, I'm honestly going for 'minimal impact'.  SapDB uses those table 
names, but it doesn't have any problems with the fields by the same name so 
none of those need to be changed.  Would you all want to see a different name?

                                                 -Mike




More information about the Opensource mailing list