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

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 fo

[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

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

|I'm trying to run a query on a database using php and postgres functions || $row[0]"); } ?> but I get these error messages. I have tested to see if the connection is still alive and it is. || *Warning*: pg_exec(): supplied argument is not a valid PostgreSQL link resource in */var/www/html/Datab

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 CLUSTER

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 want

[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 b

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

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?

[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 broadcast)-

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 May

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 a

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 whi