If your driver jdbc2.0 compliant, look at
batch processing. Choice between
one connection and many connections is not
obvious. Good driver is supposed to handle
many processes per one connection.
I would suggest starting with connection pool and 10 threads
with 10 connections doing batch update
I have 4 columns in a table, id, sub_id, timestamp and value.
The primary key is id, sub_id and timestamp combine.
I need to insert many rows (may be 10 thousands every 4 minutes)
as fast as I can to the same host, same port, same database, same table.
A.
Open only one JDBC (Java Database
I'm running Mandrake 7.2 and trying to upgrade postgresql to 7.1. The
installed version has the timestamp bug, so I must upgrade. RPM install
said I needed libc.so.6, which is on my system. So I installed rpm with
--nodeps to force it to install. However, running Postgresql complains
that
Does someone has already work with Visual Studio C++ and postgresql ???
If yes, please do you any project configuration example ?
Thanks for help.
Armelle
---(end of broadcast)---
TIP 6: Have you searched our list archives?
On Sat, Apr 28, 2001 at 09:46:44AM +0800, Harry Yau wrote:
Dear:
I wanna create a function that return a multiple rows in to a
single
row.
example:
CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
TEST;' LANGUAGE 'SQL';
when i call this function it return:
I am using following codes to get the accountname, and account from the
Table Account;
accountname, and account are varchar(30) and it can be null.
The code has no problem when both accountname, and account are not
null. It gives me an errror code of -209 when the account is null.
Anyone has any
\d tbl_c_id_seq
if it is not there, you can create it yourself
Thanks, the sequence was not there. Just puzzled me that
when creating tbl_c, I get:
test=# CREATE TABLE tbl_c
(id SERIAL PRIMARY KEY,
data VARCHAR(50),
a SERIAL CONSTRAINT a_ref REFERENCES tbl_a(id),
b SERIAL CONSTRAINT
Hello all, I'm having problems compiling pl/perl.
I've compiled perl 5.6.0 and 5.6.1 with and without threads and as shared (as
per the README in the perl distribution).
I've compiled postgresql both 7.0.3 and 7.1.
In all cases I get the following errors when trying to compile:
[ 11:26:33
Jason,
Look into the pg_result() function. You would use it something like
this:
$q = pg_Exec(SELECT id FROM article WHERE id=(SELECT MAX(id) FROM
article));
$maxid = pg_result($q,0,0); # pg_result($result,$row,$column_num)
echo The highest id is . $maxid[0];
Hope this helps.
Hello.
I was wondering if anybody knew how to run PostgreSQL in memory. We run it
on a Alphaserver DS20 with 1 Gig Ram.
The operating system is Digital Unix ver. 4.0F. We are not to happy with the
performance. Any ideas?
Best regards
Thor Ralle
IT-manager
Billettservice as
However Linux works better on SMP.
As I know FreeBSD still used global kernel lock (as Linux 2.2) on SMP...
Sean Chittenden [EMAIL PROTECTED] ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
--6iXXu7NwgEt9u5a7
Content-Type: text/plain; charset=us-ascii
Hi,
triggers call their registered functions always using the parameter-less
version. For Postgres, func() and func(text) are two entirely different
things! Also, trigger functions get an implicit set of parameters, like
NEW etc. (see documentation).
IMHO, this should be done as follows:
Philip Hallstrom wrote:
Also... is there any reason you don't just do:
SELECT MAX(id) FROM article
rather than what you have below? It would get you the same thing wouldn't
it and save a query...
On Thu, 3 May 2001, Chris Ryan wrote:
Jason,
Look into the pg_result()
Hi,
I recently upgraded to V7.1 version of Postgres on Linux and have noticed
that as the DB is being used, it gets progressively slower and slower, until
very simple queries slow down to a crawl. The basic setup I have is a set of
JSPs and Servlets running on Tomcat, that use Java
Tom Lane wrote:
Tulio Oliveira [EMAIL PROTECTED] writes:
I just lost the pg_control file, located in /usr/local/pgsql/data/global
How did that happen?
I start a new INITDB after rename the PG_DATA directory to another name,
but if I copy the pg_control file to real data directory, I
Mike Mascari wrote:
Can you access other data sources via MS-Query, such as local Access
databases, or possibly remote MSSQL server databases? I can't think
of any reason why MS-Query should be crashing...
I use PostgreSQL data in Word and Excel via linked tables in MS Access.
Maybe
Hello,
I'm trying to create a MVS C++ 6.0 project to be able to query my
postgresql database.
I build all needed libraries (libpq.dll,libpqdll.lib,libpq.lib). All are
in release mode.
I can't succeed linking my project. I always get link errors (see
below).
Does anyone as any example of
Credits are positive, debits are negative. I have never seen an accounting
package that did not follow this basic rule.
Dave Cramer wrote:
Hi all,
Can anyone out there with more experience than me give me some hints as to
how to do accounting tables in a db. The problem I am wrestling with
Try not to leave open transactions hanging around in your Apache code.
An idle database connection couldn't block VACUUM like that; it'd have
to have been in the middle of a BEGIN block, or maybe even an unfinished
query.
It's possible that the JDBC library always creates a new transaction
Hi,
does Postgresql 7.1 support triggers on a view actions? I've defined a few but they
doesn't seem to get fired. Problem is I cannot easily set the trigger on the tables
because of permission issues...
Lieven
---(end of broadcast)---
TIP
Not make pgsql 7.1
1.configure ---enable-multibyte=MULE_INTERNAL -with-tcl -without-tcl --with
-tclconfig=/lib
2.make
undefined reference to 'tcl_DeletefileHandler'
make[3]:**[libpgtcl.a] Error 1
make: Leaving directory '/postgresql-7.1/src/interfaces/libpgtcl'.
...
..
The insert statement executed from php is:
$otsikko = Insert testi;
$teksti = Koeteksti 1;
$sqllause = INSERT INTO jutut (otsikko,teksti) VALUES (';
$sqllause = $sqllause . $otsikko . ',' . $teksti . ');;
Have you tried without the ;? Just like:
$sqllause =
Hi,
I'm trying to install build DBD::Pg. against Postgres7.1
I've downloaded the latest version (0.98)
Postgres was installed via the RPMs. (base, lib, delel, perl, docs, test
and server)
it's a redhat 6.2 based system but with perl 5.6 installed.
perl Makefile.PL runs OK
make runs OK,
but
I'm compiling PostgreSQL 7.1.1 with Java support
(--with-java).
During gmake, immediately after this
line:
/usr/local/ant/bin/ant -buildfile
../../../build.xml -Dmajor=7 -Dminor=1
-Dfullversion=7.1.1 -Ddef_pgport=5432
I get the following error:
/usr/local/java/bin/java:
Tim Barnard [EMAIL PROTECTED] writes:
VFS: file-max limit 4096 reached
I'm running Linux (ver. 2.2.12-20) Anyone know how to increase
this limit?
# echo 8192 /proc/sys/fs/file-max
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the
1. Speed
2. Data Reliability
The two above depend very much (IMHO) on SYSDBA's skills. IB and its
descendants has, probably, less options to tweak, or, more correctly, less
obvious ways to improve its performance.
OTOH, if you have strong theoretical RDBMS bacground and
Tim Barnard [EMAIL PROTECTED] writes:
Incidently, I'm running RedHat 6.1.
See my previous message. BTW, please don't post in HTML.
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them,
Some additional info, I've installed Ant ver. 1.3 and Sun's Java 2 SDK
Enterprise Edition 1.2.1. JAVA_HOME is set to /usr/local/java
and /usr/local/java/bin is in the path.
Tim
- Original Message -
From: Tim Barnard
To: [EMAIL PROTECTED]
Sent: Monday, May 07, 2001 12:16 PM
Subject: A
Thanks for the help guys.
Tim
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
No you can't pull directly from JDBC, but you can from ODBC
- Original Message -
From: Tony Grant [EMAIL PROTECTED]
To: Nils Zonneveld [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, May 07, 2001 10:33 AM
Subject: Re: [GENERAL] Re: MS-Query
On 03 May 2001 23:44:59 +0200, Nils
Hello all,
I've finished upgrading to 7.1 and I'm still having trouble getting this view
to run respectably.
Does a view run its query every time I select from the view? I had been
assuming that the view recreates itself when I modify the table to which the
view is attached, but Tom mentioned
I installed PostgreSQL 7.1-1 from RPM on RH7.0 (I used GNOrpm).
Then I opened a terminal and ran
/etc/rc.d/init.d/postgresql start
chkconfig --add postgresql
as per README_rpm-dist (Lamar Owen)
psql works OK, pgaccess displays an error message
(PQConnectPoll() --connect() failed... check if
-Original Message-
From: Erick Papadakis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 05, 2001 9:13 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Re: Re: How to install on Windows?
hi fabrice,
thanks for taking the time to write that. i have indeed read
the manual
My inquiry:
Please discuss as to your point of view the advantage of
PostgreSQL over
Interbase and/or vise versa. I'm considering three (3)
important points
1. Speed
Postgresql is spotty. Some things it can do fast other
things are very slow. It's really mixed. So Postgres'
Oliver Elphick [EMAIL PROTECTED] writes:
This error was in 7.0.3 and is still found in 7.1. Could someone take a
look please.
Not without a reasonably complete bug report (where are the table
schemas, for example?). Preferably a psql script to reproduce the
problem starting from an empty
Morten Primdahl [EMAIL PROTECTED] writes:
I certain that I do not remove those. It happens every time
I run the aforementioned sequence. This is postgresql 7.0.3,
I'll upgrade to 7.1 and try again. Thanks.
Oh, I was trying 7.1. Now that I think about it, I think there's
a bug in 7.0.* that
Hello, All
How I prevent a new user to create new tables in a Data Base ?
The Data Base is owned by postgres and I need that only the postgres
user can create new tables ...
---
Where are the default messages thats appears when the Referentian
Integrity is violated ? I need change this
Mihai Gheorghiu wrote:
/etc/rc.d/init.d/postgresql restart
Shutsdown OK, then
Checking postgresql installation [OK]
Starting postgresql service [FAILED]
_I_ need to make some changes. For the time being, don't use restart.
This will be fixed for 7.1.1, which I hope to have built by this
Mihai Gheorghiu writes:
I uncommented and made changes so that now the uncommented lines look like:
tcpip_socket = true
ssl = false
max_connections = 32 # 1-1024
port = 5432
shared_buffers = 2*max_connections # min 16
This won't work. No arithmetic allowed.
--
Peter Eisentraut [EMAIL
On Mon, 7 May 2001, Tulio Oliveira wrote:
Hello, All
How I prevent a new user to create new tables in a Data Base ?
The Data Base is owned by postgres and I need that only the postgres
user can create new tables ...
I don't think you can allow users to connect to a db but not create
Does anybody know of a good way to COPY a file into a table if the data is
based on fixed width format? Do I just have to write some code with
scanf(Ick)? For example (Sorry about the poor ASCII art formatting):
| FIELD DESCRIPTIONLENGTH POSITION|
webb sprague [EMAIL PROTECTED] writes:
Does anybody know of a good way to COPY a file into a table if the data is
based on fixed width format?
COPY insists on having delimiters; you'll need to translate the file
format into something COPY can deal with.
Do I just have to write some code
Thanks to all who helped me with my questions... I sometimes forget /
loose track so I'll do it this way ;)You know who you are :)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
I'm getting poor performance on 7.1 as compared to 7.0. For 7.1, I'm
using the same setup as I had with 7.0. I use -F (disable fsync) and
have set postgres up with over 300MB of shared memory; that stuff
stayed consistent across the transition. I've got two 2.2 linux
machines, one setup with
Fran Fabrizio [EMAIL PROTECTED] writes:
Does a view run its query every time I select from the view?
Yes. That's sort of the point.
View definition: SELECT count(*) AS count, log.site_id, log.host_id FROM log
WHERE (((log.status = 'CRIT'::varchar) OR (log.status = 'EMERG'::varchar))
AND
Kyle [EMAIL PROTECTED] writes:
I'm getting poor performance on 7.1 as compared to 7.0.
Hm. I don't know why 7.1 might be slower for plain SELECTs (the WAL
changes would certainly not affect that). Could you compile 7.1 for
profiling (make clean; make PROFILE=-pg all in the src/backend
Sami wrote:
The insert statement executed from php is:
$otsikko = "Insert testi";
$teksti = "Koeteksti 1";
$sqllause = "INSERT INTO jutut (otsikko,teksti) VALUES ('";
$sqllause = $sqllause . $otsikko . "','" . $teksti . "');";
Hmmm Looks a bit
On Thu, May 03, 2001 at 11:11:20AM -0700, Terry Fielder wrote:
Is there an autonumber data type in postgreSQL?
SERIAL
CREATE TABLE xxx (id SERIAL, data TEXT);
or see docs for 'create sequence' -- it's more controllable stuff.
Karel
--
Karel Zak [EMAIL PROTECTED]
takes Vince a day or two to catch up ... yes, we are officially released,
and Tom just dump'd some major stats changes into HEAD ...
On Mon, 7 May 2001, Tatsuo Ishii wrote:
Does this mean that we have officially released 7.1.1? I could not
find any statements regarding 7.1.1 on the web
=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= [EMAIL PROTECTED] writes:
It is said that RULES are executed with rule's owner permissions, so how
is it possible that different users are getting different results?
This is not true. Rules are not executed with owner permission.
Yes they are. If you do
Lieven Van Acker [EMAIL PROTECTED] writes:
Are the nested views permission problems fixed in this release?
If so, a dump IS necessary because of a change rule creation routines.
If you're running into that issue, you might want to drop and recreate
the affected views/rules. That's a far cry
takes Vince a day or two to catch up ... yes, we are officially released,
and Tom just dump'd some major stats changes into HEAD ...
On Mon, 7 May 2001, Tatsuo Ishii wrote:
Does this mean that we have officially released 7.1.1? I could not
find any statements regarding 7.1.1 on the
On Mon, 7 May 2001, Bruce Momjian wrote:
I like the new mirrors web page at http://www.postgresql.org. Now I
just need to learn about some of those flags.
The alt tags will tell you what country. Looking at the status bar
will tell you what host (if your browser supports that).
Vince.
--
53 matches
Mail list logo