[GENERAL] PL/Perl 64-bit and sending emails

2009-09-03 Thread Mark Lubratt
Hello! I've been running the 64-bit version of 8.3.4 on OpenSolaris 2009.06 for over a year. Now, I need to put a perl function call into it to allow emails to be sent by the database backend. I tried installing plperl, but it looks like only a 32-bit version is available. Does the 64-

Re: [GENERAL] Running a query as a specific, different user

2006-11-19 Thread Mark Lubratt
Bingo! Thanks! I'm not sure how I missed that one... Mark On Nov 19, 2006, at 2:12 PM, John DeSoi wrote: On Nov 19, 2006, at 11:10 AM, Mark Lubratt wrote: I'm working on a report (using jasperreports) for an application I've written accessing PG 8.1.4. The view I'm

[GENERAL] Running a query as a specific, different user

2006-11-19 Thread Mark Lubratt
Hello all! I'm working on a report (using jasperreports) for an application I've written accessing PG 8.1.4. The view I'm doing the report on needs to run as a the specific user requesting the report; however, the report is connecting to the database using a general username for the repo

Re: [GENERAL] SRFs returning records from a view

2005-06-02 Thread Mark Lubratt
AAARRRGGGHHH... Now I understand you, Josh. Sorry. You are correct. Thanks! Mark On Jun 1, 2005, at 4:39 PM, Joshua D. Drake wrote: [EMAIL PROTECTED] wrote: Hello! I have a view that I'm putting into a report in my application. I'd like to get several blank lines returned by the view as w

Re: [GENERAL] SRFs returning records from a view

2005-06-01 Thread mark . lubratt
> Original Message > Subject: Re: [GENERAL] SRFs returning records from a view > From: "Joshua D. Drake" <[EMAIL PROTECTED]> > Date: Wed, June 01, 2005 4:39 pm > To: [EMAIL PROTECTED] > Cc: pgsql-general@postgresql.org > > [EMAIL PROTECTED] wrote: > > Hello! > > > > I have a v

[GENERAL] SRFs returning records from a view

2005-06-01 Thread mark . lubratt
Hello! I have a view that I'm putting into a report in my application. I'd like to get several blank lines returned by the view as well as the legitimate data (to leave room in the report for manual entries). I thought I could make a SRF that would return the data from the view and then spit out

[GENERAL] Access Conversion

2004-04-10 Thread Mark Lubratt
Hello, I'm trying to convert an Access application to have its backend be PostgreSQL. I've created the schema and imported the data without a problem. My problem is that the Access application wasn't written by me and has numerous queries and table relationships that I want to replace in pl

[GENERAL] Orphaned trigger -- bug?

2004-04-08 Thread Mark Lubratt
I just ran across a situation where I dropped a table that had a trigger created on it. The system let me drop the table without complaining and then I realized/remembered that the trigger also existed. I tried dropping the trigger, but of course that couldn't be done because the target relat