Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 143C29FB773
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 23 Apr 2007 05:17:58 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 69841-08 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 23 Apr 2007 05:17:50 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from smtp4.yandex.ru (smtp4.yandex.ru [213.180.223.136])
	by postgresql.org (Postfix) with ESMTP id B7F7A9FB6BF
	for <pgsql-sql@postgresql.org>; Mon, 23 Apr 2007 05:17:52 -0300 (ADT)
Received: from [82.209.238.118] ([82.209.238.118]:51208 "EHLO asup_tur"
	smtp-auth: "sql4-en" TLS-CIPHER: <none> TLS-PEER-CN1: <none>)
	by mail.yandex.ru with ESMTP id S7766673AbXDWIRj (ORCPT
	<rfc822;pgsql-sql@postgresql.org>); Mon, 23 Apr 2007 12:17:39 +0400
X-Comment: RFC 2476 MSA function at smtp4.yandex.ru logged sender identity as:
	sql4-en
Date: Mon, 23 Apr 2007 11:20:45 +0300
From: Dmitry Turin <sql4-en@narod.ru>
X-Mailer: The Bat! (v2.01) Personal
Reply-To: Dmitry Turin <sql4-en@narod.ru>
X-Priority: 3 (Normal)
Message-ID: <1312216062.20070423112045@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: We all are looped on Internet: request + transport = invariant
In-Reply-To: <1177095450.760.71.camel@pampa>
References: <14110647859.20070413105812@narod.ru>
	<20070413150936.GA31517@phlogiston.dyndns.org>
	<1684192906.20070419090827@narod.ru>
	<20070419134808.GB14187@phlogiston.dyndns.org>
	<814860828.20070420120819@narod.ru>  <4628A08F.9050804@archonet.com>
	<1177072978.760.40.camel@pampa>  <7939450187.20070420185808@narod.ru>
	<1177095450.760.71.camel@pampa>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.427 tagged_above=0 required=5 tests=AWL=-0.213,
	BAYES_50=0.001, URIBL_SBL=1.639
X-Spam-Level: *
X-Archive-Number: 200704/214
X-Sequence-Number: 28214

Good day, Joe.

>> Table must be created in traditional way (by "create table, alter
>> table") and not through browser.
>> User must use "create table", etc in database-terminal like "psql.exe".
> By "in a special way" I meant that tables have referential constraints
> to other tables and they appear to rely on synthetic keys.

Referential constraints must be created also in traditional way and
also not through browser (by "psql.exe").

>your examples have invalid PG SQL

Yes, i know.
I copy this examples from my page
http://sql40.chat.ru/site/sql40/en/author/introduction_eng.htm
(i wrote this page for all DBMS in general).

>I would change your examples to use less abstract
> data, like department/employee,  customer/product/order/order_line

This will not help.
To my mind, forum of real database is place,
when i can find programmer, which can (and maybe would like) add parser to database.
We all together can make that, i hope to that.


Dmitry Turin
http://html6.by.ru
http://sql4.by.ru