Hello,
I have a problem with compile PostgreSQL from cvs with tag REL7_4_STABLE
Error is 'ECPG_ARRAY_NONE is not declared' (in execute.c)
HEAD (7.5.devel) compile fine
Please help
Regards
Haris Peco
---(end of broadcast)---
TIP 7: don't forget
there is a mechanism to get to the end move 0 in
'cursor', which currently is being considered a bug.
Dave
On Fri, 2002-10-11 at 11:44, Doug Fields wrote:
At 08:27 AM 10/11/2002, snpe wrote:
Barry,
Is it true ?
I create table with one column varchar(500) and enter 1 milion rows
This code work for me :
Connection db = DriverManager.getConnection(url,user,passwd);
PreparedStatement st = db.prepareStatement(begin;declare c1 cursor for
select * from a);
st.execute();
st = db.prepareStatement(fetch 100 in c1);
ResultSet rs =
with setting autocommit in
clients?
thanks,
--Barry
Original Message
Subject: Re: [JDBC] Patch for handling autocommit=false in
postgresql.conf Date: Tue, 17 Sep 2002 10:26:14 -0400
From: Tom Lane [EMAIL PROTECTED]
To: snpe [EMAIL PROTECTED]
CC: pgsql-jdbc [EMAIL
Barry,
Is it true ?
I create table with one column varchar(500) and enter 1 milion rows with
length 10-20 character.JDBC query 'select * from a' get error 'out of
memory', but psql not.
I insert 8 milion rows and psql work fine yet (slow, but work)
In C library is 'execute query' without
at 12:48, snpe wrote:
Hello,
Does it mean that psql uses cursors ?
regards
Haris Peco
On Friday 11 October 2002 05:58 pm, Dave Cramer wrote:
This really is an artifact of the way that postgres gives us the data.
When you query the backend you get *all* of the results
Change directory in src/pl/plperl
and execute gcc command with option -D_GNU_SOURCE
(2 files)
and then continue make form base directory
You must add /usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE/libperl.so in
/etc/ld/so/conf or in LD_LIBRARY_PATH
regards
Haris Peco
On Monday 28 October
b) Send a decoded version of atttypmod - specifically, decode the
precision and scale for numeric types.
I want decode type,length,precision and scale
regards
Haris Peco
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thursday 07 November 2002 09:50 pm, korry wrote:
b) Send a decoded version of atttypmod - specifically, decode the
precision and scale for numeric types.
I want decode type,length,precision and scale
Type is returned by PQftype(), length is returned by PQfsize(). Precision
and
Is exists patch for 7.4devel ?
regards
Haris Peco
On Tuesday 05 November 2002 01:14 am, Satoshi Nagayasu wrote:
Hi all,
Mike Mascari [EMAIL PROTECTED] wrote:
Is there any thought about changing the protocol to support
two-phase commit? Not that 2PC and distributed transactions
would be
Hello,
I work with JDeveloper and PostgreSQL JDBC and I have one problem.
I get error :
sub-SELECT in FORM must have an alias
I can't change SQL command, but it is internal JDeveloper command
Is it SQL standard (must have alias) or PostgreSQL specific ?
Regards
Haris Peco
On Sunday 10 November 2002 05:27 am, Tom Lane wrote:
snpe [EMAIL PROTECTED] writes:
I work with JDeveloper and PostgreSQL JDBC and I have one problem.
I get error :
sub-SELECT in FORM must have an alias
Is it SQL standard (must have alias) or PostgreSQL specific ?
The SQL
On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote:
snpe kirjutas L, 09.11.2002 kell 22:51:
Hello,
I work with JDeveloper and PostgreSQL JDBC and I have one problem.
I get error :
sub-SELECT in FORM must have an alias
I can't change SQL command, but it is internal JDeveloper
Hello,
Query :
select id i
from tab
don't work in PostgreSQL
I know that
select id as i
from tab
work, but I think that AS in 'as cluse' is optional
Please comment.
regards
Haris Peco
---(end of
On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote:
snpe kirjutas L, 09.11.2002 kell 22:51:
Hello,
I work with JDeveloper and PostgreSQL JDBC and I have one problem.
I get error :
sub-SELECT in FORM must have an alias
I can't change SQL command, but it is internal JDeveloper
Hello,
When I change view and change number of column PostgreSQL return error :
'cannot change number of column in view'
Is it too hard set this command
if view exits drop view
and then change view
It is like with return type in function
Now 'or replace' don't help too much
regards
On Thursday 14 November 2002 02:41 pm, Bruno Wolff III wrote:
On Thu, Nov 14, 2002 at 13:41:18 +,
snpe [EMAIL PROTECTED] wrote:
Hello,
When I change view and change number of column PostgreSQL return error
: 'cannot change number of column in view'
Is it too hard set
On Thursday 14 November 2002 04:38 pm, Rod Taylor wrote:
On Thu, 2002-11-14 at 11:17, snpe wrote:
On Thursday 14 November 2002 02:41 pm, Bruno Wolff III wrote:
On Thu, Nov 14, 2002 at 13:41:18 +,
snpe [EMAIL PROTECTED] wrote:
Hello,
When I change view and change number
On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
On Thu, Nov 14, 2002 at 16:49:42 +,
snpe [EMAIL PROTECTED] wrote:
I want that 'create or replace view' work drop-create if view exists else
only create
Why do you want this?
Why 'create or replace
On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
On Thu, Nov 14, 2002 at 17:00:30 +,
snpe [EMAIL PROTECTED] wrote:
On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
On Thu, Nov 14, 2002 at 16:49:42 +,
snpe [EMAIL PROTECTED] wrote:
I want
On Thursday 14 November 2002 05:45 pm, Tom Lane wrote:
snpe [EMAIL PROTECTED] writes:
On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
Are you trying to save typing a few characters or what?
Yes, it is 'create or replace view', not ?
The statement was not invented to save
On Thursday 14 November 2002 08:01 pm, Stephan Szabo wrote:
On Thu, 14 Nov 2002, Scott Shattuck wrote:
It might just be me but it seems that this discussion is missing the
point if we believe this request is about saving some characters. I
don't think it is. I think it's about being able to
On Thursday 14 November 2002 10:36 pm, Stephan Szabo wrote:
On Thu, 14 Nov 2002, snpe wrote:
Problem is when I want change view (or functions) with a lot of
dependecies I must drop and recreate all dependent views (or functions) -
I want add only one column in view
I don't know
Hello,
is it planed cursor out of a transaction in 7.4 ?
Thanks
Haris Peco
On Monday 18 November 2002 12:30 am, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Let's just fix it and roll an RC2 with the fix. If not, we can just fix
it in 7.3.1 but I see little problem in rolling an
On Tuesday 26 November 2002 09:05 pm, Hannu Krosing wrote:
Reinoud van Leeuwen kirjutas K, 20.11.2002 kell 17:03:
Hi,
Is there any reason why the grolist field in the table pg_group is
implemented as an array and not as a separate table?
most likely for performance reasons.
According
On Friday 29 November 2002 06:51 pm, Christopher Kings-Lynne wrote:
Hi guys,
Just out of interest, if someone was going to pay you to hack on Postgres
for 6 months, what would you like to code for 7.4?
My ones are:
* Compliant ADD COLUMN
* Integrated full text indexes
* pg_dump
On Sunday 01 December 2002 05:03, Tom Lane wrote:
Paul Ramsey [EMAIL PROTECTED] writes:
Oracle has finally surpassed PostgreSQL in some elements of
object-relational technology. Among the things you can do are:
- Address components of objects using dot-notation. (select
employee.salary
On Friday 13 December 2002 17:51, Bruce Momjian wrote:
Shridhar Daithankar wrote:
And where are nested transactions?
I didn't mention nested transactions because it didn't seem to be a
_big_ item like the others.
This is big item
regards
Haris Peco
---(end of
Postgresql is first, now (51%, mysql 35%)
regards
Haris Peco
On Thursday 02 January 2003 08:53, Daniel Kalchev wrote:
Registration is easy, and pretty much anonymous... worth to promote our
beloved database. :)
Happy New Year,
Daniel
Marc G. Fournier said:
Just got this in my
On Wednesday 19 March 2003 04:33 am, you wrote:
Dave Cramer [EMAIL PROTECTED] writes:
On Tue, 2003-03-18 at 19:00, Hiroshi Inoue wrote:
ODBC(maybe JDBC also) has cross-transaction result sets
(rather than cursors) since long by simply holding all
results for a query at client side.
.
Hackers,
How should client interfaces handle this new autocommit feature? Is it
best to just issue a set at the beginning of the connection to ensure
that it is always on?
thanks,
--Barry
snpe wrote:
Hi Dave,
That is same.Program work with and without quote but row don't deleted
On Saturday 07 September 2002 02:55 am, Bruce Momjian wrote:
Barry Lind wrote:
Haris,
You can't use jdbc (and probably most other postgres clients) with
autocommit in postgresql.conf turned off.
Hackers,
How should client interfaces handle this new autocommit feature? Is it
release. We can document it as being
work in progress, use at your own risk.
I'm use 'autocommit=false' and have problem with psql
When any commnad is lost, then next commnad get error for transactions
(simple select command).BTW
snpe select * from org_ba;
ERROR: relation org_ba does not exists
On Monday 09 September 2002 11:03 pm, Rod Taylor wrote:
On Mon, 2002-09-09 at 17:04, snpe wrote:
I'm use 'autocommit=false' and have problem with psql
When any commnad is lost, then next commnad get error for transactions
(simple select command).BTW
snpe select * from org_ba;
ERROR
On Tuesday 10 September 2002 03:05 am, Stephan Szabo wrote:
On Tue, 10 Sep 2002, snpe wrote:
On Monday 09 September 2002 11:03 pm, Rod Taylor wrote:
On Mon, 2002-09-09 at 17:04, snpe wrote:
I'm use 'autocommit=false' and have problem with psql
When any commnad is lost, then next
On Tuesday 10 September 2002 04:16 am, Stephan Szabo wrote:
On Tue, 10 Sep 2002, snpe wrote:
On Tuesday 10 September 2002 03:05 am, Stephan Szabo wrote:
On Tue, 10 Sep 2002, snpe wrote:
On Monday 09 September 2002 11:03 pm, Rod Taylor wrote:
On Mon, 2002-09-09 at 17:04, snpe wrote
On Tuesday 10 September 2002 07:46 pm, scott.marlowe wrote:
On Tue, 10 Sep 2002, Stephan Szabo wrote:
It starts a transaction, failes the first command and goes into
the error has occurred in this transaction state. Seems like
reasonable behavior.
Select command
On Tuesday 10 September 2002 09:55 pm, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
That seems messy. What you are saying is that if autocommit is off,
then in:
SET x=1;
UPDATE ...
SET y=2;
ROLLBACK;
that the x=1 doesn't get rolled back bu the y=2
On Wednesday 11 September 2002 01:25 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
On Tuesday 10 September 2002 11:50 pm, Stephan Szabo wrote:
On Tue, 10 Sep 2002, snpe wrote:
On Tuesday 10 September 2002 07:46 pm, scott.marlowe wrote:
What if it's a select for update
On Wednesday 11 September 2002 02:09 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
yes, we're going around in circles.
Ok.I agreed (I think because Oracle do different)
Transaction start
I type invalid command
I correct command
I get error
Why.If is it transactin
On Wednesday 11 September 2002 04:58 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
On Wednesday 11 September 2002 02:09 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
yes, we're going around in circles.
Ok.I agreed (I think because Oracle do different
On Wednesday 11 September 2002 03:14 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
On Wednesday 11 September 2002 02:09 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
yes, we're going around in circles.
Ok.I agreed (I think because Oracle do different
On Wednesday 11 September 2002 02:38 pm, Rod Taylor wrote:
Why rollback.This is error (typing error).Nothing happen.
I think that we need clear set : what is start transaction ?
I think that transaction start with change data in database
(what don't change data this start not
On Wednesday 11 September 2002 02:55 pm, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
On Wednesday 11 September 2002 03:14 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
On Wednesday 11 September 2002 02:09 am, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe
On Wednesday 11 September 2002 06:11 pm, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
On Wednesday 11 September 2002 02:55 pm, Stephan Szabo wrote:
On Wed, 11 Sep 2002, snpe wrote:
If decision (transaction or not) is after parser (before execute)
this isn't problem.
I
Hello Neil,
I try example for Oracle jdbc 1.4 driver
This is sample and results.
I hope that is helps.
If you want yet another example, please tell me.
regards
Haris Peco
/**
* A simple sample to check the availability of scrollable result sets.
*
* Please use jdk1.2 or later version
hello,
This is in current cvs
regards
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
47 matches
Mail list logo
