Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Dave Cramer
Joshua, I'd love to see it donated to the community as well! Dave On Tue, 2003-11-04 at 16:01, Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: Joshua D. Drake writes: I thought that we might donate it to the project as a whole. What are people's thoughts on this? I think

Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Dave Cramer
If it doesn't do jsp now, it would be a good starting point for a web version, as java lends it self well to multiple views. Dave On Tue, 2003-11-04 at 15:59, Marc G. Fournier wrote: On Tue, 4 Nov 2003, Andrew Dunstan wrote: Marc G. Fournier wrote: On Tue, 4 Nov 2003, Joshua D. Drake

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-07 Thread Dave Cramer
Well the current argument aside, I do find it discouraging that there is a considerable difference between the four sites, advocacy, gborg, dev, and the main site, not only in form but in substance. I am listed on the dev site as a major contributor, but not on the advocacy site. Where was the

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Dave Cramer
Jira is a fantastic bug tracking project management system and is available free of charge for open source projects. http://www.atlassian.com/software/jira/ Dave On Fri, 2003-11-07 at 16:48, Andrew Sullivan wrote: On Fri, Nov 07, 2003 at 04:07:46PM -0500, Tom Lane wrote: Actually, whatever

Re: [HACKERS] What do you want me to do?

2003-11-08 Thread Dave Cramer
I think we should use the best tool available, he is more than willing to allow open source projects to use it for free. Dave On Fri, 2003-11-07 at 23:19, Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Dave Cramer wrote: Jira is a fantastic bug tracking project management system

Re: [HACKERS] logical column position

2003-11-18 Thread Dave Cramer
Will adding the logical attribute number break all of the external tools? pg_dump, etc are all dependent on attnum now? Would it be possible to keep the meaning of attnum the same externally and add another column internally to represent the physical number? Dave

Re: [HACKERS] logical column position

2003-11-19 Thread Dave Cramer
Andreas, The point of this is to maintain the column position. I don't think that an alter of a column type should move the column position. It may be that programmers should not rely on this, but it happens, and in very large projects. If we can avoid unexpected side-affects like moving the

Re: [HACKERS] logical column position

2003-11-19 Thread Dave Cramer
Andreas, On Wed, 2003-11-19 at 13:07, Andreas Pflug wrote: Dave Cramer wrote: Andreas, The point of this is to maintain the column position. I don't think that an alter of a column type should move the column position. Why should ALTER COLUMN change the column number, i.e. position

Re: [HACKERS] ALTER COLUMN/logical column position

2003-11-20 Thread Dave Cramer
Which is what started the whole discussion. Dave On Thu, 2003-11-20 at 04:40, Andreas Pflug wrote: Hannu Krosing wrote: attnum is used internally to retrieve the data Oops... So if an additional column number is invented, it should not be a logical column number, but a

Re: [HACKERS] ObjectWeb/Clustered JDBC

2003-11-25 Thread Dave Cramer
Hans, I don't understand the statement about missing DECLARE CURSOR ? The backend supports it? Dave On Sun, 2003-11-23 at 12:12, Hans-Jürgen Schönig wrote: Peter Eisentraut wrote: I was at the ObjectWeb Conference today; ObjectWeb (http://www.objectweb.org) being a consortium that has

Re: [HACKERS] Functions with COPY

2003-11-27 Thread Dave Cramer
There is a patch floating around for informix load/unload the syntax is load from 'file' insert into , and unload to 'file' select whatever you like Would this solve the problem? Dave On Thu, 2003-11-27 at 09:38, Rod Taylor wrote: On Thu, 2003-11-27 at 09:28, Stephen Frost wrote: *

Re: [HACKERS] Functions with COPY

2003-11-27 Thread Dave Cramer
Stephen, You can do whatever you can do with an insert now, so yes, I think that is possible. Even if the current patch doesn't do that, it would certainly be a start. Dave On Thu, 2003-11-27 at 10:21, Stephen Frost wrote: * Dave Cramer ([EMAIL PROTECTED]) wrote: There is a patch floating

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Dave Cramer
Have a look at Axion for a pure java db http://axion.tigris.org/ Not as full featured,but still useful. Dave On Tue, 2003-12-09 at 13:32, Andrew Dunstan wrote: D'Arcy J.M. Cain wrote: On December 9, 2003 12:15 pm, Neil Conway wrote: P.S. While we're contemplating pies-in-the-sky,

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Dave Cramer
this in java. Dave On Tue, 2003-12-09 at 15:07, Andrew Dunstan wrote: Dave Cramer wrote: Have a look at Axion for a pure java db http://axion.tigris.org/ Not as full featured,but still useful. Er, I take it that not as full featured is an example of meiosis :-) Here's what

[HACKERS] apache rotate logs

2003-12-18 Thread Dave Cramer
I see there is a cvs directory for this, what happened to the contents? Or do we just get this from apache? Dave ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[HACKERS] ecpg tests compile failure

2003-12-18 Thread Dave Cramer
test_thread.pgc:51: undefined reference to `pthread_create' undefined reference to `pthread_join' Dave ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not

Re: [HACKERS] ecpg tests compile failure

2003-12-18 Thread Dave Cramer
Shridhar, Obviously not, but I just did make inside the test directory, so I assume the Makefile needs to be fixed. Thanks, Dave On Thu, 2003-12-18 at 07:21, Shridhar Daithankar wrote: On Thursday 18 December 2003 17:37, Dave Cramer wrote: test_thread.pgc:51: undefined reference

Re: [HACKERS] ecpg tests compile failure

2003-12-18 Thread Dave Cramer
Bruce, You are correct. I did not configure with --enable-thread-safety Dave On Thu, 2003-12-18 at 08:40, Bruce Momjian wrote: Dave Cramer wrote: Shridhar, Obviously not, but I just did make inside the test directory, so I assume the Makefile needs to be fixed. Thanks, Dave

Re: [JDBC] [HACKERS] PL/Java issues

2003-12-31 Thread Dave Cramer
. Dave Cramer and I where discussing a few issues about the PL/Java implementation last night and would like to get more input and suggestions on the matter. The basic question is the definition of the lifetime of an object and it's identificaition when doing nested calls in this context

Re: [HACKERS] PL/Java issues

2004-01-01 Thread Dave Cramer
, but not necessarily on Hackers. Dave Cramer and I where discussing a few issues about the PL/Java implementation last night and would like to get more input and suggestions on the matter. The basic question is the definition of the lifetime of an object and it's identificaition when

Re: [HACKERS] PL/Java issues

2004-01-02 Thread Dave Cramer
? Also, what does the Standard say about all this? Has anyone actually seen it? cheers andrew ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Dave Cramer 519 939 0336 ICQ # 1467551 ---(end

Re: [HACKERS] PL/Java issues

2004-01-03 Thread Dave Cramer
hard it would be. cheers andrew ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Dave Cramer 519 939 0336 ICQ # 1467551

Re: [JDBC] [HACKERS] PL/Java issues

2004-01-03 Thread Dave Cramer
. Dave Cramer and I where discussing a few issues about the PL/Java implementation last night and would like to get more input and suggestions on the matter. The basic question is the definition of the lifetime of an object and it's identificaition when doing nested calls in this context

Re: [HACKERS] Announce: Search PostgreSQL related resources

2004-01-05 Thread Dave Cramer
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 3: if posting/reading through Usenet

[HACKERS] processing of unknown datatype

2004-01-06 Thread Dave Cramer
How does the unknown data type get processed, there doesn't seem to be any casts for it? I have a function expecting a timestamp, cstring, cstring if I pass it a timestamp, unknown, unkown it works? if I pass it an unknown, unknown, unkown, it can't be found? Dave -- Dave Cramer 519 939 0336

Re: [HACKERS] processing of unknown datatype

2004-01-06 Thread Dave Cramer
You are correct, it can't choose Dave On Tue, 2004-01-06 at 19:47, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: I have a function expecting a timestamp, cstring, cstring if I pass it a timestamp, unknown, unkown it works? if I pass it an unknown, unknown, unkown, it can't be found

Re: [HACKERS] processing of unknown datatype

2004-01-06 Thread Dave Cramer
So how can I create a function that it will choose, the option of casting is not available to me Dave On Tue, 2004-01-06 at 19:47, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: I have a function expecting a timestamp, cstring, cstring if I pass it a timestamp, unknown, unkown

[HACKERS] failed to re-find parent key

2004-01-13 Thread Dave Cramer
not create the oid index on the select into. I realize this is beyond the realm of supported code, but can anyone tell me what's going on or a better way to fix it. BTW, the real problem is that select * from foo where oid=? doesn't use an index scan. Dave -- Dave Cramer 519 939 0336 ICQ # 1467551

Re: [HACKERS] failed to re-find parent key

2004-01-13 Thread Dave Cramer
Sorry folks, this is a red-herring, my hack didn't have anything to do with it. It occurs with or without the index. Question is was there a bug between 7.4 and 7.4.1 which may have caused this? Dave On Tue, 2004-01-13 at 16:30, Dave Cramer wrote: I have hacked analyze.c to automatically create

Re: [HACKERS] failed to re-find parent key

2004-01-13 Thread Dave Cramer
I can't recreate it either, it is only happening on my customers machines, which are using an older version of redhat (7.2) and gcc 2.96 Is it possible these versions are relevant to the issue? Dave On Tue, 2004-01-13 at 19:05, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Sorry

Re: [HACKERS] failed to re-find parent key

2004-01-13 Thread Dave Cramer
On Tue, 2004-01-13 at 21:16, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: I can't recreate it either, it is only happening on my customers machines, which are using an older version of redhat (7.2) and gcc 2.96 Is it possible these versions are relevant to the issue? Hmm

Re: [HACKERS] failed to re-find parent key

2004-01-14 Thread Dave Cramer
Ok, that seems to have fixed it, so my next question is how did it get corrupt? Dave On Tue, 2004-01-13 at 23:07, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Actually the hack checks for oids, and doesn't make the index, if there isn't an oid in the table, so I tried

[HACKERS] building plperl on 7.4.1

2004-01-27 Thread Dave Cramer
I tried to build plperl on 7.4.1, On my system perl -MConfig -e 'print $Config{ccdlflags}' returns -rdynamic -Wl,-rpath,/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE however the build ends up using -rpath,$prefix/lib Dave -- Dave Cramer 519 939 0336 ICQ # 1467551

[HACKERS] index scan with functional indexes

2004-01-27 Thread Dave Cramer
an index scan ? How? the db is using locale 'C' -- 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])

Re: [HACKERS] index scan with functional indexes

2004-01-27 Thread Dave Cramer
at 12:33, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: create index r_url_idx on url( fn_strrev(url)); explain select * from url where url like fn_strrev('%beta12.html'); QUERY PLAN - Seq Scan on url

Re: [HACKERS] index scan with functional indexes

2004-01-27 Thread Dave Cramer
ms (3 rows) On Tue, 2004-01-27 at 13:02, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: davec=# explain analyze select * from url where fn_strrev(url) like '%beta12.html'; Don't you need the % at the right end to have an indexable plan? I suspect that both of your tries so far

Re: [HACKERS] index scan with functional indexes

2004-01-27 Thread Dave Cramer
I'm using 7.4.1, the db was initdb --locale='C' and no I don't get them on plain indexes Dave On Tue, 2004-01-27 at 13:28, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Tried, all the suggestions Mph. It works for me... what PG version are you using exactly, and are you

Re: [HACKERS] index scan with functional indexes -- solved

2004-01-27 Thread Dave Cramer
'%beta12.html'; 3310.38 ms Dave On Tue, 2004-01-27 at 13:48, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: I'm using 7.4.1, the db was initdb --locale='C' and no I don't get them on plain indexes Oh? If it's 7.4 then you can confirm the locale selection with show lc_collate

Re: [HACKERS] Pl/Java - next step?

2004-02-22 Thread Dave Cramer
Hallgren ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [HACKERS] Pl/Java - next step?

2004-02-22 Thread Dave Cramer
. There are numerous cases when you will be happy just communicating with the database, communicate with another remote resource (message queue typically), or not communicate at all (calculations, etc.). Regards, Thomas Hallgren -- Dave Cramer 519 939 0336 ICQ # 14675561

Re: [HACKERS] Pl/Java - next step?

2004-02-23 Thread Dave Cramer
out of trouble. /s/would/will Laszlo Hornyak Regards, Thomas Hallgren -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] redhat 9 rpms

