Re: [GENERAL] 7.0 RPM?

Karl DeBisschop <[EMAIL PROTECTED]> writes: > If you do use these. plan on upgrading once Lamar releases his final. But > you should be able to do that without a dump/restore cycle, which was my > prime concern. 7.0RC5 is database-compatible with the final, earlier betas are *not*. You can use p

Re: [GENERAL] textpos() function

Hitesh Patel <[EMAIL PROTECTED]> writes: > I just upgraded to postgresql 7.0 and was restoring my data when I > noticed I had a function defined that used the builtin textpos() > function. This function was available in 6.5.3 but seems to have > dissapeared in 7.0.. Is there any way to restore t

Re: [GENERAL] Problems compiling version 7

Travis Bauer <[EMAIL PROTECTED]> writes: > I have tr version 1.22 (GNU texutils). It is located in /usr/bin, and is > found by my login shell (cshrc). That was a weak theory, but worth checking ... > How could I check the locale setting? echo $LOCALE I think --- someone who actually uses non

Re: [GENERAL] Problems compiling version 7

I have tr version 1.22 (GNU texutils). It is located in /usr/bin, and is found by my login shell (cshrc). How could I check the locale setting? Thanks, Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer --

Re: [GENERAL] 7.0 RPM?

"J. Atwood" wrote: > I have been looking around for the RPM for 7.0 anyone have a quick link? > > Thanks, > J not in any way official, but I did a cheap knock off of the 7.0RC1 rpms. You should be able to pick them up at karl.debisschop.net/src/postgres/ These are based on RPMs by Lamar Owen at

[GENERAL] Re: [SQL] Mail problems

On Tue, 9 May 2000, Merrill Oveson wrote: > Jan Wieck wrote: > > > Hi all, > > > > during the past hours I had severe problems with email. > > Somehow hub.org seemed to have forgotten my subscriptions to > > the PostgreSQL GENERAL, HACKERS and SQL lists. > > > > Actually

[GENERAL] textpos() function

I just upgraded to postgresql 7.0 and was restoring my data when I noticed I had a function defined that used the builtin textpos() function. This function was available in 6.5.3 but seems to have dissapeared in 7.0.. Is there any way to restore this function or has it been renamed to something

Re: [GENERAL] Query bombed: why?

Jeff Eckermann <[EMAIL PROTECTED]> writes: > I was expecting not much more than 50 rows to be returned, with an absolute > maximum of 70. > I was trying to simulate an outer join by using the "where not exists" > clause, so that I would get back my full list of 70 and be able to see the > unmatche

RE: [GENERAL] Query bombed: why?

Thanks for your reply. I was expecting not much more than 50 rows to be returned, with an absolute maximum of 70. I was trying to simulate an outer join by using the "where not exists" clause, so that I would get back my full list of 70 and be able to see the unmatched entries... > -Original

Re: [GENERAL] Problems compiling version 7

Travis Bauer <[EMAIL PROTECTED]> writes: > I'm getting an odd error in the configure scripts: > . . . > checking for gzcat... (cached) /usr/local/gnu/bin/gzcat > checking for perl... (cached) perl > configure: error: Can't find method to convert from upper to lower case > with tr > I'm compiling

Re: [GENERAL] New geographic types....

Franck Martin <[EMAIL PROTECTED]> writes: > As part of the Fmaps project (Fmaps.sourceforge.net), Eric Miller is > developing some new geographic types for Postgres. Cool! > We have several questions relating to the implementation of new types, > variable types, and especially how to index them.

[GENERAL] 7.0 RPM?

I have been looking around for the RPM for 7.0 anyone have a quick link? Thanks, J

Re: [GENERAL] Postgres Tool Question

I know I can use perl. I already do, but sometimes you want your reports to look a little cleaner than just plain old text. I know I could probably throw in some LaTeX or Groff, but I kinda wanted something a bit more user-friendly, I would also like something to develop complex reports. As far

Re: [GENERAL] Postgres Tool Question

On Tue, 9 May 2000, Samuel A. Mullen wrote: > Are there any tools for generating reports for Postgres? I searched > RedHat, Enterprise Linux, the HOWTO, and haven't found anything. http://www.perl.com :-) I think pgAccess has some report printing faciliites as well. You can always connect t

Re: [GENERAL] USMARC and postgresql?

On Tue, 9 May 2000, Andrew Sullivan wrote: > BLOBs. It's a pain, though, because building the indices against the > catalogue is difficult. I think, actually, that the PICK-based spproach is > better, but PICK is going away. Anyway, you likely need to talk to someone > about BLOBs. I can't he

[GENERAL] Postgres Tool Question

Are there any tools for generating reports for Postgres? I searched RedHat, Enterprise Linux, the HOWTO, and haven't found anything. Sam -- _ / Samuel A. Mullen \ | Programmer Analyst |___ | Opportunities Unl. | Of old ha

Re: [GENERAL] USMARC and postgresql?

On Tue, May 09, 2000 at 10:36:51AM +0100, [EMAIL PROTECTED] wrote: > Hi everybody, > I am looking for some help on how to use postgresql to organize > MARC bibliographic records. I am a beginner. Are there any sites > or projects that have already been started? > > Perhaps anyone knows where to

Re: [GENERAL] USMARC and postgresql?

On Tue, May 09, 2000 at 10:36:51AM +0100, [EMAIL PROTECTED] wrote: > Any information will help me a lot, Sorry, one other thing. There is a project around this: the Open Source Digital Library System project. See A -- Andrew Sullivan

[GENERAL] Physical data storage

Hi, Does anyone know where I could find a documentation describing physical storage format in Postgres ? Thanks Patrick Fiche

[GENERAL] USMARC and postgresql?

Hi everybody, I am looking for some help on how to use postgresql to organize MARC bibliographic records. I am a beginner. Are there any sites or projects that have already been started? Perhaps anyone knows where to find a series of SQL statements to create an usable database for holding bibl