[GENERAL] test

2004-02-14 Thread mike
None of my mail messages seem to be getting through to the list, so this is a test ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] Freelance postgresql related jobs

2004-02-14 Thread David Costa
Hello, I manage a small albeit promising website (not for profit, no ads, no subscriptions) dedicated to PHP Development (http://www.dotgeek.org) I am currently interested in contracting some freelance postgresql related jobs: a) I would like to offer a binary easy to install version of postgre

[GENERAL] postgresql system column errors

2004-02-14 Thread Ashish Mahabal
Hello Hiroshi, When I try to use the column name xmin in one of my tables I get ERROR: column name "xmin" conflicts with a system column name You seem to have been affected by these errors in the past too. Had you found a solution? Anybody else have any solutions? Cheers, ashish Ashish Mahab

Re: [GENERAL] sybase->postgresql

2004-02-14 Thread Ashish Mahabal
> Easiest way? Use perl to pull from Sybase and build a COPY-formatted file. > Then have perl log into postgres and load the file. Seems awkward, but it's > actually *much* faster than other methods. We do this for a 1GB Sybase > database for one client on a nightly basis; takes about 40 minu

[GENERAL] SQL99 IGNORE

2004-02-14 Thread Jackson Miller
I notice that postgres does not support IGNORE. I am currently migrating an app from a MySQL datastore to Postgres, and I would really like to use IGNORE. I am curious if there is a recommended work-araound. Thanks, -Jackson ---(end of broadcast)

Re: [GENERAL] book for postgresql

2004-02-14 Thread Stephen Howard
also, as much as i really like o'reilly books in general, i find the index in this one quite lacking. Benjamin Jury wrote: -Original Message- From: Christopher Browne [mailto:[EMAIL PROTECTED] Sent: 10 February 2004 01:57 To: "[EMAIL PROTECTED]"@postgresql.org Subject: Re: [GENERAL] book

[GENERAL] Index storage question...

2004-02-14 Thread Joe Maldonado
Hello all, I am in the process of planning disk utilization for postgres and was wondering what was the storage size was for btree, rtree and hash indexes. Thanks, -Joe -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ ---(end of broadcast)-

[GENERAL] Schizophrenic design and solution to it

2004-02-14 Thread nobody
I have a database which design I inherited. It is not PostgreSQL but I hope somebody here could help. There are two tables "RemovalProject" and "Carriage. Both are 90 percent equal and basicaly represent a transport job. I need to extend the database to handle allocation of labour to both Removal

Re: [GENERAL] Providing the password to psql from a script

2004-02-14 Thread Martijn van Oosterhout
On Sat, Feb 14, 2004 at 05:11:14PM +0100, Willem Herremans wrote: > I have used the Tcl command > >set psqlChannel [open "|psql $dbname" RDWR] > > to create a channel that effectively becomes the input/output channel > for psql. By writing to that channel, SQL statements are sent to psql, >

Re: [GENERAL] Quad Xeon vs. Dual Itanium

2004-02-14 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Andrew Sullivan) wrote: > On Fri, Feb 13, 2004 at 12:19:39PM -0500, Bruce Momjian wrote: >> 64-bits isn't faster than 32, and can be slower because of the longer >> pointer length, decreasing cache performance. The major advantage to >>

Re: [GENERAL] Quad Xeon vs. Dual Itanium

2004-02-14 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Dann Corbit") would write: > Available memory is huge (e.g. you buy a machine with 24 gigs of ram) Actually, as soon as 2GB of memory starts to feel "restrictive," 64 bit addressing starts being at least nominally worthwhile. The only wa

Re: [GENERAL] Quad Xeon vs. Dual Itanium

2004-02-14 Thread Christopher Browne
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Dann Corbit") wrote: >> -Original Message- >> From: Andrew Sullivan [mailto:[EMAIL PROTECTED] >> Sent: Friday, February 13, 2004 9:05 PM >> To: [EMAIL PROTECTED] >> Subject: Re: [GENERAL] Quad Xeon vs. Dual Itanium >> >> On Fr

[GENERAL] nonblocking libpq large object access?

2004-02-14 Thread David Helgason
I was just wondering whether this was either: - supported, or - doable, either - using the normal poll-read-done? loop - a settable timeout It would be awfully nice. David Helgason, Over the Edge Entertainments ---(end of broa

Re: [GENERAL] Quad Xeon vs. Dual Itanium

2004-02-14 Thread Lincoln Yeoh
At 09:30 PM 2/13/2004 -0800, Dann Corbit wrote: > Well, unless the Postgres cache is more efficient than the OS's, no?. > You could then use the nocache filesystem option, and just > let Postgres handle the whole thing. Of course, that's a > pretty big unless, and not one that I'm volunteering to