Re: [GENERAL] how to capture query?

2005-02-11 Thread Yury Don
M> Hi, M> I'm getting some errors in log file saying "invalid character at M> position M> #20..." I know that this is most likely that query is wrong. M> Is it possible to capture all queries that get send or at least the M> invalid queries? M> I'm using postgresql 7.4.3 on Red Hat 9 M> Thanks,

Re: [GENERAL] Creating an index-type for LIKE '%value%'

2005-02-07 Thread Yury Don
Hello CG, Monday, February 7, 2005, 10:28:24 PM, you wrote: C> Return-Path: <[EMAIL PROTECTED]> C> Delivered-To: [EMAIL PROTECTED] C> Received: (qmail 15486 invoked from network); 7 Feb 2005 17:36:10 - C> Received: from svr4.postgresql.org (66.98.251.159) C> by ns.vpcit.ru with SMTP; 7 Feb

[GENERAL] PostgreSQL on cluster

2005-02-02 Thread Yury Don
Hello All, Does anybody have a live cluster with 2 or more computers running PostgreSQL, connected to single database on shared storage or to replicated database with load balancing between them? -- Best regards, Yury mailto:[EMAIL PROTECTED] -

Re: [GENERAL] os.h

2000-09-16 Thread Yury Don
Horst Herb wrote: > > Where is the misterious "os.h" located that is required when I try to use libpq++ >??? It is not included in the 7.02 packages (neither source nor binary packages). >There are no problems / error messages when using just libpq. > > The other misteriously missing file seem

Re: [GENERAL] plpgsql function

2000-09-05 Thread Yury Don
Hello Marcin, Once, Tuesday, September 05, 2000, 8:42:59 PM, you wrote: MM> Hi, MM> creation of following function works just fine but usage not:): MM> mtldb=# select mtldb_wykonane(0); MM> ERROR: unexpected SELECT query in exec_stmt_execsql() MM> Can You help me find an error? MM> tia MM> CRE

[GENERAL] plpgsql and cyrillic characters

2000-07-13 Thread Yury Don
Hello All, I have a database where tables and fields have a names consisting of cyrillic characters. And I would like to create a trigger on plpgsql, but when I use cyrillic characters in names of elements of record NEW or OLD, I am getting an errors. I tried NEW.fieldname_with_cyrillic, NEW."fie

Re[2]: [GENERAL] Conversion from MS Access to Postgresql

2000-06-26 Thread Yury Don
Hello Len, Once, Tuesday, June 27, 2000, 4:22:08 AM, you wrote: LM> While we're on the subject of Access/Postgres, I have a consistent problem LM> in moving tables between Access and Postgres. Access doesn't seem to want LM> to export a fixed length character field (i.e., I have a text field th

[GENERAL] postgresql and web application

2000-03-24 Thread Yury Don
Hello All, I am trying to develop web application with postgresql as datastorage, using zope. I read in documentation that postgresql is not multithreaded. So, I understand that I can't use one connection to database for all users and I must to open new connection for every user. -- Best regar

[GENERAL] postgresql and web application

2000-03-24 Thread Yury Don
Hello All, I am trying to develop web application with postgresql as datastorage, using zope. I read in documentation that postgresql is not multithreaded. So, I understand that I can't use one connection to database for all users and I must to open new connection for every user. Am I right? Or m

Re: [GENERAL] converting MSAccess db tables into postgresql

2000-02-14 Thread Yury Don
Hello Marco, Once, Monday, February 14, 2000, 4:11:25 PM, you wrote: MG> I'm really a novice on postgresql but i'm using it on a linux server and MG> i find it really usefull. MG> Now I'd like to convert from MS Access some tables to use them with MG> postgresql. MG> I'm sure must exists a tutor

No Subject

2000-02-14 Thread Yury Don
Hello All, I am writing the second time about my problem, maybe this time somebody will answer. The problem is following: I use a cyrillic characters in the names of tables and fields. When I use plpgsql function as a trigger I have a record NEW in this function, and consequently this record has

[GENERAL] pl/pgsql and national characters

2000-02-04 Thread Yury Don
Hello All, I have a following problem. I have a tables and fields whith names, consisting of cyrillic characters and getting an error. When I am doing the same things but with only english characters, everything ok. All other things works properly, only pl/pgsql functions. Does anybody knows how

[GENERAL] pl/pgsql and national characters

2000-02-04 Thread Yury Don
Hello All, create function round_mark() returns opaque as ' begin NEW."" := 1; return NEW; end; ' LANGUAGE 'plpgsql'; CREATE CREATE TRIGGER marks_round_marks BEFORE INSERT OR UPDATE ON "rr" FOR EACH ROW EXECUTE PROCEDURE round_mark(); CREATE UPDATE "rr" SET "òò"=1 WHERE "òò" = 1; NOTICE:

Re: [GENERAL] Proposed Changes to PostgreSQL

2000-02-03 Thread Yury Don
Hello Chris, Once, Thursday, February 03, 2000, 6:30:26 AM, you wrote: CB> 1) An imaginary field in every tuple that tells you the class it came CB> from. CB> This is useful when you select from table* and want to know which CB> relation the object actually came from. It wouldn't be stored on di

