*** DarylM has joined #ingres | 05:46 | |
*** DarylM1 has joined #ingres | 06:18 | |
*** DarylM has quit IRC | 06:20 | |
pboro | Err. How do I remove foreign key using ALTER TABLE... | 08:52 |
---|---|---|
pboro | eeeh wtf | 08:55 |
pboro | Ingres allows the same referential key to be added multiple times... | 08:55 |
*** Dejan has joined #ingres | 09:14 | |
*** Dejan has quit IRC | 10:16 | |
*** Dejan has joined #ingres | 10:35 | |
*** Dejan has quit IRC | 14:34 | |
DarylM1 | pboro: you mean the same column names in a key spec? | 14:53 |
pboro | yup | 15:04 |
pboro | 10.0.1 pre on Linux x86_64, maybe I'll report a bug... | 15:05 |
DarylM1 | Did you let Ingres create a constraint name for you? | 15:05 |
pboro | yup | 15:05 |
DarylM1 | Not a bug. But it isn't very pleasent determining the name that was generated. | 15:05 |
pboro | but it should be clever enough to check that there's a referential key already for the same table and column | 15:05 |
pboro | that too | 15:06 |
DarylM1 | That is why I always name my constraints | 15:06 |
pboro | yea, you just have to define the constraints separately, you can't do it in CREATE TABLE | 15:06 |
pboro | or can you? | 15:06 |
DarylM1 | Not that I know of. I never really ran into that because I have always only put primary keys in the create table. Foreign keys I declare separately but that is just a personal choice. | 15:08 |
pboro | ok | 15:09 |
DarylM1 | Try "help constraint <tablename>" | 15:09 |
DarylM1 | It will give you the constraint names. | 15:10 |
DarylM1 | Caveat: I am running 10.1 experimental. | 15:10 |
pboro | hehe :) | 15:10 |
DarylM1 | On a Mac | 15:10 |
DarylM1 | :-D | 15:10 |
*** Dejan has joined #ingres | 15:26 | |
*** Dejan has quit IRC | 15:53 | |
*** grantc has quit IRC | 18:27 | |
*** grantc has joined #ingres | 18:28 | |
*** TylerM has joined #ingres | 19:07 | |
*** TylerM has quit IRC | 20:00 | |
*** TylerM has joined #ingres | 20:02 | |
*** TylerM has joined #ingres | 20:02 | |
*** DarylM1 has quit IRC | 23:17 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!