Re: [HACKERS] Idea about better configuration options for sort memory

2004-05-30 Thread scott.marlowe
On 12 Feb 2004, Greg Stark wrote: Tom Lane [EMAIL PROTECTED] writes: Hmmm ... maybe query_work_mem and maintenance_work_mem, or something similar? I'll go with these unless someone has another proposal ... dml_sort_mem and ddl_sort_mem ? I like those. Are they an accurte

Re: [HACKERS] PITR Dead horse?

2004-05-13 Thread scott.marlowe
On Thu, 5 Feb 2004, Rod Taylor wrote: Don't know. But apparently different users will have different demands From a database. Of course, but I would argue that my claim that PostgreSQL is reliable is backed up by the lack of people posting messages like 'we had a powercut and now

Re: [HACKERS] ALTER TABLE TODO items

2004-05-06 Thread scott.marlowe
On Thu, 6 May 2004, Richard Huxton wrote: Bruce Momjian wrote: Tom Lane wrote: Richard Huxton [EMAIL PROTECTED] writes: Does that mean I'll want to disable triggers while I do this? Hrm. Right now the code does not fire triggers at all, but that seems wrong. However, I doubt that

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-06 Thread scott.marlowe
On Thu, 6 May 2004, Tom Lane wrote: sdv mailer [EMAIL PROTECTED] writes: The point is pre-forking can *potentially* speed up connections by 5x as shown in this simplistic non-conclusive benchmark. I think this benchmark proves no such thing. The thing that pgpool is doing is not

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-05 Thread scott.marlowe
On Wed, 5 May 2004, sdv mailer wrote: Forking is quite fast on Linux but creating a new process is still 10x more expensive than creating a thread and is even worse on Win32 platform. CPU load goes up because the OS needs to allocate/deallocate memory making it difficult to get a steady

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-05 Thread scott.marlowe
On Wed, 5 May 2004, Rod Taylor wrote: And, of course, most development environments (perl, php, java etc) have their own language specific connection pooling solutions. Yes, the one for php is what I was thinking of when I made my statement. They work on a per backend basis as Apache does

[HACKERS] The features I'm waiting for.

2004-05-04 Thread scott.marlowe
For me, the only features I'm likely to use in the upcoming releases are nested transactions. While PITR is a great selling point, and the Windows Port is something I do look forward to, having to do half my job programming windows boxes, nested transactions are a feature I can genuinely use

Re: [HACKERS] The features I'm waiting for.

2004-05-04 Thread scott.marlowe
On Tue, 4 May 2004, David Garamond wrote: scott.marlowe wrote: For me, the only features I'm likely to use in the upcoming releases are nested transactions. While PITR is a great selling point, and the Windows Port is something I do look forward to, having to do half my job

Re: How to Welcome Windows Users (was Re: [HACKERS] 7.5 features)

2004-04-28 Thread scott.marlowe
On Tue, 27 Apr 2004, Richard Huxton wrote: On Tuesday 27 April 2004 14:27, Bruce Momjian wrote: Here are features that are being worked on, hopefully for 7.5: o tablespaces (Gavin) o nested transactions (Alvaro) o two-phase commit (Heikki Linnakangas) o integrated

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

2004-04-28 Thread scott.marlowe
On Tue, 27 Apr 2004, Andrew Payne wrote: Scott Marlowe wrote: While Apache is and has been wildly popular for bulk hosing and domain parking, for serious commercial use, Netscape's enterprise server, now Sun One, has long been a leader in commercial web sites. Netscrape/SunONE may

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding

2004-04-27 Thread scott.marlowe
On Mon, 26 Apr 2004, Josh Berkus wrote: Shachar, I think the concensus was that the runtime part was aprox. four lines where the case folding currently takes place. Obviously, you would have to get a var, and propogate that var to that place, but not actually change program flow.

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-27 Thread scott.marlowe
On Mon, 26 Apr 2004, Josh Berkus wrote: I think that a talented manager could make the case for certain features. So? So could any community member with a good grasp of database engineering and an ability to write persuasive e-mails. I'd like to inject here that I was the one who

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

2004-04-27 Thread scott.marlowe
On Tue, 27 Apr 2004, Jochem van Dieten wrote: [EMAIL PROTECTED] wrote: (5) Programming languages. We need to make a programming language standard in PostgreSQL. plpgsql is good, but isn't someone working on a Java language. That would be pretty slick. IMHO SQL/PSM would be the obvious

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

