sql-ledger-users

database constraints

[Damon T. <da...@ra...>]

Hi,

I'm new to sql-ledger and new to postgresql but I can't seem to find where the constraint and index 
definitions are stored in the install scripts.  If anyone can point me in the right direction I 
would sure appreciate it.  If this a rtfm question I apologize in advance.

Thanks,
Damon

Ranksix Solutions Inc.
da...@ra...
250.514.6616

Re: database constraints

[Kenneth G. <la...@th...>]

this list does not have an rtfm option because there is no fm!
kg
On Thursday 07 March 2002 23:42, Damon Torgerson wrote:
  If
> this a rtfm question I apologize in advance.
>
> Thanks,
> Damon

Re: database constraints

[elizabeth z. <eli...@li...>]

At the risk of being flamed....


A) There *is* a manual - you need to buy it and it is comes with the
excellent support from Dieter. It's an amazingly good deal too.

B) There *are* notes that have been published over time and coalesced
at: http://www.minnesota.com/~tom/sql-ledger/howtos/

C) to quote my partner, if the above does not work for you, WTFM where
the W stands for Write :)

Cheers
elizabeth ziph





On Thu, 2002-03-07 at 21:31, Kenneth Gonsalves wrote:
> this list does not have an rtfm option because there is no fm!
> kg
> On Thursday 07 March 2002 23:42, Damon Torgerson wrote:
>   If
> > this a rtfm question I apologize in advance.
> >
> > Thanks,
> > Damon

Re: database constraints

[Damon T. <da...@ra...>]

Hmmmmmm....

This thread is getting a little off course.

My question pretty much has a yes or no answer.  Are the database constraints (foreign keys, check, 
etc) handled by the database or by the perl code?

Thank you all very much for your help,
Damon

Quoting elizabeth ziph <eli...@li...>:

> At the risk of being flamed....
> 
> 
> A) There *is* a manual - you need to buy it and it is comes with the
> excellent support from Dieter. It's an amazingly good deal too.
> 
> B) There *are* notes that have been published over time and coalesced
> at: http://www.minnesota.com/~tom/sql-ledger/howtos/
> 
> C) to quote my partner, if the above does not work for you, WTFM where
> the W stands for Write :)
> 
> Cheers
> elizabeth ziph
> 
> 
> 
> 
> 
> On Thu, 2002-03-07 at 21:31, Kenneth Gonsalves wrote:
> > this list does not have an rtfm option because there is no fm!
> > kg
> > On Thursday 07 March 2002 23:42, Damon Torgerson wrote:
> >   If
> > > this a rtfm question I apologize in advance.
> > >
> > > Thanks,
> > > Damon
> 
> 
> 


Ranksix Solutions Inc.
da...@ra...
250.514.6616

Re: database constraints

[Dieter S. <dsi...@sq...>]

Anyone who knows about database constraints must have a reason for asking.

What's yours.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Fri, 8 Mar 2002, Damon Torgerson wrote:

> Hmmmmmm....
> 
> This thread is getting a little off course.
> 
> My question pretty much has a yes or no answer.  Are the database
> constraints (foreign keys, check, etc) handled by the database or by
> the perl code?
> 
> Thank you all very much for your help,
> Damon

Re: database constraints

[Wil C. <wc...@na...>]

Also Sprach Damon Torgerson <da...@ra...> on Fri, Mar 08, 2002 at 11:=
01:38AM PST
> Hmmmmmm....
>=20
> This thread is getting a little off course.
>=20
> My question pretty much has a yes or no answer.  Are the database constra=
ints (foreign keys, check,=20
> etc) handled by the database or by the perl code?
>=20
> Thank you all very much for your help,

Maybe it's a matter of RTFS? :)

Looking over sql-ledger/sql/Pg-tables.sql, I don't actually see a
lot of integrity rules; in fact, I don't even see any primary keys,
although there might be defaults that I don't know about.

Hm, this is interesting.  'id' is a single sequence, that most
of the tables use for their 'id' field.  If I'm not mistaken,
this means none of the table ids will be internally contiguous,
because the id sequence will increment for every table update.

Wil
--=20
W. Reilly Cooley                           wc...@na...
Naked Ape Consulting                        http://nakedape.cc
irc.linux.com                                     #orlug,#lnxs

The penalty for laughing in a courtroom is six months in jail; if it
were not for this penalty, the jury would never hear the evidence.
		-- H. L. Mencken