an open source SCM?
Kind Regards,
Dave Cramer
When I run VACUUM ANALYZE it fails and all the backend connections are
closed. Has anyone else run into this problem?
--DC--
in __libc_start_main (main=0x80b5670 main, argc=8,
ubp_av=0xbb24, init=0x80648b8 _init,
fini=0x814632c _fini, rtld_fini=0x4000d684 _dl_fini,
stack_end=0xbb1c) at ../sysdeps/generic/libc-start.c:111
- Original Message -
From: "Alfred Perlstein" [EMAIL PROTECTED]
To: "Dave
You should have a look at the wiki stuff
http://c2.com/cgi/wiki?WikiWikiWeb
Dave
- Original Message -
From: "Richard" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 16, 2001 12:40 PM
Subject: [GENERAL] Annotatable on-line documentation
(This was: "Re: [GENERAL] Re:
SQLException{ if (x ==
null){ // postgres ignores the type so it
doesn't matter what we pass
setNull(parameterIndex,Types.OTHER);
return; }
Is there any reason why it wouldn't check for null
right away ?
Can someone commit this to the source tree if it is
ok?
Regards,
Dave Cramer
postgres doesn't allow me to do.
recreate the type and find all the references to it. Can someone tell me
where to look for all the references to it?
Thanks in advance,
Dave Cramer
---(end of broadcast)---
TIP 3: if posting/reading through Usenet
Certainly an interesting article. Alot of negative comments about existing
OODBMS. Personally I have been using a persistence layer to acheive similiar
results on top of postgres. The main drawback is the speed degradation
imposed by the persistence layer. The upside is that I have direct mapping
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
On redhat, if you used the rpms you can start postgres by
cd /etc/rc.d/init.d
./postgresql start
You should set it to start automatically using the gnome configurator
Dave
- Original Message -
From: Lee Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 22, 2001 11:57
Tony,
The GetProcedures function in the driver does not work.
You should be able to a simple select of the stored proc however
Dave
On July 11, 2001 09:06 am, Tony Grant wrote:
Hello,
I am trying to use a stored procedure via JDBC. The objective is to be
able to get data from more than one
Yes,
Binaries can be found at
http://jdbc.fastcrypt.com
Source is in postgres cvs
Dave
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of stefan
Sent: July 16, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] JDBC 2.0 support?
Hi:
Are there
Hi,
First of call can you make sure you are using the latest source. There
are binaries at http://jdbc.fastcrypt.com
Second, my instincts are telling me that there is some sort of overflow
occurring with 6k records. Is there some way to reduce the size of the
resultset?
Dave
-Original
Yes, they are called sequences in postgres.
Create table tablename (id serial, )
This creates a sequence named tablename_id_seq
You can then do a select on
Select next('tablename_id_seq')
Which will give you the next sequence and increment it
Dave
-Original Message-
From:
Hello,
I get the following error
pl=# select * from person where id !=-1;
ERROR: Unable to identify an operator '!=-' for types 'int8' and 'int4'
You will have to retype this query using an explicit cast
pl=# select * from person where id =-1;
id | name | last_update_time
Title: Message
you
have to start a transaction with begin
Dave
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of MonaSent: October 13, 2001 2:32
AMTo: [EMAIL PROTECTED]Subject: [GENERAL]
Hi
We are trying to rollback an update
associated with
them.
At least the work arounds are simple... :-\
Robert Treat
--
Dave Cramer [EMAIL PROTECTED]
fastcrypt
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
Unless you specifically ask for it postgresql doesn't lock any rows
when you update data.
Dave
On 6-Dec-06, at 2:04 AM, Joost Kraaijeveld wrote:
Does PostgreSQL lock the entire row in a table if I update only 1
column?
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB
On 6-Dec-06, at 8:20 AM, Jens Schipkowski wrote:
On Wed, 06 Dec 2006 13:29:37 +0100, Dave Cramer [EMAIL PROTECTED]
wrote:
Unless you specifically ask for it postgresql doesn't lock any
rows when you update data.
Thats not right. UPDATE will force a RowExclusiveLock to rows
matching
Tom,
I've also got a customer getting this error message.
the OS is OSX 10.3 they are using plpgsql, and shared buffers is set
very low
shared_buffers = 16
Dave
On 3-Jan-07, at 10:19 AM, Tom Lane wrote:
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
and - after some time of
snacktime wrote:
I'm working through the architecture design for a new product. We
have a small group working on this. It's a web app that will be using
ruby on rails. The challenge I'm running into is that the latest
conventional wisdom seems to be that since obviously databases don't
scale
Jamie,
That's strange, I have 8.03 building fine on 10.4 ? Did you simply do
a make without a make clean and run configure again ?
Dave
On 20-Jul-05, at 3:37 AM, Jamie Deppeler wrote:
Hi, i have just installed 10.4 on one of our machines and cannot
get past this error during make
gcc
://archives.postgresql.org
---(end of
broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Dave Cramer
[EMAIL PROTECTED]
www.postgresintl.com
ICQ #14675561
jabber [EMAIL PROTECTED
Values is optional. We support insert into select
Dave
On 9-Dec-07, at 11:05 AM, Alain Roger wrote:
Hi,
i would like to understand why the following INSERT INTO statement
works :
INSERT INTO mytable
SELECT nextval('my_sequence'),
'myname',
'myfirstname'
;
whereas usually we
On 12-Feb-08, at 1:02 PM, Gregory Stark wrote:
Dave Cramer [EMAIL PROTECTED] writes:
On 12-Feb-08, at 10:37 AM, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Dave Cramer wrote:
reindex table user_profile;
ERROR: deadlock detected
DETAIL: Process 32450 waits
On 12-Feb-08, at 5:05 PM, Tom Lane wrote:
Dave Cramer [EMAIL PROTECTED] writes:
The other process is inserting into the user_profile table.
Did either transaction do anything else in the same transaction
previously?
It would appear that the insert is running before the reindex starts
On 12-Feb-08, at 10:37 AM, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Dave Cramer wrote:
reindex table user_profile;
ERROR: deadlock detected
DETAIL: Process 32450 waits for AccessExclusiveLock on relation
194689112 of database 163880909; blocked by process 31236.
Process
reindex table user_profile;
ERROR: deadlock detected
DETAIL: Process 32450 waits for AccessExclusiveLock on relation
194689112 of database 163880909; blocked by process 31236.
Process 31236 waits for AccessShareLock on relation 194689110 of
database 163880909; blocked by process 32450.
First of all apologies for the noise.
Please reply off list.
Dave
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
pl-j ( the other java procedural language ) is definately interested in
being in core.
Dave
Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
On Fri, 1 Apr 2005, Joshua D. Drake wrote:
Are we interested in having plPHP in core?
Is there a reason why it can no longer
Very actively, http://plj.codehaus.org
Dave
Joshua D. Drake wrote:
Dave Cramer wrote:
pl-j ( the other java procedural language ) is definately interested
in being in core.
Is it actively developed? Not being rude... I just haven't heard much
(almost nothing) about it.
Sincerely,
Joshua D
--
Dave Cramer [EMAIL PROTECTED]
fastcrypt
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
So are you donating your replication work to the community then? Or do
we still have to write PITR?
Dave
On Tue, 2003-11-18 at 19:55, Joshua D. Drake wrote:
I think the opposit:
Once the PITR is written it can be used for Replication as side
effect.
Command Prompt has found the
Marceio
The sequence logic takes care of it. try it yourself
open two connections with psql
on one do a
begin;
insert into table
select curval('forn_id_seq');
on the other
do a
begin
insert into table
select curval('forn_id_seq');
You will see that they both increment the sequence
, but
this one, especially, CAN'T have holes! It is the
problem!!! ;-)
So, if I rollback or whatever, the ID will be
populated with the sequence values, but the forn_id
must increase in a controled way, ie, without holes!
Advices??
Regards!
Marcelo
--- Dave Cramer [EMAIL
. and ensure that these tranasactions
are fully isolated.
Marc A. Leith
redboxdata inc.
E-mail:[EMAIL PROTECTED]
Quoting Uwe C. Schroeder [EMAIL PROTECTED]:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 24 November 2003 08:01 am, Dave Cramer wrote:
Marcelo
I'm actually starting to write one of these for postgres, and apparently
there is another one in the works, from Thomas Hallgren.
There is at least one significant architectural issue here to deal with
Is it more desirable to have a single java vm and communicate via RPC,
or some other
2003, Dave Cramer wrote:
One thing that they do have over postgres is a unified experience, one
doesn't have to go to n different sites to find things, such as
interface libraries, advocacy sites, development sites, etc.
Course they don't ... cause they have one, full time, paid webmaster
/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
Dave Cramer
519 939 0336
ICQ # 1467551
---(end of broadcast
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Dave Cramer
519 939 0336
ICQ # 1467551
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
with multiple servers searching against the
same database ... so I don't *think* that ht/Dig is a solution, but may be
wrong there ...
On Wed, 30 Dec 2003, Dave Cramer wrote:
search for create index took 59 seconds ?
I've got a fairly ( 1 second for the same search) fast search engine
, as we're dealing with multiple servers searching against the
same database ... so I don't *think* that ht/Dig is a solution, but may be
wrong there ...
On Wed, 30 Dec 2003, Dave Cramer wrote:
search for create index took 59 seconds ?
I've got a fairly ( 1 second for the same search) fast
, but I *really* want to showcase PostgreSQL
on this :(
Well, PostgreSQL is being un-showcased in the current setup, that's for
sure. :-(
In fact this is a very bad advertisement for postgres
--
Dave Cramer
519 939 0336
ICQ # 1467551
---(end of broadcast
://archives.postgresql.org
--
Dave Cramer
519 939 0336
ICQ # 1467551
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
that your
message can get through to the mailing list cleanly
--
Dave Cramer
519 939 0336
ICQ # 1467551
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
can get through to the mailing list cleanly
--
Dave Cramer
519 939 0336
ICQ # 1467551
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
installation? Build my own JDBC driver?
!DSPAM:40d7062152562688613027!
--
Dave Cramer
519 939 0336
ICQ # 14675561
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
and unsubscribe commands go to [EMAIL PROTECTED]
!DSPAM:40d39dbb71311869725949!
--
Dave Cramer
519 939 0336
ICQ # 14675561
---(end of broadcast)---
TIP 8: explain analyze is your friend
Agreed,
But people who buy RHAS2.1 in my experience are quite adamant about
using RHAS2.1 packages.
You can get it to build but you have to go in and manually remove some
lines from the spec file.
Dave
On Wed, 2004-06-23 at 12:26, Joshua D. Drake wrote:
Dave Cramer wrote:
rpmbuild is broken
PostgreSQL and that would have been made clear had they provided
a complete transcript.
Of course it is possible that the author misquoted Rivot, or misinterpreted
which database he was referring to.
--
Dave Cramer
519 939 0336
ICQ # 14675561
---(end of broadcast
Joost,
Everyone has to do a select for update, then they will be serialized.
Dave
On 3-Jul-06, at 6:45 AM, Joost Kraaijeveld wrote:
Hi,
I have a table with events that must be handled by multiple
clients. It
does not matter which client handles an event, but no two clients may
handle the
On 27-Aug-06, at 11:47 PM, Joshua D. Drake wrote:
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have been looking at the migration of Gborg lately. It looks
like the
only two active projects on that site are Slony, and pljava.
Libpqxx has
recently moved to
My guess would be that you are getting the connection with autocommit
(false);
Either way try
conn = getConn...
conn.setAutoCommit(false);
conn.changeTransactionLevel
On 29-Aug-06, at 9:15 AM, Tom Lane wrote:
josh hes. [EMAIL PROTECTED] writes:
We recently updated our postgres to 8.1.4,
Peter,
On 9-Sep-06, at 2:14 PM, Peter L. Berghold wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi folks,
I've run into an issue that I'm sure there's a fix for, I just haven't
quite figured it out on my own.
First the overview of the environment:
Linux (CentOS release 4.2)
On 10-Sep-06, at 12:12 AM, Jack Orenstein wrote:
Tom Lane wrote:
Peter L. Berghold [EMAIL PROTECTED] writes:
What I'm seeing is the first time my web application is being run
there
is a bunch of processes running around that look like:
postgres: peter peter_trialdb 127.0.0.1(46222) idle
On Thu, Jun 25, 2009 at 2:59 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jack Orenstein wrote:
I'm using postgresql 8.3.7. Under what conditions does a JDBC prepared
statement
result in a server-side prepared statement?
The only difference JDBC has over psql is that it has to connect via
tcpip. Not sure about pgadmin.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Tue, Aug 23, 2011 at 6:47 PM, Sam Nelson s...@consistentstate.com wrote:
Hi list,
A client is hitting an issue with JDBC
I looked at the link.
Where is the code ? What license ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Tue, Sep 13, 2011 at 4:18 AM, Jimmy K. jimmypg...@gmail.com wrote:
Hello,
I asked this question on JDBC list, but it seems dead.
I found alternative JDBC driver
Jimmy,
What was your question ? The JDBC list is not dead.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
2011/9/18 Jimmy K. jimmypg...@gmail.com:
Thanks for answer, we will try this driver, because it's more
promising, if we will found some bugs or suggestion, You
Can you be more specific as to what you are looking for ? I presume
there is something between you and the connection so when you turn
autocommit on it doesn't work ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Thu, Oct 20, 2011 at 4:34 PM, S. Balch sba...@gmail.com
:1996
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
--
Sent via pgsql-general mailing list (pgsql-general
Answering my own question
hot_standby = off by default..
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Dec 5, 2011 at 6:43 AM, Dave Cramer p...@fastcrypt.com wrote:
This is the second hot_standby server that I have setup for this
particular master server
Dong,
How are you copying the wal logs over to the secondary ? Since this is
loosely coupled I am wondering how the master would be effected by
load.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Tue, Dec 13, 2011 at 12:42 AM, Dong Han d...@bluecatnetworks.com wrote
Dong,
Once the wal_copy command completes the primary is free to handle the
wal logs as it sees fit. Is it possible that rsync is getting behind ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Dec 12, 2011 at 11:28 PM, Dong Han d...@bluecatnetworks.com wrote
pgadmin uses multi line queries and copy from 'cvslogs' cannot read them.
Does anyone have a work around or other solution ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
AND
r.package_id IS NOT NULL
INNER JOIN printdata_page p ON r.id = p.report_id
INNER JOIN printdata_item i ON p.id = i.page_id
WHERE
r.timestamp = '2012-09-01' AND r.timestamp = '2013-08-31'
GROUP BY
Month Name,
Target,367,,pgAdmin III - Query Tool
Dave Cramer
text,
PRIMARY KEY (session_id, session_line_num)
);
2) The exact error message is ERROR: extra data after last expected column
considering ~39000 lines go in before this line I am fairly certain it
is the line.
Dave
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
OK,
I have a little more information.
Yes, in isolation I can import these lines, however something happens after
69000 lines. These lines cause an error.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Sep 20, 2013 at 9:59 AM, Adrian Klaver adrian.kla
I tried copying 500 lines above it and it still works :(
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 4:15 PM, Alvaro Herrera alvhe...@2ndquadrant.comwrote:
Dave Cramer escribió:
OK,
I have a little more information.
Yes, in isolation I
Ok, I found the offending line. It was not the pgadmin line. There was a
line with a large binary insert.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 6:31 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 09/23/2013 12:46 PM, Dave Cramer wrote
Yes, please check the server logs. There should be no reason whatsoever
that JDBC would effect the results if the query is the same
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Jan 3, 2014 at 3:42 PM, Igor Neyman iney...@perceptron.com wrote:
-Original
You said they upgraded the driver but the versions you stated are the same
???
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, Feb 5, 2014 at 12:23 PM, CS DBA cs_...@consistentstate.com wrote:
Hi All;
We have a client running Pentaho to migrate data
Hi,
I'm not sure what you mean by without result set ? There is no real
way to get information back from the driver except using a result set.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, May 11, 2011 at 3:19 AM, mephysto genna...@email.it wrote:
Hi,
I would
Bob,
Can you provide a snippet of code so I can understand what you mean by
declare ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Jan 28, 2013 at 7:11 AM, Bob Futrelle bob.futre...@gmail.comwrote:
Do the declare statements and insert all have to be done in one
Bob,
Ok, have a look at PreparedStatement
Essentially the same
PreparedStatement pstmt= db.prepareStatement(insert into hello values ?)
pstmt.setInt(1,intVar)
pstmt.execute()
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Jan 28, 2013 at 1:50 PM, Bob Futrelle
As far as I remember this is an artifact of using rules to update a table.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Feb 25, 2013 at 2:52 PM, Russell Keane russell.ke...@inps.co.ukwrote:
Hi,
** **
We have a table which is inserted to and update via
Ya, they probably don't like that we use server side prepared statements
Might be possible to just mess with classpath's to get it done.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 11 April 2014 17:39, Rob Sargent robjsarg...@gmail.com wrote:
On 04/11/2014 03:31 PM
Can you elaborate as to your problems. That driver should work fine
depending on what you are doing. Also it would be better to use the jdbc
list.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 3 July 2014 06:25, Orestis Tsakiridis otsa...@gmail.com wrote:
Hello,
I'm
Well the JDBC4 bits that are not implemented may or may not be relevant.
You can try the 9.1 driver or even the 9.3 driver. I still don't see enough
information in the stacktrace to tell what the issue really is?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 3 July
unfortunately not.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 6 March 2015 at 11:27, Philippe EMERIAUD p.emeri...@ordirope.fr wrote:
Hi all,
We have an application based on DB2 database, We are testing this same
application on PostgreSQL database. By default we
Well you could always just put it back to whatever you want when you open
the connection ie set timezone
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 08:40, George Woodring george.woodr...@iglass.net
wrote:
Anyone have a suggestion
to control
which timezone both the server and the client are operating in.
I'm open to suggestions ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 10:42, George Woodring george.woodr...@iglass.net
wrote:
Yes, that is where we think we are heading
For posterity please be aware this will very likely break any timestamps
transfer using JDBC and binary transfer.
This is not recommended for general consumption
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 10:49, Tom Lane t...@sss.pgh.pa.us wrote
On 23 February 2015 at 16:31, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
Everytime you get a connection the driver will issue set timezone ...
It does not change the default time zone for the server (AFAICS)
Hmm ... depending on exactly how you issue
George,
Everytime you get a connection the driver will issue set timezone ...
It does not change the default time zone for the server (AFAICS)
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 15:29, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 02
George,
One solution for you might be to write a C function which gets the OS
timezone and then you can execute set timezone=server_timezone();
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 24 February 2015 at 09:25, George Woodring george.woodr...@iglass.net
wrote
The logs from the server would be useful
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 07:05, Thomas Kellerer spam_ea...@gmx.net wrote:
Hannes Erven schrieb am 04.05.2015 um 12:31:
Hi,
String sql = select test_user_result_insert_func
So we can consider this matter closed ? CallableStatements are necessary
because postgres has to use select to call a function.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 18:06, Nanker Phelge n.phelg...@gmail.com wrote:
The database function does
have no idea if this will work
5) pg_dump everything and reload it into a new db.
Let me know how it goes.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 6 June 2016 at 16:57, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 06/04/2016 01:20 PM, lifetron
Unfortunately JSONB is output in text. So this is the way it is done.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 27 August 2016 at 06:39, Alexander Farber <alexander.far...@gmail.com>
wrote:
> Hello,
>
> what do you use to retrieve a jsonb column using JDBC?
&
+list
First off you are going to get considerably better response from the JDBC
list or our github project.
Looking at the code; in order to ensure the backend has received the
acknowledgement you need to call forceUpdateStatus
Otherwise it may not receive the ack
Dave Cramer
da
The JDBC driver release is divorced from the server release.
Thanks
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 August 2017 at 19:33, Rob Sargent <robjsarg...@gmail.com> wrote:
> I see no mention of a new jdbc driver on the release notes for Beta 1.
> Do
There are newer versions out there!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 25 August 2017 at 19:53, Rob Sargent <robjsarg...@gmail.com> wrote:
>
>
> On 08/25/2017 05:34 PM, Dave Cramer wrote:
>
> The JDBC driver release is divorced from the serve
Well we won't be fixing any bugs in anything but the latest version if that
makes a difference to you.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 25 August 2017 at 21:34, Rob Sargent <robjsarg...@gmail.com> wrote:
>
>
> On Aug 25, 2017, at 5:55 PM,
93 matches
Mail list logo
