[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

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

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 a

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

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 o

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 integ

[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 YourEmailAddress

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