FAQ

PostgreSQL > pgsql-bugs > January 2005

Search Discussions

152 discussions - 406 posts

  • The following bug has been logged online: Bug reference: 1393 Logged by: Fahad Email address: Fahad.Gilani@anusf.anu.edu.au PostgreSQL version: 8.0.0rc2 Operating system: Linux Description: Adding ...
    FahadFahad
    Jan 12, 2005 at 11:09 pm
    Jan 17, 2005 at 2:57 am
  • The following bug has been logged online: Bug reference: 1440 Logged by: Edmund Bacon Email address: ebacon@onesystem.com PostgreSQL version: 8.0.0 Operating system: Linux Redhat 9 Pentium-4 ...
    Edmund BaconEdmund Bacon
    Jan 24, 2005 at 6:51 pm
    Feb 4, 2005 at 9:50 am
  • Hi, I see test failures in float4, float8 and misc. Both float4 and float8 fail on the tests involving NaN and Infinity. Here's the verbose output of the failed statements: template1=# SELECT ...
    Tamas VinczeTamas Vincze
    Jan 27, 2005 at 4:10 pm
    Feb 1, 2005 at 8:38 pm
  • In the PostgreSQL RC-1, whenever we have the pgAdminIII open and try to create a database, it says that template1 is locked up and hence the database cannot be created. I believe it shouldn't lock it ...
    Mehul Doshi-A20614Mehul Doshi-A20614
    Jan 31, 2005 at 12:58 pm
    Jan 31, 2005 at 9:22 pm
  • I have postgres 7.4.6 installed on 2 machines one debian and one freebsd. Both are the most recent installs of each OS. On both I have the plpython module and both are having the same issue. ...
    Lee JensenLee Jensen
    Jan 27, 2005 at 10:17 pm
    Jan 27, 2005 at 11:23 pm
  • Hi, I've successfully built PostgreSQL 8.0.0 on SPARC/Solaris (7), with gcc-3.2.2. Hardware is SPARCstation 5, 170 MHz. Because it doesn't build optimally right out of the box, I'd like to provide ...
    Rolf SponselRolf Sponsel
    Jan 29, 2005 at 11:23 pm
    Feb 5, 2005 at 5:46 pm
  • Hi, If I put the source for 8.0.0 on disk (RAID 1) , configure, compile and run gmake check, it fails with 33 errors, 30 of which are ! psql: could not send startup packet: Broken pipe If I put the ...
    Jeff RossJeff Ross
    Jan 22, 2005 at 12:04 am
    Jan 24, 2005 at 4:33 pm
  • The following bug has been logged online: Bug reference: 1414 Logged by: Mike Blackwell Email address: maiku41@anet.com PostgreSQL version: 8.0.0 Operating system: N/A Description: DOC - pl/Perl hash ...
    Mike BlackwellMike Blackwell
    Jan 19, 2005 at 5:26 pm
    Jan 23, 2005 at 12:42 am
  • The following bug has been logged online: Bug reference: 1434 Logged by: Brad Snobar Email address: bradsnobar@netscape.net PostgreSQL version: 8.0 Operating system: Linux Description: ERROR: type ...
    Brad SnobarBrad Snobar
    Jan 22, 2005 at 10:28 pm
    Jan 30, 2005 at 2:20 pm
  • [I've Cc'ed pgsql-bugs and set the Reply-To header to that list.] I see the same thing with PostgreSQL 8.0.0 (REL8_0_STABLE) on Solaris 9 and FreeBSD 4.11. Here's part of the backtrace from the core ...
    Michael FuhrMichael Fuhr
    Jan 27, 2005 at 5:52 pm
    Jan 27, 2005 at 8:01 pm
  • Summary: "epoch" does not produce a consistent behavior when cast as TIMESTAMP WITHOUT TIMEZONE Severity: Annoyance Tested On: 7.4.6, 8.0b4 Example: test= select extract(epoch from '2004-12-01 ...
    Josh BerkusJosh Berkus
    Jan 25, 2005 at 12:27 am
    Jan 27, 2005 at 7:13 pm
  • Hi guys, It appears that low privileged users can invoke the LOAD extension to load arbitrary libraries into the postgres process space. On Windows systems this is achieved by calling LoadLibrary ...
    John HeasmanJohn Heasman
    Jan 21, 2005 at 11:08 am
    Jan 25, 2005 at 6:54 pm
  • PostgreSQL 8.0.0rc4 pg_dump fails to set ownership on indexes. When a database superuser restores a dump, indexes will be owned by the superuser instead of by the table's owner. The table owner will ...
    Michael FuhrMichael Fuhr
    Jan 11, 2005 at 2:29 am
    Jan 11, 2005 at 6:14 am
  • Hello, We have been using postgres 8.0.0beta4 successfully on various windows machines for a while now, but we have run across a particular windows machine of one of our customers where initdb.exe is ...
    Steve McWilliamsSteve McWilliams
    Jan 7, 2005 at 5:16 pm
    Jan 7, 2005 at 6:55 pm
  • The following bug has been logged online: Bug reference: 1397 Logged by: Chris Jones Email address: chris@cjones.org PostgreSQL version: 7.4.6 Operating system: NetBSD 2.0 i386 Description: busy-loop ...
    Chris JonesChris Jones
    Jan 13, 2005 at 11:57 pm
    Feb 26, 2005 at 6:30 pm
  • Testcase: create table boxtest (a box); create index boxtest_idx on boxtest using rtree (a); create function gen_data() returns void as ' begin for i in 1..200 loop insert into boxtest values ...
    Andrew - SupernewsAndrew - Supernews
    Jan 24, 2005 at 11:44 pm
    Feb 14, 2005 at 11:24 pm
  • The following seems to me a bug in either initdb or create operator: CREATE FUNCTION my_func (inet, inet) as '$libdir/my_func.so' LANGUAGE 'C' IMMUTABLE STRICT; CREATE OPERATOR <<< ( PROCEDURE = ...
    John HansenJohn Hansen
    Jan 30, 2005 at 2:01 am
    Jan 30, 2005 at 3:13 am
  • PostgreSQL 8.0.0 Running "pg_restore -l" to create a list file and then restoring using "pg_restore -L" fails to restore ACLs. See the "Privileges where [sic] not restored" thread in pgsql-admin: ...
    Michael FuhrMichael Fuhr
    Jan 20, 2005 at 4:18 am
    Jan 25, 2005 at 10:48 pm
  • This was reproduced on 7.4. I don't know if it is still an issue on 8.0. If you set shared_buffers (shmem_max) to greater than the shmem config on the OS pg will not start. And gives a useful message ...
    EleinElein
    Jan 23, 2005 at 6:40 pm
    Jan 23, 2005 at 8:46 pm
  • The following bug has been logged online: Bug reference: 1392 Logged by: Kanu Patel Email address: kpry99@yahoo.com PostgreSQL version: 7.4.6 Operating system: Linux Description: could not select ...
    Kanu PatelKanu Patel
    Jan 12, 2005 at 8:12 pm
    Jan 18, 2005 at 5:54 pm
  • The following bug has been logged online: Bug reference: 1402 Logged by: raxfar Email address: raxfar@yahoo.com.tw PostgreSQL version: 8.0.0-rc2 Operating system: windows 2000 Description: ...
    RaxfarRaxfar
    Jan 15, 2005 at 1:14 pm
    Jan 18, 2005 at 3:16 pm
  • The following bug has been logged online: Bug reference: 1406 Logged by: manikanti sreedhar reddy Email address: manikant@intoto.com PostgreSQL version: 7.4.2 Operating system: Windows Description: ...
    Manikanti sreedhar reddyManikanti sreedhar reddy
    Jan 17, 2005 at 9:27 am
    Jan 18, 2005 at 5:57 am
  • Developers, I'm finding an issue I thought was fixed with RC2, which is affecting my ability to use arrays in RC5: Summary: Fast repeated calls to INT[] = INT[] operator causes error Severity: Query ...
    Josh BerkusJosh Berkus
    Jan 17, 2005 at 12:53 am
    Jan 17, 2005 at 3:08 am
  • Hi, Forgive me my poor English for writing. Sees, below, that it seems to have one bug in set transform_null_equals or, then, in < NULL. This fact occurs in Versions: 7.4.5 and 8.0.0-rc2. -- Creation ...
    GonzagaGonzaga
    Jan 15, 2005 at 7:13 pm
    Jan 16, 2005 at 9:05 pm
  • I have a view definition that creates a view on both Postgres 7 and Postgres 8. The view definition works OK in that it does not return an error and the resulting view seems to operate correctly on ...
    Laurie BurrowLaurie Burrow
    Jan 13, 2005 at 12:50 pm
    Jan 13, 2005 at 6:57 pm
  • If PostgreSQL is intalled with native language support with the windows installer and if German is used as locale, local characters like Umlaute are displayed wrong in the windows command window. In ...
    Christoph BeckerChristoph Becker
    Jan 12, 2005 at 10:13 am
    Jan 13, 2005 at 5:26 pm
  • I wanted to install rc4 on Windows XP in g:\pgsql and selected this in the Installprocess. PGDATA was already set to this directory. However, PostgeSQL as well as the data-directory were installed at ...
    Christoph BeckerChristoph Becker
    Jan 12, 2005 at 10:14 am
    Jan 13, 2005 at 11:54 am
  • Hi, I try a "make check" without success. The compilation is done correctly. But "make check" throws: I recompile with the option for configure from the 7.4 ports. Nothing better. Any help welcomed. ...
    Pailloncy Jean-GerardPailloncy Jean-Gerard
    Jan 12, 2005 at 1:34 pm
    Jan 12, 2005 at 6:19 pm
  • It seems rules don't work as expected. I could be wrong,... In which case, what am I doing wrong? Clearly, the first insert below should not update the table as well. ... John CREATE TABLE test (a ...
    John HansenJohn Hansen
    Jan 12, 2005 at 7:44 am
    Jan 12, 2005 at 1:55 pm
  • The following bug has been logged online: Bug reference: 1373 Logged by: Bazsi Email address: bazsi@jonapot.hu PostgreSQL version: 7.2.2 Operating system: debian linux Description: constraints, rules ...
    BazsiBazsi
    Jan 5, 2005 at 11:39 am
    Jan 9, 2005 at 5:48 pm
  • Hello: I download the postgresql-docs-7.4.6.tar.gz and unzip it .I can`t intall it and the help documents is for unix! How can I intall postgresql on my win2000? Please help me thanks! Wang ...
    王亮王亮
    Jan 7, 2005 at 5:48 am
    Apr 30, 2005 at 5:44 am
  • The following bug has been logged online: Bug reference: 1453 Logged by: Email address: m.woehling@barthauer.de PostgreSQL version: 8.0.0 Operating system: Windows 2000 Description: NULLs in UNION ...
    """"
    Jan 31, 2005 at 11:55 pm
    Feb 5, 2005 at 4:46 pm
  • Good afternoon. I think I may have found a bad planner decision in Postgres. In essence, I have a table that is well-sorted, and has an index on the sort column. I wish to retrieve all rows from the ...
    Matthew WakelingMatthew Wakeling
    Jan 31, 2005 at 6:21 pm
    Feb 1, 2005 at 5:59 pm
  • The following bug has been logged online: Bug reference: 1447 Logged by: Olleg Samoylov Email address: olleg@mipt.ru PostgreSQL version: 7.4.6, 8.0.0 Operating system: x86_64-pc-linux-gnu, compiled ...
    Olleg SamoylovOlleg Samoylov
    Jan 28, 2005 at 3:13 pm
    Jan 31, 2005 at 2:34 pm
  • I have a standard Redhat 9 installation with the exception of upgrading bison to bison-1.875-7.1 I can build the postgres rpm files from the source for version 7.4.5 no problems with the following ...
    Donald FraserDonald Fraser
    Jan 31, 2005 at 12:20 pm
    Jan 31, 2005 at 1:05 pm
  • The following bug has been logged online: Bug reference: 1443 Logged by: phucle Email address: le.viet.phuc@gmail.com PostgreSQL version: 8.0 Operating system: Windows XP Pro japanese Description: ...
    PhuclePhucle
    Jan 27, 2005 at 1:34 pm
    Jan 30, 2005 at 11:20 am
  • Consider that foodb=# \d parent Table "public.parent" Column | Type | Modifiers --------+---------+-------------------------------------------------------- id | integer | not null default ...
    Achilleus MantziosAchilleus Mantzios
    Jan 25, 2005 at 3:05 pm
    Jan 25, 2005 at 5:02 pm
  • The following bug has been logged online: Bug reference: 1428 Logged by: Hendrik Mueller Email address: acone@gmx.de PostgreSQL version: 8.0.0.0 Operating system: Windows NT 4.0 + SP4 Description: ...
    Hendrik MuellerHendrik Mueller
    Jan 21, 2005 at 10:36 am
    Jan 25, 2005 at 11:27 am
  • The following bug has been logged online: Bug reference: 1429 Logged by: Hendrik Mueller Email address: acone@gmx.de PostgreSQL version: 8.0.0.0 Operating system: Windows 2000 SP4 Description: stats ...
    Hendrik MuellerHendrik Mueller
    Jan 21, 2005 at 11:43 am
    Jan 25, 2005 at 11:08 am
  • Hello, FOR EACH STATEMENT trigger with plperl crash backaned. FOR EACH ROW trigger works well. Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Jan 24, 2005 at 11:42 pm
    Jan 25, 2005 at 12:35 am
  • The following bug has been logged online: Bug reference: 1433 Logged by: craig perras Email address: craigp98072@yahoo.com PostgreSQL version: 8.0 release Operating system: win2000 Description: ...
    Craig perrasCraig perras
    Jan 22, 2005 at 8:28 am
    Jan 24, 2005 at 11:33 pm
  • The following bug has been logged online: Bug reference: 1432 Logged by: Sam Hahn Email address: SamHahn@StoneSpring.org PostgreSQL version: 8.0 Operating system: Windows XP Pro v2002 SP 2 ...
    Sam HahnSam Hahn
    Jan 22, 2005 at 2:25 am
    Jan 24, 2005 at 2:17 pm
  • Disclaimer that this was found under RC1 so it might have been fixed in final release, though I don't recall it being reported, anyway, the problem is that tab completion does not seem to work for ...
    Robert TreatRobert Treat
    Jan 23, 2005 at 3:01 pm
    Jan 23, 2005 at 5:02 pm
  • The following bug has been logged online: Bug reference: 1409 Logged by: Lutischán Ferenc Email address: yoursoft@freemail.hu PostgreSQL version: 8.0 B5, 7.4.6 Operating system: WinXp, SLES9 ...
    Lutischán FerencLutischán Ferenc
    Jan 18, 2005 at 9:14 am
    Jan 23, 2005 at 2:28 am
  • The following bug has been logged online: Bug reference: 1410 Logged by: Simon Nicholls Email address: simon@mintsource.org PostgreSQL version: PostgreSQL 8.0 Operating system: WindowsXP Description: ...
    Simon NichollsSimon Nicholls
    Jan 18, 2005 at 10:27 am
    Jan 21, 2005 at 12:20 am
  • The following bug has been logged online: Bug reference: 1388 Logged by: Holger Klawitt Email address: lists@klawitter.de PostgreSQL version: 8.0.0 Operating system: all Description: ...
    Holger KlawittHolger Klawitt
    Jan 12, 2005 at 8:31 am
    Jan 18, 2005 at 9:50 am
  • 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. Other backslash commands seem to ...
    Dave BodenstabDave Bodenstab
    Jan 17, 2005 at 5:31 pm
    Jan 18, 2005 at 9:43 am
  • PostgreSQL RC4 Command prompt functions on Windows (Windows 2000 Professional - Spanish with SP4) still displays a message in the format: could not find a "functionname" to execute when executing a ...
    Elvis E. Henriquez A.Elvis E. Henriquez A.
    Jan 11, 2005 at 11:54 am
    Jan 15, 2005 at 4:13 am
  • I think thi is a bug, I've a lot of db up with same structure and I don't have any prioblem.. I'm using psql 7.4.2 the problem is that i've a table sportellounico=# \d cfp Tabella "public.cfp" ...
    Francesco AndreozziFrancesco Andreozzi
    Jan 13, 2005 at 11:17 am
    Jan 13, 2005 at 1:44 pm
  • OS ist Windows XP Prof, PgSQL version is rc5 via windowsinstaller When trying to restore a db, psql does not ask for the password but responds imediately with an erromessage as in the following ...
    Christoph BeckerChristoph Becker
    Jan 12, 2005 at 11:02 pm
    Jan 13, 2005 at 2:46 am
Jan 2005
1234
Group Navigation
period‹ prev | Jan 2005 | next ›
Group Overview
grouppgsql-bugs @
categoriespostgresql
discussions152
posts406
users157
websitepostgresql.org
irc#postgresql

157 users for January 2005

Tom Lane: 78 posts Michael Fuhr: 36 posts Magnus Hagander: 24 posts Alvaro Herrera: 10 posts Bruce Momjian: 9 posts Christoph Becker: 9 posts Peter Eisentraut: 8 posts Josh Berkus: 7 posts Kris Jurka: 6 posts Dave Page: 5 posts Fahad G.: 5 posts T.J.: 5 posts Hendrik Müller: 4 posts Jeff Ross: 4 posts John Hansen: 4 posts John R Pierce: 4 posts Oliver Jowett: 4 posts Edmund Bacon: 3 posts Farid Zidan: 3 posts Joseph Donahue: 3 posts
show more
Archives