On Fri, Aug 10, 2012 at 7:19 AM, Tom Lane wrote:
> Haifeng Liu writes:
> > I have a program running like a daemon, which analyze data and write to
> postgresql 9.1 on centos 5.8. There is only one connection between my
> program and the postgresql database, and I hope the connection may keep
> a
Haifeng Liu writes:
> I have a program running like a daemon, which analyze data and write to
> postgresql 9.1 on centos 5.8. There is only one connection between my program
> and the postgresql database, and I hope the connection may keep alive all the
> time. But I failed, the connection will
You could do a stored procedure for inserting into another table... Otherwise if
you want to get the result as a query, you could do something like,
Select field1, exp(field2) as expoffield2 from tablename1
Hope that helps,
Srini
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
The problem is resolved. OpenOffice doesn't edit tables without primary
key with any driver (I've tried JDBC,native OpenOffice, ODBC). But - the
primary key can't be ignored, when it is made on OID.
Greetings
Adam
Adam Radlowski wrote:
I'm using very often OpenOffice to administrate databases
Dear Adam,
I usualy do use the native driver for OpenOffice from
http://dba.openoffice.org/drivers/postgresql/index.html.
With this driver a lot of things do work out of the box which do need tweeking
with the JDBC driver.
Best regards
Ivo Rossacher
Am Dienstag, 5. Dezember 2006 12.09 schrieb
Adriaan Joubert wrote
>Dave Cramer wrote:
>>
>> On 23-Oct-06, at 9:49 AM, Adriaan Joubert wrote:
>>
>>> Hi,
>>>
>>> I've run into an intermittent problem with our code recently. We
>>> have the following set-up:
>>>
>>> table A : some data table
>>> table B : a history table for table A
>>>
>>
Sriram Dandapani wrote:
Autocommit is set to off once a connection is obtained from the jboss
pool. It is turned back on when it is closed (so that any idle
transactions are committed).
Don't know what to suggest then -- if autocommit is off then the JDBC
driver should be sending BEGIN before
FYI..I use the postgres8.1.404 jdbc driver
-Original Message-
From: Oliver Jowett [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 28, 2006 3:24 PM
To: Sriram Dandapani
Cc: pgsql-jdbc@postgresql.org; pgsql-admin@postgresql.org
Subject: Re: [JDBC] number of transactions doubling
Sriram
Autocommit is set to off once a connection is obtained from the jboss
pool. It is turned back on when it is closed (so that any idle
transactions are committed).
I had the following 2 lines in my postgres-ds.xml which I commented
Even after this, I am seeing twice the number of transactions.
Sriram Dandapani wrote:
The target table has triggers that route data to appropriate tables. The
tables to which data is routed has check constraints that do further
inserts. (All of this happens in 1 jdbc transaction)
I expect JDBC Batching to generate fewer transactions depending on
batch
On Tue, 2006-04-18 at 14:32 +0300, Achilleus Mantzios wrote:
> Thanx for your thoughts, but this would require touching
> 173 tables +
> 2,594 SQL statements in a sum of 324 programs (which sum into 125,085
> lines of code)
We did a very similar conversion to the one proposed here a couple of
ye
Hi, Achilleus,
Achilleus Mantzios wrote:
[schema trickery]
> Why do you think its ugly after all?
It is not ugly to split such things via schemas per se, but it is ugly
to use this schema trick together with a bunch of views, rules and
triggers to "upgrade" a legacy single-deployment application
O Markus Schaber έγραψε στις Apr 18, 2006 :
> Hi, Achilleus,
>
> Achilleus Mantzios wrote:
>
> > Now i am thinking of restructuring the whole architecture as:
> > - Create one EAR app for every mgmt company
> > - Create one DB USER for every mgmg company
> > - Create one SCHEMA (same as the USER
Hi, Achilleus,
Achilleus Mantzios wrote:
> Now i am thinking of restructuring the whole architecture as:
> - Create one EAR app for every mgmt company
> - Create one DB USER for every mgmg company
> - Create one SCHEMA (same as the USER) for every mgmt company
> (mgmtcompany1,mgmtcompany2,etc...
Is your client machine on the same machine as the database?
Your pg_hba.conf file needs to have an entry in it that covers your
client machine. It's not 100% clear from your post whether you've
achieved that or not (I think you've added your server to the
pg_hba.conf, not your client).
So i
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> Also, I found by re-indexing the pg_largeobject table the problem seems to
> have gone away.
Um. That's probably destroyed the evidence :-( ie gotten rid of
whatever weird state you'd gotten the index into. But if you have
any luck reproducin
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> I am putting a large object into my database using jdbc interface and using
> LargeObjectManager to do largeobject open, write and close. After several
> largeobject writes I get the following message
> 'failed to re-find parent-key in "pg_lar
This is 7.4.5. I'm not sure I can get it to happen on an empty database, the
database this is happening on has about 300 large objects, but I will try.
Also, I found by re-indexing the pg_largeobject table the problem seems to
have gone away.
Chris White
-Original Message-
From: Tom Lane
Functions can't have transactions inside of them
You need to start the transaction then call the function.
couple of questions though
why not use sequences ? Then you have no concurrency issues. They are
guaranteed to be incremented.
Also you can use select for update, instead of locking the en
On Wed, Apr 28, 2004 at 10:13:14 +0200,
Edoardo Ceccarelli <[EMAIL PROTECTED]> wrote:
> do you mean that, declaring an index serial, I'd never have to deal with
> incrementing its primary key? good to know!
That isn't what is happening. Serial is a special type. It is int plus
a default rule li
do you mean that, declaring an index serial, I'd never have to deal with
incrementing its primary key? good to know!
anyway in this particular situation I don't need such accurate
behaviour: this table is filled up with a lot of data twice per week and
it's used only to answer queries.
I could
do you mean that, declaring an index serial, I'd never have to deal with
incrementing its primary key? good to know!
Yep. You can use 'DEFAULT' as the value, eg:
INSERT INTO blah (DEFAULT, ...);
anyway in this particular situation I don't need such accurate
behaviour: this table is filled up wit
I am going to use them as primary key of the table, so I'll surely need
them unique :)
Eduoardo, I REALLY suggest you don't use them at all. You should make a
primary key like this:
CREATE TABLE blah (
id SERIAL PRIMARY KEY,
...
);
Also note that by default, OIDs are NOT dumped by pg_dump.
I am going to use them as primary key of the table, so I'll surely need
them unique :)
thank you for you help
Edoardo
Dave Cramer ha scritto:
Edoardo,
Are you using them for referential integrity? If so you would be wise to
use sequences instead.
Christopher: yes you are correct, I wasn't sur
Edoardo,
Are you using them for referential integrity? If so you would be wise to
use sequences instead.
Christopher: yes you are correct, I wasn't sure if that is what he was
doing.
Dave
On Tue, 2004-04-27 at 11:01, Christopher Kings-Lynne wrote:
> > AFAIK, oids aren't used for anything inter
AFAIK, oids aren't used for anything internally, so duplicates don't
really matter. Besides, what would you do about duplicate oid's ?
If he's using them _externally_, then he does have to worry about
duplicates.
Chris
---(end of broadcast)---
TIP 5
AFAIK, oids aren't used for anything internally, so duplicates don't
really matter. Besides, what would you do about duplicate oid's ?
The best suggestion is of course his last, don't use them.
On Mon, 2004-04-26 at 22:48, Christopher Kings-Lynne wrote:
> > I am using the oid of the table as the
Yes, you can create an index on the oid, but unless you are selecting on
it, it is of little use.
you would have to do select * from foo where oid=? to get any value out
of the index.
Dave
On Mon, 2004-04-26 at 12:38, Edoardo Ceccarelli wrote:
> I am using the oid of the table as the main key and
I had similar failures with JSDK 1.4, I used 1.3.1_03 instead and everything was
ok.
The build.xml file for the JDBC driver looks for a special class for deciding
between J2EE and J2SE, but there were some changes between 1.3 and 1.4, so this
way doesn't work.
Egon
"Ravi K.R." wrote:
> JDBC co
Gordon-
This looks like a subject for the PSQL-ADMIN list. I'll forward it over
there, & you should also look there for the response. I know that one of the
7.1->7.2 issues is that unicode chars were not checked/rejected by 7.1 if
there was no multibyte support in the compile, but you seem to hav
James-
This problem ought to get posted over on the postgresql JDBC list- I'll cc
this reply on that list. (You may even find some Resin users over there.)
Here's the only thought that occurs to me based on my experiences with
Tomcat- Is it possible that when running with Resin, that at some poi
James-
We're using the Tomcat servlet engine & have had no similar problems, So I
think you can eliminate the JDBC driver from your list & focus on Resin or
something in your code.
We also quickly decided that we needed to be using a connection pool for a
web app. Opening & closing connections r
It looks like it is fixed in the current sources. He probably had an
old version.
Bruce Momjian wrote:
>
> We have had a number of fixes in the 7.1 beta JDBC driver. Would you test
> that and let us know if it is still broken. You can get the JAR file
> from the JDBC website at http://www.ret
We have had a number of fixes in the 7.1 beta JDBC driver. Would you test
that and let us know if it is still broken. You can get the JAR file
from the JDBC website at http://www.retep.org.uk.
> Hello to all,
> I'm writing because i have noticed a problem with the JDBC driver:
> JDBC specific
> Hello to all,
> I'm writing because i have noticed a problem with the JDBC driver:
> JDBC specification say that "ResultSet.absolute( 1 )" is equivalent to
> "ResultSet.first()". With the postgresql jdbc driver this is not true.
> I suppose that this problem happens because theVector implementat
My guess is that you are using Kaffe. It does not handle self-dependent
compiles like Sun java. The only solution is to download the
precompiled jar file from the URL in the interfaces/jdbcc README.
[ Charset ISO-8859-15 unsupported, converting... ]
> Hello,
> I tried to build the JDBC2 driver
Colin wrote:
>
> Any ideas on jdbc for postgres and where I can get the software?
>
> -Colin Bodor
> 3GE Development
Check src/interfaces in the distribution ;-)
/Palle
Vance Greenway wrote:
>
> i am using visual cafe for windows to develop an applet to access my
> postgresql data on a linux server. the package requires that the
> driver i want to develop with reside on the same computer...ie the
> windows box. can the jdbc driver "jdbc6_4.jar" be placed on th
On Mon, 6 Jul 1998, Gabor wrote:
> Hi,
>
> One of my users needs a JDBC driver for Postgres, where do I find the
> darn thing? The machine is Intel PII 400 running FreeBSD 3.0. I went
> to the javasoft site but the only applicable driver was from OpenLink
> and wasn't for FreeBSD.
Since V6.3,
Gabor wrote:
>
> Hi,
>
> One of my users needs a JDBC driver for Postgres, where do I find the
> darn thing? The machine is Intel PII 400 running FreeBSD 3.0. I went
> to the javasoft site but the only applicable driver was from OpenLink
> and wasn't for FreeBSD.
>
Take a look in /usr/src/pg
40 matches
Mail list logo
