Re: [GENERAL] Wrong string length from unicode database in Borland's app

TL> Alex Guryanow <[EMAIL PROTECTED]> writes: >> When pg-server is version 7.1.3 windows app works fine, but when >> pg-server is version 7.4.6 or 8.0beta4 under certain conditions the >> app receives strings with wrong lengths. TL> Are both servers set up with

[GENERAL] Wrong string length from unicode database in Borland's app

Hi, I have windows app written in Borland C++ Builder 5.0. Using ODBC driver windows app connects to database on linux server. Database is created with UNICODE encoding. When pg-server is version 7.1.3 windows app works fine, but when pg-server is version 7.4.6 or 8.0beta4 under certain condition

Re: [GENERAL] Solaris 8 compilation errors

JG> I don't see Solaris 8 on the list of supported platforms, I have compiled postgres 7.0.3 on SPARC/Solrais 8. But it was compiled w/o tcl support. There is no much time since installation, but yet all works fine. JG> but Solaris 7 is JG> there, so I had hoped 8 would work pretty much the

Re[6]: [GENERAL] SPI_getvalue problem

Monday, January 29, 2001, 9:49:32 AM Tom wrote: TL> Alex Guryanow <[EMAIL PROTECTED]> writes: >> DEBUG: tupdesc is NULL TL> Hm. Well, I can assure you that rd_att will *never* be null in a valid TL> relation cache entry. So there is something wrong with either TL>

Re[4]: [GENERAL] SPI_getvalue problem

Monday, January 29, 2001, 9:33:06 AM Tom wrote: TL> Alex Guryanow <[EMAIL PROTECTED]> writes: >> You have right. One of the values passed to SPI_getvalue is NULL. This is second >parameter >> (tupdesc). But why on Linux it is not NULL, and on Solaris is? >> H

Re[2]: [GENERAL] SPI_getvalue problem

Sunday, January 28, 2001, 8:24:51 PM Tom wrote: TL> Alex Guryanow <[EMAIL PROTECTED]> writes: >> I have the following problem: the backend crashes on Solaris while >> executing the function SPI_getvalue. >> At the same time on Linux this trigger works f

[GENERAL] SPI_getvalue problem

ble-locale --enable-multibyte=UNICODE Best regards, Alex Guryanow

[GENERAL] SPI_modifytuple for varchar

Hi, my query is about using the function SPI_modifytuple for a varchar field. I have (for example) a table with a field my_field of type varchar(100). And I need to create a trigger that adds the phrase "hello, world" to any value, that user inserts (or updates) in field my_field. Using SPI_getva

[GENERAL] sorting in UNICODE table

Hi, I'm use postgresql-7.0.2. It's compiled with unicode support (./configure --enable-multibyte=UNICODE ...) I have a table which contains both latin and non-latin letters. All they are in UTF-8 encoding. When I try to sort the rows ( SELECT * FROM my_table ORDER BY sort_field ) I receive str

[GENERAL] using INTERSECT and UNION in IN clause

Hi, postgresql 7.0.2. Why by executing the following query select * from magazine where id in ( select mag_id from dict where word = 'akademie' intersect select mag_id from dict where word = 'der' intersect select mag_id from dict where word = 'klasse' ) I receive the followin

[GENERAL] problem with plpgsql function

Hi, I have a table "isbn" (postgres-7.0.2) with two columns: book_id int4 isbn varchar(20) I want to create a function that joins all isbn for specified book_id. The code of this function is: CREATE FUNCTION all_isbn2( int4 ) RETURNS varchar AS 'DECLARE i isbn%ROWTYPE; res varch

[GENERAL] pqReadData() error

Hi, during execution of block of commands like BEGIN INSERT INTO... INSERT INTO... . INSERT INTO... COMMIT sometimes receive the error pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the

[GENERAL] uninterruptible sleep

Hi, I'm use postgresql 6.5.3 on RedHat 6.1. To monitor the perfomance of the system I use top. When I run VACUUM ANALYZE in psql monitor top shows sometimes the state of postmaster as D. "man top" says that D in STAT column is "uninterruptible sleep". Is this normal? Best regards, Alex **

[GENERAL] inserting timestamp values

Hi, I have troubles inserting the timestamp values. I use postgresql 6.5.3 on RedHat 6.1 (kernel 2.2.13). I do the following sample==> create table t1 (d timestamp); CREATE sample==> create index t1_d on t1 using btree (d datetime_ops); CREATE sample==> insert into t1 (d) values ('1999-01-01 14:

[GENERAL] NOTICE: (transaction aborted): queries ignored until END

Hi, I'm use Postgres-6.5.1 on Linux. My database contains two tables and two indices. I wrote simple program on C that - begins transaction: BEGIN WORK - inserts many (10-500) rows in the first table - commits the transaction: COMMIT - begins transaction: BEGIN WORK - inserts many (1-50) rows in