On Wed, 14 Dec 2011, Andreas wrote:
Hi,
I asked elsewhere about the best way to store db credentials within a
user-session of a web-app.
You might give this a read:
http://database-programmer.blogspot.com/2009/02/comprehensive-database-security-model.html
It goes through how using a DB use
On Tue, 29 Jan 2008, David Owen wrote:
On Tue, 29 Jan 2008, David Owen wrote:
I discovered that if I change the rule to only do the insert, I still have
troubles. The first update to simple2 will insert an row, but a second
update will give a duplicate primary key error.
Sorry, that
On Tue, 29 Jan 2008, David Owen wrote:
CREATE TABLE simple1(a varchar, b varchar, c timestamp DEFAULT now(),
d timestamp, PRIMARY KEY(a, c));
CREATE VIEW simple2 AS SELECT a, b FROM simple1 WHERE d IS NULL;
INSERT INTO simple1(a, b) VALUES('a', '1');
CREATE RULE simple2
ith (a, b, c, d) = ('a', '2', some time, NULL).
However, the new row isn't inserted; only the previous row is changed.
What am I missing? Any pointers? I've read through the docs (I'm on
8.2.6) for rules several times, and nothing seems to
