[ADMIN] Strange error

1999-12-21 Thread Andy Lewis
I have a problem. First I had a drive error that I corrected and when I do a vacuum, I get the following: mydb=> vacuum; ERROR: OperatorObjectIdFillScanKeyEntry: unknown operator 93 Anyone know what I am susposted to do? I haven't the slightest idea of how to correct this one. Thanks Andy

Re: [ADMIN] Enormous pg_sorttemp~ files when using "OR"

1999-12-18 Thread Andy Lewis
This has also happened to me. I had another programmer write a query that was requesting a field from a table but, forgot to include the name of the table in the query. It was a 3 table query and he accidentally included a fourth table field but didn't add the table in the clause. I was suprised

[ADMIN] Authentication Problem

1998-10-30 Thread Andy Lewis
I'm running PHP 3.05 on a remote machine trying to make a connection to our Postgres 6.1 machine. Here's the error that I'm getting: - Warning: Unable to connect to PostgresSQL server: Failed to authenticate client as Postgres us

[ADMIN] Compiling with Perl Support [Solved]

1998-05-23 Thread Andy Lewis
I have fixed this problem. The docs should say that: --prefix=BASEDIR must be specified in order for the --with-perl directive to work. Otherwise it will fail. Sorry Andy ===

[ADMIN] Compiling with Perl Support

1998-05-23 Thread Andy Lewis
I am trying to build Postgres 6.3.2 on Linux. I would like to build using the "./configure --with-perl" directive. The docs say: --- --with-perlEnables the perl interface. Note that this requires an installed

Re: [ADMIN] postgresql-6.3.2 question

1998-05-17 Thread Andy Lewis
I'm not totall sure but, I wouldn't think that user postgres has enough system rights to install. Andy On Sat, 16 May 1998, The Hermit Hacker wrote: > >Hello, > >My question is this: > >Do I have to be user progres to install? Can I not use an existing user? If >yes, is there any change to the