Hello

we are trying out policyd v2 with PostgreSQL and have some question/remarks.

1.) The script for creating the tables uses some mysql only datatypes  
like "TINYTEXT" and "DATETIME" which are not supported by PostgreSQL.  
Would it be better to use the "portabel" types "VARCHAR(255)" and  
"TIMESTAMP" instead?

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.

Regards

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

Reply via email to