Re: [HACKERS] Spinlock support for linux-hppa?

2004-01-02 Thread Oliver Elphick
On Thu, 2004-01-01 at 22:20, Tom Lane wrote: > > My object is to get 7.4.1 working on all the Debian architectures. > > I'd have been more willing to buy into that goal if you'd been working > on it during the 7.4 beta test cycle. I gather from what you are saying > that you couldn't, because Deb

Re: [HACKERS] PL/Java issues

2004-01-02 Thread Dave Cramer
Where is the standard, I for one would be interested in seeing it? Dave On Fri, 2004-01-02 at 01:09, Andrew Dunstan wrote: > Jan Wieck wrote: > > > The basic question is the definition of the lifetime of an object and > > it's identificaition when doing nested calls in this context. In the > >

Re: [HACKERS] PL/Java issues

2004-01-02 Thread Andrew Dunstan
Dave Cramer said: > Where is the standard, I for one would be interested in seeing it? > AFAIK it is not available except for $$$. It looks like the relevant standards are parts 1 and 2 of the SQLJ standard (Part 0 covers embedded SQL). cheers andrew ---(end of broadca

Re: [HACKERS] cache in plpgsql

2004-01-02 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Another little problem is that plpgsql doesn't really have any mechanism >> for invalidating cached stuff at all; it will leak memory like there's >> no tomorrow if we start dropping cached subplans. > Everyone seems to look at it as a PL/

Re: [HACKERS] cache in plpgsql

2004-01-02 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> No, of course not, but plpgsql has issues of its own that (IMHO) should >> be solved along with the SPI-level problem. > Not sure what you mean by that. I'm referring to the fact that plpgsql's internal data structures are all built with

Re: [HACKERS] cache in plpgsql

2004-01-02 Thread Jan Wieck
Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: Tom Lane wrote: Another little problem is that plpgsql doesn't really have any mechanism for invalidating cached stuff at all; it will leak memory like there's no tomorrow if we start dropping cached subplans. Everyone seems to look at it as a

Re: [HACKERS] cache in plpgsql

2004-01-02 Thread Jan Wieck
Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: But can you tell me how to actually check if a saved SPI plan references that particular catalog object or not? This is certainly doable in principle. recordDependencyOnExpr() contains much of the logic that would be needed -- it would need to

Re: Postgres + Xapian (was Re: [HACKERS] fulltext searching via a custom index type )

2004-01-02 Thread Alvaro Herrera
On Thu, Jan 01, 2004 at 11:19:07PM -0500, Eric B.Ridge wrote: > I couldn't think of a way to create a whole new database type for > Xapian that could deal with managing 5 btree indexes inside of Postgres > (other than using tables w/ standard postgres btree index on certain > fields), so instea

Re: [JDBC] [HACKERS] PL/Java issues

2004-01-02 Thread Jan Wieck
Dave Cramer wrote: Barry, Ok, so if we drop this limitation then we leave it up to the architect to manage the caching problem themselves. Maybe I don't understand enough about Java, but isn't this limitation (only static methods callable) exactly what avoids having to deal with the call->insta

Re: [HACKERS] PL/Java issues

2004-01-02 Thread Andrew Dunstan
Will we need to address this TODO item: . Add capability to create and call PROCEDURES before proceding to do PL/Java? It would add to the usefulness greatly, I should think. I'm not sure how hard it would be. cheers andrew ---(end of broadcast)-

Re: [HACKERS] PL/Java issues

2004-01-02 Thread Joe Conway
Andrew Dunstan wrote: AFAIK it is not available except for $$$. It looks like the relevant standards are parts 1 and 2 of the SQLJ standard (Part 0 covers embedded SQL). For working drafts try: http://www.wiscorp.com/sql/sql_2003_standard.zip (5WD-13-JRT-2003-09.pdf) http://www.wiscorp.com/sql/sql

Re: Postgres + Xapian (was Re: [HACKERS] fulltext searching via a

2004-01-02 Thread Christopher Kings-Lynne
I think one way of attacking the problem would be using the existing nbtree by allowing it to store the five btrees. First read the README in the nbtree dir, and then poke at the metapage's only structure. You will see that it has a BlockNumber to the root page of the index. Try modifying that t

Re: [HACKERS] time format

2004-01-02 Thread Christopher Kings-Lynne
Create table with type TIMESTAMP(0) Chris ivan wrote: how can i change default time format because now i have for example 2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out millisec. a tryed with Data-Style but there arent custom style :/ ---(end o