On Tuesday 13 August 2002 08:07 pm, Curt Sampson wrote:
> On Tue, 13 Aug 2002, Lamar Owen wrote:
> > > Curt, I think his reply stems from his frustration of chosen content in
> > > many emails that originate from you. We all pretty well understand
> > > postgres has a broken feature. We all unde
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Agreed. Most of this would be easy to implement for curent
> implementation (but perhaps no more efficient than when done by manually
> added rules/triggers) if constraints could contain subqueries.
I don't understand what a constraint containing a subq
On Tue, 2002-08-13 at 23:42, Bruce Momjian wrote:
> Curt Sampson wrote:
> > On Tue, 13 Aug 2002, Bruce Momjian wrote:
> >
> > > Yea, you have to question what value the discussion has, really. We
> > > have users of inheritance that like it. If we can get a TODO item out
> > > of the disucssion
> Summary:
>
> 1. The current implementation is broken.
>
> 2. We have no proper description of how a "fixed" implementation
> should work.
>
> 3. It's hard to fix the current implementation without such a
> description.
>
> 4. Thus, we are in other messages here tryin
Hannu Krosing wrote:
> I guess what he meant was that you were arguing for arguments sake (mine
> is better than yours! Yes it is! Yes it is! ...)
That's the dictionary definition of the phrase.
> and not to get to some
> solution,
and that's the source of the frustration. I only re-subscribe
On Wed, 2002-08-14 at 09:49, Curt Sampson wrote:
> On Wed, 14 Aug 2002, Bruce Momjian wrote:
>
> > OK, great summary. Isn't the bottom-line issue the limitation of not
> > being able to create an index that spans tables?
>
> That would be one way to fix one particular problem. I can think of
>
On Wed, 2002-08-14 at 05:07, Curt Sampson wrote:
> On Tue, 13 Aug 2002, Lamar Owen wrote:
>
> > > Curt, I think his reply stems from his frustration of chosen content in
> > > many emails that originate from you. We all pretty well understand
> > > postgres has a broken feature. We all understa
On Wed, 14 Aug 2002, Bruce Momjian wrote:
> OK, great summary. Isn't the bottom-line issue the limitation of not
> being able to create an index that spans tables?
That would be one way to fix one particular problem. I can think of
another way to fix it right off-hand. (Put the parent's part of
Curt Sampson wrote:
> On Tue, 13 Aug 2002, Bruce Momjian wrote:
>
> > Yea, you have to question what value the discussion has, really. We
> > have users of inheritance that like it. If we can get a TODO item out
> > of the disucssion, great, but there doesn't seem to be any direction of
> > whe
On Tue, 13 Aug 2002, Bruce Momjian wrote:
> Yea, you have to question what value the discussion has, really. We
> have users of inheritance that like it. If we can get a TODO item out
> of the disucssion, great, but there doesn't seem to be any direction of
> where the discussion is heading.
S
Yea, you have to question what value the discussion has, really. We
have users of inheritance that like it. If we can get a TODO item out
of the disucssion, great, but there doesn't seem to be any direction of
where the discussion is heading.
---
Bruce Momjian wrote:
> It is hard to argue with this logic.
If he were actually making a technical argument I might actually agree
with you myself.
Thus far all he's done is argue from authority, and in tight circles to
boot.
Which means the term is an accurate description of his behavior ...
It is hard to argue with this logic.
---
Curt Sampson wrote:
> On Tue, 13 Aug 2002, Lamar Owen wrote:
>
> > > Curt, I think his reply stems from his frustration of chosen content in
> > > many emails that originate from yo
On Tue, 13 Aug 2002, Lamar Owen wrote:
> > Curt, I think his reply stems from his frustration of chosen content in
> > many emails that originate from you. We all pretty well understand
> > postgres has a broken feature. We all understand you see zero value in
>
> Knowing Don to some extent, I
On Tue, 2002-08-13 at 18:48, Don Baccus wrote:
> Greg Copeland wrote:
> > On Tue, 2002-08-13 at 00:16, Curt Sampson wrote:
> >
...
>
> And yes I know he's not reading my mail and no, don't bother repeating
> this to him, he'll just continue to ignore the point.
I suspect that he will still rea
On Tuesday 13 August 2002 01:40 am, Greg Copeland wrote:
> On Tue, 2002-08-13 at 00:33, Curt Sampson wrote:
> > On Mon, 12 Aug 2002, Don Baccus wrote:
> > > Give it up. You're acting like a turkey. If you aren't, skin yourself
> > > a new non-turkey skin.
> > Since he appears not to be able to
Greg Copeland wrote:
> On Tue, 2002-08-13 at 00:16, Curt Sampson wrote:
>
>>I will revise my opinion the instant someone shows me something that I
>>can't do relationally, or is easy to implement with inheritance, and
>>difficult with relational methods.
The traditional view approach requires un
On Tue, 2002-08-13 at 10:16, Curt Sampson wrote:
> On 12 Aug 2002, Greg Copeland wrote:
...
> > Are we then assuming that tuples in the child tables do not appear
> > > in the base table? That's more or less what I'd assumed when I
> > > originally heard about table inheritance (after all, instan
On 13 Aug 2002, Greg Copeland wrote:
> On Tue, 2002-08-13 at 00:16, Curt Sampson wrote:
> > I will revise my opinion the instant someone shows me something that I
> > can't do relationally, or is easy to implement with inheritance, and
> > difficult with relational methods. Now you know what you
On Tue, 2002-08-13 at 00:16, Curt Sampson wrote:
> I will revise my opinion the instant someone shows me something that I
> can't do relationally, or is easy to implement with inheritance, and
> difficult with relational methods. Now you know what you need to do, and
> if you have no example, we c
On Tue, 2002-08-13 at 00:33, Curt Sampson wrote:
> On Mon, 12 Aug 2002, Don Baccus wrote:
>
> > Give it up. You're acting like a turkey. If you aren't, skin yourself
> > a new non-turkey skin.
>
> Since he appears not to be able to avoid abusive ad hominem attacks,
> I'm now sending mail with
On Mon, 12 Aug 2002, Don Baccus wrote:
> Give it up. You're acting like a turkey. If you aren't, skin yourself
> a new non-turkey skin.
Since he appears not to be able to avoid abusive ad hominem attacks,
I'm now sending mail with "[EMAIL PROTECTED]" in the From: header
to /dev/null. If there'
On 12 Aug 2002, Greg Copeland wrote:
> You're constantly confusing Postgres' implementation with a "desired"
> implementation.
No. I'm still trying to figure out what the desired implementation
actually is. This is documented nowhere.
> If you're so keen on examples, please provide one that jus
On Mon, 12 Aug 2002, Don Baccus wrote:
> It's a pity, as I pointed out the reduction in joins alone would really
> be great.
So implement the same thing relationally, and get your reduction
in joins. There are tricks, discussed on this very list in the
last few days, that would let you do what
On Mon, 2002-08-12 at 20:34, Curt Sampson wrote:
> Ok, big bundled up reply here to various people.
>
> > From: Greg Copeland <[EMAIL PROTECTED]>
> >
> > > What makes things more confusing is poor understanding of a feature, not
> > > the feature itself.
> >
> > Agreed. Just because a feature ma
Curt Sampson wrote:
> ... the bugs in the postgres implementation
> of table inheritance, I've found the relational model much easier
> to use for solving problems.
No one has argued that the shortcomings (not bugs, really, just things
left out) makes the current implementation of very limited
Ok, big bundled up reply here to various people.
> From: Greg Copeland <[EMAIL PROTECTED]>
>
> > What makes things more confusing is poor understanding of a feature, not
> > the feature itself.
>
> Agreed. Just because a feature may not be well understood by the masses
> doesn't mean the feature
On Mon, 2002-08-12 at 17:30, Greg Copeland wrote:
> On Mon, 2002-08-12 at 10:39, Oliver Elphick wrote:
> > On Mon, 2002-08-12 at 15:00, Greg Copeland wrote:
> > > How exactly would you create an abstract base class for table type?
> >
> > CREATE TABLE abstract_base (
> >cols ...,
> >CONST
On Mon, 2002-08-12 at 10:39, Oliver Elphick wrote:
> On Mon, 2002-08-12 at 15:00, Greg Copeland wrote:
> > How exactly would you create an abstract base class for table type?
>
> CREATE TABLE abstract_base (
>cols ...,
>CONSTRAINT "No data allowed in table abstract_base!" CHECK (1 = 0)
>
On Mon, 2002-08-12 at 15:00, Greg Copeland wrote:
...
> Look a little deeper here. In other OO implementations, I can define a
> class (say class a) which has no instances (abstract base class).
> Furthermore, I can take this case and use it for building blocks
> (assuming multiple inheritance i
On Mon, 2002-08-12 at 00:29, Hannu Krosing wrote:
> On Mon, 2002-08-12 at 11:52, Curt Sampson wrote:
> > On Sun, 11 Aug 2002, Don Baccus wrote:
[snip]
> > But anyway, I have no particularly huge objection to syntatic sugar
> > alone. I do have objections to it when it's not saving much typing. (It
On Mon, 2002-08-12 at 13:14, Curt Sampson wrote:
> On 12 Aug 2002, Hannu Krosing wrote:
>
> > Are you saying that inheritance in SQL is something fundamentally
> > different than inheritance in OO languages ?
>
> Yes.
>
...
> So is an instance a relation (a set of tuples) or a tuple?
An inst
On 12 Aug 2002, Hannu Krosing wrote:
> Are you saying that inheritance in SQL is something fundamentally
> different than inheritance in OO languages ?
Yes.
> > (For example, the distinction
> > between types and instances of types is critical in OO theory. What are
> > the TI equivalants of th
On Mon, 2002-08-12 at 11:52, Curt Sampson wrote:
> On Sun, 11 Aug 2002, Don Baccus wrote:
>
> > Obviously it would require extending SQL, but since you in part argue
> > that SQL sucks in regard to the relational model this shouldn't matter,
> > right?
>
> Well, if we're going to go so far as to
On Mon, 2002-08-12 at 11:38, Mario Weilguni wrote:
> Am Montag, 12. August 2002 08:02 schrieb Don Baccus:
> > Curt Sampson wrote:
> > > On Sun, 11 Aug 2002, Don Baccus wrote:
> > >>I've been wanting to point out that SQL views are really, when
> > >>scrutinized, "just syntactic sugar" ...
> > >
>
On Sun, 11 Aug 2002, Don Baccus wrote:
> Obviously it would require extending SQL, but since you in part argue
> that SQL sucks in regard to the relational model this shouldn't matter,
> right?
Well, if we're going to go so far as to get rid of SQL, we can go all
the way with the D&D thing, and
Am Montag, 12. August 2002 08:02 schrieb Don Baccus:
> Curt Sampson wrote:
> > On Sun, 11 Aug 2002, Don Baccus wrote:
> >>I've been wanting to point out that SQL views are really, when
> >>scrutinized, "just syntactic sugar" ...
> >
> > Oh? Ok, please translate the following into equivalant SQL th
Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
>
>>On Sun, 11 Aug 2002, Don Baccus wrote:
>>
>>>Granulize GRANT to the table column level.
>>
>
>>Can you please show me the code for that?
>
>
> It's required by the SQL spec. PG hasn't got it, but the spec is
> perfectly clear abou
Curt Sampson wrote:
> On Sun, 11 Aug 2002, Don Baccus wrote:
>
>
>>>Oh? Ok, please translate the following into equivalant SQL that
>>>does not use a view:
>>>...
>>
>>Granulize GRANT to the table column level.
>
>
> Can you please show me the code for that? After all, I showed you
> all of my
> > > Oh? Ok, please translate the following into equivalant SQL that
> > > does not use a view:
> > > ...
> > Granulize GRANT to the table column level.
>
> Can you please show me the code for that? After all, I showed you
> all of my code when doing equivalants.
>
> Or are you saying that it's s
Curt Sampson <[EMAIL PROTECTED]> writes:
> On Sun, 11 Aug 2002, Don Baccus wrote:
>> Granulize GRANT to the table column level.
> Can you please show me the code for that?
It's required by the SQL spec. PG hasn't got it, but the spec is
perfectly clear about how it should be done.
I think this
On Sun, 11 Aug 2002, Don Baccus wrote:
> > Oh? Ok, please translate the following into equivalant SQL that
> > does not use a view:
> > ...
> Granulize GRANT to the table column level.
Can you please show me the code for that? After all, I showed you
all of my code when doing equivalants.
Or ar
Curt Sampson wrote:
> On Sun, 11 Aug 2002, Don Baccus wrote:
>
>
>>I've been wanting to point out that SQL views are really, when
>>scrutinized, "just syntactic sugar" ...
>
>
> Oh? Ok, please translate the following into equivalant SQL that
> does not use a view:
>
> CREATE TABLE t1 (key
On Sun, 11 Aug 2002, Don Baccus wrote:
> I've been wanting to point out that SQL views are really, when
> scrutinized, "just syntactic sugar" ...
Oh? Ok, please translate the following into equivalant SQL that
does not use a view:
CREATE TABLE t1 (key serial, value1 text, value2 text);
Curt Sampson wrote:
> The problem is, table inheritance is just syntatic sugar for creating
> separate tables, and a view that does a UNION SELECT on them all
> together, projecting only the common columns.
I've been wanting to point out that SQL views are really, when
scrutinized, "just syntac
> So my initial thinking is that this is a profound problem. But after a little
> more thought, I can make the question_id field of the question table be a
> SERIAL type and the primary key. That way, when I insert rows into either
> the position question or the binary question table, it will be
I'm a little out of my league on this list, but I thought I might discuss a
problem I'm having since it seems to have come up here recently. I have read
the archives w/ respect to the inheritance mechanism, the problems with it,
etc. But I still think it would be a useful thing to have in Postgr
47 matches
Mail list logo