Обсуждение: ODBC 7.1
Greetings All, Is this the correct forum to discuss ODBC driver issues? I have a Linux/PostgreSQL server which has been upgraded to run 7.1 - the main reason was to be able to use the TOAST extensions. We have some documentation attached to fields which is up to 64kb. After upgrading the server I installed the current (7.1) ODBC driver for Win32. It now seems that concurrent table writes are limited? My write times are fairly slow. (significantly slower than 6.4/7.0) Some tables which are updated simultaneously - like sales and general ledger are not staying in synch. Any suggestions would be welcomed (including upgrades) -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au
Keith Gray wrote: > > Greetings All, > > Is this the correct forum to discuss ODBC driver issues? > No, pgsql-odbc is the right forum. > I have a Linux/PostgreSQL server which has been upgraded > to run 7.1 - the main reason was to be able to use the > TOAST extensions. We have some documentation attached > to fields which is up to 64kb. > > After upgrading the server I installed the current (7.1) > ODBC driver for Win32. > Is the version 7.01.0006 ? > It now seems that concurrent table writes are limited? > > My write times are fairly slow. (significantly slower > than 6.4/7.0) > Is the comparison for the < 8k data ? Is it as fast as 6.4/7.0 except concurrent write ? regards, Hiroshi Inoue
hi all i have a table like this CREATE SEQUENCE seq_student_id INCREMENT 1 START 1; CREATE TABLE students ( student_id INT4 NOT NULL DEFAULT NEXTVAL('seq_student_id'), student_name text, student_address text, primary key(student_id) ) CREATE TABLE student_club ( student_id INT4 NOT NULL; club_id INT4, CONSTRAINT student_id_update FOREIGN KEY(student_id) REFERENCES students(student_id) ON UPDATE CASCADE ) my question is how i can make auto insert student_id on table student_club when i insert into table students example: INSERT INTO students(student_name) VALUES('Willy'); table STUDENT student_id | name | address --------------------------------- 1 | Willy | and on TABLE student_club student_id | club_id -------------------- 1 | i have trying with create rule and with check_foreign_key, but i haven't found solution. anyone can help me? Thanks in advance __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
Are you ready to solve your problem using a trigger and 'plpgsql' function ?? .. then proceed .. trigger :) +++++++++++++++++++++++++++++++++++++++++++ CREATE TRIGGER trigger_student_club before INSERT OR UPDATE ON students FOR EACH ROW EXECUTE PROCEDURE ins_student_club_func(); +++++++++++++++++++++++++++++++++++++++++++ function :) +++++++++++++++++++++++++++++++++++++++++++ CREATE FUNCTION ins_student_club_func()RETURNS OPAQUEAS 'BEGIN INSERT INTO student_club(student_id) VALUES (new.student_id); return new; END;' LANGUAGE 'plpgsql'; +++++++++++++++++++++++++++++++++++++++++++ Hope it works. :) Regards, Bhuvaneswar. On Aug 9, Johny Jugianto wrote: > hi all > > i have a table like this > > CREATE SEQUENCE seq_student_id INCREMENT 1 START 1; > CREATE TABLE students ( > student_id INT4 NOT NULL DEFAULT > NEXTVAL('seq_student_id'), > student_name text, > student_address text, > primary key(student_id) > ) > CREATE TABLE student_club ( > student_id INT4 NOT NULL; > club_id INT4, > CONSTRAINT student_id_update FOREIGN KEY(student_id) > REFERENCES students(student_id) ON UPDATE CASCADE > ) > > my question is how i can make auto insert student_id > on table student_club when i insert into table > students > > example: > INSERT INTO students(student_name) VALUES('Willy'); > > table STUDENT > student_id | name | address > --------------------------------- > 1 | Willy | > > and on TABLE student_club > student_id | club_id > -------------------- > 1 | > > > i have trying with create rule and with > check_foreign_key, but i haven't found solution. > anyone can help me? > > Thanks in advance > > > __________________________________________________ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >