Re: [BUGS] BUG #1637: age() function is giving different results

Andrew - Supernews <[EMAIL PROTECTED]> writes: > I did some analysis for this one when it was mentioned just now in the irc > chan. I can reproduce on 7.4.x as follows: > test=> set timezone to 'America/Buenos_Aires'; > SET > test=> select age(date '2005-05-05', date '1964-05-05'); >

[BUGS] Wrong Query Plan

Below if the query plan that postgres is generating. The troubling part is the sequential scan on fund_data table. This table has close to million records. It started doing this from yesterday. We have added lot of data in allocation_data & transfer_data tables. If I have just sub query 1 or sub

[BUGS] Win1250 database under linux

Hi. I have ecountered strange behaviour with postgres 8 under linux so I am reporting this as a bug. I haven't compiled postgres myself because it is on hosted server but it is an options if it would solve this problem. The problem i'm having seems to be known but i don't know if there is a worka

[BUGS] BUG #1638: ODBC driver problem

The following bug has been logged online: Bug reference: 1638 Logged by: Vig Sandor Email address: [EMAIL PROTECTED] PostgreSQL version: ANY ( now: 8.0) Operating system: ANY (XP, W2k, Linux...) Description:ODBC driver problem Details: Hi, I wrote an application (i

Re: [BUGS] BUG #1637: age() function is giving different results

On 2005-04-29, Tom Lane <[EMAIL PROTECTED]> wrote: > Andrew - Supernews <[EMAIL PROTECTED]> writes: >> I did some analysis for this one when it was mentioned just now in the irc >> chan. I can reproduce on 7.4.x as follows: > >> test=> set timezone to 'America/Buenos_Aires'; >> SET >> test=> select

Re: [BUGS] BUG #1638: ODBC driver problem

I believe the ODBC package is managed by a different group. Bugs can be viewed and added here: http://gborg.postgresql.org/project/psqlodbc/bugs/buglist.php Mike On Fri, Apr 29, 2005 at 04:31:02PM +0100, Vig Sandor wrote: > > The following bug has been logged online: > > Bug reference: 1

[BUGS] looks like apple fixed /etc/rc

I just updated to 10.3.9 and of course the /etc/rc was dinged. I opened the /etc/rc and found a change.. # System tuning sysctl -w kern.maxvnodes=$(echo $(sysctl -n hw.physmem) '33554432 / 512 * 1024 +p'|dc) if [ -f /etc/sysctl-macosxserver.conf ]; then awk '{ if (!index($1, "#") && index(

Re: [BUGS] Win1250 database under linux

Damir Bijuklic <[EMAIL PROTECTED]> writes: > The problem i'm having seems to be known but i don't > know if there is a workaround. Functions upper() and > lower() don't change value for Croatian national > characters under linux (others probably as well, but i > havent tested). Operator ILIKE doesn

Re: [BUGS] BUG #1637: age() function is giving different results

Andrew - Supernews <[EMAIL PROTECTED]> writes: > Looking more closely, the significant thing seems to be that neither of my > 7.4 servers is on 7.4.7, and this seems to have been fixed there (in response > to bug 1331). 1332 you mean. Yeah, I was testing on 7.4.7, so this is almost certainly a du

Re: [BUGS] looks like apple fixed /etc/rc

That's interesting. On my powerbook, I had to comment out the sysctl -w kern.sysv.shmmax line in /etc/rc. It appears that you can shrink shmmax but not expand it. This meant that it would properly set it based on /etc/syscttl.conf, but that (large) setting would then be over-written by the subsique

[BUGS] BUG #1639: Problema re-instalacion

The following bug has been logged online: Bug reference: 1639 Logged by: PABLO Email address: [EMAIL PROTECTED] PostgreSQL version: 8.02 Operating system: windows 2000 Description:Problema re-instalacion Details: Hola : Tuve que reinstalar posgresql 8.02. Primero l

[BUGS] BUG #1640: Using JDBC, multiple statements do not return results if select follows insert,delete or update

The following bug has been logged online: Bug reference: 1640 Logged by: Kevin Self Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Windows XP Description:Using JDBC, multiple statements do not return results if select follows insert,delet

Re: [BUGS] BUG #1639: Problema re-instalacion

On Fri, Apr 29, 2005 at 07:47:18PM +0100, PABLO wrote: > Bug reference: 1639 > Logged by: PABLO > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.02 > Operating system: windows 2000 > Description:Problema re-instalacion > Details: I've replied on private red

Re: [BUGS] looks like apple fixed /etc/rc

Are they still running on the default PostgreSQL port number for their remote administration tool? --- Jim C. Nasby wrote: > That's interesting. On my powerbook, I had to comment out the sysctl -w > kern.sysv.shmmax line in

Re: [BUGS] BUG #1640: Using JDBC, multiple statements do not return

On Fri, 29 Apr 2005, Kevin Self wrote: > Bug reference: 1640 > PostgreSQL version: 8.0.2 > Description:Using JDBC, multiple statements do not return results if > select follows insert,delete or update > > When attempting to perform a multi-statement command through the JDBC > State

Re: [BUGS] looks like apple fixed /etc/rc

Is that tool on OSX Server? I don't have a copy, though I could probably find out from a friend. On Fri, Apr 29, 2005 at 11:57:54PM -0400, Bruce Momjian wrote: > > Are they still running on the default PostgreSQL port number for their > remote administration tool? -- Jim C. Nasby, Database Consu