Table has type character varying, but query expects character varying - Mailing list pgsql-general

From Howard Cole
Subject Table has type character varying, but query expects character varying
Date
Msg-id 47276216.3040804@selestial.com
Whole thread Raw
Responses Re: Table has type character varying, but query expects character varying  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I have the following table in a win32 8.2.2 database: (dumped from pgadmin)

CREATE TABLE email_directory
(
  email_directory_id serial NOT NULL,
  mailbox_id integer NOT NULL,
  path character varying(255) NOT NULL,
  marked_for_deletion boolean NOT NULL DEFAULT false,
  CONSTRAINT email_directory_pkey PRIMARY KEY (email_directory_id),
  CONSTRAINT email_directory_mailbox_id_fkey FOREIGN KEY (mailbox_id)
      REFERENCES mailbox (mailbox_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
)
WITHOUT OIDS;

ALTER TABLE email_directory OWNER TO postgres;
GRANT ALL ON TABLE email_directory TO postgres;

CREATE UNIQUE INDEX email_directory_mailbox_id_path_idx
  ON email_directory
  USING btree
  (mailbox_id, lower(path::text));


I have the following row in the table:

56, 4,'/Demo', f


When I try the following query I get the error below.

update email_directory set path='/Something else' where
email_directory_id=56

ERROR: attribute 3 has wrong type
SQL state: XX000
Detail: Table has type character varying, but query expects character
varying.

What has gone wrong?

Howard
www.selestial.com

pgsql-general by date:

Previous
From: M Rather
Date:
Subject: Re: pgsql.broken.csc
Next
From: "Sushant Sinha"
Date:
Subject: Re: Fragments in tsearch2 headline