Re: [GENERAL] PostgreSQL Top 10 Wishlist

2006-01-21 Thread Tony Caduto
I think a client that tells me the columns are a, b, c but then gives me an error on "insert into table values (aval, bval, cval)" because the actual logical order is different is probably fairly broken. I guess that could be a problem, I was thinking in terms of how I do a insert, I rarely d

Re: [GENERAL] PostgreSQL Top 10 Wishlist

2006-01-21 Thread Stephan Szabo
On Sat, 21 Jan 2006, Tony Caduto wrote: > Tom Lane wrote: > > > Please go back and read the very extensive discussions of this question > > a couple years ago in the pghackers archives (around the time we were > > implementing DROP COLUMN, iirc). There is no "just" about it. > > So it's a real bi

Re: [GENERAL] PostgreSQL Top 10 Wishlist

2006-01-21 Thread Tony Caduto
Tom Lane wrote: Please go back and read the very extensive discussions of this question a couple years ago in the pghackers archives (around the time we were implementing DROP COLUMN, iirc). There is no "just" about it. Maybe we need a easy button like in those Staples commercials :-) So it'

Re: [GENERAL] [HACKERS] Need help in installing postgresql 8.1.2 on Windows

2006-01-21 Thread Tony Caduto
Sarvjot Kaur wrote: Sir I am trying to install Globus Toolkit4 on Windows machine. Postgresql8.1.2 is required software for installing GT4. But i cant get installation steps from anywhere.. Please help me and do reply Installing on windows is super easy, just run the MSI installer and follow

Re: [GENERAL] logging connections

2006-01-21 Thread Nikola Ivanov
You need to edit your postgresql.conf file and in the "Error reporting and logging" section set "log_connections=true", "log_disconnections=true", and "log_hostname=true" On 1/20/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote: i want to know, how i can log connections to postgres. the sampl

Re: [GENERAL] RAID 5 and postgresql

2006-01-21 Thread Sander Steffann
Hi, I would suppliment this with just saying that your controller card is your performance, the only cards I've seen score well on linux, and people have expressed on this list for SCSI are the LSI card, for SATA, LSI, 3ware (now AMCC) and Areca claim good linux support and seem to work well. St

Re: [GENERAL] standard normal cumulative distribution function

2006-01-21 Thread Michael Fuhr
On Fri, Jan 20, 2006 at 04:54:00PM -0700, Michael Fuhr wrote: > On Sat, Jan 21, 2006 at 12:00:49AM +0100, SunWuKung wrote: > > Does somebody have/know of a function for pg returning the standard > > normal cumulative distribution for a Z score? > > Are you looking for something like this? > > te

Re: [GENERAL] Creation of tsearch2 index is very slow

2006-01-21 Thread Stephan Vollmer
Tom Lane wrote: > The problem seems to be mostly tsearch2's fault rather than the general > GIST code. I've applied a partial fix to 8.1 and HEAD branches, which > you can find here if you're in a hurry for it: > http://archives.postgresql.org/pgsql-committers/2006-01/msg00283.php > (the gistidx.

Re: [GENERAL] mac os x compile failure

2006-01-21 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > Unfortunately I don't have a recent-enough version of bison on the > 10.2 machine and can't get bison-1.875 or bison-2.1 to compile so I > can't install from CVS. I'll definitely check when 8.1.3 is released. That's odd --- AFAIR I've never had

[GENERAL] optimizing server for a 10 million row table

2006-01-21 Thread Tony Caduto
Hi, we have a client that has a table that holds transactions from sales and it is now at 10 million rows. it was in MS Access and they could only hold 2 million rows, so we installed Postgres for them and they dumped 10 million rows from the mainframe into Postgres. I was just wondering if a

[GENERAL] numeric data type?

2006-01-21 Thread Zlatko Matić
Is "numeric" data type good choice for a field that would store integer values in most cases, but sometimes decimal values as well? Thanks,   Zlatko  

Re: [GENERAL] Is there a way to list running queries

2006-01-21 Thread Gregory S. Williamson
Frank Church caused electrons to display this: > > Is there a way to list running queries in PostgreSQL, especially those that > appear to have gone away or don't seem to be running at all? You should always include relevant info such as which version of postgres you are using. If the stats are

[GENERAL] Is there a way to list running queries

2006-01-21 Thread frank church
Is there a way to list running queries in PostgreSQL, especially those that appear to have gone away or don't seem to be running at all? This message was sent using IMP, the Internet Messaging Program. ---

Re: [GENERAL] mac os x compile failure

2006-01-21 Thread Michael Glaesemann
On Jan 18, 2006, at 9:17 , Michael Glaesemann wrote: On Jan 18, 2006, at 4:56 , Tom Lane wrote: I'll try to see that this gets fixed for PG 8.1.3, but in the short run you might be best off to update your OS X installation, or revert to PG 8.0.* which doesn't try to use FULLFSYNC at all.