Re: [GENERAL] Problem JDBC, AutoCommit ON and SELECT FOR UPDATE

2015-03-06 Thread Dave Cramer
unfortunately not. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On 6 March 2015 at 11:27, Philippe EMERIAUD wrote: > Hi all, > We have an application based on DB2 database, We are testing this same > application on PostgreSQL database. By default we are in auto

Re: [GENERAL] Errors using JDBC batchUpdate with plpgsql function

2015-05-04 Thread Dave Cramer
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 wrote: > Hannes Erven schrieb am 04.05.2015 um 12:31: > > Hi, > > > > > >> String sql = "

Re: [GENERAL] Errors using JDBC batchUpdate with plpgsql function

2015-05-05 Thread Dave Cramer
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 wrote: > The database function does not use out parameters

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-06 Thread Dave Cramer
rs. I 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 wrote: > On 06/04/2016 01:20 PM, lifetronics wrote: > >> This morning I a

Re: [GENERAL] How to retrieve jsonb column through JDBC

2016-08-27 Thread Dave Cramer
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 wrote: > Hello, > > what do you use to retrieve a jsonb column using JDBC? > > I have tried > >

Re: [GENERAL] looking for some real world performance numbers

2007-10-21 Thread Dave Cramer
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 o

Re: [GENERAL] insert into...

2007-12-09 Thread Dave Cramer
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 shou

Re: [GENERAL] postgresql server version & JDBC driver version

2014-07-03 Thread Dave Cramer
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 wrote: > Hello, > > I&#x

Re: [GENERAL] postgresql server version & JDBC driver version

2014-07-03 Thread Dave Cramer
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

Re: [GENERAL] SQL solution for my JDBC timezone issue

2015-02-23 Thread Dave Cramer
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 wrote: > Anyone have a suggestion for setting the tim

Re: [GENERAL] SQL solution for my JDBC timezone issue

2015-02-23 Thread Dave Cramer
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 wrote: > Yes, that is where we think we are heading, the issue is that

Re: [GENERAL] SQL solution for my JDBC timezone issue

2015-02-23 Thread Dave Cramer
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 wrote: > George Woodr

Re: [GENERAL] SQL solution for my JDBC timezone issue

2015-02-23 Thread Dave Cramer
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 wrote: > On 02/23/2015 12:15

Re: [GENERAL] SQL solution for my JDBC timezone issue

2015-02-23 Thread Dave Cramer
On 23 February 2015 at 16:31, Tom Lane wrote: > Dave Cramer 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 it, it might bec

Re: [GENERAL] SQL solution for my JDBC timezone issue

2015-02-24 Thread Dave Cramer
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 wrote: > -- In your origi

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

2013-01-28 Thread Dave Cramer
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 wrote: > Do the declare statements and insert all have to be done in one statement > e

Re: [GENERAL] JDBC - Need to declare variables for values in insert statement

2013-01-28 Thread Dave Cramer
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, Bo

Re: [GENERAL] JDBC not returning update count from updateable view

2013-02-26 Thread Dave Cramer
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 wrote: > Hi, > > ** ** > > We have a table which is inserted to and update via a vi

Re: [GENERAL] jdbc driver vis Release 10

2017-08-25 Thread Dave Cramer
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 wrote: > I see no mention of a new jdbc driver on the release notes for Beta 1. > Does that mean there isn

Re: [GENERAL] jdbc driver vis Release 10

2017-08-25 Thread Dave Cramer
There are newer versions out there! Dave Cramer da...@postgresintl.com www.postgresintl.com On 25 August 2017 at 19:53, Rob Sargent wrote: > > > On 08/25/2017 05:34 PM, Dave Cramer wrote: > > The JDBC driver release is divorced from the server release. > > Thanks &

Re: [GENERAL] jdbc driver vis Release 10

2017-08-28 Thread Dave Cramer
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 wrote: > > > On Aug 25, 2017, at 5:55 PM, Dave Cramer wrote: > > There ar

