Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: |Indicating that they should produce the same results, but that they work |differently. I am not sure what that implies, but maybe someone else knows ? | The only difference the docs are talking about is what kind of lock is | held

Re: [GENERAL] Cache lookup failure for pg_restore?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Razvan Surdulescu wrote: | After I restore a Postgres database (using pg_restore), I get the | following error message when I try to run a simple UPDATE query: | | ERROR: cache lookup failed for function 70529 Hi Razvan, Just to add to what Tom has

Re: [GENERAL] Cache lookup failure for pg_restore?

Recently, we discover how to avoid problem with OIDs backup/restore in tsearch2. Check http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ for a little patch (regprocedure_7.4.patch.gz). It won't work on existed tsearch2 installation, though, but will help in future. Oleg On Sun, 9

[GENERAL] Fwd: Favorite DB poll on ORA

Folks, We've been issued a challenge ... so Vote! Vote! Vote! - Hey Gents, You might want to rally the troops - http://www.oreilly.com/ - -- Josh Berkus Aglio Database Solutions San Francisco ---(end of

Re: [GENERAL] Slow network retrieves

[EMAIL PROTECTED] writes: I'm seeing what seems like slow retrieval times over the network. Are you sure it is a network problem? What performance do you get if you run the same test program locally on the database machine? How about issuing the same sort of FETCH commands via a psql script?

Re: [GENERAL] Slow network retrieves

On 5/9/04 9:32 AM, Tom Lane [EMAIL PROTECTED] wrote: Are you sure it is a network problem? What performance do you get if you run the same test program locally on the database machine? How about issuing the same sort of FETCH commands via a psql script? Yes, it is definitely due to the

[GENERAL] alter owner on schema?

Is there a way to change the owner of a schema (without deleting/recreating it)? __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover ---(end of

Re: [GENERAL] Slow network retrieves

[EMAIL PROTECTED] writes: On 5/9/04 9:32 AM, Tom Lane [EMAIL PROTECTED] wrote: Are you sure it is a network problem? Yes, it is definitely due to the network latency even though that latency is very small. Here it is running locally: [ about 2 records/sec ] Okay, I just wanted to

Re: [GENERAL] Partial index in other DB

Can anybody confirm whether these databases support partial indexes (and what are their term and syntax)? SQL Server 2000: I've glanced the T-SQL Reference and it seems it doesn't support it, though it supports indexing views. CLUSTERED index is not the same thing, right? No. A CLUSTERED

[GENERAL] full tuple count in cursor.

I have a cursor that i got from a select statement. I would like to know how many records are in the cursor so i dont go over the last one when using FETCH on the cursor. How can i do this? thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443

Re: [GENERAL] PL/Ruby

Hello David, thanks, changing to Ruby18 solved my problem after some manual passages with woodoo around the computer :) Best regards, Anton Nikiforov David Garamond wrote: Anton Nikiforov wrote: Thanks, David, but i did try this way already and in the case i build plruby like this i have the

Re: [GENERAL] alter owner on schema?

CSN wrote: Is there a way to change the owner of a schema (without deleting/recreating it)? No, I don't see a way to change the owner. You might be able to update the pg_namespace table to do this, but I am not sure. Of course, you can control the permissions on the schema easily with GRANT

[GENERAL] error messages (not valid postgresql link resoucre)

|I'm trying to run a query on a database using php and postgres functions ||?php db_connect(); $stat = pg_exec($connstr,SELECT WSID from tblWorkstation ); while ($row = pg_fetch_rows($stat)) { print(option $row[0]/option); } ? but I get these error messages. I have tested to see if the connection