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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[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

[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] 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*.

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

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

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

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

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

[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

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.

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

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