[HACKERS] ANNOUNCEMENT: Availability of TelegraphCQ v0.2 (BETA release)

2003-07-16 Thread Sailesh Krishnamurthy

ANNOUNCEMENT: Availability of TelegraphCQ v0.2 (BETA release)
-

The Telegraph Team at UC Berkeley is pleased to announce the immediate
availability of TelegraphCQ v0.2 (a BETA release). TelegraphCQ is a
system for processing long-running continuous queries over data
streams. TelegraphCQ is implemented as a significant modification to
the PostgreSQL open-source database system. Specifically, TelegraphCQ
v0.2 is based on the PostregreSQL 7.3.2 code-base.

For more information on the Telegraph project please visit:

   http://telegraph.cs.berkeley.edu

To download TelegraphCQ and for more information, please visit:

   http://telegraph.cs.berkeley.edu/telegraphcq

Here is the README.TelegraphCQ from the source distribution:

--
This file contains information on TelegraphCQ 0.2 (a Beta releae). 

What's new (since TelegraphCQ 0.1)
-

- Better stability: Lots of bugs have been squashed

- CSV Wrapper: An easy to use wrapper that accepts simple comma
separated text as input and supports all PostgreSQL and user-defined
types. There is now no need to write C code to develop a new wrapper
if your data source produces textual data.

- Pull Wrappers: If you want to pull (lookup) data from external
sources (such as web pages) based on query predicates, you can use the
new infrastructure for the Pull Wrapper.

- Introspective Query Processing: The dynamic catalog is a new feature
in TelegraphCQ. It lets users query three special purpose internal
data streams to get a continuous view of how the TelegraphCQ system is
behaving.

- Applications: Included with this distribution are a few applications
that we demonstrated at the ACM FCRC/SIGMOD 2003 Conference in San
Diego. We have integrated data from CalTrans (California Department of
Transportation), CHP (California Highway Patrol) and a local network
interface (using the tcpdump utility). We have also included graphical
visualizers that run some interesting queries over data streams from
these sources.

Request
---

If you are using TelegraphCQ for any project (research or otherwise),
we'd like to know ! 

  - If you are making any performance measurements of TelegraphCQ and
  are publishing it or disseminating it in some way, please do let us
  know.

  - We welcome bug fixes and code contributions of any kind. Please
  send all patches to [EMAIL PROTECTED]

Caveat Emptor
-

The current version of TelegraphCQ (0.2) is still a Beta release and
is very much research code. We haven't optimized it for
performance. Also, you will need to create a fresh database to use it
as it will not work against an existing PostgreSQL database. You are
free to use pgdump to export and then import your data from an
existing PostgreSQL database. 

- Archived streams: Note that although TelegraphCQ 0.2 supports
archived streams, we currently do not support access of historical
data. This will be fixed in our next release. 

For more information


Getting Started: 
  
  A TelegraphCQ Getting Started guide can be found in
  docs/TelegraphCQ/gettingstarted.html

  The Getting Started guide also has links to other information such
  as DDL/DML syntax, examples etc. Note that the documentation
  installed in your TelegraphCQ installation directory contains
  documentation for the new syntax changes (CREATE/ALTER/DROP STREAM,
  the WINDOW clause in DML) integrated into the existing PostgreSQL
  documentation.

The Telegraph Project:

  http://telegraph.cs.berkeley.edu

Supported Platforms
---

TelegraphCQ is supported on Linux x86 (various distributions including
Red Hat Linux 8,9 and Debian) and MacOS X 10.2, the platforms on which
it was developed. In addition, it has been minimally tested on the
SPARC Solaris platform. 

In general, TelegraphCQ should run anywhere PostgreSQL runs. However,
there are significant differences in how we use shared memory and
synchronization primitives such as semaphores. This is likely to cause
some hiccups on platforms where we have not tested it yet. We welcome
patches that help in porting TelegraphCQ. 


Please send all comments (and patches) to [EMAIL PROTECTED]

--




-- 
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] postmaster startup failure