2004-03-02 Thread Dave Cramer
I can find rpms for rh8, rhel 3 but not rh9; is there some reason why they aren't necessary? Are rhel 3 binaries compatible with rh9? -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

[HACKERS] Some one deleted pg_database entry how to fix it?

2004-03-16 Thread Dave Cramer
psql dbname can still connect but when I go to the pg_database table the db is not there as a result I cannot do a pg_dump on it? I tried forcing an entry into pg_database but it won't allow me to set the oid ? Dave -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end

Re: [HACKERS] Some one deleted pg_database entry how to fix it?

2004-03-16 Thread Dave Cramer
: Dave Cramer [EMAIL PROTECTED] writes: psql dbname can still connect but when I go to the pg_database table the db is not there as a result I cannot do a pg_dump on it? Hm, it doesn't make a lot of sense that fresh connections would still succeed if the pg_database row is deleted

[HACKERS] pl/j looking for alpha testers

2004-04-20 Thread Dave Cramer
Hi, Pl/J is a java procedural language for postgres. We are looking for alpha testers to help us find bugs, and get feedback. The project can be found at http://plj.codehaus.org/ Bugs can be reported at http://jira.codehaus.org/secure/BrowseProject.jspa?id=10430 Regards, Dave -- Dave

Re: [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Dave Cramer
. Matthew ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html !DSPAM:40892fd393131228097780! -- Dave Cramer 519 939 0336 ICQ # 14675561

Re: [HACKERS] pl/j looking for alpha testers

2004-04-26 Thread Dave Cramer
The reason we are using pl/j instead of pl/java is that the word java is protected by sun. We chose J, who knew there was a programming language called J :( --dc-- On Tue, 2004-04-20 at 15:19, Chris Browne wrote: [EMAIL PROTECTED] (Dave Cramer) writes: Pl/J is a java procedural language

[HACKERS] question about information_schema

2004-05-18 Thread Dave Cramer
that the user is the owner of the cluster. I see that pg_dump can do this ? -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[HACKERS] pg_type oid's do they change from version to version

2004-05-19 Thread Dave Cramer
into java type values, so if we can rely on the oids not changing then it would make it easier. -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Downloadable Mailing List Archives

2004-05-21 Thread Dave Cramer
unregister YourEmailAddressHere to [EMAIL PROTECTED]) !DSPAM:40ae452d278361798176055! -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs

[HACKERS] move 0 behaviour

2002-10-11 Thread Dave Cramer
Currently there is a TODO list item to have move 0 not position to the end of the cursor. Moving to the end of the cursor is useful, can we keep the behaviour and change it to move end, or just leave it the way it is? Dave ---(end of

Re: [HACKERS] [JDBC] Conversion between UNICODE and LATIN1 is not supported

2002-12-18 Thread Dave Cramer
)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge

[HACKERS] interactive docs error

2003-01-25 Thread Dave Cramer
Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: Sorry, too many clients already in /usr/local/www/www.postgresql.org/idocs/opendb.php on line 3 Unable to access database -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast

[HACKERS] Request for qualified column names

2003-01-26 Thread Dave Cramer
-- Dave Cramer [EMAIL PROTECTED] Cramer Consulting This is useful for some O/R tools. The JDBC spec has a getTableName method for each column in a result set. One issue which will come up is what to do with aggregate, and computed values. For now, we could return null So for a select a, b

Re: [HACKERS] how do I get the table name from a query?

2003-01-27 Thread Dave Cramer
to know this to discover nullability of fields, uniqueness, etc. Thanks Reggie -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Request for qualified column names

2003-01-28 Thread Dave Cramer
The method in question is ResultSetMetaDate.getTableName(int column) and while were at it ResultSetMetaData.getSchemaName(int column) and FWIW, the return value if not applicable is Dave On Tue, 2003-01-28 at 17:21, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Dave Cramer says

Re: [HACKERS] JDBC drivers and streaming content

2003-01-29 Thread Dave Cramer
commands go to [EMAIL PROTECTED] -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] [Fwd: [JDBC] 7.3.2 psql error!] GLIBC_2.3 not found

