[BUGS] BUG #5330: No CREATE SYNONYM command

The following bug has been logged online: Bug reference: 5330 Logged by: zhuge Email address: zhuge_x...@yahoo.com PostgreSQL version: 8.4.2 Operating system: Linux Description:No CREATE SYNONYM command Details: I want to port from Oracle to PostgreS. But Postgres h

Re: [BUGS] BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error

On Wed, Feb 17, 2010 at 2:15 AM, Tom Lane wrote: > We most certainly do print something --- in your example I get this: > > LOG:  invalid authentication method "127.0.0.1" > CONTEXT:  line 81 of configuration file "/home/postgres/data/pg_hba.conf" > FATAL:  could not load pg_hba.conf > > I suspec

[BUGS] BUG #5331: Integer overflow in tmie counter

The following bug has been logged online: Bug reference: 5331 Logged by: Kajetan Abt Email address: kdan...@gmx.ch PostgreSQL version: 8.3 Operating system: Windows Server 2008 Description:Integer overflow in tmie counter Details: Amusingly, the counter on the lower

[BUGS] BUG #5332: Installation weirdness

The following bug has been logged online: Bug reference: 5332 Logged by: Sivaguru Sankaridurg Email address: uc_rege...@yahoo.com PostgreSQL version: 8.4.1 Operating system: FreeBSD 6.3 Description:Installation weirdness Details: I am seeing some install script weir

Re: [BUGS] BUG #5330: No CREATE SYNONYM command

On Wed, Feb 17, 2010 at 05:41:45AM +, zhuge wrote: > I want to port from Oracle to PostgreS. But Postgres has no the command, > CREATE SYNONYM, > which exists in Oracle. I have read the information, > http://archives.postgresql.org/pgsql-patches/2006-03/msg00085.php, and > download the file. Ho

Re: [BUGS] BUG #5331: Integer overflow in tmie counter

Kajetan Abt escreveu: > Amusingly, the counter on the lower right of the SQL-input window sometimes > shows negative numbers counting up, probably some sort over overflow. No > harm done though. > If you don't provide more details (test case) it's hard to say if it's a bug or not. -- Euler Ta

Re: [BUGS] BUG #5332: Installation weirdness

"Sivaguru Sankaridurg" writes: > In Try#1, when I configure the prefix to be "/tmp/pgsql", and subsequently > do a "gmake install", the install script creates the "internal", "server" > and "informix" directories right under "include". > However, in Try#2, when I configure the prefix to be "/tmp/

Re: [BUGS] BUG #5332: Installation weirdness

Hi Tom, Ah! I see. Thank you for your quick response. Best Regards Siva From: Tom Lane To: Sivaguru Sankaridurg Cc: pgsql-bugs@postgresql.org Sent: Wed, February 17, 2010 9:12:36 PM Subject: Re: [BUGS] BUG #5332: Installation weirdness "Sivaguru Sankaridur

Re: [BUGS] BUG #5331: Integer overflow in tmie counter

On Wed, Feb 17, 2010 at 5:59 AM, Euler Taveira de Oliveira wrote: > Kajetan Abt escreveu: >> Amusingly, the counter on the lower right of the SQL-input window sometimes >> shows negative numbers counting up, probably some sort over overflow. No >> harm done though. >> > If you don't provide more d

[BUGS] planner regression in 8.4 (from 8.1)

I have a query which performs much better on 8.1.19 than on 8.4.2, unless I add "offset 0" to the subqueries. I believe this is due to miscalculating the expected row count of nest loop joins. I cannot give you my data, but I can give you the query and the plans. Let me know if anything else wou

Re: [BUGS] BUG #5327: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows.

I've got it working after building with Visual Studio. Thanks. But there is still a problem when building some .dll files. The version I'm using is 2008. When building libecpg there are errors like, Error 1 error LNK2019: unresolved external symbol _PGTYPESdate_from_asc referenced in function _E