[SQL] connection delay

I have a client made in java who interogate postgres using jdbc driver. If the tcp conection falls (for a few seconds) the client give an error message about that connection. How can I avoid this error? ---(end of broadcast)--- TIP 4: Don't 'kill -9

[SQL] sql

I have the following table structure: CREATE TABLE "xxx" ( "co" character varying(7), "co1" character varying(9), "n1" character varying(15), "l1" character varying(5), "m1" smallint, "ore" bigint ); who contains the following date: 22021CC 1044 637 S5G8 407 5 22021CC 1044 637 S5G8 409 47

[SQL] conversion of postgres database to oracle

How should I convert a postgres database to oracle?

Re: [SQL] FATAL 2: PageIndexTupleDelete

Yes, you right! I used pg_dump command and now is working. Thank you very much! PS. I have version 7.2.2 on RH 8.0 > > FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower =3D 12289, up= > > per =3D > > 1, special =3D 60672 > > > Why do I have this error message and how can I fix it? > >

[SQL] FATAL 2: PageIndexTupleDelete

salt=# vacuum full; FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower = 12289, upper = 1, special = 60672 server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. A

[SQL] sequence

What is wrong here? insert into table_name (field_name) values (select setval('sequence_name')-1) as currval); ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Blobs with perl

I want to insert a picture in a table from an internet browser using a script made in perl. Has somebody a code example with this kind a problem (I need only a code fragment)? Thanks! ---(end of broadcast)--- TIP 9: the planner will ignore your des

[SQL] Sorry, to many clients already

When I'm trying to connect I have this error message: Something unusual has occured to cause the driver to fail.Please report this exception: java.sql.SQLException: Sorry, to many clients already. What should I do? ---(end of broadcast)--- TIP 6

[SQL] sql

I have 3 tables.   table_a marca 15145 1455 1333   table_b data 11-01-2002 11-02-2002   table_c marca    data 15145    11-01-2002 15145    11-02-2002 1455 11-01-2002 1333  11-01-2002 1333  11-02-2002   After interogation of the tables I need this kind of result:   marca 

Re: [SQL] owner of type 'mmm' apperars to be invalid

On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > It shouldn't be this the solution of the problem? >> salt=# delete from pg_type where typname='refcursor'; >> DELETE 1 >> Now, I don't have the error message! > >Mr.Richard Huxton, thank you ver

Re: [SQL] owner of type 'mmm' apperars to be invalid

r message! Mr.Richard Huxton, thank you very much! Cristi On Tuesday 05 Nov 2002 11:55 am, cristi wrote: > I'm in this situation: > > salt=# select oid,typname,typowner from pg_type where typname='refcursor'; >oid| typname | typowner > --+--

[SQL] owner of type 'mmm' apperars to be invalid

  When I'm trying to make pg_dump on a data base I have this message: WARNING: owner of type 'mmm' apperars to be invalidWARNING: owner of type 'eee' apperars to be invalidWARNING: owner of type 'refcursor' apperars to be invalid Where are these object and how can I destroy its? 

Re: [SQL] how to continue a transaction after an error?

Multiple transactions carry a price: one cannot isolate the insertions from other sessions. This is not desirable in my case. The second suggestion is valuable. Thanks, Cristi - Original Message - From: Edmar Wiggers <[EMAIL PROTECTED]> To: Cristi Petrescu-Prahova <[EMAIL

[SQL] how to continue a transaction after an error?

commit/rollback command myself. How to do it? Is there any setting I am missing? Is it possible at all? Thanks, Cristi