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

BUG #5973: erreur SERIAL 4

From: "" <poiretlise(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5973: erreur SERIAL 4
Date: 2011-04-12 12:57:04
Message-ID: 201104121257.p3CCv44p002060@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5973
Logged by:          
Email address:      poiretlise(at)gmail(dot)com
PostgreSQL version: 9.0.3
Operating system:   windows 7
Description:        erreur SERIAL 4
Details: 

Hello,
I use PostgreSQL PgAdmin 9 and III. I am running Windows 7.
I want a scritp differential generated using the software Aqua Data Studio
9.0.13 (demo for now). I therefore generates a script that I want via Aqua
tilted in pgadmin III. However, I have a problem with the SERIAL 4.
the basic script:
CREATE TABLE USR_UTILISATEUR_UTI (
     UTI_ID Serial4 PRIMARY KEY);

Aqua Data Studio, it gives me:
CREATE TABLE public.usr_utilisateur_uti (
uti_id int4 NOT NULL DEFAULT nextval ('usr_utilisateur_uti_uti_id_seq'::
regclass);

except that pgadmin III does not want ... I'm stuck ..

Please, help me ...
Lise

Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2011-04-12 13:42:00
Subject: Re: BUG #5972: Update with subquery: erroneous results for foreign key field
Previous:From: Donald FraserDate: 2011-04-12 12:48:52
Subject: Re: Missing documentation for error code: 80S01

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