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