2003-07-16 Thread Tom Lane
Hannu Krosing <[EMAIL PROTECTED]> writes:
> WHen running PostgreSQL 7.3.3-1 (from rpm's) on Redhat 9.0 I got the
> following in logs and the postmaster will not start up.
> PANIC:  XLogWrite: write request 0/30504000 is past end of log
> 0/30504000

This looks like you've stumbled across some sort of boundary-condition
bug in xlog.c.  It must be a pretty low-probability situation since
we've not seen it before.

How large is the database in question --- would it be feasible to send
it to me (as a tar of the whole $PGDATA directory) for examination?

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [HACKERS] perm question

2003-07-16 Thread ivan

nay be not all, but only select from same function.
Is there sht like umask 

On Wed, 16 Jul 2003, Tom Lane wrote:

> ivan <[EMAIL PROTECTED]> writes:
> > In my project i need close everything even most of pg_catalog.
> > User shoudl exec only special func. and not more. He know which they are.
>
> It sounds to me like you shouldn't be allowing your users to execute SQL
> commands directly at all.
>
>   regards, tom lane
>

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [HACKERS] perm question

2003-07-16 Thread Tom Lane
ivan <[EMAIL PROTECTED]> writes:
> In my project i need close everything even most of pg_catalog.
> User shoudl exec only special func. and not more. He know which they are.

It sounds to me like you shouldn't be allowing your users to execute SQL
commands directly at all.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[HACKERS] postmaster startup failure

2003-07-16 Thread Hannu Krosing
WHen running PostgreSQL 7.3.3-1 (from rpm's) on Redhat 9.0 I got the
following in logs and the postmaster will not start up.

Any Ideas what I could do to start up ?

This in on a laptop used for development, but I still would like to not
initdb.


postmaster successfully started
LOG:  database system shutdown was interrupted at 2003-07-17 00:42:29
EEST
LOG:  checkpoint record is at 0/304E76A8
LOG:  redo record is at 0/304E76A8; undo record is at 0/0; shutdown
FALSE
LOG:  next transaction id: 3981836; next oid: 4003572
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  redo starts at 0/304E76E8
LOG:  ReadRecord: unexpected pageaddr 0/2C504000 in log file 0, segment
48, offset 5259264
LOG:  redo done at 0/30503FDC
PANIC:  XLogWrite: write request 0/30504000 is past end of log
0/30504000
LOG:  startup process (pid 2445) was terminated by signal 6
LOG:  aborting startup due to startup process failure

-'
Hannu


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [HACKERS] Archives

2003-07-16 Thread Alvaro Herrera
On Wed, Jul 16, 2003 at 03:35:51PM -0500, Larry Rosenman wrote:

> --On Wednesday, July 16, 2003 16:31:24 -0400 Alvaro Herrera 
> <[EMAIL PROTECTED]> wrote:
> 
> >On Wed, Jul 16, 2003 at 01:57:41PM -0500, Thomas Swan wrote:
> >>Does anyone have recent archives of the pgsql-hackers list in mbx or
> >>flat file format?
> >
> >I really miss this too.  I searched the entire site, including
> >Majordomo's web interface, and there is no way to get the mbox archives.
> >It seems the only way to get'em is buying them from Pgsql Inc.

> I sent Thomas my July, 2003 MBX file.

Actually I wanted everything from 2001 on general, hackers, patches and
committers...  I know I'd rather not receive all that via email; mbox
files in archives.postgresql.org just like almost every other list would
have been perfect for me.

OTOH I already did all the searching I needed via www interface...
_very_ cumbersome and I wasted several precious hours, but it worked.

Thank you anyway.

-- 
Alvaro Herrera ()
"Investigación es lo que hago cuando no sé lo que estoy haciendo"
(Wernher von Braun)

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [HACKERS] Patches List

2003-07-16 Thread Larry Rosenman
Yes I am subscribed.

I also sent it to you directly seeing as if it was slow.

LER

--On Wednesday, July 16, 2003 17:16:55 -0400 Tom Lane <[EMAIL PROTECTED]> 
wrote:

Larry Rosenman <[EMAIL PROTECTED]> writes:
Is the patches list working?
I saw something come through yesterday from Rod.

I submitted on yesterday that never made it.
Are you subscribed?  With Marc out of town this week, anything held for
moderator approval won't see the light of day before Monday or so...
			regards, tom lane


--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [HACKERS] Patches List

2003-07-16 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes:
> Is the patches list working?

I saw something come through yesterday from Rod.

> I submitted on yesterday that never made it.

Are you subscribed?  With Marc out of town this week, anything held for
moderator approval won't see the light of day before Monday or so...

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [HACKERS] perm question

2003-07-16 Thread ivan


> > and how disallow : LISTEN , SET , RESET , and SHOW ?
>
> Explain why we should?
>
When you want to LISTEN sth pg insert rec into pg_listens (?) or somewhere
there, so why someone could rubish my db ?

In my project i need close everything even most of pg_catalog.
User shoudl exec only special func. and not more. He know which they are.

will be very wlee (i think ) to div pg_catalog to more part, like types
(with in/out/cast function) , pg tables , and rest of funcs ...

(and why pg use "namespace" and "schema" ?? why we need this 2 words ?)

btw . i have one more question :
 i have a lot of namepsace , and i dont use all of them i one time,
 so when i need one i just SET search_path TO need_namespace;
 When i use it in plpgsql its working without problesm , for ei :
 create table other_nsp.table (i int);
 create functino _ble() returns boolean as '
 begin
  set search_path other_nsp;
  delete from table;
 end ; ..
 its working good
 but when i want to use SQL lang there is a error , that my table isnt
exists.
 ie :
 create ..  as '
 set search_path other_nsp;
 delete from table ; -- and there is error , but why i one line above
 -- replaced search_path ??

i tryed it witj transaction block , but it was this same result

thx :>
 bye , ivan

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [HACKERS] Archives

2003-07-16 Thread Larry Rosenman


--On Wednesday, July 16, 2003 16:31:24 -0400 Alvaro Herrera 
<[EMAIL PROTECTED]> wrote:

On Wed, Jul 16, 2003 at 01:57:41PM -0500, Thomas Swan wrote:
Does anyone have recent archives of the pgsql-hackers list in mbx or
flat file format?
I know that I can search through the website or through other
interfaces, but I would like to be able to download a file containing
the posts for a period of time.
I really miss this too.  I searched the entire site, including
Majordomo's web interface, and there is no way to get the mbox archives.
It seems the only way to get'em is buying them from Pgsql Inc.
I sent Thomas my July, 2003 MBX file.

LER



--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] Archives

2003-07-16 Thread Alvaro Herrera
On Wed, Jul 16, 2003 at 01:57:41PM -0500, Thomas Swan wrote:
> Does anyone have recent archives of the pgsql-hackers list in mbx or 
> flat file format? 
> 
> I know that I can search through the website or through other 
> interfaces, but I would like to be able to download a file containing 
> the posts for a period of time.  

I really miss this too.  I searched the entire site, including
Majordomo's web interface, and there is no way to get the mbox archives.
It seems the only way to get'em is buying them from Pgsql Inc.

-- 
Alvaro Herrera ()
"La espina, desde que nace, ya pincha" (Proverbio africano)

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[HACKERS] identifying rows in table.

2003-07-16 Thread Jenny -
hi,
what fields in LOCK datastructures can i use to uniquely identify each row of a table? if each row is seperately locked that is.
thanks
jennyAdd photos to your e-mail with MSN 8. Get 2 months FREE*.


[HACKERS] SHMSEG definition

2003-07-16 Thread Michael Brusser
Can somebody clarify for me the requirement for the SHMSEG kernel parameter,
please.

The Postgres doc says:

SHMSEG - Maximum number of shared memory segments per process
 only 1 segment is needed, but the default is much higher

I was trying to calculate the kernel parameters for running a number
of Postgres servers on Solaris, and something did not work.

Having Postgres running I executed ipcs. It shows that while Postgres is
taking
only one segment, the number of attachments is 7. This I think refers to the
number
of processes spawned by postmaster at that time.

Solaris docs describe SHMSEG as
   "Limit on the number of shared memory segments
that any one process can create"

Now run this:
sysdef | grep SHMSEG
->   50  max attached shm segments per process (SHMSEG)

I suppose there's a distinction between "can create" and "can attach to".
Looks like the manual and output of sysdef are not very consistent.

I am worried that maybe (on Solaris) SHMSEG should be set with respect
to number of connections, rather than number of servers.

Thank you,
Mike.



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


[HACKERS] Archives

2003-07-16 Thread Thomas Swan
Does anyone have recent archives of the pgsql-hackers list in mbx or 
flat file format? 

I know that I can search through the website or through other 
interfaces, but I would like to be able to download a file containing 
the posts for a period of time.  

I'm missing a large portion of the recent 2 weeks due a errant mail filter.

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly


[HACKERS] RFP announcement

2003-07-16 Thread Richard Schilling
A few weeks ago I posted a message on this board requesting interest 
from anyone who would be willing to participate in a Request For 
Proposal (RFP) to provide software development and project management 
for Washington State.  I am happy to announce that we have several 
dozen participants at present.  Everyone who has responded has been 
added to the list of participants, and will now be reviewing the actual 
RFP.

If you have not gotten any e-mails regarding this project, but wanted 
to be on the distribution list, please inform me immediately and we'll 
get you added.

I'm very excited about the possibility of working with this community 
on such a project.

Please contact me if you have any questions.

Richard Schilling
Proprietor
National Informatics Company


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] backend/parser compile prob

