From: | "Randall Parker" <randall(at)nls(dot)net> |
---|---|
To: | "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Auto-increment and data importing: problem pointed out in PHP builder review? |
Date: | 2000-07-10 23:03:19 |
Message-ID: | 23010823131285@mail.nls.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Are the following comments correct?
In particular, on his second complaint about the import and auto_increment: via what manner can one import a bunch of records and then not have the auto_increment next value be correct? I looked thru
the faq (4.16.x doesn't mention this) and and some of the manuals (admin and user) didn't see anything relevant to this issue second issue.
http://www.phpbuilder.com/columns/tim20000705.php3?page=1
Excerpt:
At this point, I ran into another small issue with Postgres - its "serial" data type (the
equivalent of MySQL's auto_increment) creates a "sequence" which does not get
dropped when its parent table is dropped. So if you try to re-create the table,
you'll get a name conflict for this sequence. A lot of new users would be
confused by this, so Postgres loses a couple points for that. Also, MySQL is
"smart" enough to increment its auto_increment value when you import data,
whereas Postgres' sequence does not get reset when you import data, causing all
new inserts to fail.
Aside: does anyone know a good easy way with Apache to use some off-the-shelf plug-in to be able to dump a bunch of HTML doc in a directory (the PostgreSQL doc is what I have in mind) and index it
and have a form where you can search it from?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2000-07-10 23:05:29 | Re: Using the JDBC Driver in version 7.02 |
Previous Message | Tom Lane | 2000-07-10 22:58:13 | Re: pg_backup symlink? |