Re: [GENERAL] RHEL

2003-11-11 Thread Adam Haberlach
, or is this not necessary? -- Adam Haberlach | We spent the 90's all trying to figure out [EMAIL PROTECTED] | how to get email and the 00's trying to http://mediariffic.com | figure out how to not get email. | -- Joe Gross ---(end

Re: [GENERAL] RHEL

2003-11-11 Thread Adam Haberlach
On Tue, Nov 11, 2003 at 04:03:44PM -0800, Rich Shepard wrote: On Tue, 11 Nov 2003, Adam Haberlach wrote: On that note, does anyone have suggestions for which version of the server I should run? I see that there are seperate binary RPMS for different Linux versions, but nothing

Re: [GENERAL] 7.1 on Solaris 8 run failure?

2001-04-15 Thread Adam Haberlach
it fails for what I would expect to be a common reason for those of us that are used to out-of-the-box Linux installs and are becoming more and more frustrated with Sun's silly defaults? -- Adam Haberlach| [EMAIL PROTECTED] | http://youlook.org http://www.newsnipple.com | '88

Re: [GENERAL] quota's ?

2001-04-07 Thread Adam Haberlach
out of space. I think this has been fixed, but you might wanna check with hackers or release nots. -- Adam Haberlach| [EMAIL PROTECTED] | http://youlook.org http://www.newsnipple.com | '88 EX500'00 ^ | ---(end of broadcast

Re: [GENERAL] Convert Filemaker Pro db to Postgresql db

2001-04-07 Thread Adam Haberlach
dealing with the breakage (we had some greater-then-8k tuples that I had to sort out). Other options, as people have mentioned, would be ODBC, but we found that this worked better. And that FileMaker sucks. -- Adam Haberlach| [EMAIL PROTECTED] | http://youlook.org http

[GENERAL] Out of date security docs

2001-03-27 Thread Adam Haberlach
jolly= /***/ -- Adam Haberlach| [EMAIL PROTECTED] | http://youlook.org http://www.newsnipple.com | '88 EX500'00 ^ | ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Max username/password length

2001-03-26 Thread Adam Haberlach
Anyone know the max username/password length for Postgres? -- Adam Haberlach| [EMAIL PROTECTED] | http://youlook.org http://www.newsnipple.com | '88 EX500'00 ^ | ---(end of broadcast)--- TIP 6: Have you

Re: [GENERAL] ...lame use of casting, looking for workaround...

2001-02-24 Thread Adam Haberlach
On Sat, Feb 24, 2001 at 11:16:49AM +, Richard Huxton wrote: Adam Haberlach wrote: One of the rocket scientests working on this project has created a system in which /either/ a description or a build number is stored in a text field. He has been writing reports Get

Re: [GENERAL] Foreign Keys

2001-02-05 Thread Adam Haberlach
On Thu, Feb 01, 2001 at 07:59:16PM -0500, No Name wrote: I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to be the problem? Your database is too purple. -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate

Re: [GENERAL] trying to back up a database

2001-02-01 Thread Adam Haberlach
On Wed, Jan 31, 2001 at 11:27:18PM +, Oliver Elphick wrote: Adam Haberlach wrote: I'm trying to back up a database, including the user records. If I use pg_dump, I can get the table, but I cannot seem to be the user information. pg_dump -d database dump should copy

Re: [GENERAL] php as stored procedures

2001-02-01 Thread Adam Haberlach
to execute arbitrary functions via plug-ins. I studied computer engineering and not computer science, but I'm pretty sure this makes them functionally equivalent, so you are both right. -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep

[GENERAL]

2001-01-31 Thread Adam Haberlach
?) -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound desire for http://www.newsnipple.com |fish and an equally deep, passionate, and '88 EX500 |profound desire to avoid getting wet.

Re: [GENERAL] php as stored procedures

2001-01-31 Thread Adam Haberlach
own language or sub-PHP. I am, however, in no way volunteering for such a project. -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound desire for http://www.newsnipple.com |fish and an equally deep, passi

Re: [GENERAL] Wild Cards

2001-01-26 Thread Adam Haberlach
'; -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound desire for http://www.newsnipple.com |fish and an equally deep, passionate, and '88 EX500 |profound desire to avoid getting wet.

[GENERAL] Backing up large objects

2001-01-23 Thread Adam Haberlach
, or should I write my own dang script? -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound desire for http://www.newsnipple.com |fish and an equally deep, passionate, and '88 EX500 |profound desire to avoid

Re: [GENERAL] Spot the error in my plpgsql...

