[GENERAL] Performance check using COPY commands

Hi All,   I have a problem in updating a table using copy commands. To brief you about the table, the table has 6 columns in which it has one column for a sequence number which increments by one on each entry. There is a constraint check for one of the columns. I am copying data in all the 6 c

[GENERAL] Performance tuning using copy

Hi,   I have to know why does copy commands work faster as compared to the insert commands. The thing is that i have a lot of constraints and triggers. I know insert will check all the triggers and constraints, but i wonder if copy will also do it and then if it does then this has also to be s

Re: [GENERAL] Problem with the sequence

Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote: sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the

Re: [GENERAL] Problem with the sequence

Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote: sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the

[GENERAL] Problem with the sequence

HI   I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns present in a sequence table ie when I do   psql=# select * from foo_seq;  sequence_name   | last_value | increment_by |  max_value  | min_value | cache_value

Re: [GENERAL] Locking of auto generated sequence

auto increments and I get the value in my next run. Can you tell me why is it happening this way and is there any solution so that i use only copy commands to update the data.Richard Huxton wrote: sid tow wrote:> Hi All,> > Is there a way to stop a auto generated sequence from incremen

[GENERAL] Locking of auto generated sequence

Hi All,   Is there a way to stop a auto generated sequence from incrementing for some time and then activate it to do the increments.   Regards Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'

[GENERAL] Problem with Autogenerated sequence

Hi,       I have a problem with the SEQUENCE generation. I have a column in a table which auto increments by 1 every time there is a entry and I am strictly prohibited to use only PostgreSQL 7.2 version. Now the problem is with the COPY command, I will have to copy entire columns present in the tab

[GENERAL] How to get back the current count of a auto incrementing number.

hi How to get the current value of a auto incrementing number generated using CREATE SEQUENCE seqname START 1 Is there any way and if yes what is it. Can we run a select query and may be a inbuilt function which will return the current value of that number? Regards. _

[GENERAL] Problem with the copy command need help

hi, I am updating a database using COPY commands. If the commmand breaks in between updating the database, is there any way to find the log of the previous updation or which part or row the loading broke. Regards Sid __ Do you Yahoo!? Rea

[GENERAL] How to lock or disable a trigger

Hi I am new to SQL. Is there a way to lock or disable temporarily a trigger? Since under load conditions while updating the database if the triggers are down then it might help updating the db faster. I am using postgre 7.2 and have to update only with INSERT commands. since with copy comman

[GENERAL] problem with the select query

Hi people,    this is my first mail to the group. i am having a problem with the select query. There are a few values in few columns of a table with some special characters like ~E and ~A and what all, and when i query the database with the select query then the ~E is getting converted into a new