pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCreate Assertion -- Question from a newbie
8+ messages / 6 participants
[nested] [flat]
* Create Assertion -- Question from a newbie
@ 2006-08-27 07:19 Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: Richard Broersma Jr @ 2006-08-27 07:19 UTC (permalink / raw)
To: pgsql-sql
Sorry if my question is a little off topic.
I am reading my new "SQL for Smarties" book side by side with the PostgreSQL 8.1 manual. I
noticed that this particular feature is not included in PostgreSQL. Some of the achieve threads
mostly discuss that this feature is currently not supported. My understanding is that Assertions
place constraints upon data spanning multiple related tables.
Is the Assertion feature slated to be added in the future? (Perhaps rolled up in a more
generalized "TO-DO" item?)
Would this feature add functionality that can not be achieved by other means? (i.e. alternative
schema definitions or triggers?) Or does it merely provide a redundant means to constrain data,
and thereby not warrant addition into the features of PostgreSQL?
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create Assertion -- Question from a newbie
@ 2006-08-27 13:54 Bruno Wolff III <bruno@wolff.to>
parent: Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: Bruno Wolff III @ 2006-08-27 13:54 UTC (permalink / raw)
To: Richard Broersma Jr <rabroersma@yahoo.com>; +Cc: pgsql-sql
On Sun, Aug 27, 2006 at 00:19:59 -0700,
Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> Sorry if my question is a little off topic.
>
> I am reading my new "SQL for Smarties" book side by side with the PostgreSQL 8.1 manual. I
> noticed that this particular feature is not included in PostgreSQL. Some of the achieve threads
> mostly discuss that this feature is currently not supported. My understanding is that Assertions
> place constraints upon data spanning multiple related tables.
>
> Is the Assertion feature slated to be added in the future? (Perhaps rolled up in a more
> generalized "TO-DO" item?)
>
> Would this feature add functionality that can not be achieved by other means? (i.e. alternative
> schema definitions or triggers?) Or does it merely provide a redundant means to constrain data,
> and thereby not warrant addition into the features of PostgreSQL?
You can accomplish what assertions do using triggers.
I think the issue is generating triggers for general assertions that don't
totally suck performancewise.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create Assertion -- Question from a newbie
@ 2006-08-27 14:39 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 8+ messages in thread
From: Richard Broersma Jr @ 2006-08-27 14:39 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-sql
> You can accomplish what assertions do using triggers.
> I think the issue is generating triggers for general assertions that don't
> totally suck performancewise.
Ah, I see. So the points is that checking the integrity between two complete data sets can become
a preformace killer.
Thanks for the feed back.
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create Assertion -- Question from a newbie
@ 2006-08-28 10:46 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 1 reply; 8+ messages in thread
From: Andrew Sullivan @ 2006-08-28 10:46 UTC (permalink / raw)
To: pgsql-sql
On Sun, Aug 27, 2006 at 07:39:49AM -0700, Richard Broersma Jr wrote:
> Ah, I see. So the points is that checking the integrity between
> two complete data sets can become a preformace killer.
Not necessarily. More exactly, building a support system that can
check such integrity in a completely general way, such that it could
be used for any arbitrary data, is a hard problem that might destroy
performance. It's also a pretty exotic feature. You might want to
ask on the -hackers list for more detail, though.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create Assertion -- Question from a newbie
@ 2006-08-28 14:27 Alvaro Herrera <alvherre@commandprompt.com>
parent: Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 8+ messages in thread
From: Alvaro Herrera @ 2006-08-28 14:27 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; +Cc: pgsql-sql
Andrew Sullivan wrote:
> On Sun, Aug 27, 2006 at 07:39:49AM -0700, Richard Broersma Jr wrote:
>
> > Ah, I see. So the points is that checking the integrity between
> > two complete data sets can become a preformace killer.
>
> Not necessarily. More exactly, building a support system that can
> check such integrity in a completely general way, such that it could
> be used for any arbitrary data, is a hard problem that might destroy
> performance. It's also a pretty exotic feature. You might want to
> ask on the -hackers list for more detail, though.
Well, it's on the SQL standard, so we should look forward to
implementing (some form of) it some day.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create Assertion -- Question from a newbie
@ 2006-08-30 20:47 Gregory Stark <gsstark@mit.edu>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 8+ messages in thread
From: Gregory Stark @ 2006-08-30 20:47 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Well, it's on the SQL standard, so we should look forward to
> implementing (some form of) it some day.
Do *any* databases implement SQL standard Assertions?
--
greg
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create Assertion -- Question from a newbie
@ 2006-08-30 22:00 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Gregory Stark <gsstark@mit.edu>
0 siblings, 1 reply; 8+ messages in thread
From: Andrew Sullivan @ 2006-08-30 22:00 UTC (permalink / raw)
To: pgsql-sql
On Wed, Aug 30, 2006 at 04:47:29PM -0400, Gregory Stark wrote:
>
> Do *any* databases implement SQL standard Assertions?
Somebody must've had an implementation, or it'd never have made it
into the spec ;-)
A
--
Andrew Sullivan | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create Assertion -- Question from a newbie
@ 2006-08-31 03:08 Christopher Browne <cbbrowne@acm.org>
parent: Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 8+ messages in thread
From: Christopher Browne @ 2006-08-31 03:08 UTC (permalink / raw)
To: pgsql-sql
ajs@crankycanuck.ca (Andrew Sullivan) wrote:
> On Wed, Aug 30, 2006 at 04:47:29PM -0400, Gregory Stark wrote:
>>
>> Do *any* databases implement SQL standard Assertions?
>
> Somebody must've had an implementation, or it'd never have made it
> into the spec ;-)
Supposedly, RDB had this feature... Of course, it disappeared into
the Oracle empire...
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/slony.html
Signs of a Klingon Programmer - 18. "Perhaps it IS a good day to die!
I say we ship it!"
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2006-08-31 03:08 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-27 07:19 Create Assertion -- Question from a newbie Richard Broersma Jr <rabroersma@yahoo.com>
2006-08-27 13:54 ` Bruno Wolff III <bruno@wolff.to>
2006-08-27 14:39 ` Richard Broersma Jr <rabroersma@yahoo.com>
2006-08-28 10:46 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-08-28 14:27 ` Alvaro Herrera <alvherre@commandprompt.com>
2006-08-30 20:47 ` Gregory Stark <gsstark@mit.edu>
2006-08-30 22:00 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-08-31 03:08 ` Christopher Browne <cbbrowne@acm.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox