Hi,
yet another strange thing that did work before:
The database doesn't save values when entered into the table grid. Instead
I get an error popup saying: ERROR: type "pg_catalog.integer" does not exist
I've double checked an older version of pgadmin, and that version has no
problems saving the changed line.
The offending statement according to the log file is:
ERROR: type "pg_catalog.integer" does not exist
STATEMENT: UPDATE rpcore_portal_template SET
template_size='long'::pg_catalog.text WHERE rpcore_template_id
= '1'::pg_catalog."integer"
The database is a version 8.1.4 installation, pgadmin is r5368 compiled from
SVN. I've attached a schema only dump of the table.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> ---- http://rp-online.de/ ----
--
-- PostgreSQL database dump
--
SET client_encoding = 'LATIN9';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: rpcore_portal_template; Type: TABLE; Schema: public; Owner: RPONLINE;
Tablespace:
--
CREATE TABLE rpcore_portal_template (
rpcore_template_id integer NOT NULL,
template_name text NOT NULL,
template_image_width integer,
template_image_height integer,
template_additional_css text,
template_additional_class text,
template_num_teaser integer,
template_size text
);
ALTER TABLE public.rpcore_portal_template OWNER TO "RPONLINE";
--
-- Name: TABLE rpcore_portal_template; Type: COMMENT; Schema: public; Owner:
RPONLINE
--
COMMENT ON TABLE rpcore_portal_template IS 'Template-Daten fuer den
Portal-Editor.';
--
-- Name: rpcoreportaltemplpkey; Type: CONSTRAINT; Schema: public; Owner:
RPONLINE; Tablespace:
--
ALTER TABLE ONLY rpcore_portal_template
ADD CONSTRAINT rpcoreportaltemplpkey PRIMARY KEY (rpcore_template_id);
--
-- PostgreSQL database dump complete
--
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