2004-04-27 Thread scott.marlowe
On Mon, 26 Apr 2004, Andrew Payne wrote: Bruce asked an excellent question: My question is, What can we learn from MySQL? I don't know there is anything, but I think it makes sense to ask the question. After watching the traffic on this, the biggest MySQL lesson has gone largely

Re: [HACKERS] Is there any method to keep table in memory at startup

2004-04-27 Thread scott.marlowe
On Wed, 21 Apr 2004 [EMAIL PROTECTED] wrote: Hi I am working on a project in postgres..in which i designed customized data type and operations on it.it requires a look up table.. I have three options regarding this table... 1. Every time a query is executed it creates table assigns values

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

2004-04-27 Thread scott.marlowe
On Mon, 26 Apr 2004, Andrew Payne wrote: For those that look to Apache: Apache never had a well-established incumbent (Oracle), an a well-funded upstart competitor (MySQL). Rob McCool's NCSA httpd (and later, Apache) were good enough and developed rapidly enough that they prevented any

Re: [HACKERS] TPC H data

2004-04-27 Thread scott.marlowe
On Wed, 21 Apr 2004, Shalu Gupta wrote: Hello, We are trying to import the TPC-H data into postgresql using the COPY command and for the larger files we get an error due to insufficient memory space. We are using a linux system with Postgresql-7.3.4 Is it that Postgresql cannot handle

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

2004-04-23 Thread scott.marlowe
On Fri, 23 Apr 2004, Bruce Momjian wrote: Here is a blog about a recent MySQL conference with title, Why MySQL Grew So Fast: http://www.oreillynet.com/pub/wlg/4715 and a a Slashdot discussion about it:

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-21 Thread scott.marlowe
I almost agree, but I think things that are being actively developed to eventually move into the backend, like autovacuum or slony-I should be in contrib. Things that aren't destined for backend integration should be removed though, like pgbench or dblink or whatnot. On Wed, 21 Apr 2004,

Re: [HACKERS] pg_encoding not needed anymore

2004-04-20 Thread scott.marlowe
On Tue, 20 Apr 2004, Bruce Momjian wrote: Andrew Dunstan wrote: past. I think createuser is much worse. :-) Agreed. Actually, the big problem with the name initdb is that the name is misleading, and newbies often get confused by it. You are preparing a data store for many

Re: [HACKERS] Remove MySQL Tools from Source?

2004-04-16 Thread scott.marlowe
On Fri, 16 Apr 2004, Christopher Kings-Lynne wrote: I always ran one of the 2 scripts (can't remember which one) and after that started checking the dump file, because there were things that didn't get changed correctly[1]. [1]: I always remember the first conversion I did. I found

Re: [HACKERS] make == as = ?

2004-04-08 Thread scott.marlowe
On Thu, 8 Apr 2004, Bruce Momjian wrote: Fabien COELHO wrote: This would help me, at least, write correct and portable SQL. :) Added to TODO: * Add a session mode to warn about non-standard SQL usage So it seems that having C-like operators would hurt a lot;-) So

Re: [HACKERS] pg_dump and INCREMENT BY

2004-04-07 Thread scott.marlowe
On Wed, 7 Apr 2004, Dennis Bjorklund wrote: On Wed, 7 Apr 2004, Dennis Bjorklund wrote: Replying to myself here :-) wants to import it into a 7.3 database. Use the 7.3 dump you might say, but since BY does not do anything why not remove it from the dump output? I just realized there

Re: [HACKERS] what do postgresql with view ?

2004-04-06 Thread scott.marlowe
On 31 Mar 2004, elrik wrote: [EMAIL PROTECTED] (elrik) wrote in message news:[EMAIL PROTECTED]... In information i have: 1. when creating view : PostgreSQL parse the query and stock the tree query. 2. when using : PostgreSQL use this tree like a subselect. my question : Do

Re: [HACKERS] pg_dump end comment

2004-03-31 Thread scott.marlowe
On Wed, 31 Mar 2004, Philip Warner wrote: At 12:13 AM 31/03/2004, Bruce Momjian wrote: Yes, they have to check for a proper exit from pg_dump, but there is still a file sitting around after the dump, with no way to tell if it is accurate. Why don't we write a hash into the header or