2003-07-16 Thread Patrick Welche
On Wed, Jul 16, 2003 at 11:58:01PM +0900, [EMAIL PROTECTED] wrote:
>   could you try lex/scan.l 1.13 i just committed?

Yes, that fixed it!

Cheers,

Patrick

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [HACKERS] FROM clause omitted

2003-07-16 Thread Bruno Wolff III
On Wed, Jul 16, 2003 at 08:29:01 +0200,
  Dennis Björklund <[EMAIL PROTECTED]> wrote:
> I had a bug in one of my queries that wasn't detected by pg because if 
> filled in the from clause by itself. Take for example a querie like

Currently this is the only way to use additional tables when doing a delete.

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[HACKERS] Patches List

2003-07-16 Thread Larry Rosenman
Is the patches list working?

I submitted on yesterday that never made it.

LER

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] Hyperthreading or not?

2003-07-16 Thread Shridhar Daithankar
On 16 Jul 2003 at 9:07, scott.marlowe wrote:
> > PS: Is really faster postgresql compiled with Intel compiler ?
> 
> Note that since most people use gcc, any problems caused by the Intel 
> compiler might take more time to get fixed.

Last I heard was that gcc was pretty neck to neck with intel compiler with gcc 
3.2.2 or later. Besides intel compiler yield performance gain on CPU intesive 
applications such as mathematical calculations and as such.

