473,889 Members | 1,388 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Is my MySQL Gaining ?

Dear all,

Their was a huge rore about MySQL recently for something in java functions
now theirs one more

http://www.mysql.com/doc/en/News-5.0.x.html

Does this concern anyone.

What I think is PostgreSQL would have less USP's (Uniqe Selling Points
though we dont sell) now.

What do you think yes we PostgreSQL users need some introspection.

Regards,
Vishal Kashyap.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05
175 11562
Le Dimanche 28 Décembre 2003 06:45, D. Dante Lorenso a écrit :
As a plug, though ... I'm hooked on EMS PostgreSQL Manager 2.0. *I'd have
to say that I'd not be as much of a PostgreSQL supporter if it weren't for
this client tool. *I think EMS did the 'making it friendly to the
developer' that was sorely lacking in stock PostgreSQL client tools.
*Kudos.


You can also have a look at pgAdmin visiting http://www.pgadmin.org.
Best regards, Jean-Michel
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 12 '05 #171
I recommend EMS PostgreSQL Manager as well. When I decided to migrate my
databases away from MS SQL Server, I narrowed my alternatives to MySQL or
PostgreSQL. I was leaning towards PostgreSQL because it was obviously more
robust and feature-rich, however MySQL has far more third-party tool
support (and a pretty slick marketing effort). It was the EMS products
that decided for me. I used their PG DataPump to migrate the databases,
which saved me countless days of work. And I use their PG Manager product
for development. For the record, I also use pgAdmin III. Both tools have
their strengths. I particularly like the visual database designer feature
that EMS added to version 2.

My 2 cents... :)

At 02:33 PM 11/01/2004 +0100, Jean-Michel POURE wrote:
Le Dimanche 28 Décembre 2003 06:45, D. Dante Lorenso a écrit :
As a plug, though ... I'm hooked on EMS PostgreSQL Manager 2.0. I'd have
to say that I'd not be as much of a PostgreSQL supporter if it weren't for
this client tool. I think EMS did the 'making it friendly to the
developer' that was sorely lacking in stock PostgreSQL client tools.
Kudos.


You can also have a look at pgAdmin visiting http://www.pgadmin.org.
Best regards, Jean-Michel
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org


_______________ _______________ _______
Rivendell Software - Dynamic Web Solutions
http://www.rivendellsoftware.com
Tel 902.461.1697
Fax 902.461.3765

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #172
Hi,
I am getting the following error when running an update from a JAVA
program using a Tomcat Connection Pool.

SQLException: Error Relation 215106760 does not exist

In the server log I see additional info Error occured while executing
PL/pgSQL function funcName
line 105 at select into variables

I dont think that the Function has a problem as I am able to run it with
the same parameters from within psql returning me a result.

The strange thing is that it works for a couple of day. Once I restart
tomcat the problem goes away... for a few days. Although I use many
objects from the same Servlet, only this particular PL/pgSQL function
has a problem.
Question:
1. Is that problem known in PG7.3.4?
2. Could this be a problem with the connection pool of tomcat or the
postgres JDBC driver ?
3. how do i find out the name of the actual object referred by 215106760
in the error message?

Thanks for any help

Alex



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 22 '05 #173


On Tue, 20 Jan 2004, Alex wrote:
Hi,
I am getting the following error when running an update from a JAVA
program using a Tomcat Connection Pool.

SQLException: Error Relation 215106760 does not exist

In the server log I see additional info Error occured while executing
PL/pgSQL function funcName
line 105 at select into variables
This error is likely the result of using a temp table without EXECUTE or
having one of your tables dropped (recreating it won't help). plpgsql
caches query plans, but doesn't track the plans dependencies, so if any of
the underlying objects change you can get this error.
2. Could this be a problem with the connection pool of tomcat or the
postgres JDBC driver ?
The plans are cached once per backend, the connection pool keeps that same
backend open forever which means you can never safely change your
schema without restarting the pool.
3. how do i find out the name of the actual object referred by 215106760
in the error message?


SELECT relname FROM pg_class WHERE oid = 215106760;

Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #174
Kris,
thanks for the reply. I dont actually use temp tables in the function
(not that I know of) but I did truncated and reloaded a few tables incl.
recreating indices the previous day, however the line no. indicated in
the serverlog does not point to these sql calls.

I am now re-starting tomcat every night which is not a bad thing anyway
but still am wondering what the real reason could be.

Alex

Kris Jurka wrote:
On Tue, 20 Jan 2004, Alex wrote:
Hi,
I am getting the following error when running an update from a JAVA
program using a Tomcat Connection Pool.

SQLExceptio n: Error Relation 215106760 does not exist

In the server log I see additional info Error occured while executing
PL/pgSQL function funcName
line 105 at select into variables


This error is likely the result of using a temp table without EXECUTE or
having one of your tables dropped (recreating it won't help). plpgsql
caches query plans, but doesn't track the plans dependencies, so if any of
the underlying objects change you can get this error.
2. Could this be a problem with the connection pool of tomcat or the
postgres JDBC driver ?


The plans are cached once per backend, the connection pool keeps that same
backend open forever which means you can never safely change your
schema without restarting the pool.
3. how do i find out the name of the actual object referred by 215106760
in the error message?


SELECT relname FROM pg_class WHERE oid = 215106760;

Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 22 '05 #175


On Wed, 21 Jan 2004, Alex wrote:
Kris,
thanks for the reply. I dont actually use temp tables in the function
(not that I know of) but I did truncated and reloaded a few tables incl.
recreating indices the previous day, however the line no. indicated in
the serverlog does not point to these sql calls.

I am now re-starting tomcat every night which is not a bad thing anyway
but still am wondering what the real reason could be.


The reason is probably the recreation of the indexes. When a plpgsql
procedure is first executed it takes the queries in it, plans them, and
saves that query plan so that every time afterward the procedure just uses
the stored plan. The problem is that one of the plans depended on one of
the indexes. When the index was dropped the procedure tried to run a plan
that was no longer valid, generating the error you saw. Restarting tomcat
closes and reopens the connection to the database, so the query in the
procedure gets replanned to use the new index and things run smoothly.

Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 22 '05 #176

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.