[GENERAL] difference in INDEX's

1998-07-04 Thread Brian
Is there a difference in doing: foo int PRIMARY KEY and CREATE INDEX idx1 on table (foo); does both do the same thing (create an index)? is one faster or preffered over the other? /-- [EMAIL PROTECTED] -\ | Brian Feeny

[GENERAL] DBI/DBD-Pg/perl question

1998-07-04 Thread Brian
I have a server which runs Postgres 6.3 under linux. On this system perl, DBI-0.93, and DBD-Pg are installed. This machine can do accesses and operations to the database with no problems. This machine is called "earth". What I am wanting to do, is allow say 20 other machines access to this data

[GENERAL] ODBC problems

1998-07-04 Thread Massimo Muraro
Hi! I should like to make a remote connection whit a Postgress DB (version 6.3) but i meet whit some problem. I have installed on my PC a PostgreSQL ODBC Driver (vv88f263.exe application that i have found at ftp://ftp.postgresql.org/odbc/ address) and i try to make a connection whit the Databa