pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedCreating table with unique key.
3+ messages / 3 participants
[nested] [flat]
* Creating table with unique key.
@ 1998-08-05 21:49 Colin Dick <cdick@mail.ocis.net>
1998-08-05 22:46 ` Re: [SQL] Creating table with unique key. Eric McKeown <ericm@palaver.net>
1998-08-06 14:09 ` Re: [SQL] Creating table with unique key. Sferacarta Software <sferac@bo.nettuno.it>
0 siblings, 2 replies; 3+ messages in thread
From: Colin Dick @ 1998-08-05 21:49 UTC (permalink / raw)
To: pgsql-sql@postgreSQL.org
> > CREATE TABLE cliente (
> > name varchar(100) UNIQUE NOT NULL,
> > username varchar(8) NOT NULL ,
> > key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY,
> > );
Hi this is from a previous post regarding auto-incrementing. I have that
part working, now I am trying to create a table with a field which will
not be null and will be unique to the rest of table. Is this possible and
what is the correct syntax. I have tried and receeved the following:
CREATE TABLE cust (FileNumber int4 unique not null, CompName varchar(50),
FirstName varchar(50), LastName varchar(50), BirthDate varchar(8), Suite
varchar(5), Address varchar(50), City varchar(20), Province varchar(20),
PostalCode varchar(7), Email varchar(50), HomePhone varchar(14), WorkPhone
varchar(14), FaxPhone varchar(14));
WARN:parser: parse error at or near "unique"
Can someone point me in the right direction. Thanks.
--
Colin Dick
On Call Internet Services
cdick@mail.ocis.net
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Creating table with unique key.
1998-08-05 21:49 Creating table with unique key. Colin Dick <cdick@mail.ocis.net>
@ 1998-08-05 22:46 ` Eric McKeown <ericm@palaver.net>
1 sibling, 0 replies; 3+ messages in thread
From: Eric McKeown @ 1998-08-05 22:46 UTC (permalink / raw)
To: Colin Dick <cdick@mail.ocis.net>; +Cc: pgsql-sql@postgreSQL.org
On Wed, 5 Aug 1998, Colin Dick wrote:
> Date: Wed, 5 Aug 1998 14:49:13 -0700 (PDT)
> From: Colin Dick <cdick@mail.ocis.net>
> To: pgsql-sql@postgreSQL.org
> Subject: [SQL] Creating table with unique key.
>
> > > CREATE TABLE cliente (
> > > name varchar(100) UNIQUE NOT NULL,
> > > username varchar(8) NOT NULL ,
> > > key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY,
> > > );
>
> Hi this is from a previous post regarding auto-incrementing. I have that
> part working, now I am trying to create a table with a field which will
> not be null and will be unique to the rest of table. Is this possible and
> what is the correct syntax. I have tried and receeved the following:
>
> CREATE TABLE cust (FileNumber int4 unique not null, CompName varchar(50),
> FirstName varchar(50), LastName varchar(50), BirthDate varchar(8), Suite
> varchar(5), Address varchar(50), City varchar(20), Province varchar(20),
> PostalCode varchar(7), Email varchar(50), HomePhone varchar(14), WorkPhone
> varchar(14), FaxPhone varchar(14));
> WARN:parser: parse error at or near "unique"
CREATE TABLE cust (FileNumber int4 PRIMARY KEY NOT NULL, ...
I think that should fix it. You could also create a unique index on
individual fields in order to enforce their uniqueness.
CREATE [UNIQUE] INDEX <indexname> on <class_name> (fieldname)
Do a \h on create index for more info...
eric
>
> Can someone point me in the right direction. Thanks.
>
> --
> Colin Dick
> On Call Internet Services
> cdick@mail.ocis.net
>
>
>
_______________________
Eric McKeown
ericm@palaver.net
http://www.palaver.net
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Creating table with unique key.
1998-08-05 21:49 Creating table with unique key. Colin Dick <cdick@mail.ocis.net>
@ 1998-08-06 14:09 ` Sferacarta Software <sferac@bo.nettuno.it>
1 sibling, 0 replies; 3+ messages in thread
From: Sferacarta Software @ 1998-08-06 14:09 UTC (permalink / raw)
To: pgsql-sql@postgreSQL.org, Colin Dick <cdick@mail.ocis.net>
Hello Colin,
mercoledì, 5 agosto 98, you wrote:
>> > CREATE TABLE cliente (
>> > name varchar(100) UNIQUE NOT NULL,
>> > username varchar(8) NOT NULL ,
>> > key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY,
>> > );
CD> Hi this is from a previous post regarding auto-incrementing. I have that
CD> part working, now I am trying to create a table with a field which will
CD> not be null and will be unique to the rest of table. Is this possible and
CD> what is the correct syntax. I have tried and receeved the following:
CD> CREATE TABLE cust (FileNumber int4 unique not null, CompName varchar(50),
CD> FirstName varchar(50), LastName varchar(50), BirthDate varchar(8), Suite
CD> varchar(5), Address varchar(50), City varchar(20), Province varchar(20),
CD> PostalCode varchar(7), Email varchar(50), HomePhone varchar(14), WorkPhone
CD> varchar(14), FaxPhone varchar(14));
CD> WARN:parser: parse error at or near "unique"
CD> Can someone point me in the right direction. Thanks.
CD> --
CD> Colin Dick
CD> On Call Internet Services
CD> cdick@mail.ocis.net
The syntax is correct for v6.3.2 and it works for me, maybe you have
an older release of PostgreSQL.
Best regards,
Jose' mailto:sferac@bo.nettuno.it
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-08-06 14:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-05 21:49 Creating table with unique key. Colin Dick <cdick@mail.ocis.net>
1998-08-05 22:46 ` Eric McKeown <ericm@palaver.net>
1998-08-06 14:09 ` Sferacarta Software <sferac@bo.nettuno.it>
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