-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sun, 23 Mar 2008 19:35:46 -0500
Seb <spluque@gmail.com> wrote:
> CREATE TABLE test
> (
> id Int8,
> phenotype Varchar(510),
> genotype Varchar(510)
> );
serial_test=# CREATE TABLE test
(
id Int8,
phenotype Varchar(510),
genotype Varchar(510)
);
CREATE TABLE
I can not duplicate your problem. However when I copy and paste
directly from your email it does indeed fail watch:
serial_test=# CREATE TABLE test
serial_test-# (
serial_test(# idInt8,
serial_test(# phenotype Varchar(510),
serial_test(# genotype Varchar(510)
serial_test(# );
ERROR: syntax error at or near "Varchar"
LINE 4: phenotype Varchar(510),
^
That is a direct copy and paste from your email. Notice that there is
no space between id and Int8. Once I manually put the space in, it
worked as expected.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFH5vpJATb/zqfZUUQRAk+zAJ0WerkdEjY2eDB24OBQMRn4iyHCngCfahBs
r8zG0uQChcr11XLkZ5dtY5A=
=k3m8
-----END PGP SIGNATURE-----
