Re: [ADMIN] Foreign Keys in PostGreSQL

2000-09-05 Thread Karel Zak
On Wed, 6 Sep 2000, vijayendra mohan agrawal wrote: > Dear all, > > How to define FOREIGN KEY in a table ??? Found you some problem in great PostgreSQL documentation? Karel CREATE [ TEMPORARY | TEMP ] TABLE table ( column type [ NULL | NOT NUL

[ADMIN] Foreign Keys in PostGreSQL

2000-09-05 Thread vijayendra mohan agrawal
Dear all, How to define FOREIGN KEY in a table ??? Thank You, Best Regards, Vijay Vijayendra Mohan Agrawal Wipro Technologies 26, Hosur Main Road, Bommanhalli, Bangalore-560068, India Tel: 91-80-5722296 Extn:3076 Fax: 91-80-5722696 E

[ADMIN] Online replication of live databases across WAN

2000-09-05 Thread Raju Mathur
Hi, A client is looking to run two identical databases, one in India and one in the US. He wants transactions on either to be replicated online to the other. Is such a feature available in PostgreSQL? A contrib module for doing this would also be fine. Thanks and regards, -- Raju

[ADMIN] What do i need before compiling postgres on solaris 7

2000-09-05 Thread Dronamraju Rajesh
Hi There, I am trying to compile postgres 7 on solaris 7. Kindly tell me what all do I need before compiling the postgres software. What is the process to compile and install the postgres 7 on solaris 7. Awaiting for an acknowledgement. Thanks in advance for all the help. Thanks & Reg

[ADMIN] PostgreSQL 6.5.3 log

2000-09-05 Thread UgK
Hi! Dear List! I use the postgresql-6.5.3 and I 've a problem. The server works correctly, but doesn't log to the log file. I create the '/var/log/postgresql' file and give 'chown postgres.postgres'and 'chmod 0700 postgresql'. I wrote to the postgres user's '.bash_profile' file: POSTGRES_LOG=/va

Re: [ADMIN] problem creating hash index

2000-09-05 Thread Mathieu Arnold
HENAFF Mari-mai FTRD/DMI/LAN wrote: > > Hi, > > I have a problem creating a hash index : it's too slow (it takes several > days, i stopped it before the end). > When i create a b-tree index on the same field, it takes approximately > twenty minutes. > The type of the field indexed is Varchar(1

[ADMIN] problem creating hash index

2000-09-05 Thread HENAFF Mari-mai FTRD/DMI/LAN
Hi, I have a problem creating a hash index : it's too slow (it takes several days, i stopped it before the end). When i create a b-tree index on the same field, it takes approximately twenty minutes. The type of the field indexed is Varchar(16). The table indexed contains 20 MO of rows. Thanks f