Zitat von Nigel Kukard <[EMAIL PROTECTED]>: > >> Sorry for being unclear. I have of course used the convert-tsql >> according to the INSTALL document. The "TINYTEXT" and "DATETIME" seam >> to be omitted. > > I don't think there are any columns which have DATETIME types, they are > all integers storing unix timestamps.
The DATETIME is used in "quotas.tsql". The "TINYTEXT" is used all over the place and is not altered by convert-tsql. > Send me the output which is given, and another output of which is > expected. > > Sorry I'm on the road at the moment so my access to my test system is > limited :( No need to hurry. For our tests i fix it "by hand". I will try to create a diff but need to know if there is some special reason at all to use TINYTEXT and not VARCHAR(255) in the first place. > >> >> 2.) In Postgres it is necessary to set a index on a column used as >> >> FOREIGN KEY explicit as far as i understand it. This has to be done >> >> for the "SERIAL" column in most of the tables. To be compatibel with >> >> MySQL it could be useful to use BIGSERIAL (8 Byte) instead. >> > >> > Hrmmm ... I'm not sure I understand what you are saying? >> > >> > The script which converts the sql "template" into the various database >> > schemas can easily be modified, so if you could explain the above a bit >> > more clear and show me examples I will make the relevant changes. >> >> In MySQL the datatype "serial" automatically get a primary key, in >> Postgres one have to specify >> >> create table somename ( >> <mumble> (big)serial PRIMARY KEY, >> ); >> >> It is an BIGINT in MySQL and an INT in Postgres. > > Fixed in r233. > Thanxs Andreas -- All your trash belong to us ;-) www.spamschlucker.org To: [EMAIL PROTECTED] ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ policyd-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/policyd-users
