From: Daniel Migowski <dmigowski@ikoffice.de>
To: pgsql-sql@postgresql.org
Subject: Re: sorry, now with subject... trigger & nextval(seq)
Date: Tue, 01 Jun 2010 13:05:36 +0200
Message-ID: <4C04E980.9080906@ikoffice.de> (raw)
In-Reply-To: <201005201846.53125.adrian.klaver@gmail.com>
References: <45e30277e8954d24114a9fd63720c7e7.squirrel@mailbox.gwdg.de>
<201005201846.53125.adrian.klaver@gmail.com>
Am 21.05.2010 03:46, schrieb Adrian Klaver:
> You know serial is just a shortcut for:
>
> pid int NOT NULL DEFAULT nextval('seq')
>
> I think you will find Access will place nice if you use the long form to define
> your autoincrement.
>
Not true. Serial will also add an internal dependency between the
sequence, will create the sequence and will drop everything if the
column gets dropped.
Regards,
Daniel Migowski
Attachments:dmigowski.vcf (text/x-vcard, 293B) download
begin:vcard
fn:Daniel Migowski
n:Migowski;Daniel
org:IKOffice.de
adr:;;Nordstr. 10;Oldenburg;Niedersachen;26123;Deutschland
email;internet:dmigowski@ikoffice.de
title:Dipl.-Inf.
tel;work:0441-2198895-2
tel;fax:0441-2198895-5
x-mozilla-html:TRUE
url:http://www.ikoffice.de
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dmigowski@ikoffice.de
Subject: Re: sorry, now with subject... trigger & nextval(seq)
In-Reply-To: <4C04E980.9080906@ikoffice.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox