[GENERAL] Postgres Tool Question

2000-05-09 Thread Samuel A. Mullen
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

Re: [GENERAL] USMARC and postgresql?

2000-05-09 Thread Brett W. McCoy
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 help,

Re: [GENERAL] Postgres Tool Question

2000-05-09 Thread Samuel A. Mullen
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

[GENERAL] 7.0 RPM?

2000-05-09 Thread J. Atwood
I have been looking around for the RPM for 7.0 anyone have a quick link? Thanks, J

Re: [GENERAL] Problems compiling version 7

2000-05-09 Thread Tom Lane
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 this in

RE: [GENERAL] Query bombed: why?

2000-05-09 Thread Jeff Eckermann
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] Query bombed: why?

2000-05-09 Thread Tom Lane
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 unmatched

[GENERAL] textpos() function

2000-05-09 Thread Hitesh Patel
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

[GENERAL] Re: [SQL] Mail problems

2000-05-09 Thread The Hermit Hacker
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 I'm scanning

Re: [GENERAL] 7.0 RPM?

2000-05-09 Thread Karl DeBisschop
"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

Re: [GENERAL] Problems compiling version 7

2000-05-09 Thread Travis Bauer
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] Problems compiling version 7

2000-05-09 Thread Tom Lane
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

Re: [GENERAL] textpos() function

2000-05-09 Thread Tom Lane
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 this

Re: [GENERAL] 7.0 RPM?

2000-05-09 Thread Tom Lane
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