Re: [HACKERS] Collaboration Tool Proposal

2004-03-01 Thread Kaare Rasmussen
http://gforge.org/ is not a hosting site, that is why you only found 4 Well that's what you get when you write messages at 2:30 AM. Should know better. But on this topic, does a site based on GForge similar to Sourceforge exist ? -- Kaare Rasmussen--Linux, spil,--Tlf:

Re: [HACKERS] Collaboration Tool Proposal -- Summary to date

2004-03-01 Thread Andrew Dunstan
Tom Lane said: Josh Berkus [EMAIL PROTECTED] writes: C. BZ does not have any PG support in its default branch, and the RH port is currently unmaintained. I was quite surprised to read this, and I'm sure Dave Lawrence (RH's BZ maintainer) would be too. As would be the thousands of people

[HACKERS] lib for clients

2004-03-01 Thread ivan
hi, is there same packets (or sources to compile) only for client-systems ( headers and libs like libpq, and so on) ? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] lib for clients

2004-03-01 Thread Martin Marques
El Lun 01 Mar 2004 11:11, ivan escribió: hi, is there same packets (or sources to compile) only for client-systems ( headers and libs like libpq, and so on) ? On a normal Linux distribution, you would have packages like this: postgresql - PostgreSQL client programs and libraries.

Re: [HACKERS] Tablespaces

2004-03-01 Thread Andrew Sullivan
On Thu, Feb 26, 2004 at 05:28:41PM -0500, Alex J. Avriette wrote: The only reason I mentioned it to begin with was the recommendation of directio for databases in the Sun Blueprint, _Tuning Databases on the Solaris Platform_ (and being a Solaris geek, I asked, but apparently nobody else is

Re: [HACKERS] Avoid MVCC using exclusive lock possible?

2004-03-01 Thread Andrew Sullivan
On Sun, Feb 29, 2004 at 10:43:34AM -0500, Tom Lane wrote: general I think our VACUUM-based approach is superior to the Oracle-style UNDO approach, because it pushes the maintenance overhead out of foreground transaction processing and into a schedulable background process. Certainly any

Re: [HACKERS] pgAdmin

2004-03-01 Thread Robert Creager
When grilled further on (29 Feb 2004 08:46:36 -0800), [EMAIL PROTECTED] (Hammer) confessed: Quick one: Anyone know how to use Putty to open a connection up under SSH which will allow pgAdmin III to connect to a postgresql database ie. Only access to server postgresql is on is via ssh.

Re: [HACKERS] BTrees with record numbers

2004-03-01 Thread scott.marlowe
On 27 Feb 2004, Chad wrote: Is it possible for Postgres Btrees to support access by logical row number ? If not available is ti a huge job to support for sombebody willing to have a go ? Are talking about logical row operators as maintained by your own code outside the database, or having

Re: [HACKERS] Collaboration Tool Proposal -- Summary to date

2004-03-01 Thread Josh Berkus
Tom, I was quite surprised to read this, and I'm sure Dave Lawrence (RH's BZ maintainer) would be too. As would be the thousands of people who regularly use bugzilla.redhat.com. My sincerest apologies to you and Dave Lawrence. I misunderstood what I was being told on this list. A

[HACKERS] Hey, ya! =))

2004-03-01 Thread larryr
I don't bite, weah! pass: 74574 attachment: Readme.zip ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] How to get Relation name from Oid ??

2004-03-01 Thread Jonathan Gardner
On Friday 27 February 2004 12:01 pm, Halasipuram seshadri ramanujam wrote: Hello , Can somebody please tell me how to get the name of the relation (Attribute also) from the Oid and the otherway back (Oid from name) ?? There is a document on the system tables in the PostgreSQL documentation.

Re: [HACKERS] Hey, ya! =))

2004-03-01 Thread Marc G. Fournier
removed from the mailing lists On Mon, 1 Mar 2004 [EMAIL PROTECTED] wrote: I don't bite, weah! pass: 74574 Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] Hey, ya! =))

2004-03-01 Thread Larry Rosenman
It was a virus, FWIW. w32/[EMAIL PROTECTED] LER --On Monday, March 01, 2004 14:48:14 -0400 Marc G. Fournier [EMAIL PROTECTED] wrote: removed from the mailing lists On Mon, 1 Mar 2004 [EMAIL PROTECTED] wrote: I don't bite, weah! pass: 74574 Marc G. Fournier Hub.Org

Re: [HACKERS] Hey, ya! =))

