Re: [HACKERS] statement logging / extended query protocol issues

On Mon, 2005-09-05 at 15:38 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > + /* > > + * If we re-issue an Execute protocol request against an existing > > + * portal, then we are only fetching more rows rather than > > + * completely re-executing the query

Re: [HACKERS] statement logging / extended query protocol issues

Simon Riggs wrote: Looking more closely, I don't think either is correct. Both can be reset according to rewind operations - see DoPortalRewind(). We'd need to add another bool onto the Portal status data structure. AFAIK this is only an issue with SCROLLABLE cursors, which v3 portals aren't

Re: [HACKERS] inet increment with int

On Mon, Sep 05, 2005 at 08:10:16PM +0100, Patrick Welche wrote: > On Mon, Sep 05, 2005 at 03:02:55PM -0400, Tom Lane wrote: > > Patrick Welche <[EMAIL PROTECTED]> writes: > > > * Allow INET + INT4 to increment the host part of the address, or > > > throw an error on overflow > > > > > I think th

[HACKERS] uuid type for postgres

--- Begin Message --- I have been in need of a uuid type and ran across the pguuid download by Xiongjian (Mike) Wang. This wasn't really useful to me for two reasons: first, it is GPLed and I would prefer a more liberal license, secondly, it didn't compile cleanly on Mac OS 10.3, due to lack of a

Re: [HACKERS] uuid type for postgres

Hey Nathan. I've started to make heavy use of pguuid. It had several bugs in it that required fixing before I could use it. I have no preference on pguuid. It was the only such PostgreSQL project I found that provided a UUID type. I'd be willing to work with you on ensuring that such a patch is i

Re: [HACKERS] How to add column in pg_class

Rafaqat Ali <[EMAIL PROTECTED]> writes: > Is there any other file in which I have to make change ? Fooling with any of the bootstrapped catalogs is pretty messy. You might grab this patch from the CVS server for comparison: 2005-03-29 14:44 tgl * doc/src/sgml/bki.sgml, doc/src

Re: [HACKERS] uuid type for postgres

[EMAIL PROTECTED] writes: > My personal preference is that the type be called 'uuid' and accepted > into the core. Tom? Is their history on this issue? > Should it remain an extension, or can be get it built-in? There is pretty much zero chance of being accepted into contrib, much less core, if th

Re: [HACKERS] dbt-4 (tpc-app) kit

On Fri, 2 Sep 2005 15:50:25 -0400 Dave Cramer <[EMAIL PROTECTED]> wrote: > > On 2-Sep-05, at 3:38 PM, Mark Wong wrote: > > > Hi Dave, > > > > Oops, EJB's are distasteful? My experience in this area is quite > > lacking. > Well, I said "personally" distasteful. > > Not that I necessarily want to

Re: [HACKERS] Simple tester for MVCC in PostgreSQL

On Tue, 2005-08-30 at 00:56 +0200, Martijn van Oosterhout wrote: > I saw the discussion about an tester for MVCC. Since I'd never done > anything with asyncronous queries before, I figured I'd try to write > something useful with it. The result is at: > > http://svana.org/kleptog/pgsql/mvcctest.ta

[HACKERS] Mysteriously lost values in nodes

[Please CC any replies, thanks] I added a field to each of Var, Const, FuncExpr and OpExpr which is set during parse_expr. But somewhere between the parsing and execution the values of these fields get reset back to NULL. But only for FuncExpr and OpExpr, for Var and Const it all works as expected

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 11:38:57AM -0400, [EMAIL PROTECTED] wrote: > > There is pretty much zero chance of being accepted into contrib, much > less core, if the code isn't pure BSD license. Hmm. Here is the copyright and license portion of the readme... COPYRIGHT AND LICENSE Copyright (c)

Re: [HACKERS] Simple tester for MVCC in PostgreSQL

On Tue, Sep 06, 2005 at 03:51:41PM +, Matt Miller wrote: > On Tue, 2005-08-30 at 00:56 +0200, Martijn van Oosterhout wrote: > > http://svana.org/kleptog/pgsql/mvcctest.tar.gz > > I've started using it in some simple cases and it seems to be a good > tool. The feature set looks to me to be a p

Re: [HACKERS] dbt-4 (tpc-app) kit

On 6-Sep-05, at 11:37 AM, Mark Wong wrote: On Fri, 2 Sep 2005 15:50:25 -0400 Dave Cramer <[EMAIL PROTECTED]> wrote: On 2-Sep-05, at 3:38 PM, Mark Wong wrote: Hi Dave, Oops, EJB's are distasteful? My experience in this area is quite lacking. Well, I said "personally" distasteful. No

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Tom Lane wrote: > Barring further changes, we'll have a hard-wired template list for > 8.1 and a real system catalog in 8.2. So there's a choice now for > PLs that are not part of the core distribution: do you want to be > listed in the hard-wired template? Is there any way to create the language

Re: [HACKERS] uuid type for postgres

Mark, > I suggest that UUID be recommended in place of SERIAL for certain > classes of applications, and that it therefore belongs in the core. > UUID and SERIAL can be used together (although, once you have a UUID, > it may not be useful to also have a SERIAL). I think that, if you want to push

Re: [HACKERS] 4D Geometry

Chris Traylor wrote: > > Configure options are generally a pain in the neck, > > Granted. Especially, if all the ifdefs start making the source hard > to read, but they are a viable compile-time way to allow the user to > make the decision for themselves. This missing piece of information here is

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Peter Eisentraut <[EMAIL PROTECTED]> writes: > Is there any way to create the language and not use the template (an > override option of some kind)? There is deliberately not a way to override (other than using a different name for the PL). One of the points of this facility is to fix up broken

Re: [HACKERS] Mysteriously lost values in nodes

On Tue, Sep 06, 2005 at 06:06:49PM +0200, Martijn van Oosterhout wrote: > [Please CC any replies, thanks] > > I added a field to each of Var, Const, FuncExpr and OpExpr which is set > during parse_expr. But somewhere between the parsing and execution the > values of these fields get reset back to

Re: [HACKERS] Attention PL authors: want to be listed in template

Tom Lane wrote: For instance, if you think you might want a validator later, you can set up a no-op validator procedure today, and then the template doesn't need to change when you make the validator do something. Similarly, you could future-proof yourself against adding a trusted (or untruste

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Andrew Dunstan wrote: > Anyway, clearly there are cases where a validator make no sense or > very little sense (pl/sh and pl/{j,java} spring to mind). PL/sh has a validator. :-) -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)---

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Tom Lane wrote: > There is deliberately not a way to override (other than using a > different name for the PL). One of the points of this facility is to > fix up broken PL definitions being imported from old dump files, so > believing what the CREATE LANGUAGE command says is exactly what we > don'

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Peter Eisentraut <[EMAIL PROTECTED]> writes: > I don't doubt that, but I just have a stomach ache with this entire > notion of having a hard-coded exception list of the sort "if the user > requires this, do this instead". I don't see it as an exception list. The direction I see for this is that

Re: [HACKERS] Attention PL authors: want to be listed in template

Peter Eisentraut wrote: Andrew Dunstan wrote: Anyway, clearly there are cases where a validator make no sense or very little sense (pl/sh and pl/{j,java} spring to mind). PL/sh has a validator. :-) Really? Curious. I must look more closely. cheers andrew ---

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Tom Lane wrote: > I don't see it as an exception list. The direction I see for this is > that the parameters to CREATE LANGUAGE are obsolete and will > eventually be removed altogether, with "CREATE LANGUAGE foo" using an > existing template as the only recommended way to do it. So your proposal

Re: [HACKERS] Mysteriously lost values in nodes

Martijn van Oosterhout writes: > grep reveals several places where new nodes are created but rather than > just changing them all, is there a particular phase where these changes > are made that I should be looking at? Grepping for "makeNode(OpExpr)" might help you. Offhand I'd finger eval_const

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Peter Eisentraut <[EMAIL PROTECTED]> writes: > So your proposal is to enable a new language by doing: > 1. register a template > 2. activate template using CREATE LANGUAGE (which would copy it to > pg_language) That's the long-term idea, yes. > How is this different from > 1. register language

Re: [HACKERS] Mysteriously lost values in nodes

On Tue, Sep 06, 2005 at 01:51:25PM -0400, Tom Lane wrote: > Grepping for "makeNode(OpExpr)" might help you. Offhand I'd finger > eval_const_expressions as the likely culprit. clauses.c has some other > code you'd better look at too. Yeah, eval_const_expressions was the culprit in this case, thou

[HACKERS] purge hash table, how to?

i am using postgresql 8.0.3 as a single user by running "postgres" I want to purge all contents in the bufferpool, and I did this by calling "InitBufTable(256)" (buf_table.c) after each query. However, this seems not working for each followup query I still get less disk read (tracked by "smgrread

Re: [HACKERS] Simple tester for MVCC in PostgreSQL

On Tue, Sep 06, 2005 at 06:21:11PM +0200, Martijn van Oosterhout wrote: > On Tue, Sep 06, 2005 at 03:51:41PM +, Matt Miller wrote: > > On Tue, 2005-08-30 at 00:56 +0200, Martijn van Oosterhout wrote: > > > http://svana.org/kleptog/pgsql/mvcctest.tar.gz > > > > I've started using it in some sim

Re: [HACKERS] Call for 7.5 feature completion

FWIW, I think a lot of people didn't "me too" on all the features they want, so I wouldn't put too much weight on the ranking here... On Mon, Sep 05, 2005 at 05:43:16PM +0200, Peter Eisentraut wrote: > Am Freitag, 26. August 2005 01:13 schrieb Alvaro Herrera: > > Or, slightly different, what are p

[HACKERS] count(*) optimization

not sure where to put this. I run two queries: 1. select count(*) from table where indexed_column<10; 2. select * from table where indexed_column<10; the indexed column is not clustered at all. I saw from the trace that both query runs through index scans on that index and takes the same amoun

Re: [HACKERS] count(*) optimization

huaxin... I'll save you the time... see the topic "MUCH ADO ABOUT COUNT(*)" and "ADVANCED INDEX USAGE". On 9/6/05, huaxin zhang <[EMAIL PROTECTED]> wrote: not sure where to put this.I run two queries:1. select count(*) from table where indexed_column<10;2. select * from table where indexed_column<1

Re: [HACKERS] count(*) optimization

On Tue, Sep 06, 2005 at 15:21:16 -0400, huaxin zhang <[EMAIL PROTECTED]> wrote: > not sure where to put this. > > I run two queries: > > 1. select count(*) from table where indexed_column<10; > 2. select * from table where indexed_column<10; > > the indexed column is not clustered at all. I

[HACKERS] need info about extensibility in other databases

Hi there, after we have GiST with concurrency and recovery support (thanks to PosGIS community for support) I'd trying to find info about level of extensibility support in other major RDBMS's like Relational Extenders of DB2, Cartridges in Oracle and (?) in MS SQL. With current GiST one coul

Re: [HACKERS] uuid type for postgres

I agree with Josh on the UUID type, it gets abused far too often and (IMHO) isn't widely enough used to belong in the core.  Couldn't you just fix the problem in pguuid rather than write a whole new type?On 9/6/05, Josh Berkus wrote: Mark,> I suggest that UUID be recommended in

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 03:57:55PM -0400, [EMAIL PROTECTED] wrote: > I agree with Josh on the UUID type, it gets abused far too often Out of curiosity, how does it get abused? It doesn't seem to me that it would be any more prone to abuse than any other type. > and (IMHO) isn't widely enough use

[HACKERS] PITR on different hardware

I didn't see anything mentioned in the docs about this, so I'm curious as to how significant of a change you can make to the hardware or software configuration for a restore before breaking things. Secondly, is PostgreSQL smart enough to complain in these cases or will it be silent and cause unexp

Re: [HACKERS] uuid type for postgres

On Sep 6, 2005, at 12:57 PM, Jonah H. Harris wrote:On 9/6/05, Josh Berkus wrote: Mark,> I suggest that UUID be recommended in place of SERIAL for certain> classes of applications, and that it therefore belongs in the core.> UUID and SERIAL can be used together (although, once yo

Re: [HACKERS] uuid type for postgres

The only time I've seen someone use UUIDs in PostgreSQL is when they were converting from SQL Server.  I've seen many bad data models using UUID that could've/should've used normal sequences for portability. I look forward to seeing you're code. Thanks! On 9/6/05, nathan wagner <[EMAIL PROTECTED]

Re: [HACKERS] purge hash table, how to?

huaxin zhang <[EMAIL PROTECTED]> writes: > I want to purge all contents in the bufferpool, Why do you think that's a good idea? It certainly won't purge the kernel's disk caches, so if you're hoping to restore the system to ground zero this won't do it. > and I did this by > calling "InitBufTabl

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 03:57:55PM -0400, Jonah H. Harris wrote: > I agree with Josh on the UUID type, it gets abused far too often and (IMHO) > isn't widely enough used to belong in the core. There is much in PostgreSQL from my perspective that falls under the category of 'most advanced open sou

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 09:16:13PM +, nathan wagner wrote: > On Tue, Sep 06, 2005 at 03:57:55PM -0400, [EMAIL PROTECTED] wrote: > > I agree with Josh on the UUID type, it gets abused far too often > > Out of curiosity, how does it get abused? It doesn't seem to me > that it would be any more

Re: [HACKERS] PITR on different hardware

Rod Taylor <[EMAIL PROTECTED]> writes: > Secondly, is PostgreSQL smart enough to complain in these cases or will > it be silent and cause unexpected data corruption later on? It will catch anything that affects the contents or layout of pg_control, which includes a fair amount of stuff (endianness

Re: [HACKERS] count(*) optimization

[EMAIL PROTECTED] (huaxin zhang) writes: > not sure where to put this. > > I run two queries: > > 1. select count(*) from table where indexed_column<10; > 2. select * from table where indexed_column<10; > > the indexed column is not clustered at all. I saw from the trace > that both query runs th

Re: [HACKERS] need info about extensibility in other databases

On Tue, Sep 06, 2005 at 11:52:18PM +0400, Oleg Bartunov wrote: > btw, "GiST programming tutorial" is available in Russian, > http://www.sai.msu.su/~megera/postgres/talks/gist_tutorial.html Cool. Is an English version in the works? -- Michael Fuhr ---(end of broadcast)--

Re: [HACKERS] Remove xmin and cmin from frozen tuples

On Fri, Sep 02, 2005 at 03:51:15PM -0400, Bruce Momjian wrote: > One possible solution is to create a phantom cid which represents a > cmin/cmax pair and is stored in local memory. If we're going to look at doing that I think it would also be good to consider including xmin and xma

Re: [HACKERS] uuid type for postgres

On Sep 6, 2005, at 2:16 PM, nathan wagner wrote: On Tue, Sep 06, 2005 at 03:57:55PM -0400, [EMAIL PROTECTED] wrote: I agree with Josh on the UUID type, it gets abused far too often Out of curiosity, how does it get abused? It doesn't seem to me that it would be any more prone to abuse t

Re: [HACKERS] PITR on different hardware

On Tue, 2005-09-06 at 16:53 -0400, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > Secondly, is PostgreSQL smart enough to complain in these cases or will > > it be silent and cause unexpected data corruption later on? > > It will catch anything that affects the contents or layout of

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 01:49:28PM -0700, David Fetter wrote: > On Tue, Sep 06, 2005 at 09:16:13PM +, nathan wagner wrote: > > On Tue, Sep 06, 2005 at 03:57:55PM -0400, [EMAIL PROTECTED] wrote: > > > I agree with Josh on the UUID type, it gets abused far too often > > Out of curiosity, how does

Re: [HACKERS] Remove xmin and cmin from frozen tuples

On Tue, Sep 06, 2005 at 03:58:28PM -0500, Jim C. Nasby wrote: > On Fri, Sep 02, 2005 at 03:51:15PM -0400, Bruce Momjian wrote: > > One possible solution is to create a phantom cid which represents a > > cmin/cmax pair and is stored in local memory. > > If we're going to look at doing t

Re: [HACKERS] uuid type for postgres

[EMAIL PROTECTED] writes: > In my choice of use, I'm using them instead of SERIAL columns, as I > wish to have more freedom merging production data with test data. I > wish to continually import production data into my test environment, > in a single direction. UUID will prevent conflicts from o

Re: [HACKERS] uuid type for postgres

[EMAIL PROTECTED] writes: > Personally, I'm not sure what the big opposition to UUID is all about. I don't see any "big opposition". People are simply questioning the idea whether it belongs in core PG. The reason we don't want to accept everything-and-the-kitchen-sink in core is that we have on

Re: [HACKERS] Remove xmin and cmin from frozen tuples

On Tue, Sep 06, 2005 at 05:37:06PM -0400, Alvaro Herrera wrote: > On Tue, Sep 06, 2005 at 03:58:28PM -0500, Jim C. Nasby wrote: > > On Fri, Sep 02, 2005 at 03:51:15PM -0400, Bruce Momjian wrote: > > > One possible solution is to create a phantom cid which represents a > > > cmin/cmax pair a

Re: [HACKERS] Remove xmin and cmin from frozen tuples

"Jim C. Nasby" <[EMAIL PROTECTED]> writes: >>> If we're going to look at doing that I think it would also be good to >>> consider including xmin and xmax as well. >> >> If you do that, you'll never be able to delete or update the tuple. > My idea was to use an int to represent combinations of (c|

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 05:31:43PM -0400, Greg Stark wrote: > Just do something like this for every sequence: > ALTER SEQUENCE foo INCREMENT BY 100 > And then choose a particular initial value for each server. *shudder* But you are right. That would work. :-) (I shudder from the maintenance he

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 05:54:34PM -0400, Tom Lane wrote: > I don't see any "big opposition". People are simply questioning the > idea whether it belongs in core PG. The reason we don't want to accept > everything-and-the-kitchen-sink in core is that we have only limited > manpower to maintain it

Re: [HACKERS] uuid type for postgres

As promised a link to the code. http://granicus.if.org/~nw/ossp_pg_uuid-0.1.tar.gz You'll also need Ralf Engelschall's uuid library, which mine is a postgres interface to. It's available at ftp://ftp.ossp.org/pkg/lib/uuid/uuid-1.3.0.tar.gz It probably has a few warts. I'm mainly posting it fo

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 05:54:34PM -0400, [EMAIL PROTECTED] wrote: > One thing that is raising my own level of concern quite a bit is the > apparent portability issues. I can't speak to the portability in general, but there is a PORTING file in the ossp uuid library that states OSSP uuid was al

Re: [HACKERS] Remove xmin and cmin from frozen tuples

On Tue, Sep 06, 2005 at 06:02:27PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > >>> If we're going to look at doing that I think it would also be good to > >>> consider including xmin and xmax as well. > >> > >> If you do that, you'll never be able to delete or update the

Re: [HACKERS] Remove xmin and cmin from frozen tuples

"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > If the 4 header fields in question were just normalized out, wouldn't > all the semantics continue to work the same? All I'm envisioning is > replacing them in each tuple with a pointer (vis_id) to another > datastore that would be roughly equivalent to:

Re: [HACKERS] uuid type for postgres

On Sep 6, 2005, at 3:06 PM, [EMAIL PROTECTED] wrote: On Tue, Sep 06, 2005 at 05:54:34PM -0400, Tom Lane wrote: I don't see any "big opposition". People are simply questioning the idea whether it belongs in core PG. The reason we don't want to accept everything-and-the-kitchen-sink in cor

Re: [HACKERS] uuid type for postgres

Tom, you worded my thoughts much better than I did. Bob, I too had heard that host-based UUIDs/GUIDs had issues with uniqueness.  I think Microsoft's implementation was hosed and they ended up eliminating using the MAC completely. I'll check out the code & get back. On 9/6/05, Bob Ippolito <[EMAI

Re: [HACKERS] uuid type for postgres

[EMAIL PROTECTED] writes: > Eventually, SERIAL wraps around. So you switch to SERIAL8. At the point that > you have SERIAL8, you aren't worried terribly about disk space, and you > realize there is usually no benefit at all to the numbers being ordered so > closely. a) Except for trivially small

Re: [HACKERS] [ADMIN] How to determine date / time of last postmaster restart

adey <[EMAIL PROTECTED]> writes: > Please let me know if there is a way to determine when the Postmaster was > last restarted? The last postmaster start time, or the last database reset? These are not the same if any backends have crashed since the postmaster started. For determining stats lifesp

Re: [HACKERS] uuid type for postgres

Bob, People, Let me clarify my stance here, because it seems to be getting misrepresented. Mark (and Nathan) pushed at repaired UUID type for possible inclusion in the core PostgreSQL distribution. I'm not opposed to that, provided that the portability, licensing, and bugs are worked out. Wh

Re: [HACKERS] uuid type for postgres

On Sep 6, 2005, at 6:02 PM, Josh Berkus wrote: Bob, People, Let me clarify my stance here, because it seems to be getting misrepresented. Mark (and Nathan) pushed at repaired UUID type for possible inclusion in the core PostgreSQL distribution. I'm not opposed to that, provided that the

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 06:02:50PM -0700, Josh Berkus wrote: > However, Mark went on to suggest that we should recommend UUID over SERIAL > in the docs, and that we could consider dropping SERIAL entirely in favor > of UUID: > ---quoth Mark-- > I suggest that UUID be recommended i

Re: [HACKERS] uuid type for postgres

Mark, > I agree. Although I lost it on the "cannot be normalized". I'm assuming > there are designs you have seen much worse than the ones I have seen. > :-) Mostly it's the problem of tables that don't have a real key, only a surrogate key. How do you know what's a duplicate? > > For my part,

Re: [HACKERS] uuid type for postgres

> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-hackers- > [EMAIL PROTECTED] On Behalf Of Josh Berkus > Sent: Tuesday, September 06, 2005 6:40 PM > To: [EMAIL PROTECTED] > Cc: Bob Ippolito; [EMAIL PROTECTED]; pgsql-hackers@postgresql.org; > nathan wagner > Subject: Re: [HACKERS

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 06:40:27PM -0700, josh@agliodbs.com wrote: > Sure. What's a UUID, after all? It's three pieces of information: > 1) A server or database instance identifier > 2) A table identifier > 3) A row identifier > > e.g.: > chayote.sf.agliodbs.com | public.customers | 4271 > >

Re: [HACKERS] inet increment with int

On 2005-09-06, Patrick Welche <[EMAIL PROTECTED]> wrote: > Now with: > > test=# select '192.168.0.0/24'::inet + 1; > ERROR: Trying to increment a network (192.168.0.0/24) rather than a host What possible justification is there for this behaviour? > test=# select '192.168.0.1/24'::inet + -1; > ER

Re: [HACKERS] 4D Geometry

Peter Eisentraut wrote: Chris Traylor wrote: Configure options are generally a pain in the neck, Granted. Especially, if all the ifdefs start making the source hard to read, but they are a viable compile-time way to allow the user to make the decision for themselves. This missing piece of

Re: [HACKERS] uuid type for postgres

Just an FYI: We also ended up rolling our own uuid type, against libuuid. It seems that uuid is a widespread enough concept that implementors *will* be asked to support it, moderately often. We *could* roll our own (were capable), others are not so lucky, and would have to point out the

Re: [HACKERS] uuid type for postgres

Paul Ramsey <[EMAIL PROTECTED]> writes: > I am not sure if I heard clearly from the core team that a self- > contained, BSD-licensed uuid would be accepted(able)? I don't think any of the other core members weighed in on this thread, so speaking strictly for myself: BSD license is an issue, and p

Re: [HACKERS] need info about extensibility in other databases

On Tue, 6 Sep 2005, Michael Fuhr wrote: On Tue, Sep 06, 2005 at 11:52:18PM +0400, Oleg Bartunov wrote: btw, "GiST programming tutorial" is available in Russian, http://www.sai.msu.su/~megera/postgres/talks/gist_tutorial.html Cool. Is an English version in the works? I was optimistic when

Re: [HACKERS] uuid type for postgres

On Tue, Sep 06, 2005 at 08:40:08PM -0700, [EMAIL PROTECTED] wrote: > - linking against libuuid is fine for a contrib/ extension, but no > good for a built-in type. A real uuid would have to do a proper > independent implementation of uuid creation within pgsql. Why? I'm not sure what the d

Re: [HACKERS] Remove xmin and cmin from frozen tuples

On Tue, Sep 06, 2005 at 07:02:20PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > If the 4 header fields in question were just normalized out, wouldn't > > all the semantics continue to work the same? All I'm envisioning is > > replacing them in each tuple with a pointer (v

Re: [HACKERS] Attention PL authors: want to be listed in template table?

Tom, I assume that the path of the shared library will be somehow relative to the GUC dynamic_library_path? If not, the lanlibrary should be changed to "$libdir/libpljava". That requires that PL/Java is installed within the PostgreSQL distribution. I also assume that the handler name can be p

Re: [HACKERS] [ADMIN] How to determine date / time of last postmaster restart

On Tue, Sep 06, 2005 at 08:22:34PM -0400, Tom Lane wrote: > PG 8.1 will have a function to return postmaster start time, but not > database reset time. I wonder if this is misdefined --- if you are > trying to measure database uptime, the last reset would be more > appropriate to track. Is it too