While it would provide some performance benefit, I doubt how much and in how 
many cases for a database app. like postgresql. It's not a CPU hog in the first 
place, most of the times.

Bye
 Shridhar

--
Bones: "The man's DEAD, Jim!"


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] Hyperthreading or not?

2003-07-16 Thread scott.marlowe
On Wed, 16 Jul 2003, Mendola Gaetano wrote:

> Hi all,
> we are going to move our production postgres box ( on Linux ) 
> in a new machine, I'm wondering if I shall leave the Hyperthreading
> feature on or disable it.

The newer kernels are hyper-threading aware.  No idea how much faster that 
might make things for a postgresql server though.

> Anyone have experience on this?

Nope, but I will this fall.

> PS: Is really faster postgresql compiled with Intel compiler ?

Note that since most people use gcc, any problems caused by the Intel 
compiler might take more time to get fixed.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] Criteria for contrib/ versus gborg?

2003-07-16 Thread scott.marlowe
On Wed, 16 Jul 2003, Andrew Sullivan wrote:

> On Tue, Jul 15, 2003 at 06:35:38PM -0400, Robert Treat wrote:
> > is this code really a "replacement" for rserv? There has been work on
> > rserv in contrib that I'm guessing was not used in the commercial
> > version. are we better off calling this rserv2 or something and letting
> > both projects stand side by side?
> 
> Good point: this code branched back in the summer of 2001, and hasn't
> had anything to do with the rserv code since.  So perhaps both should
> live.
> 
> > as the person doing the legwork, do you see one location or the other as
> > a hindrance to getting the release done? 
> 
> Not to me, no.  But since I can't commit the changes to CVS, someone
> else would have to do that.  Mind you, last time I tried to set up a
> project on gborg, I couldn't get it to work after 4 hours, and gave
> up.

