[GENERAL] Postgres Security Checklist

2009-04-04 Thread Eduardo Henrique
Hi, I'm developing a Graduation Work about Database security. My idea is develop an application that connect in an database (in this case Postgres) and make some security verification of that db. The problem is that my verification only can be in a dabatase scope. I can't include Network and OS thr

Re: [GENERAL] uuid-ossp

2009-04-04 Thread Chris spotts
Go figure, eh? It wasn't there when I installed the RHEL version. But its all good. Chris On Sat, 2009-04-04 at 22:28 +0300, Devrim GÜNDÜZ wrote: > On Sat, 2009-04-04 at 11:36 -0500, Chris spotts wrote: > > Well, the only file that shows up is the uninstall file? Thats a > > little odd. > > I s

Re: [GENERAL] strange behavior of plpgsql function

2009-04-04 Thread Merlin Moncure
On Sat, Apr 4, 2009 at 10:07 AM, Justin wrote: > I think i may be the way the function is being called?? > > if you are doing Select fnvs.docrelatedassociatedetails() > > it will not return any records, it needs to be > > Select * From fnvs.docrelatedassociatedetails() select func(); will return

Re: [GENERAL] uuid-ossp

2009-04-04 Thread Devrim GÜNDÜZ
On Sat, 2009-04-04 at 13:03 -0700, David Kerr wrote: > FWIW it's not in contrib on SLES 11 or on opensuse 11 for 8.3 I am about to announce OpenSuSE 11+ and SLES 10+ RPMs soon, really soon, which will include all features that PGDG Fedora/RH/CentOS RPMs have. If you are not in a hurry, you may wai

Re: [GENERAL] uuid-ossp

2009-04-04 Thread David Kerr
FWIW it's not in contrib on SLES 11 or on opensuse 11 for 8.3 I'm planning on rolling my own from source as well. Dave Kerr Chris spotts wrote: Thanks, I got it installed from source and got uuid-ossp working. One of the easier installs from source for a major app that I've done. Appreciate

Re: [GENERAL] uuid-ossp

2009-04-04 Thread Devrim GÜNDÜZ
On Sat, 2009-04-04 at 11:36 -0500, Chris spotts wrote: > Well, the only file that shows up is the uninstall file? Thats a > little odd. I see these files on my 8.4 : /usr/share/pgsql/contrib/uninstall_uuid-ossp.sql /usr/share/pgsql/contrib/uuid-ossp.sql See second one. It is there. uuid support

Re: [GENERAL] uuid-ossp

2009-04-04 Thread Chris spotts
Thanks, I got it installed from source and got uuid-ossp working. One of the easier installs from source for a major app that I've done. Appreciate the help. Chris On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote: > Chris spotts writes: > > I’m brand new to Postgresql and working on moving an

Re: [GENERAL] uuid-ossp

2009-04-04 Thread Chris spotts
Well, the only file that shows up is the uninstall file? Thats a little odd. Looks like I'll be rebuilding from source on monday...joyous. On Sat, 2009-04-04 at 11:40 -0400, Tom Lane wrote: > Chris spotts writes: > > I’m brand new to Postgresql and working on moving an > > existing large DB into i

[GENERAL] uuid-ossp

2009-04-04 Thread Chris spotts
I’m brand new to Postgresql and working on moving an existing large DB into it. I’m trying to get uuid-ossp functions to work. I know the UUID type is installed, but I need the generate functions. I’ve installed postgresql-server and postgresql-contrib from the postgresql yum repos (working with

Re: [GENERAL] strange behavior of plpgsql function

2009-04-04 Thread Justin
I think i may be the way the function is being called?? if you are doing Select fnvs.docrelatedassociatedetails() it will not return any records, it needs to be   Select * From fnvs.docrelatedassociatedetails() c k wrote: Hi all, I am facing a small but strange problem when using a plpgsql f

Re: [GENERAL] Rule or Function and Trigger?

2009-04-04 Thread Giorgio Valoti
Il giorno 03/apr/09, alle ore 16:58, Tom Lane ha scritto: "James B. Byrne" writes: I am beginning to migrate some functionality from an application prototype into the DBMS. One of these elements is time stamping row insertions and updates. I have been reading about rules, functions and tr

[GENERAL] deadlock in trigger before insert

2009-04-04 Thread Piotr Buczek
Hi list, I need to check some complex unique constraint before insert/update to table X so I use a before trigger to do this. If I don't use any explicit lock I get a race condition if two inserts happen very quickly because an insert changes the result of the condition that is checked in the tri

Re: [GENERAL] high load on server

2009-04-04 Thread Scott Marlowe
On Fri, Apr 3, 2009 at 4:13 PM, Erik Jones wrote: > Eh?  His run queue constantly has procs waiting for run time, although I've > seen higher.  That with a distinct lack of heavy IO says cpu bound to me... I just pulled up the linux man page and it says that r is the number of processes waiting t

[GENERAL] strange behavior of plpgsql function

2009-04-04 Thread c k
Hi all, I am facing a small but strange problem when using a plpgsql function as below. CREATE OR REPLACE FUNCTION fnvs.docrelatedassociatedetails(p_docid integer, p_addtype smallint, p_associateid integer, OUT docid integer, OUT associateid integer, OUT addressline1 varchar,OUT addressline2 varch