Skip site navigation (1) Skip section navigation (2)

Cannot insert into view without an appropriate rule (#7)

From: "Makauskas Vidas" <dbf(at)lindra(dot)lt>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Cannot insert into view without an appropriate rule (#7)
Date: 2003-02-06 12:19:23
Message-ID: MKEPLGGGIHJHKDJLKIPAGENKCAAA.dbf@lindra.lt (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,
It's convenient (search, filters, sorting...) to do local forms over ODBC
with linked tables in access. But exits incompatibility with date types:
int8, date, time in postgres with access.

I've link view with access97:
CREATE VIEW view_table AS SELECT Fdate::timestamp, Fint8::int4 FROM table;

Then make an attemp INSERT and get error:
'Cannot insert into view without an appropriate rule (#7)'.

Is it mistaken way to solve mentioned above problem with data
incompatibility postgres and access.
Or Is it posible to solve problem via rules...

Excuse me for newbie question.

Best regards,
Vidas

Su pagarba,
Vidas Makauskas
8w683,66455


pgsql-odbc by date

Next:From: SupportDate: 2003-02-06 15:43:21
Subject: Repost: problem on treatment when add a duplicate primary key
Previous:From: Anderson CichonDate: 2003-02-06 12:03:21
Subject: Driver PostgreSql x dbExpress

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group