[HACKERS] Creating a SHELL type [Was: User Defined Types in Java]

2006-05-14 Thread Thomas Hallgren
I just discovered that it is now possible to create a SHELL type using the 'CREATE TYPE type name' syntax using cvs head. Will this come in 8.2 only or will it also be included in 8.1.4? Kind Regards, Thomas Hallgren ---(end of broadcast)---

Re: [HACKERS] Creating a SHELL type [Was: User Defined Types in Java]

2006-05-14 Thread Martijn van Oosterhout
On Sun, May 14, 2006 at 09:14:38AM +0200, Thomas Hallgren wrote: I just discovered that it is now possible to create a SHELL type using the 'CREATE TYPE type name' syntax using cvs head. Will this come in 8.2 only or will it also be included in 8.1.4? Yeah, this was patched a little while

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-14 Thread Albert Cervera Areny
A Saturday 13 May 2006 08:33, Thomas Hallgren va escriure: Albert Cervera Areny wrote: Of course, that's an option for my case. Just wanted to know if this solution could be useful for PostgreSQL in general. Mainly because I'll add some triggers to check what maybe PostgreSQL should do

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-14 Thread Thomas Hallgren
Albert Cervera Areny wrote: ...What do you mean with triggers that maintain cascade behavior? It ties on to how references are handled. Since they currently ignore the inheritance aspect, you need triggers that enforce 'on cascade delete/update'. They will become obsolete if that changes

Re: [HACKERS] Inheritance, Primary Keys and Foreign Keys

2006-05-14 Thread Hannu Krosing
Ühel kenal päeval, N, 2006-05-11 kell 23:28, kirjutas Albert Cervera Areny: Of course, that's an option for my case. Just wanted to know if this solution could be useful for PostgreSQL in general. Mainly because I'll add some triggers to check what maybe PostgreSQL should do itself but it's

Re: [HACKERS] audit table containing Select statements submitted

2006-05-14 Thread Marc Munro
You could do this using Veil, http://pgfoundry.org/projects/veil/, or something like it. A Veil access function, http://veil.projects.postgresql.org/curdocs/overview-page.html, could be used to record every row returned within a query to the user that requested it. Note that this operates at the

Re: [HACKERS] Fwd: [pgsql-hackers-win32] Build with Visual Studio MSVC

2006-05-14 Thread Gurjeet Singh
Hi All, I know it has been over a week now since I said that I'll put together a document that describes how to debug postgres using Eclipse IDE on Windows. I have finally completed the first draft and uploaded it here: http://www.geocities.com/gurjeet79/pg_on_eclipse.txt And here's a

Re: [HACKERS] Fwd: [pgsql-hackers-win32] Build with Visual Studio MSVC

2006-05-14 Thread Josh Berkus
Gurjeet,     I know it has been over a week now since I said that I'll put together a document that describes how to debug postgres using Eclipse IDE on Windows. I have finally completed the first draft and uploaded it here: Hey, are you a member of the Eclipse Project? Mike was bugging me

Re: [HACKERS] Fwd: [pgsql-hackers-win32] Build with Visual Studio MSVC

2006-05-14 Thread Gurjeet Singh
No I am not... I used Eclipse for the first time just last week. But yes, I wish to contribute to the CDT plugin. I think their Indexer is a bit slow... it takes more than an hour (about two hours) to index postgres' source code!!! Also, I just noticed that the background gdb crashes when