2001-01-17 Thread Adam Haberlach
On Wed, Jan 17, 2001 at 01:03:05PM +0100, Mirko Zeibig wrote: On Tue, Jan 16, 2001 at 12:22:28PM -0800, Adam Haberlach wrote: On Tue, Jan 16, 2001 at 12:58:41PM +0100, Mirko Zeibig wrote: On Mon, Jan 15, 2001 at 07:54:26PM -0800, Adam Haberlach wrote: I've got the following procedure

Re: [GENERAL] Spot the error in my plpgsql...

2001-01-16 Thread Adam Haberlach
On Tue, Jan 16, 2001 at 12:58:41PM +0100, Mirko Zeibig wrote: On Mon, Jan 15, 2001 at 07:54:26PM -0800, Adam Haberlach wrote: I've got the following procedure... DROP FUNCTION "blank_referring_devices" (); CREATE FUNCTION "blank_referring_devices" () RETURNS o

Re: [GENERAL] PHP and PostgreSQL

2001-01-05 Thread Adam Haberlach
having wildly dissimilar systems for iterating through result sets... In mysql there was no need to count rows. Let's not start the MySQL vs. Postgres wars again... :) -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and pro

Re: [GENERAL] Schema

2000-12-19 Thread Adam Haberlach
On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote: Somebody knows how to get a sql "schema" of a Postgresql database?? pg_dump -s -d dbname -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profo

Re: [GENERAL] UNION within VIEW workarounds?

2000-12-07 Thread Adam Haberlach
. Out of curiosity, what is the advantage, other then simplification of the query itself, of using a view over a straight select? -- Adam Haberlach |A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound for fish and http://www.newsnipple.com

Re: [GENERAL] OID and joins

2000-10-18 Thread Adam Haberlach
need to do that for some reason... -- Adam Haberlach|ASCII /~\ [EMAIL PROTECTED] | Ribbon \ / Against http://www.newsnipple.com | CampaignX HTML '88 EX500 |/ \ E-mail

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-10 Thread Adam Haberlach
tion" is really meaningless unless you are prepared to jump ship or split off in a clone of the original one. The code is what you do with it. We are all lucky that it is as good and useful as it is right now. -- Adam Haberlach| A billion hours ago, human life appeared

Re: [GENERAL] Trying to use PGSql with PHP

2000-10-08 Thread Adam Haberlach
configuration. At a guess, I would say that you are probably missing an .rpm for the postgres-client or pgsql-client, but that is based on my view dealings with Red Hat. -- Adam Haberlach| A billion hours ago, human life appeared on [EMAIL PROTECTED] | earth.

Re: Fw: [GENERAL] Talking with other Dbases.

2000-09-28 Thread Adam Haberlach
systems. I still reccommend going with one database solution, though. Much easier to set up, maintain, etc. I don't trust MySQL, so I'll let you guess which one I reccommend... -- Adam Haberlach| A billion hours ago, human life appeared on [EMAIL PROTECTED] | earth

Re: [GENERAL] one more word about rules

2000-09-22 Thread Adam Haberlach
the field is an int4. Perhaps you should store the date of the article in the database, and then sort by that. You can even set the default for the field to be now() so that it automatically gets set on insert, and you can override it during backdate inserts or with later updates... -- Adam

[GENERAL] Public Database of zip code information

2000-09-20 Thread Adam Haberlach
Sometime in the past year, someone mentioned a database that contained zipcode, lat/long, and city information--does anyone else remember this, or should I check into a drug clinic? I'm pretty much looking for a way to correlate zip, city, and/or geographic locations. -- Adam

www.postgresql.org web master

2000-03-14 Thread Adam Haberlach
not a web hacker, I just play one for QA database purposes), but it would be nice, for image purposes, if the page rendered correctly on at least Opera 4.0 if not NetPositive 2.0 -- Adam Haberlach |"Your stdio isn't very std. [EMAIL PROTECTED]| Your stdio looks like linux.&

Re: [GENERAL] What does this mean ?

1999-06-26 Thread Adam Haberlach
On Fri, Jun 25, 1999 at 05:01:29PM +0100, Mario Jorge Nunes Filipe wrote: Thomas Reinke wrote: You have already started a transaction and haven't yet finished it. E.g. psql template; BEGIN; BEGIN; Not that i don't believe you but i think that in my case that is a

Re: [GENERAL] Question about Linux, threads, and Postgres

1999-01-31 Thread Adam Haberlach
On Sat, Jan 30, 1999 at 09:08:14PM -0800, Felix Morley Finch wrote: Q 1: Does anyone have experience with Postgres in a threaded program? I have done a bit of this under BeOS (where each window gets its own event loop and thread). My first program turned out to have problems in my