Re: [BUGS] [GENERAL] NEED URGENT HELP....

select * from sp_get_phase ('sandip', 'oms', '1,4') this return a Blank record it would match ur query against '1,4' for the corressponding field in the table. do u really have one such value for that field in your table, i mean '1,4' ?? it won't search for 1 and 4 separately if that is what you

Re: [BUGS] BUG #2859: related with BUG #2568: autovacuum locks tables and do nothing

"Harry Liu" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.1.0 > After autovacuum finished vacuuming two index on the table, it stops there > when try to vacuum the table itself. (appmgr_alert_log_data) Try a more recent release ... this looks a bit like a problem that we fixed in 8.1.1.

Re: [BUGS] bug: Mac OS X 10.4.8 Intel

"Lubomir Brychta" <[EMAIL PROTECTED]> writes: > ../../../../src/include/storage/s_lock.h:543:2: error: #error > PostgreSQL does not have native spinlock support on this platform. To > continue the compilation, rerun configure using --disable-spinlocks. > However, performance will be poor. Please re

Re: [BUGS] BUG #2857: Sequence and table partitioning

"Tomislav Karastojkovic" <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE RULE r AS ON INSERT TO parent WHERE id>=1 AND id <= 100 DO > INSTEAD INSERT INTO child VALUES(NEW.id, NEW.message); > then the sequence is increasing by 5 when inserting into 'parent' table. "id" is basically a macro that ge

Re: [BUGS] BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8

"goodsforyou" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.2.0 win32 > When I make a backup of a UTF8 database then pg_dump add some comment to > backup file: > -- Started on 2006-12-23 11:04:38 中国标准时间 You *sure* that pg_dump is 8.2.0? Because we fixed that before 8.2 rc1 ...

Re: [BUGS] SIMILAR TO incorrect with alternation

Aaron Bingham <[EMAIL PROTECTED]> writes: > Here is a simple test case which triggers the problematic behavior. I > would expect the SQL regular expression and POSIX regular expression > below to give the same results. However, they produce different > answers. The difference seems to be caus

Re: [BUGS] BUG #2862: ERROR: failed to build any 7-way joins

"Sergey" <[EMAIL PROTECTED]> writes: > After migrating to 8.2 I received an error: > ERROR: failed to build any 7-way joins I think this is already reported and fixed, but your test case looks a bit different from the previous examples --- don't suppose you're in a position to try it against CVS t

[BUGS] BUG #2859: related with BUG #2568: autovacuum locks tables and do nothing

The following bug has been logged online: Bug reference: 2859 Logged by: Harry Liu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Linux sentry145.gpi.local 2.6.17-gentoo-r7-MSI #27 SMP PREEMPT Wed Dec 6 19:22:31 PST 2006 i686 Intel(R) Pentium(R)

[BUGS] BUG #2860: can't install the software

The following bug has been logged online: Bug reference: 2860 Logged by: Robert Kuhar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: windows xp Description:can't install the software Details: I'm running 700MHz Athlon with 128 MB RAM. I f

[BUGS] BUG #2856: Jdbc 4 connector running on JDK 1.6 should not raise exception for getClientInfo/setClientInfo

The following bug has been logged online: Bug reference: 2856 Logged by: Steve Langridge Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Pro SP2 Description:Jdbc 4 connector running on JDK 1.6 should not raise exception for getCli

[BUGS] BUG #2857: Sequence and table partitioning

The following bug has been logged online: Bug reference: 2857 Logged by: Tomislav Karastojkovic Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4, 8.2.0 Operating system: Linux Description:Sequence and table partitioning Details: Sequence does not increase

[BUGS] bug: Mac OS X 10.4.8 Intel

/usr/bin/gcc-4.0 -no-cpp-precomp -I/opt/local/include -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/opt/local/include -I/opt/local/include -c -o xlog.o xlog.c In file included from ../../../../src/include/storage/spin.h:50, fro

[BUGS] SIMILAR TO incorrect with alternation

Hello, We just had a case where invalid data entered our database, causing application failure. A constraint was in place to prevent this and appeared correct, however, I was able to verify that the expression was evaluating to TRUE when I expected it to be FALSE. As a work around we have f

[BUGS] BUG #2861: when backup UTF-8 database,pgdump add comments not encoded in UTF-8

The following bug has been logged online: Bug reference: 2861 Logged by: goodsforyou Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 win32 Operating system: Windows xp sp2 Simplified Chinese Version Description:when backup UTF-8 database,pgdump add comments

[BUGS] BUG #2863: vacuum failing, weird record in table...

The following bug has been logged online: Bug reference: 2863 Logged by: Robert Locke Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: FreeBSD 6.1-RELEASE-p6 Description:vacuum failing, weird record in table... Details: Our nightly vacuum

[BUGS] BUG #2862: ERROR: failed to build any 7-way joins

The following bug has been logged online: Bug reference: 2862 Logged by: Sergey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0-1 Operating system: Windows XP Pro SP2 Description:ERROR: failed to build any 7-way joins Details: After migrating to 8.2 I re

[BUGS] BUG #2858: postgres periodically restarts (problem with MemoryContextAllocZeroAligned)...

The following bug has been logged online: Bug reference: 2858 Logged by: Robert Locke Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: FreeBSD 6.1-RELEASE-p6 Description:postgres periodically restarts (problem with MemoryContextAllocZeroAli