2003-02-18 Thread Dave Cramer
http://www.ritterdosreis.br [EMAIL PROTECTED] Fone/Fax.: (51)32303341 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting

[HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Dave Cramer
clause ::= update target equals operator row value designator update target ::= object column | left paren object column list right paren or can someone think of another way? -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast

[HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Dave Cramer
It would appear that this is SQL3 compliant set clause ::= update target equals operator row value designator update target ::= object column | left paren object column list right paren or can someone think of another way? -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Dave Cramer
-- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Dave Cramer
Ok, if a patch were submitted to the parser to allow the syntax in question would it be considered? Dave On Wed, 2003-02-19 at 12:29, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Referring to http://src.doc.ic.ac.uk/packages/dbperl/refinfo/sql3/sql3bnf.sep93.txt the following

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Dave Cramer
as well. I believe the aubit project has the potential to move postgres forward considerably as well. Dave On Wed, 2003-02-19 at 21:08, Justin Clift wrote: Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Ok, if a patch were submitted to the parser to allow the syntax in question would

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-20 Thread Dave Cramer
Database document to see what it had to say, and on this subject, and it looks like update is going to be supporing this same style we're discussing here. Look on or around p. 858 in that doc.) -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-24 Thread Dave Cramer
Given that the direction of the spec seems to be headed towards the desired syntax, can we put this on the TODO list? Dave On Thu, 2003-02-20 at 11:49, Dave Cramer wrote: Scott, I can't find page 858 in that document, is it the right one? also the link s/b ? ftp://ftp.sqlstandards.org

Re: [HACKERS] Intel drops 64-bit Itanium response from Linus

2003-02-25 Thread Dave Cramer
. -- Alan Perlis ---(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 -- Dave Cramer [EMAIL

[HACKERS] autocommit off mode, how does it work?

2003-02-25 Thread Dave Cramer
-- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] autocommit off mode, how does it work?

2003-02-25 Thread Dave Cramer
what cvs version are you working with? Dave On Wed, 2003-02-26 at 01:11, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Can someone point me to the documentation for the new autocommit mode behaviour, I must be doing something wrong Must be :-(. I repeated your example as best I

Re: [HACKERS] autocommit off mode, how does it work?

2003-02-26 Thread Dave Cramer
Sorry for the noise, my instance of postgres was broken. Dave On Wed, 2003-02-26 at 02:19, Dave Cramer wrote: what cvs version are you working with? Dave On Wed, 2003-02-26 at 01:11, Tom Lane wrote: Dave Cramer [EMAIL PROTECTED] writes: Can someone point me to the documentation

[HACKERS] Request for quote

2003-03-11 Thread Dave Cramer
I have a customer porting an application from informix to postgres. They require 2 things: 1) Cursors outside of transactions. 2) For update cursors as well as where current of If anyone is interested in this work, please reply off list. -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting

Re: [HACKERS] Roadmap for FE/BE protocol redesign

2003-03-12 Thread Dave Cramer
query the system catalogs easily for whatever extra info they like. Regards, Dave. -- Dave Cramer [EMAIL PROTECTED] -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Request for quote looking to pay for work

2003-03-13 Thread Dave Cramer
Thought I would change the title to see if anyone would respond? It wasn't clear but the intent was to support the following in the backend. On Tue, 2003-03-11 at 18:20, Dave Cramer wrote: I have a customer porting an application from informix to postgres. They require 2 things: 1) Cursors

Re: [HACKERS] Roadmap for FE/BE protocol redesign

2003-03-12 Thread Dave Cramer
a throrough investigation of semantics. regards, Hiroshi Inoue http://www.geocities.jp/inocchichichi/psqlodbc/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Dave Cramer

Re: [HACKERS] cursors outside transactions

2003-03-18 Thread Dave Cramer
)--- TIP 4: Don't 'kill -9' the postmaster -- Dave Cramer [EMAIL PROTECTED] -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [HACKERS] Please clarify with regard to Renaming a Sequence

2003-03-22 Thread Dave Cramer
Andy __ Upgrade Your Email - Click here! -- Dave Cramer [EMAIL PROTECTED] Cramer Consulting ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [HACKERS] Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3

2002-06-04 Thread Dave Cramer
Java is another possibility, since it is already cross platform. Dave On Tue, 2002-06-04 at 01:08, Bruce Momjian wrote: Jean-Michel POURE wrote: - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB packages would be downloaded and installed from Debian mirrors, with

[HACKERS] looking for optimum select for exported keys

2002-06-04 Thread Dave Cramer
The jdbc driver has a method to return the exported keys from a table, we require essentially what the following select returns, but it is slow, can anyone suggest ways to optimize it? Regards, Dave SELECT c.relname as primary, c2.relname as foreign, t.tgconstrname,

Re: [HACKERS] Roadmap for a Win32 port cross platform admin tool

2002-06-10 Thread Dave Cramer
Scott, I just started a java admin tool project on sf called www.sf.net/projects/jpgadmin, which should be able to handle web based interfaces, the idea being to seperate the model and view so that we can support a swing or web interface. Dave On Fri, 2002-06-07 at 18:05, Scott Shattuck

Re: [HACKERS] [JDBC] Shouldn't aborted transaction be an ERROR? (was Re:

2002-06-14 Thread Dave Cramer
I have just tested this on the latest code using the following Connection con = JDBC2Tests.openDB(); try { // transaction mode con.setAutoCommit(false); Statement stmt = con.createStatement(); stmt.execute(select 1/0);

[HACKERS] pgadmin.postgresql.org displaying errors

2002-06-24 Thread Dave Cramer
I am getting lots of errors on pgadmin.postgresql.org Dave ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-25 Thread Dave Cramer
IMO One of the big reasons that MySQL is viewed as being better is it's percieved simplicity. It has a large following because of this, and many of them are not experienced database users, in fact just the opposite. This large user base is perhaps the best marketing that an open source project

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-26 Thread Dave Cramer
I have started a java admin tool on sourceforge just 2 weeks ago actually, www.sf.net/jpgadmin Dave On Wed, 2002-06-26 at 02:51, Christopher Kings-Lynne wrote: What other development options do we have for soemthing that is GUI and portable to all platforms that postgresql runs on? Java?

Re: [HACKERS] Postgres idea list

2002-06-27 Thread Dave Cramer
Josh, 1) There is an open source implementation of java 2) The jdbc driver is much better than it was recently we have made lots of improvements, and it won't affect jpgadmin anyway. I actually think writing the admin tool in java will make the driver better. 3) Don't see this as a big issue we

