pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Joachim Trinkwitz <jtr@uni-bonn.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: type casting bpchar
Date: Thu, 6 Dec 2001 15:18:51 -0800 (PST)
Message-ID: <20011206151755.A28880-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <871yi8xkph.fsf@waffel.germanistik.uni-bonn.de>

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.




view thread (2+ messages)

Message-ID: <20011206151755.A28880-100000@megazone23.bigpanda.com>
Permalink:  ../20011206151755.A28880-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20011206151755.A28880-100000@megazone23.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sszabo@megazone23.bigpanda.com, jtr@uni-bonn.de
  Subject: Re: type casting bpchar
  In-Reply-To: <20011206151755.A28880-100000@megazone23.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox