Re: [GENERAL] PostgreSQL 9.0 RPMs for RHEL 6 and Fedora 14 released

2010-12-03 Thread Devrim GÜNDÜZ
On Sun, 2010-11-21 at 12:39 +0300, Allan Kamau wrote: I am unable to obtain (using yum) a version of pgAdmin3 that can connect fruitfully to postgreSQL 9.x. My installation reports that the version I do have 1.10.5 is the latest. Should be fixed as of yesterday. Regards, -- Devrim GÜNDÜZ

[GENERAL] RESET ROLE and search_path, Connection pool

2010-12-03 Thread Marc Mamin
Hello, We are thinking about using a (java based) connection pool. An issue is that there are many different users to connect. My idea is to only have superuser connections in the pool and change the connection role (with SET ROLE) each time a user pick a connection there. However, I'have

Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread James B. Byrne
On Thu, December 2, 2010 15:32, James B. Byrne wrote: On Thu, December 2, 2010 15:23, Devrim GÜNDÜZ wrote: On Wed, 2010-12-01 at 16:54 -0500, Tom Lane wrote: AFAIK, the Red Hat RPMs work out-of-the-box with SELinux; They should -- we are using the same routines for initdb'ing. I will do

[GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-03 Thread Florian Weimer
The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we get it back, please? -- Florian Weimer

Re: [GENERAL] could not accept SSPI security context

2010-12-03 Thread Brar Piening
Passing null instead of empty string for the principal shouldn't make any difference as an empty CLR-String should be marshalled to an empty (null terminated) C-String. The problem could also be in InitializeSecurityContext which happens in respnse to AuthenticationGSSContinue. If you

Re: [GENERAL] how can i bugfix idle in transaction lockups ?

2010-12-03 Thread Merlin Moncure
On Fri, Dec 3, 2010 at 12:31 AM, Jonathan Vanasco postg...@2xlp.com wrote: begin w/o commit or rollback? and thanks. you've been very helpful! On Nov 30, 2010, at 2:21 PM, Merlin Moncure wrote: Begin w/o commit is a grave application error and you should consider reworking your code base

Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread James B. Byrne
On Wed, December 1, 2010 16:54, Tom Lane wrote: James B. Byrne byrn...@harte-lyne.ca writes: Earlier today I attempted to upgrade a production server from 8.1 to 8.4 using the pgdg-84-centos.repo. I say attempted because I could never get it to support ssl connections and as that is a

Re: [GENERAL] Looking for auto starting procedures

2010-12-03 Thread manfred.braun
Hello ! Yes, thanks, I am just trying to lern the difference. I am comin from Sql Server, but I am not a experienced db developer. But in Sql Server, you may hack your tests just in a direct statement and if it runs, wrap/put it in the function or procedure. Will need some time ;-) Thanks a

Re: [GENERAL] RESET ROLE and search_path, Connection pool

2010-12-03 Thread Derrick Rice
On Fri, Dec 3, 2010 at 5:13 AM, Marc Mamin m.ma...@intershop.de wrote: Hello, We are thinking about using a (java based) connection pool. An issue is that there are many different users to connect. My idea is to only have superuser connections in the pool and change the connection role

Re: [GENERAL] Looking for auto starting procedures

2010-12-03 Thread Guillaume Lelarge
Le 03/12/2010 21:22, manfred.braun a écrit : [...] Yes, thanks, I am just trying to lern the difference. I am comin from Sql Server, but I am not a experienced db developer. But in Sql Server, you may hack your tests just in a direct statement and if it runs, wrap/put it in the function or

[GENERAL] Table design - postgresql solution

2010-12-03 Thread Miguel Vaz
Hi, I have a bit of a DB design question, associated with postgresql in particular, hopefully thinking it could solve my dilemma. This is my setup of 3 tables: Table_1 id_t1 name date_of_discovery history Table_2 id_t2 name type size Table_3 id_t3 name location color I want a solution (table

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-03 Thread Tom Lane
Florian Weimer fwei...@bfk.de writes: The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we get it back,

Re: [GENERAL] PG84 and SELinux

2010-12-03 Thread Tom Lane
James B. Byrne byrn...@harte-lyne.ca writes: I wrote too soon. What I did was uncomment the ssl option. I neglected to change the setting from off to on. When I try to start the server with ssl=on it fails with this error: Auto configuration failed 29006:error:0E065068:configuration file