Re: [HACKERS] Increasing security in a shared environment ...

2004-03-29 Thread scott.marlowe
On Mon, 29 Mar 2004, Marc G. Fournier wrote: On Mon, 29 Mar 2004, Dave Page wrote: It's rumoured that Euler Taveira de Oliveira once said: Hi Christopher, The \l command should only list databases that the current user is authorized for, the \du command should only list users

Re: [HACKERS] Log rotation

2004-03-24 Thread scott.marlowe
On Wed, 24 Mar 2004, Andrew Dunstan wrote: . Peter Eisentraut's program pro: portable, better featured, no license issues con: code state uncertain, less well tested Where is Peter's code available, I'd like to try it out. ---(end of

Re: [HACKERS] Default Stats Revisited

2004-03-11 Thread scott.marlowe
On Thu, 11 Mar 2004, Josh Berkus wrote: Scott, I like it. Would a multiplier be acceptable? default_stats_index_multiplier = 10 Yeah, I thought about that, but a multiplier would be harder to manage for most people.I mean, what if your default_stats are at 25 and you want

Re: [HACKERS] About hierarchical_query of Oracle

2004-03-10 Thread scott.marlowe
On Wed, 10 Mar 2004, Li Yuexin wrote: Who can tell me how to complete oracle's hierarchical_query through postgresql? Look in the contrib/tablefunc directory for the connect_by function. ---(end of broadcast)--- TIP 3: if posting/reading

Re: [HACKERS] raising the default default_statistics_target

2004-03-09 Thread scott.marlowe
On Sun, 7 Mar 2004, Tom Lane wrote: Neil Conway [EMAIL PROTECTED] writes: Tom Lane wrote: This is something we need to consider, but we'll need more evidence before making a choice. One thing that we have very little data about is how much difference it makes in the quality of planner

Re: [pgsql-hackers-win32] [HACKERS] Tablespaces

2004-03-05 Thread scott.marlowe
On Fri, 5 Mar 2004, Thomas Swan wrote: [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] writes: [EMAIL PROTECTED] wrote: Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: My feeling is that we need not support tablespaces on OS's without symlinks.

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

2004-02-27 Thread scott.marlowe
On Fri, 27 Feb 2004, Zeugswetter Andreas SB SD wrote: Ahh. I forgot to detail my ideas on this. It seems to me that we cannot drop a table space until the directory is empty. Agreed. How would it get to be empty? Are you thinking of some sort of connect database to tablespace

Re: [HACKERS] Tablespaces

2004-02-27 Thread scott.marlowe
On Fri, 27 Feb 2004, Gavin Sherry wrote: On Thu, 26 Feb 2004, Alex J. Avriette wrote: On Thu, Feb 26, 2004 at 11:22:28PM +1100, Gavin Sherry wrote: Certainly, table spaces are used in many ways in oracle, db2, etc. You can mirror data across them, have different buffer sizes for

Re: [HACKERS] Tablespaces

2004-02-27 Thread scott.marlowe
On Fri, 27 Feb 2004, Tom Lane wrote: scott.marlowe [EMAIL PROTECTED] writes: Is possible / reasonable / smart and or dumb to look at implementing the tablespaces as riding atop the initlocation handled stuff. In my mind, one of the main benefits of this work will be that we'll be able

Re: [HACKERS] Sparc optimizations

2004-02-24 Thread scott.marlowe
On Tue, 24 Feb 2004, Shridhar Daithankar wrote: http://www.osnews.com/printer.php?news_id=6136 That page gets a please don't link to printer ready pages error and redirects to here: http://www.osnews.com/story.php?news_id=6136 ---(end of

Re: [HACKERS] MS SQL features for new version

2004-02-17 Thread scott.marlowe
On Tue, 10 Feb 2004, Rodrigo wrote: Shridhar Daithankar wrote: Just stumbled upon this. just an FYI, http://www.microsoft.com/sql/yukon/productinfo/top30features.asp Shridhar From the page: A new Snapshot Isolation (SI) level will be provided at the database level. With

Re: [HACKERS] How can I have 2 completely seperated databases in

2004-02-12 Thread scott.marlowe
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote: Thank you very much for your reply. Yes, that's true. But it seems not a good idea if I have many databases and I want them totally seperated with each other. What's your opinion? Thanks. OK, here's the issue. Postgresql uses certain

