Skip site navigation (1) Skip section navigation (2)

From: "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
Subject:
Date: 2002-02-13 19:16:10
Message-ID: 006801c1b4c2$e5be65c0$3200a8c0@jecinc.on.ca (view raw or flat)
Thread:
Lists: pgsql-novice
I'm working on a sync conduit (for memos) from a Palm pilot to a postgresql
database

I'll simplify things a bit to convey my question.

I have the main database table (notes) that has a note_id (primary key) and
note_content fields

I also have another table (called palm_memos) that matches up palm record
ids to records in the notes database (via the note_id field)

I think I have it working except for when there is a new record added to the
Palm

I need to add the contents of the new record in the Palm to the notes table
(I can do this with an INSERT SQL statement).

What I don't know how to do is to get that newly created note_id so that I
can insert it into the palm_memos table

Any ideas / advice?


Responses

  • Re: New ID at 2002-02-13 19:35:36 from Josh Berkus

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-02-13 19:30:45
Subject: Re: Function Hangs
Previous:From: Mo HolkarDate: 2002-02-13 18:09:53
Subject: Re: Peer authentication problem in CGI-Perl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group