Re: [GENERAL] JDBC: logical replication and LSN feedback

2017-09-20 Thread Dave Cramer
+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

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
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: P

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
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

Re: [GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
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. P

[GENERAL] deadlock while re-indexing table

2008-02-12 Thread Dave Cramer
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. jnj=

Re: [GENERAL] JDBC prepared statements & server-side prepared statements

2009-06-25 Thread Dave Cramer
On Thu, Jun 25, 2009 at 2:59 AM, Albe Laurenz wrote: > 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? > > > http://jdbc.postgresql.org/development/privateapi/org/postgresql/PGStatement.htm

[GENERAL] reading cvs logs with pgadmin queries

2013-09-19 Thread Dave Cramer
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

Re: [GENERAL] reading cvs logs with pgadmin queries

2013-09-19 Thread Dave Cramer
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 dave.cramer(at)credativ(dot)ca htt

Re: [GENERAL] reading cvs logs with pgadmin queries

2013-09-19 Thread 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 On

Re: [GENERAL] reading cvs logs with pgadmin queries

2013-09-23 Thread Dave Cramer
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 wrote: > On 09

Re: [GENERAL] reading cvs logs with pgadmin queries

2013-09-23 Thread Dave Cramer
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 wrote: > Dave Cramer escribió: > > OK, > > > > I have a little more information. > > > &g

Re: [GENERAL] reading cvs logs with pgadmin queries

2013-09-25 Thread Dave Cramer
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 wrote: > On 09/23/2013 12:46 PM, Dave Cramer wrote: > >> OK,

Re: [JDBC] [GENERAL] Creating an index alters the results returned

2014-01-03 Thread Dave Cramer
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 wrote: > > -Original Message- &g

Re: [GENERAL] JDBC performance issue

2014-02-05 Thread Dave Cramer
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 wrote: > Hi All; > > We have a client running Pentaho to migrate data. > > They recently u

Re: [GENERAL] Is it possible to load two different versions of the JDBC driver in the same application?

2014-04-11 Thread Dave Cramer
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 wrote: > On 04/11/2014 03:31 PM, Tecn

Re: [GENERAL] Custom types and JDBC

2011-05-11 Thread Dave Cramer
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 wrote: > Hi, > I would use c

Re: [GENERAL] JDBC Connection Errors

2011-08-23 Thread Dave Cramer
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 wrote: > Hi list, > > A client is hitting an issue

Re: [GENERAL] Alternative JDBC driver

2011-09-13 Thread Dave Cramer
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. wrote: > Hello, > > I asked this question on JDBC list, but it seems "dead". > > I found alternat

Re: [GENERAL] Alternative JDBC driver

2011-09-18 Thread Dave Cramer
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. : > Thanks for answer, we will try this driver, because it's more > promising, if we will found some bugs or suggestion, You will be &g

Re: [GENERAL] force JDBC driver fetch / autocommit parameters?

2011-10-21 Thread Dave Cramer
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

[GENERAL] FATAL: the database system is starting up

2011-12-05 Thread Dave Cramer
mum columns in an index: 32 Maximum size of a TOAST chunk: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.credati

Re: [GENERAL] FATAL: the database system is starting up

2011-12-05 Thread Dave Cramer
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 wrote: > This is the second hot_standby server that I have setup for this > particular master server. The log

Re: [GENERAL] WAL file accumulation on log shipping primary node

2011-12-12 Thread Dave Cramer
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 wrote: > Dear all, > &g

Re: [GENERAL] WAL file accumulation on log shipping primary node

2011-12-13 Thread Dave Cramer
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 wrote: > Dave, > > The

[GENERAL] OT: looking for open source developers in ukraine, or Georgia Russia

2005-02-24 Thread Dave Cramer
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

Re: [GENERAL] [HACKERS] plPHP in core?

2005-04-02 Thread Dave Cramer
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

Re: [GENERAL] [HACKERS] plPHP in core?

2005-04-02 Thread Dave Cramer
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, Jos

Re: [GENERAL] [HACKERS] Problems compiling Postgresql 8.0.3 on 10.4

2005-07-20 Thread Dave Cramer
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 -no

Re: [GENERAL] [HACKERS] No user being created during initdb for OS X

2005-07-21 Thread Dave Cramer
http://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 [

Re: [GENERAL] [PERFORM] Locking in PostgreSQL?

2006-12-06 Thread Dave Cramer
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 Nij

Re: [GENERAL] [PERFORM] Locking in PostgreSQL?

2006-12-06 Thread Dave Cramer
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

Re: [GENERAL] "no unpinned buffers available" ? why? (hstore and plperl involved)

2007-01-26 Thread Dave Cramer
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

Re: [GENERAL] [JDBC] Is what I want possible and if so how?

2006-07-03 Thread Dave Cramer
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 s

Re: [GENERAL] Cutting the Gborg throat

2006-08-28 Thread Dave Cramer
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 the

Re: [GENERAL] transaction isolation level

2006-08-29 Thread Dave Cramer
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.

Re: [GENERAL] Idle in transaction state.

2006-09-09 Thread Dave Cramer
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)

Re: [JDBC] [GENERAL] Idle in transaction state.

2006-09-10 Thread Dave Cramer
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) idl

Re: [GENERAL] MySQL Gets Functions in Java - Enlightenment Please

2003-12-20 Thread Dave Cramer
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 mechanism?

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-27 Thread Dave Cramer
Dec 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

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-29 Thread Dave Cramer
difficulty is to figure > > >out how to offer PostgreSQL in their environment > > (yes, we know > > >about CygWin). > > > > > >("clients" because we don't do business as in > > selling stuff) > > > > > >Karsten Hilbert, MD

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Dave Cramer
be executed with > the privileges of the user that calls it. That is the default. > SECURITY DEFINER specifies that the function is to be executed with > the privileges of the user that created it. > > Dante > > -- > D. Dante

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Dave Cramer
393551 > > and a vacuum analyze runs nightly ... > > anyone with suggestions/ideas? has to be something client/server, like > mnogosearch, as we're dealing with multiple servers searching against the > same database ... so I don't *think* that ht/Dig is a solution

Re: [GENERAL] website doc search is extremely SLOW

2003-12-30 Thread Dave Cramer
> Total 2 393551 > > and a vacuum analyze runs nightly ... > > anyone with suggestions/ideas? has to be something client/server, like > mnogosearch, as we're dealing with multiple servers searching against the > same database ... so I don't *think* that ht

Re: [GENERAL] website doc search is extremely SLOW

2003-12-31 Thread Dave Cramer
eading their docs, their method of storing the data doesn't appear to be > > particularly off. I'm tempted to try their caching storage manager, and > > getting away from SQL totally, but I *really* want to showcase PostgreSQL > > on this :( > > Well

Re: Mnogosearch (Was: Re: [GENERAL] website doc search is ... )

2003-12-31 Thread Dave Cramer
y killing things ... > > Note that I haven't made many changes to the postgresql.conf file, so > there might be something really obvious I've overlooked, but here are the > uncommented ones (ie. ones I've modified from defaults): > > tcpip_socket = true > ma

Re: [GENERAL] GetLastInsertID ?

2004-01-01 Thread Dave Cramer
se send an appropriate > 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 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] website doc search is extremely SLOW

2004-01-03 Thread Dave Cramer
EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 > > > > ---(end of broadcast)--- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" t

Re: [GENERAL] website doc search is extremely SLOW

2004-01-04 Thread Dave Cramer
> ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly

Re: [GENERAL] JDBC driver inserting into a table with Bytea type

2004-06-21 Thread Dave Cramer
ed in the code base? > > If it is already fixed, what are the steps to implement the changes to > my 7.4.2 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

Re: [GENERAL] RHEL 2.1 rpms for 7.4.2

2004-06-23 Thread Dave Cramer
tom lane > > ---(end of broadcast)--- > TIP 1: subscribe 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

Re: [GENERAL] RHEL 2.1 rpms for 7.4.2

2004-06-23 Thread Dave Cramer
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: > > rp

Re: [GENERAL] trash talk

2004-08-04 Thread Dave Cramer
ample they mean that Rivot was > discussing 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 #

[GENERAL] Re: [JDBC] JDBC and stored procedures

2001-07-11 Thread Dave Cramer
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

RE: [GENERAL] JDBC 2.0 support?

2001-07-23 Thread Dave Cramer
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 JDBC

RE: [GENERAL] Please Help JDBC Error!!

2001-07-31 Thread Dave Cramer
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 Mess

RE: [GENERAL] Getting key value with an insert and using it in another.

2001-07-23 Thread Dave Cramer
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: [E

[GENERAL] Sqlstatement with !=-1 fails

2001-10-10 Thread Dave Cramer
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 +--

Re: [GENERAL]

2001-10-16 Thread Dave Cramer
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

Re: [GENERAL] surppressing column names in COPY format

2003-08-01 Thread Dave Cramer
nce IMHO, because I'm not lobbying for > permanent removal of the column names, nor making the default to not > have column names, I'm simply stating that the option to not have them > provides benefits and I'm willing to take the "risks" associated with > them.

[GENERAL] grant all to database inheritence

2003-10-27 Thread Dave Cramer
Dave -- Dave Cramer <[EMAIL PROTECTED]> fastcrypt -- Dave Cramer <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] grant all to database inheritence

2003-10-31 Thread Dave Cramer
Dave -- Dave Cramer <[EMAIL PROTECTED]> fastcrypt ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Point-in-time data recovery - v.7.4

2003-11-19 Thread Dave Cramer
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 t

Re: [GENERAL] Lock strategies!

2003-11-24 Thread Dave Cramer
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 numbe

Re: [GENERAL] Lock strategies!

2003-11-24 Thread Dave Cramer
other tables use only the sequence by itself, 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!

Re: [GENERAL] Lock strategies!

2003-11-25 Thread Dave Cramer
> > > 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

[GENERAL] Supply Chain Management System

2000-11-02 Thread Dave Cramer
an open source SCM? Kind Regards, Dave Cramer

[GENERAL] VACUUM ANALYZE FAILS on 7.0.3

2001-01-23 Thread Dave Cramer
When I run VACUUM ANALYZE it fails and all the backend connections are closed. Has anyone else run into this problem? --DC--

Re: [GENERAL] VACUUM ANALYZE FAILS on 7.0.3

2001-01-24 Thread Dave Cramer
__libc_start_main (main=0x80b5670 , 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 PROTEC

Re: [GENERAL] Annotatable on-line documentation

2001-02-16 Thread Dave Cramer
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]

[GENERAL] setObject bug in postgresql jdbc driver

2001-04-13 Thread Dave Cramer
ok?   Regards,   Dave Cramer  

[GENERAL] Help, I dropped a system datatype, and now I'm ....

2001-04-27 Thread Dave Cramer
which 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 thro

Re: [GENERAL] Ideal hardware configuration for pgsql

2001-05-02 Thread Dave Cramer
While I certainly have to agree with all of the points regarding FreeBSD's ease of use, and security I have one major critisism. Unfortunately there aren't any great java ports for FreeBSD. Linux also enjoys the attention of many bigger players such as IBM, Compaq. Dave - Original Message --

Re: [GENERAL] OODBMS vs. RDBMS

2001-05-05 Thread Dave Cramer
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

Re: [GENERAL] Re: MS-Query

2001-05-07 Thread Dave Cramer
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 +020

Re: [GENERAL] can't start as root

2001-05-28 Thread Dave Cramer
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