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-----