Re: [HACKERS] How can I have 2 completely seperated databases in

2004-02-12 Thread scott.marlowe
On Thu, 12 Feb 2004, Rod Taylor wrote: But for seperating out applications from each other, there's really nothing to be gained by putting each seperate database application into it's own cluster. I believe the initial email requested individual logs, and presumably the ability to

Re: [HACKERS] RFC: Query Planner making a distinction between Cross

2004-02-12 Thread scott.marlowe
On Thu, 12 Feb 2004, Stef wrote: U. Postgresql doesn't natively support cross database queries... I know, but it does schema's, and currently, the same notation is used to specify schema's as 'cross database'. So the planner often reports 'cross-database not allowed' in areas

Re: [HACKERS] RFC: Query Planner making a distinction between Cross

2004-02-12 Thread scott.marlowe
On Thu, 12 Feb 2004, Stef wrote: case in point, the example trigger. i would have expected deliberate schemaname.table during an insert to work, but instead the parser complains about cross-database. I would think just changing the error message to no schema by the name of

Re: [HACKERS] How can I have 2 completely seperated databases in

2004-02-11 Thread scott.marlowe
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote: Hi, all What should I do if I want to have 2 completely seperated databases in PostgreSQL? I want each database to have its own data, log and everything needed to access that database. I don't want them to share anything. Has anyone done this

Re: [HACKERS] [PATCHES] Current-stream read for psql's \copy

2004-02-10 Thread scott.marlowe
On Tue, 10 Feb 2004, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: No it doesn't. EOF will do fine. The source program doesn't necessarily have to know anything about COPY, as long as its output is in a format COPY can cope with (eg, tab-delimited). The

[HACKERS] bug in substring???

2004-02-06 Thread scott.marlowe
I'm using substring. Since I'm a coder more than a database guy, I expected this: select substring('abcdefgh',0,4); would give me abcd but it gives me a left aligned 'abc' select substring('abcdefgh',1,4); works fine. select substring('abcdefgh',-4,4); gives me nothing. Shouldn't a

Re: [HACKERS] bug in substring???

2004-02-06 Thread scott.marlowe
On Fri, 6 Feb 2004, Joe Conway wrote: scott.marlowe wrote: gives me nothing. Shouldn't a negative offset, or even 0 offset result in an error or something here? Or is there a special meaning to a negative offset I'm not getting? In varlena.c there is this comment: * text_substr

Re: [HACKERS] Question on database backup

2004-02-04 Thread scott.marlowe
On Wed, 4 Feb 2004, Michael Brusser wrote: We have customers who prefer to use their backup facilities instead of what we provide in the app (we use pg_dump) I hear speed is at least one consideration. The questions I need to answer are these: 1) Is this absolutely safe to do file copy

Re: [HACKERS] Write cache

