Postgres Pro
Downloads
Home   >   mailing lists

Thread: RE: [SQL] Autogenerated Unique Index

RE: [SQL] Autogenerated Unique Index

From
Andrzej Mazurkiewicz
Date:
cfmg_adm=> CREATE TABLE A (
cfmg_adm(>        B int NOT NULL,
cfmg_adm(>        C char(5),
cfmg_adm(> PRIMARY KEY (B)
cfmg_adm(> );
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for
table 
'a'
CREATE
cfmg_adm=>
Regards,
Andrzej Mazurkiewicz


> -----Original Message-----
> From:    Antonio W. Lagnada [SMTP:alagnada@lsil.com]
> Sent:    7 marca 2000 14:41
> To:    Pgsql-sql
> Subject:    [SQL] Autogenerated Unique Index
> 
> Can someone give me a step-by-step instructions on how to generate a
> unique autogenerated index in PostgreSQL?
> 
> --
> Antonio W. Lagnada
> 
> 
> 952.921.8533
> alagnada@lsil.com_NOSPAM
> Remove the _NOSPAM for
> the actual email address
>  << File: Card for Antonio W. Lagnada >>

Re: [SQL] Autogenerated Unique Index

From
"Antonio W. Lagnada"
Date:
Hi Andrzej,

Does this mean that everytime I create a new record on the table, the field
"B" will be automatically incremented?

- Antonio

Andrzej Mazurkiewicz wrote:

> cfmg_adm=> CREATE TABLE A (
> cfmg_adm(>        B int NOT NULL,
> cfmg_adm(>        C char(5),
> cfmg_adm(> PRIMARY KEY (B)
> cfmg_adm(> );
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for
> table
> 'a'
> CREATE
> cfmg_adm=>
> Regards,
> Andrzej Mazurkiewicz
>
> > -----Original Message-----
> > From: Antonio W. Lagnada [SMTP:alagnada@lsil.com]
> > Sent: 7 marca 2000 14:41
> > To:   Pgsql-sql
> > Subject:      [SQL] Autogenerated Unique Index
> >
> > Can someone give me a step-by-step instructions on how to generate a
> > unique autogenerated index in PostgreSQL?
> >
> > --
> > Antonio W. Lagnada
> >
> >
> > 952.921.8533
> > alagnada@lsil.com_NOSPAM
> > Remove the _NOSPAM for
> > the actual email address
> >  << File: Card for Antonio W. Lagnada >>

--
Antonio W. Lagnada

952.921.8533
alagnada@lsil.com_NOSPAM
Remove the _NOSPAM for
the actual email address
Attachment

Re: [SQL] Autogenerated Unique Index

From
"Ross J. Reedstrom"
Date:
On Tue, Mar 07, 2000 at 03:30:38PM +0100, Andrzej Mazurkiewicz wrote:
> cfmg_adm=> CREATE TABLE A (
> cfmg_adm(>        B int NOT NULL,
> cfmg_adm(>        C char(5),
> cfmg_adm(> PRIMARY KEY (B)
> cfmg_adm(> );
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for
> table 
> 'a'
> CREATE
> cfmg_adm=>

Hmm, I bet Antonio is looking for an automatic sequence type, rather
than the 'autogenerated index' that he asks about. That'd be like:

test=> create table A (
test-> B serial,
test-> C text);
NOTICE:  CREATE TABLE will create implicit sequence 'a_b_seq' for SERIAL column 'a.b'
NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'a_b_key' for table 'a'
CREATE
test=> 

If you need more, look for "SERIAL" in ther docs.

Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

Re: [SQL] Autogenerated Unique Index

From
Trurl McByte
Date:
On Tue, 7 Mar 2000 (Today), Antonio W. Lagnada wrote:

Try "serial" macro-type off "id" field.

#CREATE TABLE A (
#    B serial,
#    C char(5)
#);
NOTICE:  CREATE TABLE will create implicit sequence 'a_b_seq' for SERIAL column'a.b'
NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'a_b_key' for table 'a'
CREATE 

Or make it by hand:

#CREATE SEQUENCE A_B_seq;
#CREATE TABLE A (
#    B int DEFAULT nextval('A_B_seq') NOT NULL,
#    C char(5),
#    PRIMARY KEY(B)
#);
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for table'a'  
CREATE
 AWL> Hi Andrzej, AWL>  AWL> Does this mean that everytime I create a new record on the table, the field AWL> "B" will
beautomatically incremented? AWL>  AWL> - Antonio AWL>  AWL> Andrzej Mazurkiewicz wrote: AWL>  AWL> > cfmg_adm=> CREATE
TABLEA ( AWL> > cfmg_adm(>        B int NOT NULL, AWL> > cfmg_adm(>        C char(5), AWL> > cfmg_adm(> PRIMARY KEY (B)
AWL>> cfmg_adm(> ); AWL> > NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for AWL> > table AWL>
>'a' AWL> > CREATE AWL> > cfmg_adm=> AWL> > Regards, AWL> > Andrzej Mazurkiewicz AWL> > AWL> > > -----Original
Message-----AWL> > > From: Antonio W. Lagnada [SMTP:alagnada@lsil.com] AWL> > > Sent: 7 marca 2000 14:41 AWL> > > To:
Pgsql-sqlAWL> > > Subject:      [SQL] Autogenerated Unique Index AWL> > > AWL> > > Can someone give me a step-by-step
instructionson how to generate a AWL> > > unique autogenerated index in PostgreSQL? AWL> > > AWL> > > -- AWL> > >
AntonioW. Lagnada AWL> > > AWL> > > AWL> > > 952.921.8533 AWL> > > alagnada@lsil.com_NOSPAM AWL> > > Remove the _NOSPAM
forAWL> > > the actual email address AWL> > >  << File: Card for Antonio W. Lagnada >> AWL>  AWL> -- AWL> Antonio W.
LagnadaAWL>  AWL> 952.921.8533 AWL> alagnada@lsil.com_NOSPAM AWL> Remove the _NOSPAM for AWL> the actual email address
AWL> AWL> 
 

--      Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200                   RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35  87 1F 3F EF FD 6D 84 B3--|

Re: [SQL] Autogenerated Unique Index

From
"Antonio W. Lagnada"
Date:
Hi Trurl,

#CREATE SEQUENCE A_B_seq;
#CREATE TABLE A (
#       B int DEFAULT nextval('A_B_seq') NOT NULL,
#       C char(5),
#       PRIMARY KEY(B)
#);

I think the above is what I'm looking for....Thanks to All :-)

Trurl McByte wrote:

> On Tue, 7 Mar 2000 (Today), Antonio W. Lagnada wrote:
>
> Try "serial" macro-type off "id" field.
>
> #CREATE TABLE A (
> #       B serial,
> #       C char(5)
> #);
> NOTICE:  CREATE TABLE will create implicit sequence 'a_b_seq' for SERIAL column'a.b'
> NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'a_b_key' for table 'a'
> CREATE
>
> Or make it by hand:
>
> #CREATE SEQUENCE A_B_seq;
> #CREATE TABLE A (
> #       B int DEFAULT nextval('A_B_seq') NOT NULL,
> #       C char(5),
> #       PRIMARY KEY(B)
> #);
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for table'a'
> CREATE
>
>   AWL> Hi Andrzej,
>   AWL>
>   AWL> Does this mean that everytime I create a new record on the table, the field
>   AWL> "B" will be automatically incremented?
>   AWL>
>   AWL> - Antonio
>   AWL>
>   AWL> Andrzej Mazurkiewicz wrote:
>   AWL>
>   AWL> > cfmg_adm=> CREATE TABLE A (
>   AWL> > cfmg_adm(>        B int NOT NULL,
>   AWL> > cfmg_adm(>        C char(5),
>   AWL> > cfmg_adm(> PRIMARY KEY (B)
>   AWL> > cfmg_adm(> );
>   AWL> > NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for
>   AWL> > table
>   AWL> > 'a'
>   AWL> > CREATE
>   AWL> > cfmg_adm=>
>   AWL> > Regards,
>   AWL> > Andrzej Mazurkiewicz
>   AWL> >
>   AWL> > > -----Original Message-----
>   AWL> > > From: Antonio W. Lagnada [SMTP:alagnada@lsil.com]
>   AWL> > > Sent: 7 marca 2000 14:41
>   AWL> > > To:   Pgsql-sql
>   AWL> > > Subject:      [SQL] Autogenerated Unique Index
>   AWL> > >
>   AWL> > > Can someone give me a step-by-step instructions on how to generate a
>   AWL> > > unique autogenerated index in PostgreSQL?
>   AWL> > >
>   AWL> > > --
>   AWL> > > Antonio W. Lagnada
>   AWL> > >
>   AWL> > >
>   AWL> > > 952.921.8533
>   AWL> > > alagnada@lsil.com_NOSPAM
>   AWL> > > Remove the _NOSPAM for
>   AWL> > > the actual email address
>   AWL> > >  << File: Card for Antonio W. Lagnada >>
>   AWL>
>   AWL> --
>   AWL> Antonio W. Lagnada
>   AWL>
>   AWL> 952.921.8533
>   AWL> alagnada@lsil.com_NOSPAM
>   AWL> Remove the _NOSPAM for
>   AWL> the actual email address
>   AWL>
>   AWL>
>
> --
>       Trurl McByte, Capt. of StasisCruiser "Prince"
> |InterNIC: AR3200                   RIPE: AR1627-RIPE|
> |--98 C3 78 8E 90 E3 01 35  87 1F 3F EF FD 6D 84 B3--|

--
Antonio W. Lagnada
Silicon Optimization

952.921.8533
alagnada@lsil.com_NOSPAM
Remove the _NOSPAM for
the actual email address
Attachment