Re: [BUGS] make of 8.3.5 failed on Linux

Hello, Tom Lane пишет: Ruslan A Dautkhanov writes: `/root/postgresql-8.3.5/src/backend/utils/mb/conversion_procs/utf8_and_euc_jis_2004' make[3]: *** No rule for making `utf8_and_euc_jis_2004.o', требуемой для `libutf8_and_euc_jis_2004.so.0.0'. Stop.

[BUGS] make of 8.3.5 failed on Linux

Hello! I am trying to build PostgreSQL 8.3.5 for Linux. Error log ln -s libutf8_and_uhc.so.0.0 libutf8_and_uhc.so make[3]: Leaving directory `/root/postgresql-8.3.5/src/backend/utils/mb/conversion_procs/utf8_and_uhc' make[3]: Entering directory `/root/postgresql-8.3.5/src/backen

Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup

Hello ! Tom Lane wrote: Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: Server rebooted occasionally after power failure. And I have stale postmaster.pid file, so postmaster didn't start with error bill postgres[600]: [1-1] FATAL: file "postmaster.pid

[BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

#and run postmater safely postgresql_cmd fi else #.pid file not exists, clean startup postgresql_cmd fi else postgresql_cmd fi } That

[BUGS] async. query processing

in a client C program, that not work from PG8... Thanks a lot for any comments -- Ruslan A Dautkhanov smime.p7s Description: S/MIME Cryptographic Signature

Re: [BUGS] can't startup PG-8.0.3

Tom Lane wrote: Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: I have experience with PostgreSQL 7.x, and I can't figure out why this happen. PG didn't say anything meaningful, that can point me why he did not start. That's fairly unusual ---

Re: [BUGS] can't startup PG-8.0.3

write 51/0x33  86611 postgres CALL  fork  86611 postgres RET   fork 86612/0x15254  86611 postgres CALL  exit(0) I'll keep try to startup PostgreSQL 8.0.3...  Thanks -- Ruslan A Dautkhanov smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] can't startup PG-8.0.3

--with-pgport=6543 \ --enable-cassert \ --with-perl \ --enable-odbc # ./postgres --version postgres (PostgreSQL) 8.0.3 I also tried to use pg_ctl to startup PG instance, but it silently stops: could not start postmaster Thanks a lot for any helpful info. -- Ruslan A Dautkhanov smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] unpredictable cost in explain

ny number of times, no any caching effects etc. Some maybe useful info: isbs=# select count(*) from dyBilling; - 1144078 isbs=# select count(*) from saType; --- 6472 isbs=# select version(); - PostgreSQL 7.4.1 on i386-unknown-freebsd4.7, compiled by GCC 2.95.4 Thanks. -- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] CONNECT BY

urrent CVS. -- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] Multi-process transactions [share connections]

It is enough to pass only this variable to work with high-grade transactions etc support in this case? Thanks a lot for any helpful information. -- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] vacuum inside the transaction

   version -  PostgreSQL 7.4.1 on i386-unknown-freebsd4.7, compiled by GCC 2.95.4 (1 row) I think if commit not really commit a transaction, it should return error code. Returning 'commit ok' make some confuse ... -- best regards,

[BUGS] upcoming 7.4 relaese: absent recode() function ?

: recode('...', 'Windows-1251', 'KOI8-R') to convert posted users' files into my base charset KOI8-R, if the files' content have another charset and save them into DB... How can I install recode() function for 7.4 release ? -- best regards, Ruslan A D

Re: [BUGS] conditional indexes

Hubert Lubaczewski wrote: On Wed, 25 Jun 2003 17:33:27 +0800 Ruslan A Dautkhanov <[EMAIL PROTECTED]> wrote: Postgres start to use conditional index only when I also pass index' condition: login='user' AND login<>'' ... i belive i

[BUGS] conditional indexes

