Re: [ADMIN] Forcing postgres to reload current time zone.

<[EMAIL PROTECTED]> writes: > I'm writing an application that issues "SELECT current_timestamp" from > postgres on a regular basis to get the time. However, the user may > change the system's time zone and postgres does not seem to reflect this > change unless I restart the database daemon. I cann

Re: [ADMIN] are there ways for 'idle timeout'?

The best solution would be to fix the web app but Could you set the deadlock_timeout in postgresql.conf? According to documentation that will kill one of the transactions that has issued the lock on the table or row? On Fri, 2004-07-09 at 09:36, Konstantin Pelepelin wrote: > Hi! > > In sit

Re: [ADMIN] Bad dumps...

That could be a bug. How are you dumping the data? pg_dump? Select query? How are you restoring the data? psql? On Fri, 2004-07-09 at 09:16, Stef wrote: > Oops, my button doesn't work... > > Hilary Forbes mentioned : > => Can we go back to the beginning here?! If you are doing updates to

Re: [ADMIN] Perl Modules in PL/Perl functions

Only if Perl has been installed as an untrusted language I believe. See http://www.postgresql.org/docs/7.4/static/plperl-trusted.html On Fri, 2004-07-09 at 11:22, Haron, Charles wrote: > Hello, > > I want to use Mail::Sender in a PL/Perl function. In order to use the > Mail::Sender module, do

Re: [ADMIN] seeing tables across databases

--- Jodi Kanter <[EMAIL PROTECTED]> wrote: > I am working with a colleague who is using postgres > to create a number > of databases. On his system when he views his tables > (\d) he can see > tables from other databases - not all of them but > some. He cannot access > them as the user he is sig

[ADMIN] Secure DB Systems - How to

I was wondering if it is possible to create a secure database system usingPostgreSQL/PHP combination? I have the following in mind: I wanted to store all my( and my brothers and sisters) important document information such as birth certificate, SSN, passport number, travel documents, insurance(ca

[ADMIN] seeing tables across databases

I am working with a colleague who is using postgres to create a number of databases. On his system when he views his tables (\d) he can see tables from other databases - not all of them but some. He cannot access them as the user he is signed in as because he does not have privileges, but he ca

[ADMIN] Perl Modules in PL/Perl functions

Hello, I want to use Mail::Sender in a PL/Perl function. In order to use the Mail::Sender module, do I simply use a 'use' statement in the function definition (i.e. "use Maile::Sender;")? Regards, Charles ---(end of broadcast)--- TIP 9: the planne

Re: [ADMIN] [PHP] Secure DB Systems - How to

On Thu, Jul 08, 2004 at 11:49:36 -0400, Sarah Tanembaum <[EMAIL PROTECTED]> wrote: > I was wondering if it is possible to create a secure database system > usingPostgreSQL/PHP combination? > > I have the following in mind: > > I wanted to store all my( and my brothers and sisters) important doc

[ADMIN] are there ways for 'idle timeout'?

Hi! In situations where client application is unstable there is very big chance that it will enter transaction, acquire very restrictive locks and then hang. This means: connection is not lost, but nothing happens and any transaction in conflict with those locks will hang too. statement_timeo

Re: [ADMIN] Bad dumps...

Oops, my button doesn't work... Hilary Forbes mentioned : => Can we go back to the beginning here?! If you are doing updates to remove the \N, why are you allowing them to get into the database in the first place? Why not get rid of them in your UPDATE statement using the replace statement in

[ADMIN] couldn't download postgres

Hi, does anybody know how I could download the postgres sources? I mean the released version (7.4.3). None of the mirror sites (http://www.postgresql.org/mirrors-ftp.html) are available. Thank you very much. -- Csaba Együd --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus syst

Re: [ADMIN] Bad dumps...

Can we go back to the beginning here?! If you are doing updates to remove the \N, why are you allowing them to get into the database in the first place? Why not get rid of them in your UPDATE statement using the replace statement in the first place (or dealing with them in your source applicat

Re: [ADMIN] Bad dumps...

This is very similar to my problem with the ascii code 13s when I dumped and couldn't load the dumped data. What I did was to write a short script replaced the offending characters with an empty string which is different to NULL. The other alternative is to have myfield text DEFAULT '' NOT NU

[ADMIN] Bad dumps...

Hi all, I'm stuck with a problem,about which I couldn't find much info. I'm sure somebody must have encountered this before. I've got a "NOT NULL" column of type text. It happens that freehand data gets inserted into this table, and it typically contains over 1000 rows with the value '\N' , and a