I would say that in certain contexts it would definitely be
sane/preferable to have a "worker" process work in its boss's transaction.
In the traditional bank example:
Open a transfer transaction:
One application goes to take money out of one account.
The second application goes to put money into
On Sun, Sep 10, 2006 at 09:39:59PM -0600, Michael Fuhr wrote:
> On Mon, Sep 11, 2006 at 02:32:26AM +0200, Jean-Gerard Pailloncy wrote:
> > 1) Is it possible to use the SSL authentification done by apache with
> > PostgreSQL ?
>
> I'm not aware of a way for Apache to proxy PostgreSQL's SSL
> nego
On Mon, Sep 11, 2006 at 02:32:26AM +0200, Jean-Gerard Pailloncy wrote:
> I have setup an apache server with SSL.
> I create a CA, serker.key, server.crt.
> I create a user.key and user.cert.
> Now the apache server accept only the correct certificate for login
> on a given directory.
>
> I have
Hi,I have setup an apache server with SSL.I create a CA, serker.key, server.crt.I create a user.key and user.cert.Now the apache server accept only the correct certificate for login on a given directory.I have a PHP script that query the database using the HTTP login/password as PostgreSQL user/pas
> Hi Brandon,
>
> Thank you for your response.
>
> Yes, I see what you mean when you say that I can list Qty in signed
> integers and use a view. Good point.
>
> But I'm not sure as to using a view vs using a permanent table updated
> by triggers. It seems we are dealing with the clasic tradeoff
Solved:-)
Thanks for your aanswer, now I can go further with
exploring pl/pgsql. Looks nice.
Brgds
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Dino Vliet <[EMAIL PROTECTED]> writes:
> > In my pl/pgsql procedure I have the following
> line:
>
> > execute 'copy cancella to ' || location || ' with
Angva wrote:
> Hello,
>
> I have a question regarding pg_dump and table clustering. Each night a
> job runs that basically does the following:
>
> 1) load large amounts of data from flat files into a schema
> 2) cluster the data
> 3) pg_dump that schema
> 4) copy the resulting dmp to several dest
At 01:12 AM 9/10/2006 +0330, Behrang Saeedzadeh wrote:
Hi,
Shouldn't this create statement trigger an error?
create table bar (col1 int not null default null);
No.
Shouldn't I be forbidden to insert null values into a non null column?
Yes.
Use "not null default null" when you want to f
-Original Message-
From: "maarten" <[EMAIL PROTECTED]>
To: "pgsql-general@postgresql.org"
Sent: 10/09/06 12:34
Subject: Re: [GENERAL] Reinstall problem of PostgreSQL in Windows XP
> PostgreSQL creates an Administrator user you can only get rid of by
> booting XP in "sans echec mode", o
Assuming you are logged on to the XP workstation with an
administrator-level account, you should also be able to do
net user postgres /delete
from the XP command line to delete the postgres user account that was
created by the old installation.
- Bill
> -Original Message-
> From: [
Hi Brandon,
Thank you for your response.
Yes, I see what you mean when you say that I can list Qty in signed
integers and use a view. Good point.
But I'm not sure as to using a view vs using a permanent table updated
by triggers. It seems we are dealing with the clasic tradeoff between
speed & s
I installed postgresql-8.1.4-1 once and then uninstalled it. I also
cleanup the directory
C:\Program Files\PostgreSQL
I tried to reinstall it, but cannot get past the account creation part.
The installer says that the username and/or password are bad. I have to
quit installation. How can I get Post
Am 2006-09-07 17:26:15, schrieb Csaba Nagy:
> > Or what about automatically unsubscribing at that point? (In spite
> > of other ways it's awful, mailman does that rather well.)
>
> ... and voila, you (and now myself) could have been unsubscribed
> yourself on this mail... it's not that hard to ha
I am attempting to accomplish a soft delete with a system using
PostgreSQL, Hibernate, and EJB3(JBoss). I have set up tables with a
column to indicate deleted state. What is the best way to accomplish
this? I have looked into triggers and rules but end up with the same
problem. How can I return to
Hello,
I have a question regarding pg_dump and table clustering. Each night a
job runs that basically does the following:
1) load large amounts of data from flat files into a schema
2) cluster the data
3) pg_dump that schema
4) copy the resulting dmp to several destination databases
5) pg_restore
Dino Vliet <[EMAIL PROTECTED]> writes:
> In my pl/pgsql procedure I have the following line:
> execute 'copy cancella to ' || location || ' with
> delimiter as \',\'';
quote_literal(location) would work much better and more safely.
regards, tom lane
-
On 10-Sep-06, at 12:12 AM, Jack Orenstein wrote:
Tom Lane wrote:
"Peter L. Berghold" <[EMAIL PROTECTED]> writes:
What I'm seeing is the first time my web application is being run
there
is a bunch of processes running around that look like:
"postgres: peter peter_trialdb 127.0.0.1(46222) idl
Hi,
In my pl/pgsql procedure I have the following line:
execute 'copy cancella to ' || location || ' with
delimiter as \',\'';
Location is a string that gives the absolute pathname.
It's obvious what I'm aiming for, but this still gives
an error because of the two '' I'm missing around the
loca
PostgreSQL creates an Administrator user you can only get rid of by
booting XP in "sans echec mode", or whatever this is called in your
language.
You otherwise won't be able to see this user.
You will also most likely need some register cleaning tools to get rid
of it completely and or change
A statement level trigger is basically a notification that the table has
been touched. You do not have access to the new or old tables.
You can also write a DO ALSO rule on the table, which will accomplish
what you want.
Joseph Shraibman wrote:
I have a trigger that updates a count table, based
If there is no default statement, then the default (by default) is null.
What you are suggesting is that every field that is not null should
require a default value.
Behrang Saeedzadeh wrote:
Stephan,
But "not null" is in contradiction with "default null" so the create
statement should not pr
21 matches
Mail list logo