Re: [HACKERS] Postgres idea list

2002-06-27 Thread Dave Cramer
Dave, Would you consider java as a platform independant language? I have started a project on sf.net called jpgadmin, but I see the duplication of effort as a waste of time. Dave On Wed, 2002-06-26 at 09:45, Dave Page wrote: -Original Message- From: Josh Berkus [mailto:[EMAIL

Re: [HACKERS] Postgres idea list

2002-06-27 Thread Dave Cramer
On Wed, 2002-06-26 at 14:50, Josh Berkus wrote: Dave, 1) There is an open source implementation of java Really? I thought Sun had a patent. www.blackdown.org 2) The jdbc driver is much better than it was recently we have made lots of improvements, and it won't affect jpgadmin

Re: [HACKERS] Postgres idea list

2002-06-27 Thread Dave Cramer
Josh, What do you see as the drawbacks with java, and how can they be circumvented? Dave On Wed, 2002-06-26 at 14:08, Josh Berkus wrote: Daves, Would you consider java as a platform independant language? I have started a project on sf.net called jpgadmin, but I see the duplication of

Re: [HACKERS] Democracy and organisation : let's make a revolution

2002-06-27 Thread Dave Cramer
... On 26 Jun 2002, Dave Cramer wrote: I have started a java admin tool on sourceforge just 2 weeks ago actually, www.sf.net/jpgadmin Dave On Wed, 2002-06-26 at 02:51, Christopher Kings-Lynne wrote: What other development options do we have for soemthing that is GUI

Re: [HACKERS] Fwd: XPg: a new Java PostgreSQL Interface

2002-07-21 Thread Dave Cramer
Gustavo, I had a quick look at it, and it looks great! Couple of questions? 1) Why did you choose the GPL license, I expect it cannot be added to the postgres distribution with that license? Postgres is released under the BSD license. 2) What did you modify in the driver to make it work? 3)

