[GENERAL] books/sites for someone really learning PG's advanced features?

2004-09-24 Thread Miles Keaton
I'm switching to PostgreSQL from MySQL. Using the SAMs book called PostgreSQL which has been great to skim the surface of the differerences. I had never even heard of things like triggers, views, and foreign keys before. Any recommended books or websites (or exercises) that would really help

Re: [GENERAL] books/sites for someone really learning PG's advanced

2004-09-24 Thread Mike Mascari
Miles Keaton wrote: I'm switching to PostgreSQL from MySQL. Using the SAMs book called PostgreSQL which has been great to skim the surface of the differerences. I had never even heard of things like triggers, views, and foreign keys before. Any recommended books or websites (or exercises) that

Re: [GENERAL] Building plpython on Mac OSX...

2004-09-24 Thread Tom Lane
Jerry LeVan [EMAIL PROTECTED] writes: Have any configure experts looked at building plpython.so on mac os x lately? CVS tip builds it properly, with this just-applied patch: http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plpython/Makefile.diff?r1=1.13;r2=1.14 I am not sure if

[GENERAL] Returning a list of fields in a composite type

2004-09-24 Thread Robert Fitzpatrick
Is it possible to return the field names of a composite type using a function? Any examples or pointers? -- Robert ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [SQL] [GENERAL] need ``row number``

2004-09-24 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Karsten Hilbert [EMAIL PROTECTED] writes: I am not convinced I'll need a SRF. I am not trying to calculate something that isn't there yet. I am just trying to join two views appropriately. I might have to employ some variant of Celko's integer helper

Re: [GENERAL] Building plpython on Mac OSX...

2004-09-24 Thread Jerry LeVan
I was able to get it to build with the framework change and commenting out the shared library test on 7.4.5. The patch looks a bit cleaner... Jerry On Sep 24, 2004, at 4:14 PM, Tom Lane wrote: Jerry LeVan [EMAIL PROTECTED] writes: Have any configure experts looked at building plpython.so on mac os

Re: [SQL] [GENERAL] need ``row number``

2004-09-24 Thread Ian Harding
Right. Sequence within a group. I did this in a SRF resetting the sequence after each subgroup. I would love to see a better way. Greg Stark [EMAIL PROTECTED] 9/24 1:42p Tom Lane [EMAIL PROTECTED] writes: Karsten Hilbert [EMAIL PROTECTED] writes: I am not convinced I'll need a SRF. I

Re: [GENERAL] Large arrays give long lag on server side before command executes

2004-09-24 Thread Steve Crawford
On Friday 24 September 2004 7:32 am, Tom Lane wrote: David Helgason [EMAIL PROTECTED] writes: I'm calling one stored procedure with a prepared statement on the server with 6 arrays of around 1200 elements each as parameters. The parameters are around 220K in total. Exactly how are you

Re: [GENERAL] Large arrays give long lag on server side before command executes

2004-09-24 Thread Tom Lane
Steve Crawford [EMAIL PROTECTED] writes: On Friday 24 September 2004 7:32 am, Tom Lane wrote: I'm betting on some O(N^2) behavior in the array code, but it'll be difficult to pinpoint without profile results. Possibly the bug we discussed early last year (IIRC added to todo but not fixed):

[GENERAL] cvs update: waiting for anoncvs's lock

2004-09-24 Thread Michael Fuhr
For the last couple of hours I've been trying to update my 8.0.0betaX sources with cvs update but I keep getting the following: cvs update: Updating . cvs update: Updating ChangeLogs cvs update: Updating MIGRATION cvs update: Updating config cvs update: [01:47:17] waiting for anoncvs's lock in