Re: [GENERAL] installation problem - semaphores

2006-04-02 Thread Luca Pireddu
On April 2, 2006 10:35, Tom Lane wrote: > Yadu <[EMAIL PROTECTED]> writes: > > selecting default max_connections ... 10 > > selecting default shared_buffers ... 50 > > creating configuration files ... ok > > creating template1 database in /usr/local1/postgres/data/base/1 ... > > FATAL: could not cr

Re: [GENERAL] Database Comparison tool?

2006-02-11 Thread Luca Pireddu
On February 10, 2006 00:57, Devrim GUNDUZ wrote: > Hi, > > On Wed, 2006-02-08 at 18:22 +, Nicholas Walker wrote: > > Are there any tools that can compare a database schema, and produce sql > > of the changes from one version to the next. > > http://www.sqlmanager.net/en/products/postgresql/dbco

Re: [GENERAL] bug or not? Trigger preventing delete causes circumvention

2005-12-09 Thread Luca Pireddu
On Friday 09 December 2005 09:22, Jan Wieck wrote: > On 12/8/2005 9:12 PM, Luca Pireddu wrote: > > I wrote a trigger function with the intent of preventing the deletion of > > a parent record when a referencing record would not allow it. However, > > the result is that t

[GENERAL] bug or not? Trigger preventing delete causes circumvention of FK

2005-12-08 Thread Luca Pireddu
I wrote a trigger function with the intent of preventing the deletion of a parent record when a referencing record would not allow it. However, the result is that the referencing record stays, but the referenced one is gone, so that my foreign key constraint is not respected. The behaviour can

Re: [GENERAL] Graphical modelling tool

2005-12-06 Thread Luca Pireddu
On Tuesday 06 December 2005 12:58, Thomas Hallgren wrote: > Hi, > I'm about to start a new project where the first task is to design a > database. I'm looking for some tool that will allow me to model the > tables and relationships graphically, UML or similar, and then let me > generate the SQL wit

Re: [GENERAL] lost in system tables

2005-12-06 Thread Luca Pireddu
On Tuesday 06 December 2005 08:47, Emil Rachovsky wrote: > I am trying to find the equivalent of these two > Sybase system columns : > > check_on_commit (Y/N) - Indicates whether INSERT and > UPDATE commands should wait until the next COMMIT > command to check if foreign keys are valid. A foreig