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

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

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

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

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: [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 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: [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] [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 ago; when

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++ library

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

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 likely to

[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

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] 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

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

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. I

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

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 quite activist