Zitat von Nigel Kukard <[EMAIL PROTECTED]>:
> Good day,
>
>> 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?
>
> There is a pgsql option which generates PostgreSQL schema.
>
> There is also an sqlite option which generates SQLite3 schema.
>
> There is also a mysqlv4 (i think it is) option which generates MySQL v4
> schema.
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.
>
>> 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.
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
policyd-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/policyd-users
