Обсуждение: 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
>