Problem with tablespaces on older versions of PostgreSQL

From: Albin Blaschka <albin(dot)blaschka(at)raumberg-gumpenstein(dot)at>
To: pgadmin-support(at)postgresql(dot)org
Subject: Problem with tablespaces on older versions of PostgreSQL
Date: 2007-10-12 12:03:04
Message-ID: 470F6278.8090500@raumberg-gumpenstein.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


Hello!

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!

Thanks for PGAdmin III and your continuing efforts!

Albin

--
************************************************************************
** Albin Blaschka, Mag. rer. nat.
**
** HBLFA Raumberg - Gumpenstein
** Projektaquisition
** Tel.: ++43 (0)3682 / 22451 - 244
** For the creation of this message 100% recycled electrons were used!
************************************************************************

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ariel R. Giomi 2007-10-12 13:01:56 ALTER TABLE sample SET TABLESPACE
Previous Message Dave Page 2007-10-12 11:28:02 Re: windows, pgadminiii 1.8.0 RC1 crash after server restart