Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 57CBC632413 for ; Mon, 12 Jan 2009 12:54:07 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 49366-02 for ; Mon, 12 Jan 2009 12:54:01 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 08732632410 for ; Mon, 12 Jan 2009 12:53:59 -0400 (AST) Received: (qmail 16662 invoked by uid 0); 12 Jan 2009 16:53:57 -0000 Received: from 192.124.237.8 by www163.gmx.net with HTTP; Mon, 12 Jan 2009 17:53:57 +0100 (CET) Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset="iso-8859-1" Date: Mon, 12 Jan 2009 17:53:57 +0100 From: Jan-Peter.Seifert@gmx.de In-Reply-To: <496B10E7.6050604@proventis.net> Message-ID: <20090112165357.106470@gmx.net> MIME-Version: 1.0 References: <20090112093427.316400@gmx.net> <496B10E7.6050604@proventis.net> Subject: Re: PGOPTIONS and default_tablespace To: Thomas Markus X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1/0e3gziIH0a0knbQsanFq1SNWCNhh7uNiTOhYC+F GOBuAtfytS7s86NAFxdUxZhuo204/eUL2Cgw== Content-Transfer-Encoding: 8bit X-GMX-UID: lkJZeKMBIydmAQTzemdr8XhSa2FkZlWv X-FuHaFi: 0.7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/32 X-Sequence-Number: 31079 Hello Thomas, thank you very much for your quick reply. However, this version doesn't work either - at least on Windows. Peter > try > > set PGOPTIONS="-c default_tablespace='pgdata'" > > without success I tried to set the default tablespace via the > environment variable PGOPTIONS. > > > > My tries: > > set PGOPTIONS="default_tablespace='pgdata'" > > set PGOPTIONS=default_tablespace='pgdata' > > set PGOPTIONS=default_tablespace(pgdata) > > set PGOPTIONS=default_tablespace('pgdata') > > > > > -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger