[BUGS] BUG #1427: Seq scan for SELECT 1 FROM p WHERE aid=133 LIMIT 1

2005-01-20 Thread Alexander Kirpa
The following bug has been logged online: Bug reference: 1427 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: FreeBSD 5.2.1 Description:Seq scan for SELECT 1 FROM p WHERE aid=133 LIMIT 1 Details: CREATE TABLE

[BUGS] BUG #1426: pg_restore SIGSEGV on 7.2.2 dump

2005-01-20 Thread Alan Pevec
The following bug has been logged online: Bug reference: 1426 Logged by: Alan Pevec Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: i686-redhat-linux-gnu Description:pg_restore SIGSEGV on 7.2.2 dump Details: Running pg_restore dump-produ

[BUGS] BUG #1425: False failure message on boot start

2005-01-20 Thread Jonathan Pool
The following bug has been logged online: Bug reference: 1425 Logged by: Jonathan Pool Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: Red Hat Enterprise Linux 3 Description:False failure message on boot start Details: When /etc/init.d/p

Re: [BUGS] BUG #1410: Hibernate PerformanceTest is incredibly slow

2005-01-20 Thread Tom Lane
Oliver Jowett <[EMAIL PROTECTED]> writes: > If I patch Hibernate to not add a FK constraint at all, it runs > substantially faster. It does not seem trivial to fix Hibernate to add > an index in this case -- Hibernate wants to run "ALTER TABLE tablename > " to add a FK constraint, but we need to

Re: [BUGS] BUG #1410: Hibernate PerformanceTest is incredibly slow

2005-01-20 Thread Oliver Jowett
Simon Nicholls wrote: Bug reference: 1410 PostgreSQL version: PostgreSQL 8.0 Operating system: WindowsXP Description:Hibernate PerformanceTest is incredibly slow (in effect unusable) 00:41:41,453 DEBUG SchemaExport:136 - drop table Simple 00:41:41,500 DEBUG SchemaExport:154 - create

Re: [BUGS] [pgsql-bugs] Daily digest v1.1346 (21 messages)

2005-01-20 Thread Josh Berkus
Byron, > PostgreSQL Âworks perfectly if the Win Xp does not have installed Service > Pack, the problem occurs when Win Xp has Service Pack 1 or 2. ÂPostgreSQL > does not activate Âor doesnât work Âand it presents this error: The Windows XP services packs contain a built-in firewall which autmatic

Re: [BUGS] BUG #1414: DOC - pl/Perl hash tags missing

2005-01-20 Thread Tom Lane
"Mike Blackwell" <[EMAIL PROTECTED]> writes: > In the pl/Perl section of the 8.0.0 manual, as viewed on the postgresql.org > web site, all perl code hash tags seem to be missing. i.e. Yeah, I see the same; but it's not in the devel docs. Compare http://www.postgresql.org/docs/8.0/static

Re: [BUGS] BUG #1421: Will not install in TS

2005-01-20 Thread Magnus Hagander
>The following bug has been logged online: > >Bug reference: 1421 >Logged by: Terry Williams >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0 >Operating system: Windows 2003 >Description:Will not install in TS >Details: > >Message says it will not install in

Re: [BUGS] BUG #1408: don't see index

2005-01-20 Thread Bruno Wolff III
On Tue, Jan 18, 2005 at 09:01:29 +, andrzej <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1408 > Logged by: andrzej > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.0-rc5 > Operating system: windows XP > Descript

Re: [BUGS] BUG #1409: A good and a bad news: Crazy SQL JOIN?

2005-01-20 Thread Stephan Szabo
On Tue, 18 Jan 2005, Lutischán Ferenc wrote: > CREATE TABLE test ( > col1 character varying(10), > col2 character varying(10) > ); > > > ALTER TABLE ifc.test OWNER TO postgres; > > CREATE TABLE test2 ( > col1 character varying(10), > col2 character varying(10) > ); > > > ALTER TAB

Re: [BUGS] BUG #1424: Installer bug

2005-01-20 Thread Magnus Hagander
>The following bug has been logged online: > >Bug reference: 1424 >Logged by: Alberto Monteverdi >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0 >Operating system: Windows 2000 Server SP4 >Description:Installer bug >Details: > >When the installer try to init

Re: [BUGS] BUG #1417: Enabling development installation in installation options of MSI does not enable any...

2005-01-20 Thread Magnus Hagander
>The following bug has been logged online: > >Bug reference: 1417 >Logged by: Joseph Donahue >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0 >Operating system: Win2K SP4 >Description:Enabling development installation in installation >options of MSI does not e

