Skip site navigation (1) Skip section navigation (2)

Re: Problem with tablespaces on older versions of PostgreSQL

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: albin(dot)blaschka(at)raumberg-gumpenstein(dot)at
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Problem with tablespaces on older versions of PostgreSQL
Date: 2007-10-12 14:33:31
Message-ID: 470F85BB.1010403@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2007-10-12 14:38:42
Subject: Re: ALTER TABLE sample SET TABLESPACE
Previous:From: Rolf A. de ByDate: 2007-10-12 14:24:08
Subject: Bug report pgadmin 1.8.0 Beta 5 (Sep 10 2007, rev 6631)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group