Jason van Zyl wrote:
>
> On Tue, 21 Nov 2000, svante s�rmark wrote:
>
>
> Thanks! I can't really use the diff as the SQL is generated
> but the cascade dropping of the constraints is definitely
> handy. If there are columns missing then I have messed
> something up with the conf/master/turbine-schema.xml file.
>
> One question: in what case would you use the "USING INDEX"
> suffix for the primary key? Is that just redundant? I haven't
> used Oracle in a while. Thanks for the diff! I will integrate
> it!
It seems to me as if the "using index" thingy is only there so you can
specify a different sotorage-clause for the index that is is created
for the primary keys... Indexes always get created for primary keys, so
yes, it's redundant.
I've got the docs online if you want to take a look;
http://voland.ita.chalmers.se/oracle/oracle_online_816/DOC/server.816/a76989/ch4e5.htm
>
> --
> jvz.
>
> Jason van Zyl
> [EMAIL PROTECTED]
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
--
------------------------------------------------------------------------
Svante S�rmark | Chalmers University IT systems & services | 031-7728665
------------------------------------------------------------------------
GPG Key fingerprint = 9C5C F76A 6233 9DCF 22F5 B8B8 4A58 3182 B9B4 ED6E
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
