Re: [GENERAL] upgrade to 7.0 using RPM

2000-05-17 Thread Lamar Owen
Paul Condon wrote: I am attempting to migrate to 7.0 using the RPMs that were recently announced. I use rpm -Uvh file name During the processing of several of the RPMs I get a message: /sbin/ldconfig: warning: /usr/lib/libnewt.so.0.50 is not a symlink What does this mean? Should I be

[GENERAL] pg_dump return failed sanity check

2000-05-17 Thread Patrick Robin
Hi, When I try to use pg_dump, I get this error. Can it have something to do with a custom type I added. I made sure I added the input/output functions and comparision functions for sorting and queries. The type works fine in SQL queries in general. pg_dump -s scm \connect - d23adm failed

[GENERAL] Re: PostgreSQL General Digest V1 #156

2000-05-17 Thread Paul Condon
I don't know the internals of PostgreSQL, but logically INTERSECT is a join, but with an automatic default generation of the WHERE clause. As such, there should not be any difference in performance on tables that are large enough to mask small differences in the time it takes to parse the

[GENERAL] line type

2000-05-17 Thread mikeo
hi, we're looking at migrating from ORACLE to postgres in the very near future and we've run into a small problem. there's a data type defined "LINE". we have named one of our tables as "LINE" also and it would require a great deal of code changes to rename that table. is it possible to

[GENERAL] advice on holding mail

2000-05-17 Thread Robert Wagner
Dear All, I'll be away for a few weeks... can anyone tell me how to switch my mail from this mailing list off for the duration, and how to switch it to digest mode on my return? Thanks much Rob

[GENERAL] BLCKSZ

2000-05-17 Thread Robert B. Easter
If I set the block size from 8k to 16k by editing /include/config.h, then all tuples will take up 16k on disk? If true, it just wastes lots of disk space if you are really not going to be storing more than 8k in most tuples? -- Robert B. Easter [EMAIL PROTECTED]

Re: [GENERAL] BLCKSZ

2000-05-17 Thread Ross J. Reedstrom
On Wed, May 17, 2000 at 02:53:17PM -0400, Robert B. Easter wrote: If I set the block size from 8k to 16k by editing /include/config.h, then all tuples will take up 16k on disk? If true, it just wastes lots of disk space if you are really not going to be storing more than 8k in most tuples?

[GENERAL] initdb and exit_nicely...

2000-05-17 Thread Jeffery Collins
I believe there is a bug, or at least a not very nice feature in initdb. If initdb does not succeed, it attempts to "exit_nicely". By default this involved deleting the $PGDATA directory!! So if you have put other things in you $PGDATA directory or (as in my case) you attempt to create a

[GENERAL] why so big?

2000-05-17 Thread Joseph Shraibman
I've just created a new database and I am wondering... Why are all sequence files 8K? They're one freaking int. How come the indexes are so large? They tend to be larger than the database files themselves. In one case I have a 16K index on an empty table. -rw---1 postgres

Re: [GENERAL] why so big?

2000-05-17 Thread Len Morgan
-Original Message- From: Joseph Shraibman [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, May 17, 2000 4:33 PM Subject: [GENERAL] why so big? I've just created a new database and I am wondering... Why are all sequence files 8K? They're one freaking int. How

Re: [GENERAL] 7.0 psql, readline and history.

2000-05-17 Thread Peter Eisentraut
Jeffery Collins writes: Wanna' bet? Perhaps I had an even older version? FWIW, it turns out that mine is actually 2.2.1. I don't know alot about the readline library, but perhaps it would be sufficient to check for the presence of "using_history" in the library and not bother to check for

Re: [GENERAL] initdb and exit_nicely...

2000-05-17 Thread Peter Eisentraut
Jeffery Collins writes: It seems like it would be a whole lot "nicer" if initdb only deleted the files that it attempted to create OR if the default was not to delete anything. Okay, I could go for the former. What do others think? -- Peter Eisentraut Sernanders väg 10:115

[GENERAL] getting libperl.so

2000-05-17 Thread Travis Bauer
I'd like to write some functions in embedded perl. I have installed Mandrake from the RPMS recommended on this list a few days ago ( They worked great, by the way). I have also downloaded the source so I can compile plperl.so. But I can't because appearantly libperl.so is not configured

Re: [GENERAL] initdb and exit_nicely...

2000-05-17 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: It seems like it would be a whole lot "nicer" if initdb only deleted the files that it attempted to create OR if the default was not to delete anything. Okay, I could go for the former. What do others think? It'd be a bit of a pain but I can see

Re: [GENERAL] Does Psql support Chinese?

2000-05-17 Thread Tatsuo Ishii
I want to build a database in chinese. But when I input chinese in the linux psql client , it doent's display well. So how can I solve it? Does your cat command show your Chinese texts correctly? If not, that might not be a PostgreSQL problem. BTW, what kind of encoding are you using for

Re: [GENERAL] getting libperl.so

2000-05-17 Thread Tom Lane
Travis Bauer [EMAIL PROTECTED] writes: compile plperl.so. But I can't because appearantly libperl.so is not configured properly on my machine. I'm using Mandrake 7.0, and the only copy of libperl.so that I can find is in: /usr/lib/apache (thanks to the mod-perl rpm). Probably your main

Re: [GENERAL] initdb and exit_nicely...

2000-05-17 Thread Bruce Momjian
A slightly more reasonable example is where the admin has already inserted his own pg_hba.conf in the directory; would be nice if initdb didn't overwrite it (nor delete it on failure), but I'm not sure it's worth the trouble. I am inclined to leave it as is too. I can imagine many bug

[GENERAL] RE: 7.0 psql, readline and history.

2000-05-17 Thread Michael S. Kelly
Thanks Jeff. I'm the guy that started that thread. Been meaning to get back to the problem but had other issues on the project. Now I know what to do next. Appreciate your posting the solution. -=michael=- * * Michael S. Kelly * 4800 SW

Re: [GENERAL] getting libperl.so

2000-05-17 Thread Karl DeBisschop
Tom Lane wrote: Travis Bauer [EMAIL PROTECTED] writes: compile plperl.so. But I can't because appearantly libperl.so is not configured properly on my machine. I'm using Mandrake 7.0, and the only copy of libperl.so that I can find is in: /usr/lib/apache (thanks to the

Re: [GENERAL] getting libperl.so

2000-05-17 Thread Karl DeBisschop
Tom Lane wrote: Karl DeBisschop [EMAIL PROTECTED] writes: or 'ar -a libperl.a' into a directory then gcc the resulting .o files into a single libperl.so That will only work on platforms where code is compiled position-independent by default. Yes. Such seems to be the case for RedHat