| From: | "G(dot) Allegri" <giohappy(at)gmail(dot)com> |
|---|---|
| To: | Andreas <maps(dot)on(at)gmx(dot)net> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: ms-access tables relationships question |
| Date: | 2010-09-16 07:47:20 |
| Message-ID: | AANLkTimm+7rACvD6AeK9Qw8QCzKvRDVoTZrXhh+geDp=@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi,
> When your tables are managed by postgresql and have relations then
> postgresql keeps the integrity.
> You don't have to bother about it in Access.
Yes, you're right. My problem is that my customer has a complex
application built in Access (with lots of queries, masks, macros,
etc.) and he asked me to port only the data to Postgresql (for other
requirements), keeping the 'engine' inside Access. So I have to deal
with their actual structure and constraints in Access, and switch the
data integrity management to a hybrid system. Of course I will design
the various constraints inside Postgresql, but I have to decide how to
manage the Access side...
Giovanni
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Richardson | 2010-09-17 21:00:22 | How do I use Npgsql to connect to a DSN? |
| Previous Message | Andreas | 2010-09-16 02:59:23 | Re: ms-access tables relationships question |