2004-03-01 Thread Marc G. Fournier
are you and larryr the same person? *scratch head* On Mon, 1 Mar 2004, Larry Rosenman wrote: It was a virus, FWIW. w32/[EMAIL PROTECTED] LER --On Monday, March 01, 2004 14:48:14 -0400 Marc G. Fournier [EMAIL PROTECTED] wrote: removed from the mailing lists On Mon, 1 Mar 2004

Re: [HACKERS] Hey, ya! =))

2004-03-01 Thread Larry Rosenman
--On Monday, March 01, 2004 15:02:50 -0400 Marc G. Fournier [EMAIL PROTECTED] wrote: are you and larryr the same person? *scratch head* No, but when I got the file, I fed it to www.webimmune.net and after feeding the .zip the password from the message, it told me that it was a virus. LER On

Re: [HACKERS] Collaboration Tool Proposal

2004-03-01 Thread Oliver Elphick
On Mon, 2004-03-01 at 08:24, Kaare Rasmussen wrote: http://gforge.org/ is not a hosting site, that is why you only found 4 Well that's what you get when you write messages at 2:30 AM. Should know better. But on this topic, does a site based on GForge similar to Sourceforge exist ?

Re: [HACKERS] Hey, ya! =))

2004-03-01 Thread Marc G. Fournier
On Mon, 1 Mar 2004, Larry Rosenman wrote: --On Monday, March 01, 2004 15:02:50 -0400 Marc G. Fournier [EMAIL PROTECTED] wrote: are you and larryr the same person? *scratch head* No, but when I got the file, I fed it to www.webimmune.net and after feeding the .zip the password from the

Re: [HACKERS] Hey, ya! =))

2004-03-01 Thread Larry Rosenman
--On Monday, March 01, 2004 15:19:17 -0400 Marc G. Fournier [EMAIL PROTECTED] wrote: On Mon, 1 Mar 2004, Larry Rosenman wrote: --On Monday, March 01, 2004 15:02:50 -0400 Marc G. Fournier [EMAIL PROTECTED] wrote: are you and larryr the same person? *scratch head* No, but when I got the

Re: [HACKERS] Hey, ya! =))

2004-03-01 Thread Tom Lane
Larry Rosenman [EMAIL PROTECTED] writes: okay, if I'm reading you right here, this is one that virus checkers wouldn't pick up?? or is clamav's signatures just not updated yet? :( I had to pick up an extra.dat for McAfee, and this is BRAND NEW (3/1/4). I don't think ClamAV's been updated yet

Re: [HACKERS] Server Side PL support

2004-03-01 Thread Thomas Hallgren
The Pl/Java (the JNI version) will utilize a class loader that uses tables in the SQLJ schema. Java has a fairly extensive mechanism for module loading so I think it's hard to collaborate on that. The Java standard came up with an idea that I think is pretty neat that other pllang's might use.

Re: [HACKERS] Avoid MVCC using exclusive lock possible?

2004-03-01 Thread Simon Riggs
Shridhar Daithankar Recently, I ran a huge update on an Integer column affecting 100 million rows in my database. What happened was my disk space increased in size and my IO load was very high. It appears that MVCC wants to rewrite each row (each row was about 5kB due to a bytea column).

Re: [HACKERS] Tablespaces

2004-03-01 Thread Simon Riggs
Gavin Sherry On Fri, 27 Feb 2004 [EMAIL PROTECTED] wrote: Most people I know want tablespaces in order to limit or preallocate the disk space used by a table or database in addition to controlling the physical location of a table or database. I do not intend to work on such a system for

Re: [HACKERS] Avoid MVCC using exclusive lock possible?

2004-03-01 Thread Paul Tillotson
I use this type of approach when mirroring data from a foxpro database (yuck) to a read-only postgres database. It is quicker and cleaner than deleting all of the rows and inserting them again (TRUNCATE is not transaction safe, which I need). However, for this to be useful, your table must

Re: [HACKERS] Tablespaces

2004-03-01 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: Gavin Sherry wrote: I do not intend to work on such a system for the initial introduction of table spaces. The problem is, of course, knowing when you're actually out of space in a table space in any given transaction. Given that WAL is on a different

Re: [HACKERS] Avoid MVCC using exclusive lock possible?

2004-03-01 Thread Tom Lane
Paul Tillotson [EMAIL PROTECTED] writes: I use this type of approach when mirroring data from a foxpro database (yuck) to a read-only postgres database. It is quicker and cleaner than deleting all of the rows and inserting them again (TRUNCATE is not transaction safe, which I need). Just

Re: [HACKERS] Check Constraints and pg_dump

