[Note: I'm *not* an expert in the SQL standard, but I might be able to
help clarify a misunderstanding or two in the discussion so far].
Tony Marston wrote:
Support for functional dependencies is not a feature that can be turned off
in any database engine. Dependencies, whether they are functio
Nitin Saxena escribió:
Hi,
I am using postgresql 7.0
When i am connecting my database it is giving error
[EMAIL PROTECTED] /root]# su - postgres
bash-2.04$ psql GROUPSMS
NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission
denied
NOTICE: mdopen: couldn't open /var/lib/pgsql/d
On Tue, Oct 14, 2008 at 08:28:42PM -0400, Bruce Momjian wrote:
> Tony Marston wrote:
> > I think your definition of "Feature T301 Functional Dependencies"
> > is extremely questionable. [et cetæra, ad nauseam]
>
> The issue is that Postgres is _more_ standards-compliant than MySQL,
> but Postgres
"Nitin Saxena" <[EMAIL PROTECTED]> writes:
> I am using postgresql 7.0
You really, really, really need to update to some remotely-modern PG
version. 7.0 *will* eat your data someday.
> NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission denied
So, what's the permissions on /
Hi,
I am using postgresql 7.0
When i am connecting my database it is giving error
[EMAIL PROTECTED] /root]# su - postgres
bash-2.04$ psql GROUPSMS
NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission denied
NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permis
On Wed, Oct 15, 2008 at 01:47:40PM +0100, Tony Marston wrote:
> Support for functional dependencies is not a feature that can be
> turned off in any database engine.
Repeating the same premise over and over again does not constitute an
argument. In this case, you appear to be begging the questio
Support for functional dependencies is not a feature that can be turned off
in any database engine. Dependencies, whether they are functional,
transitive, multi-valued or join dependencies, are inherent in the database
design. It is therefore nonsense to say that support for functional
dependencies
On Sat, Oct 11, 2008 at 12:07 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> The sort-and-uniq doesn't care where the data came from. But if we have
> to feed it all rows of the table, as we do here, we're going to use a
> seqscan. An indexscan can never beat a seqscan for retrieving the whole
> tabl
Tony Marston wrote:
You are still missing the point - "functional dependencies" is not a
separate module that can be turned on or off with code,
It is in the SQL standard.
they are inherent in
the database design. According to relational theory any non-key field on a
table is functionally dep
You are still missing the point - "functional dependencies" is not a
separate module that can be turned on or off with code, they are inherent in
the database design. According to relational theory any non-key field on a
table is functionally dependent of the key of that table, so if you support
bo
10 matches
Mail list logo