Re: [HACKERS] JDBC does not compile

2002-07-29 Thread Dave Cramer
Make sure you have a clean copy of the source, Barry has done an extensive re-organization to remove the duplicate code between jdbc1, and jdbc2, to prepare for jdbc3. It compiles clean on my machine using jdk1.3.1 Dave On Sun, 2002-07-28 at 22:12, Tatsuo Ishii wrote: It seems JDBC in current

Re: [HACKERS] Virus Emails

2002-07-30 Thread Dave Cramer
uvscan doesn't extract out MIME attachments but amavis does. You have to have a whole lot of un archivers on the system for that reason. Dave On Tue, 2002-07-30 at 22:13, Christopher Kings-Lynne wrote: Hmmm - I'm pretty sure that uvscan won't automatically extract out MIME attachements. You

[HACKERS] Row Versioning, for jdbc updateable result sets

2001-06-13 Thread Dave Cramer
In order to be able to implement updateable result sets there needs to be a mechanism for determining if the underlying data has changed since the resultset was fetched. Short of retrieving the current data and comparing the entire row, can anyone think of a way possibly using the row

Re: [HACKERS] RE: Row Versioning, for jdbc updateable result sets

2001-06-15 Thread Dave Cramer
the number of altered records? (if its zero then you know somethings wrong and can investigate further) - Stuart -Original Message- From: Dave Cramer [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 4:34 AM To: [EMAIL PROTECTED] Subject: Row Versioning, for jdbc updateable

Re: [HACKERS] RE: Row Versioning, for jdbc updateable result sets

2001-06-15 Thread Dave Cramer
Message - From: Tom Lane [EMAIL PROTECTED] To: Dave Cramer [EMAIL PROTECTED] Cc: Henshall, Stuart - WCP [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 15, 2001 10:21 AM Subject: Re: [HACKERS] RE: Row Versioning, for jdbc updateable result sets Dave Cramer [EMAIL PROTECTED] writes: I

[HACKERS] Protocol Documentation

2001-06-15 Thread Dave Cramer
Can someone point me in the direction of any documentation related to client/backend protocol. If it's use the source, that's ok too. Dave ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

RE: [HACKERS] OID wraparound: summary and proposal

2001-08-03 Thread Dave Cramer
I'm not sure this is related to the OID discussion, however I have seen designs where a unique id is required for all the objects in the database. This (IMO) this implies an int8 (or larger) sequence number. It would be nice if we could have different size sequences. Just thought I'd throw

[HACKERS] FW: [JDBC] BIGINT vs Java's long

2001-08-07 Thread Dave Cramer
This came into the jdbc list Apparently bigint is not really 8 bytes??? I test this out with psql test=# create table testbigint (id serial, fp0 int8); NOTICE: CREATE TABLE will create implicit sequence 'testbigint_id_seq' for SERIAL column 'testbigint.id' NOTICE: CREATE TABLE/UNIQUE will

[HACKERS] Fully qualified column names

2001-08-20 Thread Dave Cramer
This is from the jdbc list. Is there any way to get fully qualified column names? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ben Carterette Sent: August 16, 2001 11:02 AM To: Rene Pijlman Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] select on

[HACKERS] Fully qualified column names

2001-08-24 Thread Dave Cramer
This is from the jdbc list. Is there any way to get fully qualified column names? Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ben Carterette Sent: August 16, 2001 11:02 AM To: Rene Pijlman Cc: [EMAIL PROTECTED] Subject: Re: [JDBC] select on

Re: [HACKERS] [BUGS] Bug #613: Sequence values fall back to previously chec

2002-03-14 Thread Dave Cramer
I noticed a message asking if this scenario was consistent with the other reports, and yes it is. We have seen this occuring on our system with versions as old as 7.0. Glad to see someone has finally nailed this one. Dave ---(end of

Re: [HACKERS] Postgresql JDBC-Driver

2004-06-11 Thread Dave Cramer
---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster !DSPAM:40c8fe6b9391076077350! -- Dave Cramer 519 939 0336 ICQ # 14675561 ---(end of broadcast)--- TIP 3: if posting/reading through

  1   2   3   4   >