-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
-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
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
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)-
<[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?
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
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
<[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
>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
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
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
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
|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
13 matches
Mail list logo
