Re: [HACKERS] PostgreSQL as an application server

2004-08-08 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 06 August 2004 10:00 am, J. Andrew Rogers wrote: The major disadvantage is that the development environment and tools for in-database languages aren't nearly as rich as your typical standalone environment, which makes programming a pain

Re: [HACKERS] Open items

2004-08-05 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 03 August 2004 12:12 pm, Jonathan Gardner wrote: I'll look into how to actually implement this at home tonight. Well, it's two nights later but I think I made some headway. I discovered the joy that is backend/tcop/postgres.c. I

[HACKERS] PostgreSQL as an application server

2004-08-05 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Consider this. Most (well-written) applications are written in three layers. The data abstraction layer provides a clean interface to the underlying data so other people don't have to write SQL statements. The GUI layer handles all the GUI events

[HACKERS] Documentation on new features?

2004-07-17 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I know it's very early, but I think this is going to be important if you want people (like me) who want to help test. First off, the only reference to nested transaction I could find in the documentation is a note that PostgreSQL does not have

Re: [HACKERS] Documentation on new features?

2004-07-17 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 17 July 2004 9:55 am, Peter Eisentraut wrote: Jonathan M. Gardner wrote: Should I submit documentation changes to the sgml files for nested transcations? It will most likely be wrong, but maybe enough will be right that those who

[HACKERS] Fun with nested transactions in PL/pgSQL

2004-07-17 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Check out this gem. = CREATE TABLE t (i int); = CREATE OR REPLACE FUNCTION test() RETURNS VOID LANGUAGE 'plpgsql' AS ' BEGIN INSERT INTO t VALUES (1); EXECUTE ''BEGIN''; DELETE FROM t; EXECUTE ''ROLLBACK''; RETURN; END '; = SELECT test();

Re: [HACKERS] Release planning

2004-07-13 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 13 July 2004 7:33 pm, Christopher Kings-Lynne wrote: PHP's the same. Absolutely dreadful. They put all sorts of new features mixed in with security and bug fixes in their minor releases. The NUMBER OF TIMES I've upgraded PHP to fix a

Re: [HACKERS] Doxygen?

2004-03-17 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 17 March 2004 5:54 pm, Christopher Kings-Lynne wrote: I was thinking of writing a cron job to update the CVS tree and then build the documentation (takes about 10 minutes on my computer). Then I could push it to wherever you like.

Re: [HACKERS] Doxygen?

2004-03-16 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 16 March 2004 5:56 pm, Bruce Momjian wrote: Jonathan Gardner wrote: I'll start posting the documentation I am generating to my vanity site (announcements later), but would this be something that the postgresql.org main site would be

Re: [HACKERS] [SQL] Materialized View Summary

2004-02-25 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm not sure if my original reply made it through. Ignore the last one if it did. On Tuesday 24 February 2004 1:48 pm, Robert Treat wrote: On Tue, 2004-02-24 at 12:11, Richard Huxton wrote: On Tuesday 24 February 2004 16:11, Jonathan M. Gardner

[HACKERS] Materialized View Summary

2004-02-24 Thread Jonathan M. Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've written a summary of my findings on implementing and using materialized views in PostgreSQL. I've already deployed eagerly updating materialized views on several views in a production environment for a company called RedWeek: