Re: [SQL] Create Primary Key?

Thus spake Stephan Szabo We don't currently support the SQL syntax for adding a PK to a table. However, if you have the columns as NOT NULL already, adding a unique index to the columns in question has the same general effect. Except for interfaces such as PyGreSQL that recognize the

Re: [SQL] Create Primary Key?

On Wed, 30 Aug 2000, D'Arcy J.M. Cain wrote: Thus spake Stephan Szabo We don't currently support the SQL syntax for adding a PK to a table. However, if you have the columns as NOT NULL already, adding a unique index to the columns in question has the same general effect. Except for

Re: [SQL] Viewing a function

Try "SELECT prosrc FROM pg_proc WHERE proname = 'funcname'", where funcname is the name of the function you want to see. - Original Message - From: "stuart" [EMAIL PROTECTED] To: "PG-SQL" [EMAIL PROTECTED] Sent: Tuesday, August 29, 2000 3:20 AM Subject: Fw: [SQL] Viewing a function

Re: [SQL] Optimizing huge inserts/copy's

Hi, there, I tried different ways, include vaccum table , ensure index works, it still is as slow as ~100rows per minute. Stephan Szabo wrote: On Tue, 29 Aug 2000, Jie Liang wrote: Hi, there, 1. use copy ... from '.'; 2. write a PL/pgSQL function and pass multiple records as

Re: [SQL] Optimizing huge inserts/copy's

I am experimenting with this too. If I have any indexes at all, the copy's get VERY SLOW as the table gets big. Delete ALL your indexes, do your copy's, and then create your indexes again. Good luck. --- Jie Liang [EMAIL PROTECTED] wrote: Hi, there, I tried different ways, include vaccum

Re: [SQL] Optimizing huge inserts/copy's

Hi, I knew that if no constarint, it populate very quick, my question is: when two tables have been reloaded, then I want to add a foreign key constraint to it, say: tableA has primary key column (id) tableB has a column (id) references it, so I say: ALTER TABLE tableB ADD CONSTRAINT distfk

Re: [SQL] Optimizing huge inserts/copy's

On Wed, 30 Aug 2000, Jie Liang wrote: Hi, I knew that if no constarint, it populate very quick, my question is: when two tables have been reloaded, then I want to add a foreign key constraint to it, say: tableA has primary key column (id) tableB has a column (id) references it, so I

Re: [SQL] Optimizing huge inserts/copy's

Webb Sprague [EMAIL PROTECTED] writes: I am experimenting with this too. If I have any indexes at all, the copy's get VERY SLOW as the table gets big. Delete ALL your indexes, do your copy's, and then create your indexes again. Do you have a lot of equal index keys in the data you're

[SQL] 7.0.2 questions on encoding and compilation

Currently, I'm using the the 7.0.2 rpms from the postgresql.org on a RH6.2 install. I have a few questions on it and the use of the -E flag. 1 - can 7.0.2 be optimized for i686 architecture or is it only possible to compile for i386 architecture? 2 - Can createdb -E someencoding be used

[SQL] function

Hi all, how can I write function which takes text from one field, replaces some characters and puts it in other field? I have array with old and new values. For example: old array = {'r', 'Z', 'o'} new array = {'s', 'm', 't'} old field value = 'Zorro' new field value which must calculate this

[SQL] Re: [GENERAL] function

Normunds wrote: Hi all, how can I write function which takes text from one field, replaces some characters and puts it in other field? I have array with old and new values. For example: old array = {'r', 'Z', 'o'} new array = {'s', 'm', 't'} old field value = 'Zorro' new field value