Entries from David Fetter

David Fetter

Monday, June 11. 2012

VIEW triggers RETURNING...

Thanks to alecm on freenode for the idea. Thanks also to Andres Freund for pointing out a hole in the first implementation.

Access control is an excellent reason for allowing writes to a VIEW but not to the underlying table. You would ideally like that VIEW to act exactly like a TABLE, but when you put an INSTEAD OF trigger in there, what's coming back isn't necessarily what you'd expect...

Continue reading "VIEW triggers RETURNING..." »
Posted by
David Fetter
at 16:39 | Comments (7) | Trackbacks (0)

Thursday, February 3. 2011

Conferety-conf-conf-conf

I'm at the very exciting PostgreSQL Sessions in Paris, where I just talked about DBI-Link, and

FOSDEM, the Free and Open Source Software Developers' European Meeting

where I'll talk about PL/Parrot to a frighteningly large room.
Continue reading "Conferety-conf-conf-conf" »
Posted by
David Fetter
at 14:24 | Comment (1) | Trackbacks (0)

Thursday, October 21. 2010

Kick 'em out, and keep 'em out!

It's sad, really. You're about to move a database to archival storage, possibly to /dev/null, but pesky users keep talking to it. Continue reading "Kick 'em out, and keep 'em out!" »
Posted by
David Fetter
at 22:02 | Comments (3) | Trackbacks (0)

Thursday, September 16. 2010

GRAPHical SQL (or how to make a forest)

Graphs? In Databases? Yes, you can! Continue reading "GRAPHical SQL (or how to make a forest)" »
Posted by
David Fetter
at 00:47 | Comments (2) | Trackbacks (0)

Saturday, July 24. 2010

MVC Backups

Since Josh Drake has failed to allow comments on his very excellent blog, especially this post,I have to respond below. Continue reading "MVC Backups" »
Posted by
David Fetter
at 16:18 | Comments (0) | Trackbacks (0)
« previous page   (Page 5 of 6, totaling 80 entries) next page »

Archives

Subscribe

  • XML

Blog Administration

Open login screen