Received: from mail.euroweb.hu (mail.euroweb.hu [193.226.220.4]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA23608 for ; Tue, 9 Jun 1998 08:35:42 -0400 (EDT) Received: (from hu252pr@localhost) by mail.euroweb.hu (8.8.5/8.8.5) id OAA19702 for pgsql-sql@postgresql.org; Tue, 9 Jun 1998 14:35:39 +0200 (MET DST) Received: from wagnerur (lendvary-g.prolan.hu [193.91.83.34]) by aix.prolan.hu (AIX4.2/UCB 8.7/8.7) with SMTP id NAA21494 for ; Tue, 9 Jun 1998 13:57:58 +0200 (DFT) Sender: gyurika@aix.prolan.hu Message-ID: <357D2423.52EEFBA0@prolan.hu> Date: Tue, 09 Jun 1998 14:01:39 +0200 From: Lendvary Gyorgy X-Mailer: Mozilla 3.01Gold (X11; I; Linux 2.0.30 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: questions Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have a little problem with arrays. I,ve defined a type dbref. It has two fields: char type[200] and char record[200]. My prolem is that I can't insert a row into a table which has an attribute with type dbref[2]. For instance: Create table boci (hapci dbref[2]); How can I insert a row into this table? Please help me! My next problem is SPI interface. I have used LIBPQ but I need SPI. I have read a description in PostgrSQL Programmer's Guide, but I understand nearly nothing. Please write me where I can find a better description about SPI! I have to treat very big tables from my C program. I update every attribute with update command. When I update an attribute, I must go through every tuple of the table. It takes a long time. I write you a little piece of my program: sprintf(buff, "CREATE TABLE boci (tup_num int, hapci int)"); PQexec(conn, buff); for (i=0; i<10000; i++) { sprintf(buff, "INSERT INTO boci VALUES(i)"); PQexec(conn, buff); } for (i=0; i<10000; i++) { x = GetValue(); /* GetValue isn't an interesting function */ sprintf(buff, "UPDATE boci SET hapci = %d WHERE tup_num = %d", x, i); PQexec(conn, buff); } I don't want to update every tuple indvidually but I want to prepare a 'block write'. I hope you understand what I'd like to. Can you give me a good method for saving a long time? I need a program that is about 10 times faster than mine. Thanks for your attention! gyurika@prolan.hu