Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB6NInm07234 for ; Thu, 6 Dec 2001 18:18:49 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 31F0FD5F0; Thu, 6 Dec 2001 15:18:51 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 259EE5BED; Thu, 6 Dec 2001 15:18:51 -0800 (PST) Date: Thu, 6 Dec 2001 15:18:51 -0800 (PST) From: Stephan Szabo To: Joachim Trinkwitz Cc: Subject: Re: type casting bpchar In-Reply-To: <871yi8xkph.fsf@waffel.germanistik.uni-bonn.de> Message-ID: <20011206151755.A28880-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/85 X-Sequence-Number: 5908 On 6 Dec 2001, Joachim Trinkwitz wrote: > Dear all, > > I want to alter a table by creating a similar temporary table with my > modifications and inserting the values of the old table, but I get the > error message: > > ERROR: Attribute 'tag' is of type '_bpchar' but expression is of type 'bpchar' > You will need to rewrite or cast the expression > > Question is how do I do this, because when I write the offending value > as tag::_bpchar, I get: > > ERROR: Cannot cast type 'bpchar' to '_bpchar' > > This seems to be a dilemma which I don't know how to solve. I hope > someone can help me. Can you send the create statements for the two tables? It looks like one of the two has an array of chars, but I'm not sure.