Albin Blaschka a écrit : > I just discovered the following problem with PGAdmin 1.8 RC1 (on WinXP) > I have a server where still PostgreSQL version 7.4.7 is running (Debian > Sarge). I created a table with PGAdmin, finished (which went fine) and > added a little bit later some more columns. > PGAdmin gave me a syntax error, because in the SQL seen in the SQl-Pane > there is (obviously because of the version of the database server) no > name for a tablespace... > > The generated SQL looks something like > > ALTER TABLE myschema.mytable > ADD COLUMN test character varying(3); > ALTER TABLE myschema.mytable SET TABLESPACE ; > > I hope I made it clear! >
Clear enough to help me fix this. I'll commit my fix in a few minutes. Thanks for your report. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
