Re: [BUGS] dyntest.pgc not working in 7.4 ?

2003-12-11 Thread Michael Meskes
Hi, On Thu, Dec 11, 2003 at 04:10:05PM -0600, Seum-Lim Gan wrote: > Hi Michael, > > We tried but seems this didn't solve the problem. > > Actually the ldd command in the log I attached yesterday > has showed the link to the right libecpgtypes.so and libpg.so. You misunderstood me. I wasn't talk

Re: [BUGS] TimeZone bug again.....

2003-12-11 Thread Arnold Mavromatis
Title: Message [Arnold Mavromatis]       Operating system is redhat 9 Postgres is 7.3.2 binary rpm for linux Hi It seems that because to_timestamp does a time-zone conversion it is upsetting are attempt to load legitimate data... Is it possible (similar to the to_d

Re: [BUGS] BUG #1005: JDBC cancelRowUpdates() sets column values to

2003-12-11 Thread Kris Jurka
On Thu, 11 Dec 2003, PostgreSQL Bugs List wrote: > Description:JDBC cancelRowUpdates() sets column values to null > > this sequence sets all but "plz" and "kategorie" to null, "kategorie" > is changed to 0 > > rs.first(); > rs.updateInt( "plz", 9 ); > rs.cancelRowUpdates(); >

Re: [BUGS] libpq3 + ssl memory leak

2003-12-11 Thread Neil Conway
(libc-start.c:242) ==14598==by 0x8048540: ??? (start.S:102) (The line numbers are against the snapshot I'm using, which you can get from ftp://ftp.openssl.org/snapshot/openssl-SNAP-20031211.tar.gz) A cursory look at the libpq SSL code doesn't reveal anything obvious that we're doing

Re: [BUGS] dyntest.pgc not working in 7.4 ?

2003-12-11 Thread Seum-Lim Gan
Hi Michael, We tried but seems this didn't solve the problem. Actually the ldd command in the log I attached yesterday has showed the link to the right libecpgtypes.so and libpg.so. Adding the -lecpgtypes and -l libpg in build did not change anything. It looks to us that the sqlca.sqlcode will n

[BUGS] Web form bugs

2003-12-11 Thread Peter Eisentraut
I think the bugs entered through the web form should set headers to allow responding to the user more easily. Right now you have to copy the email address into the reply mail manually. ---(end of broadcast)--- TIP 3: if posting/reading through Us

Re: [BUGS] postmaster.pid in version 7.4

2003-12-11 Thread Peter Eisentraut
Dario Marini wrote: > My postmaster.pid is something like: > > 23479 > /export/home1/staff/marini/pgsql/data > 5432001 11703 > > I don't know if there is something wrong with my installation (I run > postgresql on Ultra-2 station with Solaris 6), for sure I cannot stop > postgrsql server usin

[BUGS] BUG #1005: JDBC cancelRowUpdates() sets column values to null

2003-12-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1005 Logged by: Lars Tetzlaff Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: linux 2.4.23 i686 Description:JDBC cancelRowUpdates() sets column values to null Details: this sequence

[BUGS] unsubscribe me please!

2003-12-11 Thread yingluo
Please take me off the email list. Thank you very much! ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to th

Re: [BUGS] invalid page header problem

2003-12-11 Thread Tom Lane
"Tarabas (Manuel Rorarius)" <[EMAIL PROTECTED]> writes: > We currently have a serious problem with our postgres-DB! I think you've got hardware problems. Have you tried running memory and disk tests? memtest86 and badblocks are the commonly recommended tools. Past reports have suggested that

[BUGS] invalid page header problem

2003-12-11 Thread Tarabas (Manuel Rorarius)
Hi! We currently have a serious problem with our postgres-DB! We are using postgres now for some time and lately we expericened that tables were corrupted on the 7.3.2 Database. After recreating the Tables by copying the contents to a save-table and then dropping and recreating the orig

Re: [BUGS] Changing line for user pgsql connecting via UNIX socket to "ident sameuser" causes pg_ctl start -s -w to fail.

2003-12-11 Thread Tom Lane
Constantin Stefanov <[EMAIL PROTECTED]> writes: > Then I change the line to > local all pgsql ident sameuser > and try to start server with >> su -l pgsql -c "pgsql start -D /home/pgsql/data -s -w" > It does not start. It starts fine, as the log shows. Try not using "-w

Re: [BUGS] dyntest.pgc not working in 7.4 ?

2003-12-11 Thread Michael Meskes
On Wed, Dec 10, 2003 at 03:29:44PM -0600, Seum-Lim Gan wrote: > /platdb/bin/ecpg -I /platdb/include -o dyntest74.c dyntest.pgc > cc -I/platdb/include -R/platdb/lib -L/platdb/lib -lecpg -o > lucyDyntest74 dyntest74.c This looks like a wrong library. The latest ecpg does need more that libecpg. It

[BUGS] Changing line for user pgsql connecting via UNIX socket to "ident sameuser" causes pg_ctl start -s -w to fail.

2003-12-11 Thread Constantin Stefanov
Hello. I have FreeBSD 4.9-RELEASE-p1 and upgraded to PostgreSQL 7.4 (built it from FreeBSD port databases/postgresql7). With default pg_hba.conf everything is OK. When I change line in pg_hba.conf file from local all all trust to local all pgsql

[BUGS] [7.3.3] select with stable function not being optimized to index scan

2003-12-11 Thread Barrie Slaymaker
Your name : Barrie Slaymaker Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Pentium Operating System (example: Linux 2.0.26 ELF) : WinXP+cygwin PostgreSQL version (example: PostgreSQL-7.3.3):

Re: [BUGS] [7.3.3] select with stable function not being optimized to index scan

2003-12-11 Thread Barrie Slaymaker
The underlying problem turned out to be using an function returning int8 on a column of type int. When the function is altered to return int, an index scan is used. On Dec 10 2003, Barrie Slaymaker wrote: Your name : Barrie Slaymaker Your email address : [EMAIL PROTECTED] Sys