Re: pg with different sql?

Paulo J. Matos wrote:

> Hi all,
> CREATE TABLE socio (
> id integer SERIAL PRIMARY KEY,
> nome varchar,
> alcunha string,
> data_filiacao date)
>
> CREATE TABLE paga_cota (
> ano integer,
> mes integer,
> valor integer,
> id integer,
> PRIMARY KEY(id,ano,mes),
> FOREIGN KEY(id) REFERENCES(socio))
>
>
> After this I get an error around CREATE (of the 2nd table). I
> just can't imagine what it might be.
>

First ...
SERIAL means an integer with primary key [tableName]_pkey (socio_pkey),
not null and default set to sequence: [tableName]_[fieldName]_seq
(socio_id_seq).

Probably this is what you want!!
CREATE TABLE socio (
id SERIAL,
...

Second ...
String ?? ... maybe char(x) or varchar(x) or text or ...

Third ...
FOREIGN KEY(id) REFERENCES socio ...

George Moga,
george(at)dsn(dot)ro
Braila, ROMANIA