Re: [BUGS] BUG #3398: Regress test cannot be run with Makefile in postgresql-test-8.2.4

2007-06-20 Thread Devrim GÜNDÜZ
Hello, On Wed, 2007-06-20 at 16:20 +, Ondrej Sevcik wrote: > Description:Regress test cannot be run with Makefile in > postgresql-test-8.2.4 Tom fixed it in his packages, and I applied his patch to PGDG packages: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsqlrpms/specs/8.2/postgr

Re: [BUGS] BUG #3399: Compatibility issue of the bytea field type

2007-06-20 Thread Tom Lane
"Bing Xia" <[EMAIL PROTECTED]> writes: > We use PostgreSQL 8.1.x as our server backend DB. In one table, we store all > the certificates. The data type for the certificates is bytea. Everything > works fine. However, after we upgrade to PostgreSQL 8.2.4. as we use the > exact same code to query the

[BUGS] BUG #3399: Compatibility issue of the bytea field type

2007-06-20 Thread Bing Xia
The following bug has been logged online: Bug reference: 3399 Logged by: Bing Xia Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: MS Windows Serve 2003 Standard Edition SP1 Description:Compatibility issue of the bytea field type Details:

Re: [BUGS] BUG #3396: strange error report for 'create domain ... default null'

2007-06-20 Thread Tom Lane
"Sergey Burladyan" <[EMAIL PROTECTED]> writes: > i try create domain with 'default null' value, but postgres say: > ERROR: cache lookup failed for type 0 Hmm, looks like that's been broken since day one. Fixed, thanks for the report. regards, tom lane --

[BUGS] BUG #3398: Regress test cannot be run with Makefile in postgresql-test-8.2.4

2007-06-20 Thread Ondrej Sevcik
The following bug has been logged online: Bug reference: 3398 Logged by: Ondrej Sevcik Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux RHEL 5 Description:Regress test cannot be run with Makefile in postgresql-test-8.2.4 Details: I

Re: [BUGS]

2007-06-20 Thread Stéphane Schildknecht
Vasoczki Ferenc a écrit : > Hi! > > I have several problems with pg_dump, and pg_restore, and pgadmin. > > 1. Pgadmin: > I have 2 Postgresql 8.2. One is on my machine (localhost, windows XP > SP2), and one on the server (debian linux). > I dumped my db from my database. > As you wrote here > (h

Re: [BUGS] BUG #3397: change the pg_setting

2007-06-20 Thread Andrew Sullivan
On Wed, Jun 20, 2007 at 12:51:57PM +, Murali Doss wrote: > How to change the pg_setting from en_US.UTF-8 to "C". You need to set up your locale before doing initdb. This is covered in the manual. It's also not a bug, so it'd be nice if you stopped posting this to the bugs list. Use pgsql-no

Re: [BUGS] BUG #3394: Partial search not working

2007-06-20 Thread Murali Doss
Dear All, How to change the pg_setting from en_US.UTF-8 to "C". lc_collate - en_US.UTF-8 lc_ctype- en_US.UTF-8 lc_messages - en_US.UTF-8 lc_monetary - en_US.UTF-8 lc_numeric - en_US.UTF-8 lc_time - en_US.UTF-8 Regards Murali Doss T.S. -Original Message- From:

Re: [BUGS] BUG #3397: change the pg_setting

2007-06-20 Thread Zdenek Kotala
Murali Doss napsal(a): The following bug has been logged online: Bug reference: 3397 Logged by: Murali Doss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Linux Description:change the pg_setting Details: Dear All, How to change the p

[BUGS] BUG #3397: change the pg_setting

2007-06-20 Thread Murali Doss
The following bug has been logged online: Bug reference: 3397 Logged by: Murali Doss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Linux Description:change the pg_setting Details: Dear All, How to change the pg_setting from en_US.UTF-

[BUGS]

2007-06-20 Thread Vasoczki Ferenc
Hi! I have several problems with pg_dump, and pg_restore, and pgadmin. 1. Pgadmin: I have 2 Postgresql 8.2. One is on my machine (localhost, windows XP SP2), and one on the server (debian linux). I dumped my db from my database. As you wrote here (http://archives.postgresql.org/pgadmin-support

[BUGS] BUG #3396: strange error report for 'create domain ... default null'

2007-06-20 Thread Sergey Burladyan
The following bug has been logged online: Bug reference: 3396 Logged by: Sergey Burladyan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: CentOS release 5 (Final) Description:strange error report for 'create domain ... default null' Detail

[BUGS] BeginTransaction failed when calling postgresql procedure with ado

2007-06-20 Thread nasim . sindri
PLATEFORM: VC++ 7 , ADO, WINDOWS 2003, POSTGRE 8.2 I m having a problem while calling the procedure in prostgresql 8.2 from adoconnection, It gets executed for some time and after 5-10 call it gives error either startTransaction failed or commit failed. CREATE OR REPLACE FUNCTION sp_getnewfiles(I

[BUGS] commit transaction failed

2007-06-20 Thread nasim . sindri
I m having a problem while calling the procedure in prostgresql 8.2 from adoconnection, It gets executed for some time and after 5-10 call it gives error startTransaction failed or CommitTransaction Failed. CREATE OR REPLACE FUNCTION sp_getnewfiles(IN strserverid character varying, IN nmaxcount in