[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 hast thou laid the foundation of the \ \_/| earth: and the heavens [are] the work of thy | | hands.| |Psalms 102:24 | \___/
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 help, sorry. The MARC format is really intended to be used in a full-text search environment, such as the old online systems like Dialog or Lexix-Nexis use (although they don't use MARC specifically). They all predate SQL and mapping one onto the other is not an easy task. It's easy to go from a SQl database to one of the variable-length (or 80 column card image) text-formats, but not the other way around unless you are into doing some text-processing programming. Brett W. McCoy http://www.chapelperilous.net --- If the very old will remember, the very young will listen. -- Chief Dan George
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 as that little MS Access comment goes. It took me a long time to find a job where I just use Linux, I don't want to regress to Windows. :) Sam "Brett W. McCoy" wrote: 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 to PostgreSQL via MS-Access and generate reports out of that also. Brett W. McCoy http://www.chapelperilous.net --- If the very old will remember, the very young will listen. -- Chief Dan George -- _ / Samuel A. Mullen \ | Programmer Analyst |___ | Opportunities Unl. | Great deliverance giveth he to his king; and \ \_/| showeth mercy to his anointed, to David, and | | to his seed for evermore. | |Psalms 18:49 | \___/
[GENERAL] 7.0 RPM?
I have been looking around for the RPM for 7.0 anyone have a quick link? Thanks, J
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 this in Red Hat 6.0 Weird. Do you not have 'tr' in your PATH? You wouldn't be running with some bizarre LOCALE setting, by any chance? regards, tom lane
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 Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 09, 2000 12:35 PM To: Jeff Eckermann Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Query bombed: why? Jeff Eckermann [EMAIL PROTECTED] writes: After about 25 minutes of running a query with a "where not exists 'correlated subquery'", I got a whole bunch of lines printing out: "Backend sent D message without prior T". Could someone give me an idea of what that means, and how to deal with it? How many rows were you expecting the query to produce? (It might be worth redoing it as a SELECT count(*) FROM ... to find out how many it really produced.) My first bet is that your frontend application ran out of memory while trying to absorb the query result. libpq is designed to collect the whole result before handing it back to the application, which is nice for some things but starts to look like a bad idea when you have a huge query result. Also, libpq doesn't react very gracefully to running out of memory :-( --- the symptoms you describe sound like one likely failure mode. (We need to fix that...) You might be able to increase your process memory limit; otherwise, consider using DECLARE CURSOR and FETCH to retrieve the query result a few hundred rows at a time. regards, tom lane
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 unmatched entries... Certainly 70 rows are not going to strain memory ;-). My guess is that the query didn't do what you thought, but instead produced some sort of cross-product result... regards, tom lane
[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 else (i found strpos() but i'm not sure if that does exactly the same thing). -- |-|| | Hitesh Patel| Voice: (541) 759-3126 | | | Fax: (541) 759-3214 | | Preferred Communications Inc. | Email: [EMAIL PROTECTED] | |-||
[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 I'm scanning the mail archives for anything of interest. If someone feels I've missed something, give me a kick. Jan -- #==# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #== [EMAIL PROTECTED] # I haven't been able to subscribe to the digest. I get the following error: subscribe pgsql-sql-digest Illegal list "pgsql-sql-digest". No valid commands processed. I am subscribed to the general mailing list however. The whole subscription thing changed over a month ago ... there is no longer a '-digest' list to subscribe to. Instead, you have to subscribe to the central list and then change your state to 'digest' ... I *believe* that: subscribe-digest pgsql-sql will do it all in one step now ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
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 http://www.ramifordistat.net/postgres/beta/SRPMS - I've really added nothing (though I expect to have build of the plperl procedural language by tomorrow). In fact I'd guess that the reason I can post this before Lamar is because he is trying to improve the existing RPMS, whereas I just wanted to start running 7.0 on some development machines as soon as possible. Testing is limited, but I've deployed this successfully. He has SRPMs for RC5 at his site, but not the final yet. 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. Karl DeBisschop
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 On Tue, 9 May 2000, Tom Lane wrote: 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 Red Hat 6.0 Weird. Do you not have 'tr' in your PATH? You wouldn't be running with some bizarre LOCALE setting, by any chance?
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-ASCII locales would be a better reference than I. But the critical bit here is the part of configure.in that's trying to find the right platform-specific tr invocation: dnl Check tr flags to convert from lower to upper case TRSTRINGS="`echo ABCdef | $TR '[[a-z]]' '[[A-Z]]' 2/dev/null | grep ABCDEF`" TRCLASS="`echo ABCdef | $TR '[[:lower:]]' '[[:upper:]]' 2/dev/null | grep ABCDEF`" if test "$TRSTRINGS" = "ABCDEF"; then TRARGS="'[[a-z]]' '[[A-Z]]'" elif test "$TRCLASS" = "ABCDEF"; then TRARGS="'[[:lower:]]' '[[:upper:]]'" else AC_MSG_ERROR("Can\'t find method to convert from upper to lower case with tr") fi (hmm ... the error message is exactly backwards from what's actually being tested, isn't it? Minor point but...) Anyway, try these out and see what's happening with your 'tr'. Note that the apparently doubled square brackets are a quoting artifact of autoconf --- you should actually test [a-z] and so on, not [[a-z]]. The really silly bit is that configure.in has several other invocations of tr that pay no attention at all to the results so painfully extracted (or mis-extracted) here. So it kinda looks to me like we could rip out this test, hardwire the translation as tr '[a-z]' '[A-Z]' and be no worse off. Does anyone recall why this test is in there to begin with? regards, tom lane
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 this function or has it been renamed to something else (i found strpos() but i'm not sure if that does exactly the same thing). Looks like it's called position() now --- that function has the same OID (849) as 6.5's textpos(), and even more damningly points to a C function that's still called textpos(): regression=# select oid,* from pg_proc where oid=849; oid | proname | proowner | prolang | proisinh | proistrusted | proiscachable | pronargs | proretset | prorettype | proargtypes | probyte_pct | properbyte_cpu | propercall_cpu | prooutin_ratio | prosrc | probin -+--+--+-+--+--+---+ --+---++-+-+ +++-+ 849 | position | 256 | 11 | f| t| t | 2 | f | 23 | 25 25 | 100 | 0 | 1 | 0 | textpos | - (1 row) We've made a number of changes in 7.0 to bring function and type names into alignment with the SQL92 standard. The incompatibilities I knew about were in date/time types and functions, but I guess this is another one ... If you really don't want to update your app's code just yet, you can install a pg_proc entry that defines textpos() with a CREATE FUNCTION command. But the long-term answer is to fix your code to conform with the standard. regards, tom lane
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 pg_upgrade to update from any 6.5-or-later version if you are feeling adventurous, but I'd definitely suggest making a backup first in case things go wrong and you have to initdb and restore. regards, tom lane