[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

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

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

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.

[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 sys

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 >

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 submitt

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 M

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

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 othe

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

[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

[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 recen

[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 pr

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

[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

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 com

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 migh

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 rs

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 four

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.

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

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

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 pa

[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

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 s

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 he

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 SI

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 documenta