Can't edit rows

Поиск
Список
Период
Сортировка
От Roman Uhlig Maxity.de
Тема Can't edit rows
Дата
Msg-id A025DDE0EDC0AF418528BC79E07BB10E0813ED@srv-kv11.knve.net
обсуждение исходный текст
Ответы Re: Can't edit rows  (Quan Zongliang <quanzongliang@gmail.com>)
Список pgadmin-support
In one of our Postgresql databases pgadmin (1.8.4) shows a strange
behaviour: I can't edit row data in some of the tables.

All tables have primary keys, but no OIDS. All tables have the same
owner and belong to the same database and schema. This problem only
occurs in pgadmin, in any other postgresql database editor I have tried
, editing works fine.

An example:

CAN NOT edit data:
---------------

CREATE TABLE knve_property_multilang_field
( id serial NOT NULL, id_language integer NOT NULL, id_property integer NOT NULL, "name" character varying(250) NOT
NULL,value_txt text, CONSTRAINT knve_property_multilang_field_pkey PRIMARY KEY (id), CONSTRAINT
fk_knve_property_multilang_field_languageFOREIGN KEY 
(id_language)     REFERENCES knve_language (id) MATCH SIMPLE     ON UPDATE NO ACTION ON DELETE RESTRICT, CONSTRAINT
fk_knve_property_multilang_field_propertyFOREIGN KEY 
(id_property)     REFERENCES knve_property (id) MATCH SIMPLE     ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH (OIDS=FALSE);


CAN edit data:
-------------

CREATE TABLE knve_instance
( id serial NOT NULL, id_type integer NOT NULL, deleted boolean NOT NULL DEFAULT false, created_on timestamp without
timezone NOT NULL DEFAULT now(), changed_on timestamp without time zone, created_by integer, changed_by integer,
CONSTRAINTknve_instance_pkey PRIMARY KEY (id), CONSTRAINT fk_knve_instance_type FOREIGN KEY (id_type)     REFERENCES
knve_type(id) MATCH SIMPLE     ON UPDATE NO ACTION ON DELETE RESTRICT 
)
WITH (OIDS=FALSE);


Any ideas on that would be very appreciated.

Thanks in advance,
Roman


В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Feature request: pgdump and version number / -i option
Следующее
От: Quan Zongliang
Дата:
Сообщение: Re: Can't edit rows