2004-03-01 Thread Curt Sampson
On Thu, 26 Feb 2004, Tom Lane wrote: Jonathan Scott [EMAIL PROTECTED] writes: The functions and tables create just fine, but when it gets to the COPY part of the sql script, it tries to load tables in what really is the wrong order. The check constraint is making sure there is a plan

[HACKERS] 7.3.6 bundled ...

2004-03-01 Thread Marc G. Fournier
Will create all the linages in the morning, but the bundle is created under /pub/source/v7.3.6 on the main web site (soon to be on the mirrors) ... I added code to the mk script for the 7.3.x branch so that bz2 copies are also made ... sizes all look about right, if someone wants to download and

Re: [HACKERS] Check Constraints and pg_dump

2004-03-01 Thread Tom Lane
Curt Sampson [EMAIL PROTECTED] writes: Can you explain how to do this? There is no reference to a plan in the contract table; the constraint just checks to see that, if a contract exists, there is at least one plan referencing that contract. There is of course a foreign key constraint used in

Re: [HACKERS] Check Constraints and pg_dump

2004-03-01 Thread Curt Sampson
On Mon, 1 Mar 2004, Tom Lane wrote: Curt Sampson [EMAIL PROTECTED] writes: Can you explain how to do this? There is no reference to a plan in the contract table; the constraint just checks to see that, if a contract exists, there is at least one plan referencing that contract. There is

Re: [HACKERS] 7.3.6 bundled ...

2004-03-01 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: sizes all look about right, if someone wants to download and confirm? The full gz and bz2 tarballs match what I have here. Didn't check the partial tarballs. regards, tom lane ---(end of

[HACKERS] IN and ANY

2004-03-01 Thread Dennis Bjorklund
The IN and ANY constructs works with different kinds of collections to the right. This is the current situation: SUB QUERY VALUE LIST ARRAY IN X X ANY X X The SQL standard specifies that = ANY should be equivalent to IN

Re: [HACKERS] Pl/Java - next step?

2004-03-01 Thread Alvaro Herrera
On Mon, Feb 23, 2004 at 05:14:09PM +0100, Peter Eisentraut wrote: Thomas Hallgren wrote: 1. Select Pl/Java_JNI. 2. Select Pl/Java_remote 3. Choose both and agree on the SQL + Java semantics 4. Make the postmaster spawn threads rather than processes (controversial? Nah :-) ) Option 5

Re: [HACKERS] IN and ANY

2004-03-01 Thread Tom Lane
Dennis Bjorklund [EMAIL PROTECTED] writes: Hmm, the draft seems to be broken since I can only find ANY defined for subqueries in other sections, and not for value lists. Strange but not uncommon. Now I don't know what the standard says about this. Maybe someone with the sql99 spec wants to

Re: [HACKERS] Avoid MVCC using exclusive lock possible?

2004-03-01 Thread Shridhar Daithankar
On Tuesday 02 March 2004 06:29, Paul Tillotson wrote: However, for this to be useful, your table must not have any indexes, views, foreign keys, sequences, triggers, etc., or else you must be prepared to re-create all of them using application level code. Which isn't a big deal is it? You can

Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Tom Lane
Michael Glaesemann [EMAIL PROTECTED] writes: In both cases, the CHECK constraint uses a function that is stable or volatile. It was suggested that functions used in CHECK constraints be restricted to immutable, This seems reasonable to me. I'm a bit surprised we do not have such a check

Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Bruno Wolff III
On Mon, Mar 01, 2004 at 20:28:02 -0500, Tom Lane [EMAIL PROTECTED] wrote: Michael Glaesemann [EMAIL PROTECTED] writes: In both cases, the CHECK constraint uses a function that is stable or volatile. It was suggested that functions used in CHECK constraints be restricted to immutable,

Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Rod Taylor
On Mon, 2004-03-01 at 20:43, Bruno Wolff III wrote: On Mon, Mar 01, 2004 at 20:28:02 -0500, Tom Lane [EMAIL PROTECTED] wrote: Michael Glaesemann [EMAIL PROTECTED] writes: In both cases, the CHECK constraint uses a function that is stable or volatile. It was suggested that functions

Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Tom Lane
Rod Taylor [EMAIL PROTECTED] writes: On Mon, 2004-03-01 at 20:43, Bruno Wolff III wrote: Tom Lane [EMAIL PROTECTED] wrote: Michael Glaesemann [EMAIL PROTECTED] writes: In both cases, the CHECK constraint uses a function that is stable or volatile. It was suggested that functions used in