[GENERAL] how to insert xml datatype using jdbc?

hi all, I'm trying to use SQLXML ( con.createSQLXML();) with 8.4-703 jdbc4 and I'm getting this : Method org.postgresql.jdbc4.Jdbc4Connection.createSQLXML() is not yet implemented. how do I insert xml data type using jdbc in postgre 8.4? thanks. -- Sent via pgsql-general mailing list (pgsql-g

[GENERAL] Unable to upgrade old cluster from 8.4 to 9.0

Hello, I have Debian Linux (unstable) server, and I am trying to upgrade 8.4 version database to 9.0, all developer packages for both versions were installed, as well as client ( postgresql-server-dev-8.4 postgresql-client-8.4 postgresql-server-dev-9.0 postgresql-client-9.0). Here is the comma

[GENERAL] Some interesting errorcodes (FreeBSD) PG 7.1 from cvs

65539 2137653008 --rw-rw-rw- nobody nobody 100 m 65541 1238250651 --rw-rw-rw- nobody nobody 100 m 65542 1266349731 --rw-rw-rw- nobody nobody 100 m 65543 360309096 --rw-rw-rw- nobody nobody 100 m 65544 1444703832 --rw-rw-rw- nobody nobody 5242880 -- Boris

RE: [GENERAL] Thing that makes me go "Hmmm"

> Bruce Tong writes: >> PostgreSQL wants to create a file for each table. BT> /var/lib/pgsql/base/zztong/* BT> There is a file there named "mytemp" but it is empty. I've run into this situation before -- it appears to be a Postgres bug. You start a command that creates a table, and cancel

[GENERAL] [ANN] ODB C++ ORM adds support for PostgreSQL

additional column definition options. A more detailed discussion of the new features as well as some performance numbers for the new PostgreSQL support can be found in the following blog post: http://www.codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/ For the complete list of new

[GENERAL] migrating/spliting Postgres data directory on OpenIndiana

en about a decade since I've administered Postgres:) Thank you for any and all help, Cheers, Boris.

[GENERAL] Postgres 8.4 on OpenIndiana would not shutdown

tting down LOG: shutting down LOG: database system is shut down LOG: database system was shut down at 2012-10-26 12:22:00 EDT LOG: database system is ready to accept connections LOG: autovacuum launcher started Would anybody know what's wrong with this picture? And how to fix it? Thanks. Boris.

Re: [GENERAL] Postgres 8.4 on OpenIndiana would not shutdown

On Fri, Oct 26, 2012 at 12:46 PM, Tom Lane wrote: > Boris Epstein writes: > > The Postgres 8.4 would simply not shutdown for me. Don't know why: > > > Here's a snippet of /var/postgres/8.4/data_64/server.log seemingly > > corresponding to these shutdown attempt

[GENERAL] control file errors

happen? 2) When that does happen is there a way to re-init that control file somehow? Thanks. Boris.

[GENERAL] migration

**I've also tryed to move DB from 7.4 (linux) to 7.4 (cygwin) but same errors acured. Is there some bug in 7.4 or pg_dumpall i should know about ? Any idea? Boris

[GENERAL] is it possible to get current_user inside security definer function ?

Is there any way to get the name of the current user inside a plpgsql function that is defined with security definer? I know that this question was discused earlier, and session_user should be the answer, but user's curren_user doesn't have to be the same as session_user before function call

Re: [GENERAL] pid of current session?

P> then look the rest in pg_stat_activity. Please nevermind, I must have missed it in the docs the first time. select * from pg_stat_activity where procpid = pg_backend_pid(); -- -Boris ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] pid of current session?

Hello pgsql-general, Is there a way to tell which session from 'select * from pg_stat_activity' is a current session? Obviously if there's way to find out pid of a current session by some other means I could then look the rest in pg_stat_activity. Tha

[GENERAL] Help with "locking" please

stict would be to make procpid reference pg_stat_activity(procpid), but of course that's a view, so its not going to fly. What's a common pattern that deals with these kinds of issues? I'd like to be able to do this in other areas of the application also. Any help will be appreciated! --

[GENERAL] Temp rows - is it possible?

Hello pgsql-general, I'm trying to implement a table with rows that are automatically deleted when the session that inserted them disconnects, sort of like our own alternative to pg_stat_activity. Is it possible and what approach should I be trying to achieve such a thing? Thanks! -- -

Re: [GENERAL] Temp rows - is it possible?

Hello Dennis, Friday, November 7, 2003, 1:29:32 PM, you wrote: DG> Boris Popov wrote: >>Hello pgsql-general, >> >>I'm trying to implement a table with rows that are automatically >>deleted when the session that inserted them disconnects, sort of like >>o

Re: [GENERAL] Temp rows - is it possible?

temp rows in tables visible to everyone? I worked around the original problem I had by using custom entries in pg_listener (listen "identifier") and that works well because they disappear as soon as backend detects the disconnect, but I'd really like to be able to do exact same thing out

[GENERAL] [Fedora Core 1] yum repositories with 7.4?

ant some expert advice on how to upgrade the installation without breaking it. Thanks! -- -Boris ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTE

[GENERAL] concurrency

they proceed extremely slowly) until after the large operation is finished. Is there any way around this limitation? Is this something that can be addressed through parameter tweaking of the postmaster, or would it be solved by having multiple CPUs on the database machine? Boris Goldowsky

[GENERAL] V6.4.2 port to SCO Openserver 5.0.5

Is there a binary for this port? Or is there a HOW-TO to compile this. I have seen some threads on 6.3 but I am trying to compile 6.4.2 and it is failing with an error 2 and a few other errors in the make. TIA -- "Mr. Scott ..One to Beam up!" John J. Boris, Sr. JEN-A-Sys Adm