| From: | Dev <dev(at)umpa-us(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Foriegn Keys? |
| Date: | 2004-11-22 21:38:45 |
| Message-ID: | 6.1.0.6.2.20041122163658.075dde70@pop3.umpa-us.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello all,
I have a database system in which i truncate a main table to update the
information. I would like to setup some foriegn keys referencing back to
that table but am concerned as to how the truncating of the Parent table
will effect the keys? Would all I have to do is insure that I vacuum the
db after I truncate and repopulate the table?
----------
UMPA
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
<http://www.umpa-us.com>http://www.umpa-us.com
1-800-555-9665 ext 212
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sally Sally | 2004-11-22 21:45:10 | primary key and the default index operator class |
| Previous Message | Goutam Paruchuri | 2004-11-22 21:33:03 | Postgres-Windows -Perl DBI |