es start to use conditional index only when I also pass index' condition: login='user' AND login<>'' ... isbs=# select version(); version --------- PostgreSQL 7.3.3 on i

Re: [BUGS] ERROR: Memory exhausted in AllocSetAlloc(68)

Tom Lane wrote: > Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > > isbs=# SELECT count(i.*),sum(i.param1),sum(60-i.param1) FROM inlog i, > ^^ > > Make that just count(*). I think you're running into the poor handling > of whole-row

[BUGS] performance for MIN,MAX aggregates

n can be located in the index. Is it possible to force PostgreSQL use indexes for MIN/MAX aggregate functions? Thanks a lot for any comments. -- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] PPTP + Cisco - is it possible for RADIUS server to allocate IPs?

Is it possible to correct such Cisco behaviour? Thanks a lot for any comments. -- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[BUGS] Serialize transactions

lem in the html-docs sql-set-transaction.html . Why this happen? How to solve this problem? Thanks a lot. -- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] O_DIRECT option used?

l be much bigger. If you have no plans to implement this, please let us know what source files I should looking for patching. I think it's somewhere DB tables files are opened (and maybe WAL files too). Thanks a lot on any comments. --- best regards, Ruslan A Daut

[BUGS] datatypes: text vs varchar

ynonym for 'text', or not? Thanks. --- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] DROP COLUMN really work?

a lot for comments. P.S. btw, I upgrade my DBs from 7.2.1 to 7.3 version without any problems, but found, that psql's help messages (\h, \h alter table etc.) not from 7.3 version. For example, it do not contain \h CREATE SCHEMA help message. -- best regards, Ruslan A Dautkhanov

[BUGS] database caches

rate), and which less, if this possible?? Or which tables not to cache completely. Thanks a lot in advice. --- best regards, Ruslan A Dautkhanov [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

Re: [BUGS] Creating server-side functions: one simple error

Tom Lane wrote: > Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > > SPI, and I have trap again - I can't translate datetime column, which > > pass to my procedure. I must convert it to UNIX 1970-seconds counter for > > my internal needs, but I havn't found

Re: [BUGS] Creating server-side functions: one simple error

Joe Conway wrote: > Ruslan A Dautkhanov wrote: > > Btw, how I can convert TEXT field to a CString one? I had tried to use > > char *cnum = PG_GETARG_CSTRING(0) instead of > > text tnum = PG_GETARG_NAME(0), but it's not worked properly. Is any function > >

Re: [BUGS] Creating server-side functions: one simple error

Tom Lane wrote: > Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > > I have to create my own function in C lanuage, which > > will use SPI. The problem that when I had done all things, > > PostgreSQL says: > > isbs=# select pgf1test('123'); >

[BUGS] Creating server-side functions: one simple error

#x27;t find function pgf1test in file /usr/local/pgsql/lib/pgf1test.so show errors. Why PostgreSQL can't found C-function? I know that problem is not complex, and it's very simple question for you. Thanks. --- best regards, Ruslan A Dautkhanov smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] Postmaster crash!

ems. Should I better wait for 7.3 version or patch for this problem exists?     --- best regards, Ruslan A Dautkhanov   [EMAIL PROTECTED] smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] 7.2.1: Can't create prcedural language PLPERL

Hi, I have to use PlPerl procedural language to write my functions on PostgreSQL. I have recompiled Perl interpreter, so libperl now built as a shared library. After this I had done perl Makefile.pl; make; make install All is good, but when I tries to run createlang ... plperl it fail. I

[BUGS] numeric type conversions

ould have default convertors from and to the 'text' (varchar etc) type.. Thanks, Ruslan A Dautkhanov smime.p7s Description: S/MIME Cryptographic Signature

[BUGS] get last OID

Hi all, I has some disappointed, when read that PG can't return OID of statements, which had INSERTed multiple rows (not "exactly one"). Please help, how can I know OID of last(or first) inseted row ? Thanks for your suggestions. Ruslan A Daut