I'd say contrib is the natural place for it, as it's a todo item and a 
step towards integration.  It's a feature most people can use, and if it's 
in /contrib it's more likely to get used than if it's on gborg.  


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


Re: [HACKERS] [ADMIN] problems with pg_restore

2003-07-16 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Jul 15, 2003 at 04:03:13PM -0400, Tom Lane wrote:
>> Given the current implementation, it seems like there are three possible
>> behaviors for COMMENT ON DATABASE when the database name isn't the same
>> as the current database:

> There's a fourth possibility:  ignore the command and issue a WARNING.

Hmm, that seems like a reasonable choice.  Anyone have an objection?

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [HACKERS] perm question

2003-07-16 Thread Tom Lane
ivan <[EMAIL PROTECTED]> writes:
> why when i revoke all on scheme pg_catalog from all (with public)
> i can make select from pg_ tables and views as ordinary user ??

Hm.  pg_catalog is forcibly placed into the search path, thus bypassing
the normal check on whether you have USAGE privilege on it.  I suppose
that could be claimed to be a bug ... but in point of fact, honoring
denial of USAGE on pg_catalog would mean that the system would fail to
function at all.  So I cannot see any actual usefulness in doing such a
thing.  You might as well just delete the user entirely as forbid him
access to pg_catalog.

> and how disallow : LISTEN , SET , RESET , and SHOW ?

Explain why we should?

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [HACKERS] backend/parser compile prob

2003-07-16 Thread Patrick Welche
On Tue, Jul 15, 2003 at 12:42:45PM -0400, Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
... 
> > What string constant?! Will try again later...
>
> Which flex version are you using?  You need 2.5.4 --- the most recent
> versions have broken backwards compatibility :-(.  I'm not sure what the
> symptom looks like, though.

Answer is: a broken flex 2.5.4. There were some commits to NetBSD flex to
use bounded strings. Using 13th July flex source builds a happy PostgreSQL.
Now to track down which bit broke - anyway, not a PostgreSQL problem :-)

Cheers,

Patrick
==
 All 91 tests passed. 
==
NetBSD-1.6U/i386

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] FROM clause omitted

2003-07-16 Thread Christoph Haller
>
> I had a bug in one of my queries that wasn't detected by pg because if

> filled in the from clause by itself. Take for example a querie like
>
> select foo.a;
>
> which I guess is transformed to
>
> select foo.a
> from foo;
>
> Is this really a good thing to do? Is it part of the standard? Can it
be
> turned of? In my case it hid a bug and made my query work but produce
the
> wrong result.
>
> Isn't this yet another case of "helpful" parsing that will only hurt
in
> the end? Look at how hard it is to parse html-pages because all
browsers
> accept broken code, but different broken code.
>
> What about an example like this (the transformed code above but with
alias
> x added):
>
> select foo.a
> from foo x;
>
> By adding the alias x the query still workes but gives a different
result.
>
Dennis,
This feature has been addressed many times before.
Please search the archives and refer to Extensions within SELECT doc.
AFAIK it can even be turned off, but don't know how exactly.
As I said, search the archive.
HTH
Regards, Christoph




---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] FROM clause omitted

2003-07-16 Thread Rod Taylor
> Is this really a good thing to do? Is it part of the standard? Can it be
> turned of? In my case it hid a bug and made my query work but produce the
> wrong result.