2004-01-28 Thread scott.marlowe
On Wed, 28 Jan 2004 [EMAIL PROTECTED] wrote: I agree I MAY have an hardware problem. What happens is more a system freeze than a system crash (there's no panic, no nothing, just freezes, no disk activity, not network) I would suspect either bad hardware,a flakey SCSI driver, or a possible

Re: [HACKERS] Bunch o' dead code in GEQO

2004-01-22 Thread scott.marlowe
On Wed, 21 Jan 2004, Tom Lane wrote: The GEQO planner module contains six different recombination algorithms, only one of which is actually used --- the others are ifdef'd out, and have been ever since we got the code. Does anyone see a reason not to prune the deadwood? considering the

Re: [HACKERS] Bunch o' dead code in GEQO

2004-01-22 Thread scott.marlowe
On Thu, 22 Jan 2004, Tom Lane wrote: scott.marlowe [EMAIL PROTECTED] writes: On Wed, 21 Jan 2004, Tom Lane wrote: The GEQO planner module contains six different recombination algorithms, considering the recent discussion about REALLY slow query planning by the GEQO module, it might

Re: [HACKERS] cache control?

2004-01-16 Thread scott.marlowe
On Fri, 16 Jan 2004, Michael Brusser wrote: Is there a way to force database to load a frequently-accessed table into cache and keep it there? Nope. But there is a new cache buffer handler that may make it into 7.5 that would make that happen automagically. ---(end

Re: [HACKERS] What's planned for 7.5?

2004-01-12 Thread scott.marlowe
On Mon, 12 Jan 2004, Martin Marques wrote: Mensaje citado por Marc G. Fournier [EMAIL PROTECTED]: Native Win32 is planned for it (whether it makes it or not is another question, but it is the goal) ... Replication wasn't another BIG one? Actually, I think it was PITR (Point in Time

Re: [HACKERS] Project status pages

2003-12-22 Thread scott.marlowe
On Fri, 19 Dec 2003, Bruce Momjian wrote: Robert Treat wrote: Wasn't there a patch posted many months ago for PITR. IIRC it wasn't complete, but would be a good starting point for those interested in helping out. If it's in the archives it would be nice to add a link to it on the project

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-16 Thread scott.marlowe
On Tue, 16 Dec 2003, Jon Jensen wrote: On Tue, 16 Dec 2003, Jan Wieck wrote: If you want to prevent accidential access, start postmaster on a non-standard port. That seems like an unfriendly thing to do. You'd have to check to see what port is standard for this particular

Re: [HACKERS] Performance features the 4th

2003-11-10 Thread scott.marlowe
On Sun, 9 Nov 2003, Jan Wieck wrote: scott.marlowe wrote: On Fri, 7 Nov 2003, Matthew T. O'Connor wrote: - Original Message - From: Jan Wieck [EMAIL PROTECTED] Tom Lane wrote: Gaetano and a couple of other people did experiments that seemed to show it was useful

Re: [HACKERS] Performance features the 4th

2003-11-07 Thread scott.marlowe
On Fri, 7 Nov 2003, Matthew T. O'Connor wrote: - Original Message - From: Jan Wieck [EMAIL PROTECTED] Tom Lane wrote: Gaetano and a couple of other people did experiments that seemed to show it was useful. I think we'd want to change the shape of the knob per later

Re: [HACKERS] Hacking PostgreSQL to work in Mac OS X 10.3 (Panther

2003-11-05 Thread scott.marlowe
Is this a bug we should fix for 7.3.5 when it eventually comes out? On Tue, 4 Nov 2003, Andrew Rawnsley wrote: Just build RC1 today on Panther, no problems. On Nov 4, 2003, at 5:06 PM, Jeff Hoffmann wrote: Tom Lane wrote: [EMAIL PROTECTED] writes: After spending a few hours of

Re: [HACKERS] 7.4RC1 tag'd, branched and bundled ...

2003-11-05 Thread scott.marlowe
On Tue, 4 Nov 2003, Gaetano Mendola wrote: I agree in general with you for these general arguments, but here we are talking about to introduce a sleep ( removable by guc ) or not! What about the hash refactoring introduced with 7.4? Are you going to discourage people to use the hash?

Re: [HACKERS] Very poor estimates from planner

2003-11-05 Thread scott.marlowe
On Wed, 5 Nov 2003, Rod Taylor wrote: Since this is a large query, attachments for the explains / query. Configuration: dev_iqdb=# select version(); version

Re: [HACKERS] Very poor estimates from planner

2003-11-05 Thread scott.marlowe
On Wed, 5 Nov 2003, Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: I'm not sure if that will actually change the default_statistics_target Hmm.. I was under the impression that it would work for any tables that haven't otherwise been overridden. It will. I think Scott is

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-04 Thread scott.marlowe
On Tue, 4 Nov 2003, Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: What still needs to be addressed is the IO storm cause by checkpoints. I see it much relaxed when stretching out the BufferSync() over most of the time until the next one should occur. But the kernel sync at it's

Re: [HACKERS] 7.4RC1 planned for Monday

2003-10-31 Thread scott.marlowe
On Thu, 30 Oct 2003, Joshua D. Drake wrote: If I understood correctly, Josh was complaining about VACUUM sucking too much of his disk bandwidth. autovacuum wouldn't help that --- in fact would likely make it worse, since a cron-driven vacuum script can at least be scheduled for low-load

Re: [HACKERS] Deadlock problem

2003-10-30 Thread scott.marlowe
On 30 Oct 2003, Vatsal Avasthi wrote: Hi, I am facing a strange problem and thats bugging me for a long time, I am using postgres version 7.2.1. Is it possible for you to upgrade to 7.2.4 just to make sure it's not a problem that was fixed from 7.2.1 to 7.2.4?

Re: [HACKERS] pg_user

2003-10-30 Thread scott.marlowe
On Thu, 30 Oct 2003, ivan wrote: you can also patch your kernel and when you write cat /etc/passwd system give you only your line , whitout any others users, so exacly what you need , in pgsql i think that users dont need to know about others , and also them databases, i call it security

Re: [HACKERS] 7.4RC1 planned for Monday

2003-10-30 Thread scott.marlowe
On Thu, 30 Oct 2003, Joshua D. Drake wrote: Hello, I know I will probably be flamed into oblivion for this but I would like to make a suggestion about the upcoming release. What if we delayed until the end of the year? The two reasons that I can come up with are: 1.

Re: [HACKERS] O_DIRECT in freebsd

2003-10-29 Thread scott.marlowe
On 29 Oct 2003, Doug McNaught wrote: Christopher Kings-Lynne [EMAIL PROTECTED] writes: FreeBSD 4.9 was released today. In the release notes was: 2.2.6 File Systems A new DIRECTIO kernel option enables support for read operations that bypass the buffer cache and put data directly

Re: [BUGS] [HACKERS] Autocomplete TAB on Postgres7.4beta5 not

2003-10-28 Thread scott.marlowe
On Tue, 28 Oct 2003, Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: I say leave it the way it is. If you want system table tab completion, simply: ALTER USER ... SET search_path =3D pg_catalog,...; Unfortunately, that *does not* affect the tab-completion behavior; it will

Re: [BUGS] [HACKERS] Autocomplete TAB on Postgres7.4beta5 not

2003-10-28 Thread scott.marlowe
On Tue, 28 Oct 2003, Tom Lane wrote: scott.marlowe [EMAIL PROTECTED] writes: Is it possible to remove the implicit search path of pg_catalog from a psql session without it breaking lots of stuff? Do you consider +, count(), etc to be important stuff? Me, hardly ever use them :-) So I

Re: [HACKERS] round() function wrong?

2003-10-24 Thread scott.marlowe
On Wed, 22 Oct 2003, Jochen Westland [invigo] wrote: Hi All, i'm running Postgresql 2.2x, so i am not quitse sure wether the bug i am reporting is already fixed in newer versions or not. In my version select round(2.5); returns 2; select round(2.501) returns 3; refering to my

Re: [HACKERS] round() function wrong?

2003-10-24 Thread scott.marlowe
On Fri, 24 Oct 2003, Michael Brusser wrote: But this seems to work correctly on 7.3.2 and 7.3.4: psql -c select round (2.5) Password: round --- 3 (1 row) = I just tried that on my 7.2.4 and 7.4 beta 4 machines and I get 2 for round(2.5) Ackkk. I

Re: [HACKERS] Failed to create temporary file

2003-10-23 Thread scott.marlowe
Sounds like your drives are full. On Thu, 23 Oct 2003, Yuval Lieberman wrote: Hi! I'm doing a select (from an OACS page or from psql) and I get: ERROR: Failed to create temporary file pgsql_tmp/pgsql_tmp27212.775 The same select work ok a different database (which is on a different

Re: [HACKERS] integer ceiling in LIMIT and OFFSET

2003-10-22 Thread scott.marlowe
On Wed, 22 Oct 2003, Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: That said, perhaps the TODO for changing LIMIT / OFFSET to be expression based should also mention bumping them to int8. Can't get excited about it ... this would slow down the normal use of the facility for what

Re: [HACKERS] So, are we going to bump catversion for beta5, or not?

2003-10-22 Thread scott.marlowe
On Wed, 22 Oct 2003, Tom Lane wrote: Richard Huxton [EMAIL PROTECTED] writes: On Wednesday 22 October 2003 06:55, Peter Eisentraut wrote: The idea is that you give each function its own schema search path at creation time, and that path applies to that function for the rest of its life.

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-14 Thread scott.marlowe
On 14 Oct 2003, Greg Stark wrote: Michael Brusser [EMAIL PROTECTED] writes: Michael Brusser [EMAIL PROTECTED] writes: 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks: Interrupted system call Hmm. I found this hard to believe at first, but indeed my

[HACKERS] IDE Drives and fsync

2003-10-08 Thread scott.marlowe
OK, I've done some more testing on our IDE drive machine. First, some background. The hard drives we're using are Seagate drives, model number ST380023A. Firmware version is 3.33. The machine they are in is running RH9. The setup string I'm feeding them on startup right now is: hdparm -c3

Re: [HACKERS] Question regarding coopting Database Engine

2003-10-03 Thread scott.marlowe
On Tue, 30 Sep 2003, Steve Yalovitser wrote: Hello, I'd like to know if its possible to coopt the postgres storage subsystem to rely entirely on ram based structures, rather than disk. Any documentation or ideas would be appreciated. Sure, create a ram disk. Set $PGDATA to it with proper

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-01 Thread scott.marlowe
On Tue, 30 Sep 2003, Joshua D. Drake wrote: Hello, With the recent stint of pg_upgrade statements and the impending release of 7.4 what do people think about having a dedicated maintenance team for 7.3? 7.3 is a pretty solid release and I think people will be hard pressed to upgrade

Re: [HACKERS] Wednesday beta postponed till Thursday

2003-10-01 Thread scott.marlowe
On Tue, 30 Sep 2003, Tom Lane wrote: It seems some junior electrician in Panama pulled the wrong circuit breaker ... and then the mail.postgresql.org server spent an unreasonable number of hours fsck'ing. (Why is Marc a FreeBSD fan anyway? Don't ask me, I work for Red Hat.) Anyhow, due to

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-01 Thread scott.marlowe
On Wed, 1 Oct 2003, Joshua D. Drake wrote: With 7.4 I'm finding upgrading to be easier. I'll likely upgrade out production servers to 7.4.0 when it comes out and wind up skipping 7.3 altogether. Sure but I talking about people who are running 7.3 and are happy with it. The

Re: [HACKERS] Lost mails

2003-10-01 Thread scott.marlowe
On Wed, 1 Oct 2003, Darko Prenosil wrote: Two mails with updated translations for /src/backend/po/hr.po are lost. First time I send clear po file, second tar.gz - no result. Is something blocking mails with attachment ? I didn't receive notification that mail is blocked or something like

Re: [HACKERS] feature request: show pgsql version when running initdb

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Christopher Kings-Lynne wrote: Is there any chance we could have initdb show the version of postgresql it is running as when initdb is run? If you install many different versions in parallel, don't you give your installation paths some meaning that contain the

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Bruce Momjian wrote: Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: so it appears that cygwin's echo generates a different newline style than what got put into sql_features.txt. A possible way to fix this is to put the \. line into

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Tom Lane wrote: scott.marlowe [EMAIL PROTECTED] writes: I'm running into issues where 7.4's pg_dump/pg_dumpall from a 7.2 database to a 7.4beta3 database is producing some errors like this: ERROR: literal newline found in data HINT: Use \n to represent newline

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Bruce Momjian wrote: scott.marlowe wrote: The attached file produces this problem. Note it's a blank trailing field that looks to be causing it. The error for this .sql file is: ERROR: literal carriage return found in data HINT: Use \r to represent carriage

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Bruce Momjian wrote: scott.marlowe wrote: OK, 'vi' shows it as: COPY people2 (id, persons) FROM stdin; 59 Chance Terry--S 60 ^M \. which is _exactly the case the error was supposed to catch. Now, the big question is where did

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Bruce Momjian wrote: scott.marlowe wrote: OK, 'vi' shows it as: COPY people2 (id, persons) FROM stdin; 59 Chance Terry--S 60 ^M \. which is _exactly the case the error was supposed to catch. Now, the big question is where did

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Peter Eisentraut wrote: Bruce Momjian writes: The argument that you want a warning because you might have mixed newlines in the file seems less likely than this case where they are using a literal carriage return as a data value at the end of the line. I don't

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Peter Eisentraut wrote: scott.marlowe writes: but I get basically the same thing if I dump it to a .sql file and do: psql dbname dbname.sql Use psql -f dbname.sql instead. and the output is: psql:webport.sql:803: ERROR: function odbc_user already exists

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: scott.marlowe writes: but I get basically the same thing if I dump it to a .sql file and do: psql dbname dbname.sql Use psql -f dbname.sql instead. This doesn't seem like a good argument not to add more

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Peter Eisentraut wrote: scott.marlowe writes: table name too, like Bruce said. The bothersome bit is that in pg_dump, it says the line, relative to just this part of the copy command, so you don't even know which table is giving the error. I don't see the problem

Re: [HACKERS] PostgreSQL not ACID compliant?

2003-09-19 Thread scott.marlowe
On Fri, 19 Sep 2003, Joshua D. Drake wrote: Hello, I just read a rather disturbing post PostgreSQL does not support read uncommited and repeatable read isolation levels? If that is so... then PostgreSQL is NOT ACID compliant? What is the real deal on this? Postgresql

Re: [HACKERS] Maximum table size

2003-09-09 Thread scott.marlowe
On Tue, 9 Sep 2003, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Is our maximum table size limited by the maximum block number? Certainly. Is the 16TB number a hold-over from when we weren't sure block number was unsigned, though now we are pretty sure it is handled as

Re: [HACKERS] pgsql vc++|win32

2003-09-08 Thread scott.marlowe
On Mon, 8 Sep 2003, Bruce Momjian wrote: Dann Corbit wrote: Mingw uses the native Win32 libraries. Porting from a Mingw port to VC++ will be trivial compared to what we have now. where can I access latest dev source code and dev docs in the/from CVS ? Maybe you want the

Re: [HACKERS] Seqscan in MAX(index_column)

2003-09-05 Thread scott.marlowe
Would it be possible to catch an unconstrained max(id)/min(id) and rewrite it as select id from table order by id [desc] limit1 on the fly in the parser somewhere? That would require fairly little code, and be transparent to the user. I.e. low hanging fruit. On 5 Sep 2003, Greg Stark wrote:

Re: [HACKERS] Nasty problem in hash indexes

2003-08-29 Thread scott.marlowe
On Fri, 29 Aug 2003, Tom Lane wrote: scott.marlowe [EMAIL PROTECTED] writes: On Thu, 28 Aug 2003, Neil Conway wrote: On Thu, Aug 28, 2003 at 05:37:39PM -0400, Tom Lane wrote: shrug Who's to say? We've found bugs in the btree logic recently, too. I'd rather print a loud warning when

Re: [HACKERS] Nasty problem in hash indexes

2003-08-28 Thread scott.marlowe
On Thu, 28 Aug 2003, Tom Lane wrote: I've traced through the failure reported here by Markus Kräutner: http://archives.postgresql.org/pgsql-hackers/2003-08/msg01132.php What is happening is that as the UPDATE adds tuples (all with the same hash key value) to the table, the hash bucket being

Re: [HACKERS] Bumping block size to 16K on FreeBSD...

2003-08-28 Thread scott.marlowe
On Thu, 28 Aug 2003, Marc G. Fournier wrote: On Thu, 28 Aug 2003, Thomas Swan wrote: Has anyone looked at changing the default block size across the board and what the performance improvements/penalties might be? Hardware has changed quite a bit over the years. I *think* that the

Re: [HACKERS] Oversight?

2003-08-14 Thread scott.marlowe
On Tue, 12 Aug 2003, Christopher Kings-Lynne wrote: rbt=3D# ALTER USER rbt SET CONSTRAINTS ALL DEFERRED; ERROR: syntax error at or near ALL at character 32 rbt=3D# ALTER USER rbt SET CONSTRAINTS =3D DEFERRED; ERROR: constraints is not a recognized option SET CONSTRAINTS ALL

Re: [HACKERS] logging stuff

2003-08-06 Thread scott.marlowe
On Tue, 5 Aug 2003, Andrew Dunstan wrote: (Responding to the deafening silence regarding my posts a couple of days ago about logging dbnames and disconnections) ;-) The dbname patch is now done. If nobody objects to the format ([db:yourdbname]) I'll submit it - I did it that way to make

Re: [HACKERS] logging stuff

2003-08-05 Thread scott.marlowe
If we're looking at this, we might want to look at how apache does it with it's customlog feature. This allows you to first define custom log types, then set them according to which virtual server you're setting up. I could see that being nice so you could create a couple of different custom

Re: [HACKERS] truncate all?

2003-08-04 Thread scott.marlowe
I agree, a plain truncate blasting a whole database is a very bad thing. however, truncate with cascade would be quite useful. On Mon, 4 Aug 2003, Bruce Momjian wrote: This this a TODO? Keep in mind if we follow the syntax of VACUUM and (7.4) CLUSTER, that the all-database truncate would

  1   2   3   >