[HACKERS]
Hi I saw in TODO CLIENTS * Add XML interface: psql, pg_dump, COPY, separate server and there's some code for JDBC in contrib/retep directory. Are there any plans to add xml support to postgresql, to return rown in formatted in xml for start? not only from psql, but from everywhere (e.g. php) I am (as time allows) adding to the xml under contrib/retep, but I don't know of anyone else working on it. Adding xml support to psql shouldn't be too difficult (it has html support already), and there is the ResultSet-XML stuff under contrib/retep. Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS]
Hi I saw in TODO CLIENTS * Add XML interface: psql, pg_dump, COPY, separate server and there's some code for JDBC in contrib/retep directory. Are there any plans to add xml support to postgresql, to return rown in formatted in xml for start? not only from psql, but from everywhere (e.g. php) I am (as time allows) adding to the xml under contrib/retep, but I don't know of anyone else working on it. Adding xml support to psql shouldn't be too difficult (it has html support already), and there is the ResultSet-XML stuff under contrib/retep. Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Toast, Text, blob bytea Huh?
Quoting Joe Conway [EMAIL PROTECTED]: TEXT is a datatype which stores character data of unspecified length (up to the max value of a 4 byte integer in length, although I've seen comments indicating that the practical limit is closer to 1 GB -- not sure why). It may be something to do with the 1Gb splitting of the physical files representing a table... Unless it changed recently, a table was split over multiple files at the 1Gb mark. Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(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: [HACKERS] Final Call: RC1 about to go out the door ...
Quoting The Hermit Hacker [EMAIL PROTECTED]: Okay folks ... We'd like to wrap up an RC1 and get this release happening this year sometime :) Tom mentioned to me that he has no outstandings left on his plate ... does anyone else have any *show stoppers* left that need to be addressed, or can I package things up? Nothing that would stop RC1 (I've still got some testing which I'm doing later tonight). Speak now, or forever hold your piece (where forever is the time between now and RC1 is packaged) ... I'm surprised it hasn't been out already - being worked to death the last two weeks, I'm still catching up with developments :( ... Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] PostgreSQL-JDBC driver
Quoting sourabh dixit [EMAIL PROTECTED]: - Hi, I am trying to access PostGreSQL database running at the default port 5432 using JDBC. But the application is giving error "Cannot find suitable driver". I have included JDBC driver JAR file in my CLASSPATH and Class.forName("org.postgresql.Driver") is loading driver successfully. Can anybody tell me how to go about to solve the problem? Sounds like your URL is wrong. Make sure it begins with jdbc:postgresql: Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(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: [HACKERS] Re: PostgreSQL JDBC Unicode Support
Quoting Tatsuo Ishii [EMAIL PROTECTED]: [Cced: to PostgreSQL hackers list] Alexander, I believe this problem was fixed in the latest JDBC driver, that is supposed to be shipped with 7.1. It asks your database which encoding is used for particular database while connecting to the database. So you should be able to see "select getdatabaseencoding" if you turn on a debugging option for postmaster. I also think the latest driver is compatible with 7.0.3, but I'm not sure. Peter T? It should be at the basic level, but methods in DatabaseMetaData will fail as they are specific to 7.1's system table changes etc. Peter -- Tatsuo Ishii From: "Alexander Vaysman" [EMAIL PROTECTED] Subject: PostgreSQL JDBC Unicode Support Date: Thu, 15 Mar 2001 15:34:43 -0500 Message-ID: [EMAIL PROTECTED] Tatsuo, my name is Alex Vaysman, and I saw your numerous posts in the newsgroups regarding Postgres and mutli-language support. I have a problem with our Postgres database, and intensive searches on the Internet/newsgroups didn't provide me with an answer. I was wondering if you would know the answer or point me towards it. In the nutshell, we are trying to get Postgres DB running that supports Unicode and interacts with clients via JDBC. We have PostgreSQL version 7.0.3 installed. I have downloaded the latest JDBC driver from http://jdbc.postgresql.org. I have created a Unicode database (confirmed through \l command in psql, reported encoding is 'UNICODE'). In that DB I've created a table with two fields integer and varchar(64). Then I store a record into this table. In my code I specify the string through Unicode escapes. After that I retrieve this value and write it out. I don't get my value back but rather ?. I'm attaching the code I use for reference. My Internet searches for the solution indicated that I need to apply some patches to JDBC driver. However, I don't know how to do that. Do you know where I may download the JDBC driver version with the appropriate patches applied? If you're using one, would you be kind enough and e-mail it to me. Also, having some experience with SQL Server, I know that if I wanted to store Unicode values into some column I was creating that column as nvarchar rather the varchar. Is anything like this required for Postgres? Your help is greatly appreciated. Thanks in advance, Alex Vaysman. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(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: [HACKERS] CORBA and PG
Quoting Franck Martin [EMAIL PROTECTED]: I guess these stubs are for accessing PG as a corba server... I'm trying to look to see if I can store CORBA objects inside PG, any ideas... Although I've not tried it (yet) it should be possible to access Java EJB's from corba. If so, then using an EJB server (JBoss www.jboss.org) you could then store them as Entity beans. Each one would then have its own table in the database. Peter Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web site: http://www.sopac.org/ http://www.sopac.org/ Support FMaps: http://fmaps.sourceforge.net/ http://fmaps.sourceforge.net/ This e-mail is intended for its addresses only. Do not forward this e-mail without approval. The views expressed in this e-mail may not be necessarily the views of SOPAC. -Original Message- From: Peter T Mount [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 March 2001 3:52 To: Franck Martin Cc: PostgreSQL List Subject: Re: [HACKERS] CORBA and PG Quoting Franck Martin [EMAIL PROTECTED]: Does anyone has pointers on CORBA and PostgreSQL? What is the story ? There's some old stubs for one of the orbs somewhere in the source (C/C++) Also the old JDBC/Corba example is still there (src/interfaces/jdbc/example/corba) Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] CORBA and PG
Quoting Franck Martin [EMAIL PROTECTED]: Does anyone has pointers on CORBA and PostgreSQL? What is the story ? There's some old stubs for one of the orbs somewhere in the source (C/C++) Also the old JDBC/Corba example is still there (src/interfaces/jdbc/example/corba) Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/ ---(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: [HACKERS] beta5 ...
Quoting The Hermit Hacker [EMAIL PROTECTED]: On Sun, 18 Feb 2001, Tom Lane wrote: The Hermit Hacker [EMAIL PROTECTED] writes: things appear to have quieted off nicely ... so would like to put out a Beta5 for testing ... Unless Peter E. has some more commits up his sleeve, I think we're good to go. okay, I'll put one out Mon aft, just in case of any strays that come up tonight, or any final commits from our overseas committers ... I'm not planning on doing any until after Beta5 is out ;-) Peter thanks ;:) -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
[HACKERS] Quick question about 7.1 SQL92 Entry Level
Just a quick question, but how much of SQL92 Entry Level does 7.1 support, and what parts haven't we got (yet)? I need to know for a couple of internal bits in the JDBC driver... Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
Re: [HACKERS] using the same connection?
Quoting Mathieu Dube [EMAIL PROTECTED]: Hi y'all, Is it a bad idea for an app to keep just a couple of connections to a database, put semaphore/mutex on them and reuse them all through the program? Of course I would check if their PQstatus isnt at CONNECTION_BAD and reconnect if they were... I need some opinions on that practice... In the Java world it's called ConnectionPooling and is standard practice, especially with Servlets/JSP/EJB's. Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
Re: [HACKERS] Postgre SQL for Windows
Quoting sourabh dixit [EMAIL PROTECTED]: Hello! Can anybody tell me the website from which I can download PostgreSQL for Windows95. I'm not sure if it will run under Win95, but I have it running fine under NT using Cygwin and WinIPC. While my linux box was down, I had to use it under NT to work on the JDBC driver. Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
[HACKERS] Format of the Money field
When did the MONEY type change it's output format? While working on the JDBC test suite, Money broke. It seems to output: $10.99 ($10.99) for negative values While since ages past, the PGMoney class interprets it as a number (no currency symbol). Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
[HACKERS] Re: [GENERAL] Trouble porting postgreSQL to WinNT
Quoting Tom Lane [EMAIL PROTECTED]: This doesn't make any sense, since genbki.sh has nothing to do with creating the fmgr.h file. I think your rebuild probably cleaned up something else ... hard to tell what though. On a similar vein, is anyone seeing initdb hanging under NT? So far everything compiles, but it just hangs (CPU isn't going anything either, so it's not looping etc). Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
[HACKERS] Re: [JDBC] Open 7.1 items
Quoting Bruce Momjian [EMAIL PROTECTED]: Here are my open 7.1 items. Thanks for shrinking the list so far. --- FreeBSD locale bug Reorder INSERT firing in rules Philip Warner UPDATE crash JDBC LargeObject short read return value missing Working on this on Saturday. SELECT cash_out(1) crashes all backends LAZY VACUUM FOREIGN KEY INSERT UPDATE/DELETE in transaction "change violation" Usernames limited in length Does pg_dump preserve COMMENTs? Failure of nested cursors in JDBC JDBC doesn't support cursors full stop yet. JDBC setMaxRows() is global variable affecting other objects Does JDBC Makefile need current dir? No as it's obsolete in 7.1 ;-) Fix for pg_dump of bad system tables Steve Howe failure query with rules ODBC/JDBC not disconnecting properly? Client code not calling Connection.close() method. Magnus Hagander ODBC issues? Merge MySQL/PgSQL translation scripts Fix ipcclean on Linux Merge global and template BKI files? Peter -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
Re: [HACKERS] Open 7.1 items
Quoting Bruce Momjian [EMAIL PROTECTED]: I have trickled the emails as I reviewed them, asking for comments. It was not one big email. I haven't seen them either, although my Inbox is big again, and I'm filtering out mails by their subject line, so it's possible I've missed them. I'm slowly working my way through JDBC, but it's all hinging on getting my linux box back online. It's powered up, but not talking to the network :-( Should be sorted by Saturday morning... Peter haven't seen it posted to hackers, or, if I did, I didn't clue into it ... and just checked to see if maybe it was waiting for approval due to size, and nothing in the queue ... posting it here is easier to respond to ... On Wed, 24 Jan 2001, Bruce Momjian wrote: I have about 20 open 7.1 items that I need to get resolved before I can start getting the doc TODO list started. The issues relate to JDBC, ODBC, and lots of other stuff that need to be settled before we can finalize 7.1. They can not be easily summarized in one line. You really have to see the whole email to understand the issues. How do people want to do this? I can post them to hackers, or put them on my web site. I posted them to hackers during the past few days, but many went unanswered. These are all relatively new from the past few months. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/