Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-15 Thread Kevin Brown
[EMAIL PROTECTED] wrote: > Kevin Brown wrote: > > Simply saying "MySQL has better marketing" isn't enough. It's too > > simple an answer and obscures some issues that should probably be > > addressed. > > I think it /is/ a significant factor, the point being that the MySQL company > has been qui

Re: [HACKERS] about table function

2002-12-15 Thread Joe Conway
Jinqiang Han wrote: > it seems the crosstab function you write in contrib/tablefunc can't work. > it saids that A column definition list is required for functions returning RECORD. > How can i make it work? >From contrib/tablefunc/README.tablefunc: Outputs Returns setof record, which must def

[HACKERS] about table function

2002-12-15 Thread Jinqiang Han
hello, Joe Conway. it seems the crosstab function you write in contrib/tablefunc can't work. it saids that A column definition list is required for functions returning RECORD. How can i make it work? thank you very much best regard, Jinqiang Han ---(end of broadcas

Re: [mail] Re: [HACKERS] Big 7.4 items - Replication

2002-12-15 Thread Jan Wieck
Darren Johnson wrote: > The group communication system doesn't just run on one system. For > postgres-r using spread The reason why group communication software is used is simply because this software is designed with two goals in mind: 1) optimize bandwidth usage 2) make many-to-many communic

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-15 Thread Greg Copeland
But it's something they should of already had to do. We're just paying late for old sins. ;) Greg On Thu, 2002-12-12 at 23:34, Bruce Momjian wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > OK, so what do we do with 7.3.1. Increment major or minor? > > > > Major

Re: [HACKERS] PageGetMaxOffsetNumber

2002-12-15 Thread Alvaro Herrera
On Sun, Dec 15, 2002 at 11:49:57PM -0300, Alvaro Herrera wrote: > I iterate over the elements of the parent page in a for loop, and the > upper bound is rarely reached because the item is found. However > sometimes the item isn't found, and PageGetItem fails its assertion > because the item isn't

[HACKERS] PageGetMaxOffsetNumber

2002-12-15 Thread Alvaro Herrera
Hello hackers, I wonder what the PageGetMaxOffsetNumber macro is supposed to do (in a btree index page)? The scenario is the following: I need to get the pointer to a btree page (leaf or internal) in its parent page, to call _bt_itemdel on it. The only thing I can think of is to use its parent l

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-15 Thread Christopher Kings-Lynne
> You can't sell into the "ISP appliance market" until there's something as > ubiquitous as "PHPMyAdmin" for PostgreSQL. And note that the "ISP appliance > market" only cares about this in a very indirect way. They don't actually use > the database; their /customers/ do. And their customers are

Re: [mail] Re: [HACKERS] Big 7.4 items - Replication

2002-12-15 Thread Al Sutton
Jonathan, Many thanks for clarifying the situation some more. With token passing, I have the following concerns; 1) What happends if a server holding the token should die whilst it is in posession of the token. 2) If I have n servers, and the time to pass the token between each server is x milli

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-15 Thread Jeroen T. Vermeulen
On Sun, Dec 15, 2002 at 11:21:07AM -0500, Tom Lane wrote: > > However, an app linked against libpq++ would also be linked against > libpq, and so the incompatibility will be flagged by the linker anyway. > I can see no need to bump libpq++'s own number. Plus, of course, libpq++ being a C++ librar

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-15 Thread cbbrowne
Kevin Brown wrote: > Devrim G?ND?Z wrote: > > I do NOT like hearing about MySQL in this (these) list(s). > > > > PostgreSQL is not in the same category with MySQL. MySQL is for > > *dummies*, not database admins. I do not even call it a database. I > > have never forgotten my data loss 2,5 years

Re: [mail] Re: [HACKERS] Big 7.4 items - Replication

2002-12-15 Thread Al Sutton
Jonathan, How do the group communication daemons on system A and B agree that T2 is after T1?, As I understand it the operation is performed locally before being passed on to the group for replication, when T2 arrives at system B, system B has no knowlege of T1 and so can perform T2 sucessfully.

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-15 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Bruce Momjian writes: >> Do I need to increment the other interfaces that >> _use_ libpq, like ecpg? > If and only if the libpq API is part of their documented API. For ecpg I > think this is not the case, but for libpq++ it would seem to be the case

Re: [HACKERS] Information schema now available

2002-12-15 Thread Peter Eisentraut
Hannu Krosing writes: > Could you also post it somewhere as a plain SQL script for 7.3 ? It depends on SQL features not present in 7.3. But you can download it from the CVS web interface and make the adjustments yourself if you want to use it. -- Peter Eisentraut [EMAIL PROTECTED]

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-15 Thread Peter Eisentraut
Bruce Momjian writes: > Do I need to increment the other interfaces that > _use_ libpq, like ecpg? If and only if the libpq API is part of their documented API. For ecpg I think this is not the case, but for libpq++ it would seem to be the case. -- Peter Eisentraut [EMAIL PROTECTED] --

Re: [MLIST] Re: [mail] Re: [HACKERS] Big 7.4 items - Replication

2002-12-15 Thread Al Sutton
David, This can be resolved by requiring that for any transaction to succeed the entrypoint database must receive acknowlegements from n/2 + 0.5 (rounded up to the nearest integer) databases where n is the total number in the replicant set. The following cases are shown as an example; Total Numbe

Re: [MLIST] Re: [mail] Re: [HACKERS] Big 7.4 items - Replication

2002-12-15 Thread David Walker
Another concern I have with multi-master systems is what happens if the network splits in 2 so that 2 master systems are taking commits for 2 separate sets of clients. It seems to me that to re-sync the 2 databases upon the network healing would be a very complex task or impossible task. On Su

Re: [mail] Re: [HACKERS] Big 7.4 items - Replication

2002-12-15 Thread Al Sutton
Many thanks for the explanation. Could you explain to me where the order or the writeset for the following scenario; If a tranasction takes 50ms to reach one database from another, for a specific data element (called X), the following timeline occurs at 0ms, T1(X) is written to system A. at 10ms,

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-15 Thread Kevin Brown
Bruce Momjian wrote: > > OK, I have updated the libpq major number in 7.3.X, and updated major > and minor in HEAD. Do I need to increment the other interfaces that > _use_ libpq, like ecpg? I think so. You'll only need to increment the major number of those other interfaces that are no longer b