No Subject

2000-01-23 Thread Yury Don
Hello All, Does anybody knows where to send bugreport for postgresql? I can't find this information on postgres site. Best regards, Yury ICQ 11831432 mailto:[EMAIL PROTECTED]

Re: [GENERAL] RE: stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory

2000-01-23 Thread Yury Don
Hello Ed, Once, Friday, January 21, 2000, 11:47:07 PM, you wrote: EB> I can do a ls /usr/lib/pgsql/plpgsql.so with no problem. EB> By the way: EB> 1: I am using Red hat 6.0 with kernel 2.2.52. EB> 2: What shloud be the rights and the ownership of the plpgsql file and those EB> of the directories

Re[3]: [GENERAL] Bug or my crooked hands?

2000-01-20 Thread Yury Don
Hello Richard, Once, Thursday, January 20, 2000, 3:04:43 PM, you wrote: RH> - Original Message - RH> From: Yury Don <[EMAIL PROTECTED]> RH> To: pgsql-general <[EMAIL PROTECTED]> RH> Sent: Wednesday, January 19, 2000 11:32 AM RH> Subject: Re[2]: [GENERAL] Bug o

[GENERAL] Bug with indexing int4?

2000-01-20 Thread Yury Don
Hello All, I ma sorry, I have sent previous uncomplited e-mail accidentally. I have created the table CREATE TABLE "tt" ( "cc" int4); COPY "tt" FROM stdin; -2112563299 -2111287024 -2110307960 . 2146589610 2146589611 2146589612 \. About 30 000 records totally Then I am doing the fo

Re[2]: [GENERAL] Bug or my crooked hands?

2000-01-19 Thread Yury Don
Hello J., Once, Wednesday, January 19, 2000, 4:19:12 PM, you wrote: >> Hello All, >> >> I have the following situation: >> >> CREATE TABLE "Contacts" ( >> "Contact" Serial, >> "StuffTheir" Text, >> "TheDate" datetime DEFAULT TEXT 'now', >> "Subj" Text,

[GENERAL] Bug or my crooked hands?

2000-01-19 Thread Yury Don
Hello All, I have the following situation: CREATE TABLE "Contacts" ( "Contact" Serial, "StuffTheir" Text, "TheDate" datetime DEFAULT TEXT 'now', "Subj" Text, "CustomerId" int4, "Agent" int4, "ActionType" int2, "Done"

[GENERAL] Plpgsql qestion

1999-11-03 Thread Yury Don
Hi All. Is it possible to create function (preferably in plpgsql) which gets table name and field name as an arguments and does select something from this table? Something like CREATE FUNCTION "ft" (text, text) RETURNS int4 AS ' declare res int4; begin select max($2

[GENERAL] List of all PostgreSQL functions

1999-09-22 Thread Yury Don
Hi All. Does anywhere exists list of all PostgreSQL functions with description? Sincerely yours, Yury. don.web-page.net, ICQ 11831432

[GENERAL] long object names vs object description

1999-08-19 Thread Yury Don
Hi All. Once I asked already on similar subject but haven't got any reply. Try to formulate my question on other way. I would like to show table names and field names to users who not familiar with databases and programming etc. Therefore I need to show them something understandable. Postgres all

[GENERAL] PyGreSQL module 2.4

1999-07-30 Thread Yury Don
Can somebody send me a compiled module _pgmodule.so version 2.4 for debian kernel 2.0.36 libc6-2.07u? Thank you in advance. Sincerely yours, Yury. don.web-page.net, ICQ 11831432