| From: | Mike <1100100(at)gmail(dot)com> |
|---|---|
| To: | Joshua Tolley <eggyknap(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Beginner Question: "Running Notes" or "Diary-like" |
| Date: | 2009-12-02 13:47:04 |
| Message-ID: | 8ca422820912020547n1ebb8a05kfd153885ac4ea88b@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, Dec 2, 2009 at 7:02 AM, Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:
> Perhaps I'm misunderstanding your situation, but it sounds like you should
> just create a second table for your running notes. This table would contain a
> TEXT field for the note data, a TIMESTAMPTZ field for the timestamp, and
> a field or set of fields to match the primary key of your mostly static client
> table, to link each note with a particular client.
>
Mr. Tolley,
Thank you for the rapid response.
I appreciate the suggestion; no misunderstanding on your part. :-)
Looks like I need to do more reading, absorbing, and experimenting
with primary keys and foreign keys.
Thanks for your help.
Mike
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Gentz | 2009-12-02 21:07:46 | Currval and transactions. |
| Previous Message | Bala senthil | 2009-12-02 12:52:30 | initdb fails in win xp |