Re: [BUGS] BUG #1419: Uninstall v8.0 removes files v8 Beta4 is dependant on.

2005-01-20 Thread Magnus Hagander
>Bug reference: 1419 >Logged by: Joseph Donahue >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.x >Operating system: Win2K SP4 >Description:Uninstall v8.0 removes files v8 Beta4 is >dependant on. >Details: > >I installed release v8.0 in a seperate directory f

Re: [BUGS] BUG #1416: Win Installer doesn't grab registry settings.

2005-01-20 Thread Magnus Hagander
>The following bug has been logged online: > >Bug reference: 1416 >Logged by: Joseph Donahue >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0 >Operating system: Win2K SP4 >Description:Win Installer doesn't grab registry settings. >Details: > >When upgrading

Re: [BUGS] BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured

2005-01-20 Thread Kris Jurka
On Wed, 19 Jan 2005, jerome celle wrote: > With following entry in pg_hba.conf : > host all all 192.168.2.0/32 trust > > I get the following error when attempting to open a connection from > 192.168.2.27 host : Perhaps you want 192.168.2.0/24. Kris Jurka ---(end of b

[BUGS] BUG #1424: Installer bug

2005-01-20 Thread Alberto Monteverdi
The following bug has been logged online: Bug reference: 1424 Logged by: Alberto Monteverdi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Server SP4 Description:Installer bug Details: When the installer try to initialize the

[BUGS] Problem with driver ODBC / VB

2005-01-20 Thread Kalitech
Hello,   These tests are done with the 2 versions of the driver 7.3   Table User description : u_num int4 nextval( …), u_comm varchar(512)   In my table I have one row :     u_num  1     u_comm   ‘hello world all is fine.’   Imagine I want to

Re: [BUGS] BUG #1388: documentation/announcement suggestion

2005-01-20 Thread Holger Klawitter
Thanks for your reply! > For most people I expect the release notes are more useful than the change > log. [...] > (http://developer.postgresql.org/docs/postgres/release.html). The only problem with that page is that it is not mentioning changes between release candidates... Anyway, my main po

Re: [BUGS] BUG #1392: could not select filter an entry from copied data table

2005-01-20 Thread Kanu Patel
Yes, the employee id=1 and it is text. So I agree with you that could be a space problem. How can I resolve that? May be change id as integer or real?   Thanks.   Michael Fuhr <[EMAIL PROTECTED]> wrote: On Mon, Jan 17, 2005 at 12:36:33PM -0800, Kanu Patel wrote:> I had an employee table with the f

[BUGS] BUG PostgreSQL for Windows

2005-01-20 Thread MAX MARCELL
Ao ser executado, após a escolha do idioma, ocorre a seguinte mensagem de erro: Failed to process: 2! e aborta a instalação. Grato Max Marcell ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [BUGS] psql 8.0.0 rc5 parser error on \dt?

2005-01-20 Thread Dave Bodenstab
> > Dave Bodenstab <[EMAIL PROTECTED]> writes: > > I built 8.0.0rc5 on FreeBSD 4.8. It built with no errors. I then > > tried psql using another host running postgresql 7.1.3 and I get the > > goofy error message shown below. > > psql's backslash commands are only guaranteed to work with a server

[BUGS] BUG #1420: Doesn't accomplish connection with the server

2005-01-20 Thread Byron Zambrano
The following bug has been logged online: Bug reference: 1420 Logged by: Byron Zambrano Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 - rc5 Operating system: Win Xp Service Pack 1, 2 Description:Doesn't accomplish connection with the server Details: I l

[BUGS] BUG #1423: ODBC SQLTables SQL_ALL_CATALOGS and SQL_ALL_SCHEMAS options don't work

2005-01-20 Thread Farid Zidan
The following bug has been logged online: Bug reference: 1423 Logged by: Farid Zidan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:ODBC SQLTables SQL_ALL_CATALOGS and SQL_ALL_SCHEMAS options don't work Details: Y

[BUGS] BUG #1414: DOC - pl/Perl hash tags missing

2005-01-20 Thread Mike Blackwell
The following bug has been logged online: Bug reference: 1414 Logged by: Mike Blackwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: N/A Description:DOC - pl/Perl hash tags missing Details: In the pl/Perl section of the 8.0.0 manual,

[BUGS] BUG #1421: Will not install in TS

2005-01-20 Thread Terry Williams
The following bug has been logged online: Bug reference: 1421 Logged by: Terry Williams Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2003 Description:Will not install in TS Details: Message says it will not install in TS and req

[BUGS] BUG #1417: Enabling development installation in installation options of MSI does not enable any...

2005-01-20 Thread Joseph Donahue
The following bug has been logged online: Bug reference: 1417 Logged by: Joseph Donahue Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Win2K SP4 Description:Enabling development installation in installation options of MSI does not enable an

[BUGS] BUG #1422: ODBC SQLTables SQL_ALL_TABLE_TYPES no resultset

2005-01-20 Thread Farid Zidan
The following bug has been logged online: Bug reference: 1422 Logged by: Farid Zidan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2 Description:ODBC SQLTables SQL_ALL_TABLE_TYPES no resultset Details: ::SQLTables( hstmt,

[BUGS] BUG #1419: Uninstall v8.0 removes files v8 Beta4 is dependant on.

2005-01-20 Thread Joseph Donahue
The following bug has been logged online: Bug reference: 1419 Logged by: Joseph Donahue Email address: [EMAIL PROTECTED] PostgreSQL version: 8.x Operating system: Win2K SP4 Description:Uninstall v8.0 removes files v8 Beta4 is dependant on. Details: I installed relea

[BUGS] BUG #1410: Hibernate PerformanceTest is incredibly slow (in effect unusable)

2005-01-20 Thread Simon Nicholls
The following bug has been logged online: Bug reference: 1410 Logged by: Simon Nicholls Email address: [EMAIL PROTECTED] PostgreSQL version: PostgreSQL 8.0 Operating system: WindowsXP Description:Hibernate PerformanceTest is incredibly slow (in effect unusable) Detail

[BUGS] BUG #1408: don't see index

2005-01-20 Thread andrzej
The following bug has been logged online: Bug reference: 1408 Logged by: andrzej Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0-rc5 Operating system: windows XP Description:don't see index Details: Create table t1 ( v varchar(5) not null, m varchar(20)

[BUGS] BUG #1412: binaries are linked to numerous extraneous shared

2005-01-20 Thread Todd Eigenschink
The following bug has been logged online: Bug reference: 1412 Logged by: Todd Eigenschink Email address: [EMAIL PROTECTED] PostgreSQL version: 8 (any recent) Operating system: Linux Description:binaries are linked to numerous extraneous shared Details: For a long ti

[BUGS] BUG #1407: instalation problems

2005-01-20 Thread Jair
The following bug has been logged online: Bug reference: 1407 Logged by: Jair Email address: [EMAIL PROTECTED] PostgreSQL version: -8.0.0-rc5-3 Operating system: windows 2000 Description:instalation problems Details: Hi i’ve been having some troubles installing Post

[BUGS] BUG #1416: Win Installer doesn't grab registry settings.

2005-01-20 Thread Joseph Donahue
The following bug has been logged online: Bug reference: 1416 Logged by: Joseph Donahue Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Win2K SP4 Description:Win Installer doesn't grab registry settings. Details: When upgrading from an 8

[BUGS] BUG #1413: pg_hba.conf : 192.168.2.0/32 not honoured

2005-01-20 Thread jerome celle
The following bug has been logged online: Bug reference: 1413 Logged by: jerome celle Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: Linux Redhat 9 Description:pg_hba.conf : 192.168.2.0/32 not honoured Details: With following entry in p

[BUGS] BUG #1415: odbc driver SQLGetInfo SQL_CATALOG_TERM returns empty string

2005-01-20 Thread Farid Zidan
The following bug has been logged online: Bug reference: 1415 Logged by: Farid Zidan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:odbc driver SQLGetInfo SQL_CATALOG_TERM returns empty string Details: odbc driver

[BUGS] BUG #1409: A good and a bad news: Crazy SQL JOIN?

2005-01-20 Thread Lutischán Ferenc
The following bug has been logged online: Bug reference: 1409 Logged by: Lutischán Ferenc Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 B5, 7.4.6 Operating system: WinXp, SLES9 Description:A good and a bad news: Crazy SQL JOIN? Details: Dear Developer Tea

[BUGS] BUG #1411: Ref Bug#1410 Hibernate PerformanceTest is incredibly slow

2005-01-20 Thread Simon Nicholls
The following bug has been logged online: Bug reference: 1411 Logged by: Simon Nicholls Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0-rc4 Operating system: WindowsXP Description:Ref Bug#1410 Hibernate PerformanceTest is incredibly slow Details: Sorry, I