Thread: beta2 or cvs?

beta2 or cvs?

From
Antoine
Date:
Hi,
I am intending using the latest and greatest postgresql to learn about
how it works and where it is heading (the project I am on is in for
the long haul, and won't need to be "in production" for months
yet...), so is the best place to be for the time being cvs? I am
running gentoo so we get the hottest of the press in terms of releases
but would it be better to be even closer? I am not at all bothered
about the odd bug, and would like to be involved in the testing
process - a lot of projects just tell you to update to the latest cvs
before reporting a bug, is that the general story here?
Cheers
Antoine

--
G System, The Evolving GUniverse - http://www.g-system.at

Re: beta2 or cvs?

From
Tom Lane
Date:
Antoine <melser.anton@gmail.com> writes:
> I am intending using the latest and greatest postgresql to learn about
> how it works and where it is heading (the project I am on is in for
> the long haul, and won't need to be "in production" for months
> yet...), so is the best place to be for the time being cvs? I am
> running gentoo so we get the hottest of the press in terms of releases
> but would it be better to be even closer? I am not at all bothered
> about the odd bug, and would like to be involved in the testing
> process - a lot of projects just tell you to update to the latest cvs
> before reporting a bug, is that the general story here?

If it's convenient for you to pull from CVS, by all means do that.
Another option is to grab the nightly CVS-snapshot tarball from our ftp
servers (look in the dev/ directory).

If we were not in beta phase, I'd not necessarily recommend using CVS
;-) but since we are, CVS tip should theoretically be as or more stable
than the last beta.

            regards, tom lane

A generic question: Schema without foreign key specification?

From
Kumar S
Date:
Dear group,
 While designing 3-4 different schemas for my
database, a question has been chasing me. I am not a
CS graduate and I was never taught the nitty gritty's
of Dabase schema or rules.

My question is - a schema that has no foreign key
defined (except in 1 or 2 instances), will it be
considered a good schema or bad schema by experts.

Imagine a scenario where most of the relations are
defined by linker tables(relationship table) that is
formed by two different primary keys from two
different tables are defined to avoid foreign key
relationships. creating a database in this kind of
scenario, can it be considered a good database design.


I hope it is not a stupid question. If it is please
excuse my ignorance.

Thanks
Kumar.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: A generic question: Schema without foreign key specification?

From
Josh Berkus
Date:
Kumar,

>  While designing 3-4 different schemas for my
> database, a question has been chasing me. I am not a
> CS graduate and I was never taught the nitty gritty's
> of Dabase schema or rules.

Me neither.  I learned the hard way, on the job.

> My question is - a schema that has no foreign key
> defined (except in 1 or 2 instances), will it be
> considered a good schema or bad schema by experts.

Bad, unless there's only 2 or 3 tables for your 1 or 2 joins.

> Imagine a scenario where most of the relations are
> defined by linker tables(relationship table) that is
> formed by two different primary keys from two
> different tables are defined to avoid foreign key
> relationships. creating a database in this kind of
> scenario, can it be considered a good database design.

But in that case you should have FKs from the linker tables.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco