Re: [SQL] pg & Delphi

2007-09-02 Thread Josh Tolley
On 9/1/07, Dmitry Turin <[EMAIL PROTECTED]> wrote: > Very thanks to all. > Some questions: > > RH> You should be able to connect via ODBC. > I don't know Delphi well (i used only BDE). > What Delphi's object should be used to connect via ODBS > (instead of BDE-components TTable, TDatabase) ? > > JT

[SQL] PK & FK & Index Question

2007-09-02 Thread L D
Hi All, Assume the following have a one-to-one relationship: team_contact team_contact_id (PK) first_name last_name ... team_contact_contacts team_contact_id (FK) home_phone work_phone ... Should I set the latter table's FK also to PK? If so, do I

Re: [SQL] PK & FK & Index Questio

2007-09-02 Thread Rodrigo De León
On 9/2/07, L D <[EMAIL PROTECTED]> wrote: > Should I set the latter table's FK also to PK? It's sane. > If so, do I need to set an index on the FK even though it's also the primary > key? No need to do so. ---(end of broadcast)--- TIP 9: In vers