Re: create table error

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Mon, 13 Sep 2004, Kumar S wrote:

> I am getting a constant error that says Parse error
> at "(".
>
> I am using 7.4 and I never had this kind of problem in
> previous versions.

The lines below would never ever work in any PostgreSQL server...

> lines of my code:
>
> create table contacts
> (
> con_id serial ,
> exp_id serial REFERENCES experiment,
> con_lname varchar(32) ,
> con_fname varchar(32) ,
> con_addressline varchar (64),
> con_zip varchar(16) ,
> );

con_zip varchar(16) ,

would be

con_zip varchar(16)

You cannot use a comma after the last column definition.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBRaQLtl86P3SPfQ4RAnPnAJ41BEsJvrz+CJGKckByVHag0pJ9xQCgjZIK
w0A+rtK/XRljlbjOV+Dxfsc=
=SJ6k
-----END PGP SIGNATURE-----