Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E41BD6324A5
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 12 Jan 2009 05:45:21 -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 83369-07-4
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 12 Jan 2009 05:44:57 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from intern.proventis.net (intern.proventis.net [87.234.204.123])
	by mail.postgresql.org (Postfix) with ESMTP id 3379E6324D6
	for <pgsql-admin@postgresql.org>; Mon, 12 Jan 2009 05:44:17 -0400 (AST)
Received: from server1.proventis.net (unknown [192.168.22.250])
	by intern.proventis.net (Postfix) with ESMTP id AA6EA2C055;
	Mon, 12 Jan 2009 10:44:14 +0100 (CET)
Received: from localhost (localhost [127.0.0.1])
	by server1.proventis.net (Postfix) with ESMTP id C1877C440C4;
	Mon, 12 Jan 2009 10:44:09 +0100 (CET)
Received: from server1.proventis.net ([127.0.0.1])
	by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 09151-09; Mon, 12 Jan 2009 10:44:08 +0100 (CET)
Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130])
	by server1.proventis.net (Postfix) with ESMTP id C184BC440C3;
	Mon, 12 Jan 2009 10:44:07 +0100 (CET)
Message-ID: <496B10E7.6050604@proventis.net>
Date: Mon, 12 Jan 2009 10:44:07 +0100
From: Thomas Markus <t.markus@proventis.net>
Organization: proventis GmbH
User-Agent: Thunderbird 2.0.0.19 (X11/20081209)
MIME-Version: 1.0
To: Jan-Peter.Seifert@gmx.de
Cc: pgsql-admin@postgresql.org
Subject: Re: PGOPTIONS and default_tablespace
References: <20090112093427.316400@gmx.net>
In-Reply-To: <20090112093427.316400@gmx.net>
Content-Type: multipart/mixed; boundary="------------070909020006030709070903"
X-Virus-Scanned: by amavisd-new at proventis.net
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/31
X-Sequence-Number: 31078

This is a multi-part message in MIME format.
--------------070909020006030709070903
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

hi,

try

set PGOPTIONS="-c default_tablespace='pgdata'"

regards
thomas



Jan-Peter.Seifert@gmx.de schrieb:
> Hello,
>
> 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')
>
>   


--------------070909020006030709070903
Content-Type: text/x-vcard; charset=utf-8;
 name="t_markus.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="t_markus.vcf"

begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:t.markus@proventis.net
tel;work:+49 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard


--------------070909020006030709070903--