r is: yes for PK, no for FK in PG.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 8:57 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] A simple question
Hello,
I wonder if postgres autocreates an index o
Hello,
I wonder if postgres autocreates an index on foreign or primary key fields.
For example:
create table t1 (
f1 integer,
f2 varchar,
primary key (f1));
create table t2 (
f1 integer,
f2 integer,
primary key (f1),
foreign key (f2) references t1(f1)
);
In this sample, "t1" has a
Hi,
I am new to postgresql. I have it installed on FreeBSD, can anyone please
tell me how could I check the no of connection to the database or How many
people are connected to the database at a time.
Thanks,
-Prashant.
- Original Message -
From: "Thalis A. Kalfigopoulos" <[EMAIL PROTEC