7.4 has a switch to turn this off for the same reasons you cite.


signature.asc
Description: This is a digitally signed message part


[HACKERS] FROM clause omitted

2003-07-16 Thread Dennis Björklund
I had a bug in one of my queries that wasn't detected by pg because if 
filled in the from clause by itself. Take for example a querie like

select foo.a;

which I guess is transformed to

select foo.a
from foo;

Is this really a good thing to do? Is it part of the standard? Can it be
turned of? In my case it hid a bug and made my query work but produce the
wrong result.

Isn't this yet another case of "helpful" parsing that will only hurt in
the end? Look at how hard it is to parse html-pages because all browsers
accept broken code, but different broken code.

What about an example like this (the transformed code above but with alias
x added):

select foo.a
from foo x;

By adding the alias x the query still workes but gives a different result.

-- 
/Dennis


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [HACKERS] Criteria for contrib/ versus gborg?

2003-07-16 Thread Andrew Sullivan
On Tue, Jul 15, 2003 at 06:35:38PM -0400, Robert Treat wrote:
> is this code really a "replacement" for rserv? There has been work on
> rserv in contrib that I'm guessing was not used in the commercial
> version. are we better off calling this rserv2 or something and letting
> both projects stand side by side?

Good point: this code branched back in the summer of 2001, and hasn't
had anything to do with the rserv code since.  So perhaps both should
live.

> as the person doing the legwork, do you see one location or the other as
> a hindrance to getting the release done? 

Not to me, no.  But since I can't commit the changes to CVS, someone
else would have to do that.  Mind you, last time I tried to set up a
project on gborg, I couldn't get it to work after 4 hours, and gave
up.

A

-- 

Andrew Sullivan 204-4141 Yonge Street
Liberty RMS   Toronto, Ontario Canada
<[EMAIL PROTECTED]>  M2P 2A8
 +1 416 646 3304 x110


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [HACKERS] Criteria for contrib/ versus gborg?

2003-07-16 Thread Andrew Sullivan
On Wed, Jul 16, 2003 at 02:23:21PM +0200, Kaare Rasmussen wrote:
> > pro contrib/:
> 
> You have four pro arguments, two of which are for marketing and the
> other two are for lazyness :-)

For what it's worth, I don't think the marketing arguments are
nothing.  That view was confirmed by what I heard at the OSCON BOF.

> Maybe a wish for some official mention of this - and other important - gborg 
> project in the documentation ?

That's not a bad idea, actually.  The projects on gborg suffer from
too little publicity.  I knew nothing about the very cool PL/R until
I heard about it directly from Joe.

A

-- 

Andrew Sullivan 204-4141 Yonge Street
Liberty RMS   Toronto, Ontario Canada
<[EMAIL PROTECTED]>  M2P 2A8
 +1 416 646 3304 x110


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] Criteria for contrib/ versus gborg?

2003-07-16 Thread greg

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


> - allows us to say that PostgreSQL ships with field-tested
>   replication in the source tree


We have a winner! I think this one trumps all the rest.


- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200307160920

-BEGIN PGP SIGNATURE-
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/FVGlvJuQZxSWSsgRAhvZAJ0fqYZctnt45zTAqbL7dLajOfewGQCeKaUq
9VJkugleaEukmFsbwabNyO8=
=wIZT
-END PGP SIGNATURE-



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [HACKERS] Criteria for contrib/ versus gborg?

2003-07-16 Thread Kaare Rasmussen
> pro contrib/:

You have four pro arguments, two of which are for marketing and the other two 
are for lazyness :-)

> pro gborg:

As you note, you will be more independent on gborg, so why not?

Maybe a wish for some official mention of this - and other important - gborg 
project in the documentation ?

-- 
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Datatshirts, merchandize  Fax:3816 2501
Howitzvej 75   Åben 12.00-18.00Email: [EMAIL PROTECTED]
2000 FrederiksbergLørdag 12.00-16.00   Web:  www.suse.dk

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]