Properties of 'Relationships' in FK definiton.
От | Anil Jangam |
---|---|
Тема | Properties of 'Relationships' in FK definiton. |
Дата | |
Msg-id | F73B646FCC01D5118F530002B32C337263B24D@INDTS_FS обсуждение исходный текст |
Список | pgsql-cygwin |
Hi Dave, After defining the FK relationship in one of the tables, the pgAdmin generates the view as follows. Foreign Keys [2] - PrimaryCompID -> FunctionEntityInventory - Relationships[1] - SecondaryCompID -> FunctionEntityInventory - Relationships[1] Here as shown, the 'PrimaryCompID' is a FK in table 'FunctionEntityInventory' and so the 'SecondaryCompID'. When I click on the 'PrimaryCompID' and 'SecondaryCompID', it shows the properties on the RHS (right hand side). But when I try to see the properties of 'Relationships' it gives the following error. An error has occured in pgAdminII:frmMain.tvNodeClick: Number: 5 Description: Invalid procedure call or argument. What is the meaning of this??? I have defined while creating the FK and its relationships correctly. But couldn't understand the meaning of 'deferrable' key word. Also in the properties of the FK, it shows some options: deferrable: No (I didn't checked this while creating the r'ship) Initally: Immidiate (What is the meaning and use of this??? There were two things to select here.. (immidiate, and deferred). System FK: NO. (What is the system FK??) -anil.
В списке pgsql-cygwin по дате отправления: