Zamknięty

94712 PostgreSQL - updatable VIEW

Mam problem z updatable VIEW potrzebnym w DRUPAL6 do realizacji wspolnej bazy uzytkowników dla wielu serwisów.

I\'m connecting to a second database on the same host through a view:

The view works as i see in it the data from the table.

Next i created a rule to update the source table:

I tailored the code for the rule from the documentation and some examples on the web. I\'m not certain it is correct. When i try to update data in the view i get the following error:

Query failed: ERROR: missing FROM-clause entry for table \"new\" CONTEXT: Error occurred on dblink connection named \"unnamed\"

Tried googling it but to no effect so far. It would be great if someone could just point me in the right direction.

Regards,

Pustka

postgres 9.1

debian 2.6.26-1-amd64

(make sure u installed the postgres-contrib)

CREATE DATABASE db1;

CREATE TABLE users

(

uid serial NOT NULL,

name character varying(60) NOT NULL DEFAULT \'\'::character varying,

pass character varying(32) NOT NULL DEFAULT \'\'::character varying,

CONSTRAINT users_pkey PRIMARY KEY (uid )

)WITH( OIDS=FALSE );

ALTER TABLE users OWNER TO test;

CREATE DATABASE db2;

\\connect db2;

CREATE extension dblink;

CREATE VIEW users AS SELECT usersxx.*

FROM dblink(\'hostaddr=127.0.0.1 port=5432 dbname=db1 user=test password=test\'::text,

\'SELECT uid, name, pass FROM users\'::text)

AS usersxx(uid integer, name character varying(60), pass character varying(32));

CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD SELECT

dblink_exec(\'hostaddr=127.0.0.1 port=5432 dbname=db1 user=test password=test\'::text,

\'UPDATE users SET name = [url removed, login to view], pass = [url removed, login to view] WHERE uid = [url removed, login to view] \'::text) AS dblink_exec;

Umiejętności: Plany biznesowe, Kontrakty, Zarządzanie projektem

Zobacz więcej: uid data entry, named query, unnamed, the view, point view, pass query, postgres error, missing database table, port extension, table data entry test, postgresql serial, web serial port, data entry googling, user view extension, postgresql table, googling, user view update, serial connection, serial entry, debian update

O pracodawcy:
( 0 ocen ) Warszawa, Poland

Numer ID Projektu: #5667018