FAQ

PostgreSQL > pgsql-bugs > November 2006

Search Discussions

79 discussions - 254 posts

  • I've been attempting to run PostgreSQL 8.1.5/win32 on a production deployment, but have started having many problems. McAfee Antivirus is installed and running, although I've excluded the entire ...
    Jeremy HaileJeremy Haile
    Nov 27, 2006 at 2:48 pm
    Dec 5, 2006 at 5:17 am
  • Hi, I have problems building 8.2beta2 on a Solaris 10 x86-64 machine: gmake[4]: Entering directory `/files/dsk1/lsw/src/postgresql/postgresql-8.2beta2/src/backend/utils/adt' ...
    Andreas LangeAndreas Lange
    Nov 3, 2006 at 2:01 pm
    Nov 15, 2006 at 10:21 am
  • The following bug has been logged online: Bug reference: 2737 Logged by: Balazs Nagy Email address: bnagy@thenewpush.com PostgreSQL version: 8.1.5 Operating system: RHEL4 Description: hash indexing ...
    Balazs NagyBalazs Nagy
    Nov 5, 2006 at 1:47 pm
    Nov 17, 2006 at 3:36 pm
  • The following bug has been logged online: Bug reference: 2731 Logged by: Leonid Shlyapnikov Email address: lshlyapnikov@gmail.com PostgreSQL version: 8.1.5-1 Operating system: Windows XP Media Center ...
    Leonid ShlyapnikovLeonid Shlyapnikov
    Nov 3, 2006 at 2:01 am
    Nov 4, 2006 at 6:04 pm
  • Hi All, It doesn't appear that ANALYZE uses the specified operator class for producing statistics on an index when that operator class is not the default for the data type. This appears to be leading ...
    Rusty ConoverRusty Conover
    Nov 3, 2006 at 10:16 pm
    Nov 23, 2006 at 3:48 am
  • The following bug has been logged online: Bug reference: 2768 Logged by: Mikko Tiihonen Email address: mikko.tiihonen@iki.fi PostgreSQL version: 8.1.5 Operating system: Linux/amd64/gcc-4.1.1 ...
    Mikko TiihonenMikko Tiihonen
    Nov 19, 2006 at 2:01 am
    Nov 21, 2006 at 5:01 pm
  • Hi all, On this page ( http://www.postgresql.org/docs/8.1/interactive/functions-array.html), the entry for array_lower() says: Example: array_lower(array_prepend(0, ARRAY[1,2,3]), 1) -- ...
    Gurjeet SinghGurjeet Singh
    Nov 22, 2006 at 4:46 am
    Nov 22, 2006 at 2:59 pm
  • We found the problem on one of our production 8.1 servers; a big concern is that it breaks dumps (allows you to dump a table with a value that can't be restored). Seems to be a problem in 8.2 as ...
    Robert TreatRobert Treat
    Nov 2, 2006 at 10:27 pm
    Nov 3, 2006 at 6:18 am
  • The following bug has been logged online: Bug reference: 2781 Logged by: Greg Peters Email address: gregpeters79@gmail.com PostgreSQL version: 8.1/8.2beta3 Operating system: WInXP Description: ...
    Greg PetersGreg Peters
    Nov 26, 2006 at 11:38 am
    Nov 28, 2006 at 12:36 pm
  • this somehow sounds buggy: there's this table forum.posts which had 224mb table size, 145mb toast table size and 176mb indexes size (aproximately 60'000 rows). as i was doing some updates of all the ...
    Thomas H.Thomas H.
    Nov 27, 2006 at 5:48 am
    Nov 27, 2006 at 6:06 pm
  • See example below. At the very least the documentation needs to tell users that savepoints use shared memory, and the cofusing HINT string needs to be changed to something more useful. When run on a ...
    Joseph ShraibmanJoseph Shraibman
    Nov 15, 2006 at 7:58 pm
    Nov 16, 2006 at 9:08 pm
  • The following bug has been logged online: Bug reference: 2758 Logged by: scoanda Email address: sabin.coanda@deuromedia.ro PostgreSQL version: 8.1.4 Operating system: Windows XP sp2 Description: ...
    ScoandaScoanda
    Nov 14, 2006 at 3:42 pm
    Nov 15, 2006 at 8:28 am
  • The following bug has been logged online: Bug reference: 2784 Logged by: Michael Simms Email address: michael@tuxgames.com PostgreSQL version: 8.1.4 Operating system: Linux kernel 2.6.12 Description: ...
    Michael SimmsMichael Simms
    Nov 26, 2006 at 4:35 pm
    Nov 28, 2006 at 11:08 am
  • The following bug has been logged online: Bug reference: 2769 Logged by: Chris Jones Email address: chris@cjones.org PostgreSQL version: 8.0.9 Operating system: NetBSD 2.0.2 Description: "invalid ...
    Chris JonesChris Jones
    Nov 19, 2006 at 7:34 am
    Nov 26, 2006 at 4:37 pm
  • The following bug has been logged online: Bug reference: 2779 Logged by: Sven Klemm Email address: sven@c3d2.de PostgreSQL version: 8.1 Operating system: Linux (Debian) Description: Making an ...
    Sven KlemmSven Klemm
    Nov 24, 2006 at 6:35 pm
    Nov 24, 2006 at 9:58 pm
  • The following bug has been logged online: Bug reference: 2773 Logged by: Amelio Email address: ameliocf@yahoo.com.br PostgreSQL version: 8.2 beta 2 Operating system: Windows XP Description: Problem ...
    AmelioAmelio
    Nov 21, 2006 at 2:08 pm
    Nov 21, 2006 at 5:16 pm
  • The following bug has been logged online: Bug reference: 2764 Logged by: Ron Teitelbaum Email address: ron@usmedrec.com PostgreSQL version: 1.4.1 Operating system: Windows Description: Capital letter ...
    Ron TeitelbaumRon Teitelbaum
    Nov 17, 2006 at 7:40 pm
    Nov 21, 2006 at 3:38 pm
  • I have a sugestion for pgsql 8.2 or next versions ... Is complicated encrypt the procedures/functions on Database like Oracle or similar? I sugest this because we develop ERP/MRP with complex ...
    MarcioMarcio
    Nov 3, 2006 at 1:11 pm
    Nov 8, 2006 at 1:16 am
  • The following bug has been logged online: Bug reference: 2789 Logged by: Lucian Capdefier Email address: luciancapdefier@gmail.com PostgreSQL version: 8.1.5 Operating system: Windows XP Description: ...
    Lucian CapdefierLucian Capdefier
    Nov 28, 2006 at 12:21 am
    Dec 3, 2006 at 10:15 pm
  • The following bug has been logged online: Bug reference: 2790 Logged by: Gurjeet Singh Email address: singh.gurjeet@gmail.com PostgreSQL version: 8.2beta3 Operating system: Windows Description: ...
    Gurjeet SinghGurjeet Singh
    Nov 28, 2006 at 12:27 pm
    Nov 28, 2006 at 3:19 pm
  • The following bug has been logged online: Bug reference: 2785 Logged by: Patrick Hayes Email address: pkhayeskp@hotmail.com PostgreSQL version: 8.1 Operating system: Windows Professional Description: ...
    Patrick HayesPatrick Hayes
    Nov 27, 2006 at 6:04 pm
    Nov 28, 2006 at 2:14 pm
  • Hi, PostgreSQL 8.1.5 have a problem with division by zero on sparc. Solaris 9 sparc, gcc 4.0.2, 4.1.1: $ ./configure --enable-thread-safety --disable-nls --without-perl --without-python ...
    Дейтер Александр ВалериевичДейтер Александр Валериевич
    Nov 24, 2006 at 12:51 pm
    Nov 26, 2006 at 5:02 pm
  • The following bug has been logged online: Bug reference: 2759 Logged by: Leon Miller-Out Email address: pg_bugs@leonout.com PostgreSQL version: 8.1.5 Operating system: CentOS 4.4 x64 Description: \df ...
    Leon Miller-OutLeon Miller-Out
    Nov 14, 2006 at 4:25 pm
    Nov 21, 2006 at 9:05 pm
  • I have a query that is aborting because of out of memory, and am wondering what I can do to prevent this from *ever* happening (shouldn't it be able to use disk)? =# explain INSERT INTO term_doc_rel3 ...
    Joe MalickiJoe Malicki
    Nov 15, 2006 at 9:34 pm
    Nov 21, 2006 at 3:53 pm
  • The following bug has been logged online: Bug reference: 2771 Logged by: vincent Email address: vincent@iim.nctu.edu.tw PostgreSQL version: 8.x Operating system: windows2k Description: NULL values in ...
    VincentVincent
    Nov 20, 2006 at 9:43 am
    Nov 21, 2006 at 4:47 am
  • The following bug has been logged online: Bug reference: 2767 Logged by: Steffen Macke Email address: sdteffen@gmail.com PostgreSQL version: 8.1.4 Operating system: Windows XP Description: Bug in ...
    Steffen MackeSteffen Macke
    Nov 18, 2006 at 7:18 am
    Nov 21, 2006 at 4:17 am
  • The following bug has been logged online: Bug reference: 2739 Logged by: Mason Hale Email address: masonhale@gmail.com PostgreSQL version: 8.1.5 Operating system: GNU/Linux 2.6.9-42.0.3.ELsmp ...
    Mason HaleMason Hale
    Nov 6, 2006 at 5:33 pm
    Nov 6, 2006 at 7:57 pm
  • I read it http://www.postgresql.org/docs/8.1/interactive/tutorial-accessdb.html I can't use examples: maxim-# SELECT version(); ERROR: syntax error at or near "SELECT" at character 18 СТРОКА 2: ...
    Maxim BritovMaxim Britov
    Nov 1, 2006 at 7:07 pm
    Nov 2, 2006 at 4:35 pm
  • The following bug has been logged online: Bug reference: 2794 Logged by: Email address: andres.ortega@farmacity.com.co PostgreSQL version: 8.1.3 Operating system: macosx Description: corrupted table ...
    """"
    Nov 29, 2006 at 3:32 pm
    Dec 1, 2006 at 9:51 am
  • The following bug has been logged online: Bug reference: 2795 Logged by: Ilia Email address: iluha@igchat.com PostgreSQL version: postgreSQL 8.1 Operating system: windows server 2003 standart edition ...
    IliaIlia
    Nov 30, 2006 at 1:33 pm
    Nov 30, 2006 at 5:11 pm
  • The following bug has been logged online: Bug reference: 2791 Logged by: Raman Dabhade Email address: raman.dabhade@coalitiondev.com PostgreSQL version: 8.1 Operating system: Win XP Description: ...
    Raman DabhadeRaman Dabhade
    Nov 28, 2006 at 2:13 pm
    Nov 29, 2006 at 2:46 pm
  • The following bug has been logged online: Bug reference: 2792 Logged by: Santhinesh Kumar Email address: santhineshkumar_n@sifycorp.com PostgreSQL version: 7.1.3 Operating system: Fedora - 4 ...
    Santhinesh KumarSanthinesh Kumar
    Nov 28, 2006 at 4:37 pm
    Nov 28, 2006 at 5:13 pm
  • The following bug has been logged online: Bug reference: 2786 Logged by: Gilberto Xavier Email address: gilbertoxavier@gmail.com PostgreSQL version: 8.1 Operating system: Linux and Windows ...
    Gilberto XavierGilberto Xavier
    Nov 27, 2006 at 7:33 pm
    Nov 28, 2006 at 8:58 am
  • The following bug has been logged online: Bug reference: 2788 Logged by: Shawn Tayler Email address: stayler@washoecounty.us PostgreSQL version: 8.1.5 Operating system: Linux 2.6.17 Description: ...
    Shawn TaylerShawn Tayler
    Nov 27, 2006 at 9:53 pm
    Nov 28, 2006 at 5:09 am
  • The following bug has been logged online: Bug reference: 2782 Logged by: Alaa El Gohary Email address: alaaelgohary@bftech.com.eg PostgreSQL version: 7.4.12 Operating system: FreeBSD 6.0 Description: ...
    Alaa El GoharyAlaa El Gohary
    Nov 26, 2006 at 1:58 pm
    Nov 28, 2006 at 3:01 am
  • I'm getting some odd results when running two generate_series calls in a SELECT. When the two calls return the same number of rows you get that many rows out: # SELECT generate_series(1,3), ...
    Kris JurkaKris Jurka
    Nov 27, 2006 at 11:26 am
    Nov 27, 2006 at 6:48 pm
  • The following bug has been logged online: Bug reference: 2776 Logged by: Raghava Email address: kraghavaiah@velankani.com PostgreSQL version: 8.1.4 Operating system: RHEL Description: unable to ...
    RaghavaRaghava
    Nov 22, 2006 at 2:24 pm
    Nov 25, 2006 at 8:16 am
  • The following bug has been logged online: Bug reference: 2775 Logged by: Mas Kus Email address: kusuma_ok@telkom.net PostgreSQL version: 7.4.1-2 Operating system: Mandrake 10.0 Description: Error ...
    Mas KusMas Kus
    Nov 22, 2006 at 1:35 pm
    Nov 24, 2006 at 9:47 pm
  • The following bug has been logged online: Bug reference: 2772 Logged by: S.Balaji Email address: balajisundar@midascomm.com PostgreSQL version: 7.4 Operating system: CentOS 4.4 Description: Undefined ...
    S.BalajiS.Balaji
    Nov 20, 2006 at 12:07 pm
    Nov 22, 2006 at 7:28 pm
  • Hello, I Sule Rahman from the International Institute of Tropical Agriculture, Ibadan, Nigeria( IITA). IITA is an international research organisation committed to the development and improve ...
    Sule, Olufemi (IITA)Sule, Olufemi (IITA)
    Nov 21, 2006 at 2:10 pm
    Nov 21, 2006 at 5:28 pm
  • The following bug has been logged online: Bug reference: 2766 Logged by: Karl DeBieechop Email address: kdebisschop@alert.infoplease.com PostgreSQL version: 8.1.4 Operating system: Fedora 5 ...
    Karl DeBieechopKarl DeBieechop
    Nov 17, 2006 at 9:23 pm
    Nov 21, 2006 at 4:16 am
  • The following bug has been logged online: Bug reference: 2755 Logged by: Basil Evseenko Email address: evseenko@sysoft.ru PostgreSQL version: 8.1.4 Operating system: Linux 2.6 Description: strange ...
    Basil EvseenkoBasil Evseenko
    Nov 12, 2006 at 4:49 pm
    Nov 13, 2006 at 5:42 am
  • The following bug has been logged online: Bug reference: 2732 Logged by: Basil Evseenko Email address: evseenko@sysoft.ru PostgreSQL version: 8.2beta2 Operating system: Linux 2.6 Description: ...
    Basil EvseenkoBasil Evseenko
    Nov 3, 2006 at 2:27 pm
    Nov 10, 2006 at 11:00 pm
  • The following bug has been logged online: Bug reference: 2750 Logged by: Stephen haberman Email address: stephen@exigencecorp.com PostgreSQL version: 8.2 beta 3 Operating system: win32 Description: ...
    Stephen habermanStephen haberman
    Nov 10, 2006 at 1:04 am
    Nov 10, 2006 at 4:44 pm
  • The following bug has been logged online: Bug reference: 2751 Logged by: Dennis Email address: aiwa_azca@yahoo.com PostgreSQL version: 8.1.5 Operating system: Gentoo 2006.1 server x86 Description: ...
    DennisDennis
    Nov 10, 2006 at 9:23 am
    Nov 10, 2006 at 3:44 pm
  • the JDBC driver does not handle setNull for boolean types. the switch statement in setNull should be expanded with a case that checks for Types.BOOLEAN
    David GreenDavid Green
    Nov 8, 2006 at 11:27 pm
    Nov 10, 2006 at 2:21 pm
  • The following bug has been logged online: Bug reference: 2749 Logged by: Hagen Email address: sixtus@gmail.com PostgreSQL version: 8.2beta2 Operating system: OSX Description: Function's final ...
    HagenHagen
    Nov 9, 2006 at 10:07 am
    Nov 10, 2006 at 7:04 am
  • The following bug has been logged online: Bug reference: 2742 Logged by: Email address: chad.wilson@ngc.com PostgreSQL version: 8.0rc5 Operating system: Linux Red Hat 8 Description: psql -c is not ...
    """"
    Nov 7, 2006 at 11:11 pm
    Nov 10, 2006 at 6:52 am
  • The following bug has been logged online: Bug reference: 2735 Logged by: Emil J. Email address: emilj@inmail.sk PostgreSQL version: 8.1.5, 8.1.4 Operating system: Windows XP Pro SP2 Description: ...
    Emil J.Emil J.
    Nov 4, 2006 at 9:46 am
    Nov 6, 2006 at 9:29 am
  • The following bug has been logged online: Bug reference: 2738 Logged by: Michael Deichen Email address: deichen@meta-preissuche.de PostgreSQL version: 8.1 Operating system: Kubuntu 6.10 Description: ...
    Michael DeichenMichael Deichen
    Nov 5, 2006 at 6:18 pm
    Nov 5, 2006 at 11:00 pm
Nov 2006
12
Group Navigation
period‹ prev | Nov 2006 | next ›
Group Overview
grouppgsql-bugs @
categoriespostgresql
discussions79
posts254
users105
websitepostgresql.org
irc#postgresql

105 users for November 2006

Tom Lane: 51 posts Thomas H.: 19 posts Jeremy Haile: 13 posts Magnus Hagander: 8 posts Bruce Momjian: 7 posts Gurjeet Singh: 6 posts Simon Riggs: 6 posts Alvaro Herrera: 5 posts Andreas Lange: 5 posts Dave Page: 5 posts Heikki Linnakangas: 4 posts Leonid Shlyapnikov: 4 posts Basil Evseenko: 3 posts Bruno Wolff III: 3 posts Harald Armin Massa: 3 posts Mikko Tiihonen: 3 posts Rusty Conover: 3 posts Zdenek Kotala: 3 posts Tomas: 2 posts Bradley Russell: 2 posts
show more
Archives