FAQ

Search Discussions

65 discussions - 261 posts

  • I just checked out CVS this morning the REL7_1_STABLE branch. I configured it with: ./configure --enable-debug and ran the regression test fine on OpenBSD 2.8 (AMD processor) (The same problem has ...
    Robert HentoshRobert Hentosh
    May 7, 2001 at 10:14 pm
    May 10, 2001 at 6:32 pm
  • I installed the sample startup script for postgres for FreeBSD, but it reports the following error upon running: # /usr/local/etc/rc.d/postgres.sh start pg_ctl: no database directory or environment ...
    Vivek KheraVivek Khera
    May 3, 2001 at 2:53 pm
    May 11, 2001 at 12:19 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Robert HentoshRobert Hentosh
    May 5, 2001 at 2:24 am
    May 7, 2001 at 10:09 pm
  • In chapter: 7.7. Keys you have However, my application requires that each collection will also have a unique name. Why? So that a human being who wants to modify a collection will be able to identify ...
    Maxim MaletskyMaxim Maletsky
    May 30, 2001 at 3:45 am
    May 30, 2001 at 5:18 pm
  • When Postgres is configured and decides to use libncurses and libreadline, the backend gets linked against those two libs, too, even though it really doesn't use them. This is just extra wasted size ...
    Todd R. EigenschinkTodd R. Eigenschink
    May 11, 2001 at 12:18 pm
    May 16, 2001 at 7:53 pm
  • Hello , mans Your server have a bug that sometimes cause coredumps..... System: FreeBSD 4.2-20001127-STABLE Compiler: gcc 2.95.2 Platform: x86 (PII-600) Ram: 256 Mb With server work only one program ...
    A.V.ShutkoA.V.Shutko
    May 13, 2001 at 12:55 am
    May 16, 2001 at 7:03 pm
  • System: SunOS 5.8 Generic_108528-07 sun4u sparc SUNW,Ultra-Enterprise Configuration options: env CFLAGS='-O2 -pipe' ./configure --prefix=/opt/pgsql \ --with-perl --with-python --with-CXX \ ...
    Arcady GenkinArcady Genkin
    May 28, 2001 at 12:16 pm
    Jun 11, 2001 at 12:52 pm
  • Hello, I tried to install PstgreSQL 7.1.1, and I got these error log: gmake[3]: Leaving directory `/users/noorbakh/postgreSQL/postgresql-7.1.1/src/backend/tcop' gmake -C utils all gmake[3]: Entering ...
    Fariba NoorbakhshFariba Noorbakhsh
    May 11, 2001 at 12:21 pm
    May 11, 2001 at 9:23 pm
  • When I execute the following query: SELECT DISTINCT title FROM division ORDER BY UPPER(title); I get: ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target list If I remove DISTINCT, ...
    J.R. OnyschakJ.R. Onyschak
    May 3, 2001 at 2:52 pm
    May 4, 2001 at 5:15 pm
  • To Whom It May Concern: Just wanted to share with you the errors I keep getting trying to upgrade my current version 6.5 of Postgresql to 7.1. 1.) Installed 6.5 via the Red Hat linux install of 6.2 ...
    Schroeder, SteveSchroeder, Steve
    May 16, 2001 at 7:50 pm
    May 16, 2001 at 9:19 pm
  • Are there any problems with 7.1.1 when using libpg and TCP/IP socket connections? I have three machines, two with 7.1.1 and the other with 7.0.3. The 7.1.1 machines are 40 times slower than the 7.0.3 ...
    Chris StorahChris Storah
    May 15, 2001 at 3:40 pm
    May 15, 2001 at 4:34 pm
  • When I build PostgreSQL 7.1.1 from the port on FreeBSD 4.3, pg_config gets built with a syntax error in the "val_configure=..." line. It looks like multiple levels of single quotes, where different ...
    Glenn TrewittGlenn Trewitt
    May 13, 2001 at 12:52 am
    May 13, 2001 at 12:55 am
  • Hello, I think, that I've found one bug in PostgreSQL 7.1 on sparc-sun-Solaris2.7, compilied by GCC 2.7.2.3: When executing a SQL-Query with a "where not exists (...)" Statement, the result is wrong. ...
    Christian BreimannChristian Breimann
    May 11, 2001 at 12:20 pm
    May 11, 2001 at 6:52 pm
  • From my point of view, NULL is neither bigger, nor smaller, you can't compare it with a number. So it just comes at the end if you sort at all. (Perhaps you need to take a think about what NULL means ...
    Piers ScannellPiers Scannell
    May 3, 2001 at 4:21 pm
    May 4, 2001 at 5:16 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Tomasz WegrzanowskiTomasz Wegrzanowski
    May 3, 2001 at 2:52 pm
    May 3, 2001 at 6:15 pm
  • Apparently readline-4.2 gratuitously breaks backward compatibility by undefining filename_completion_function (now called rl_filename_completion_function). This causes the compilation of ...
    Fazal MajidFazal Majid
    May 3, 2001 at 2:54 pm
    May 3, 2001 at 4:48 pm
  • Arcady GenkinArcady Genkin
    May 28, 2001 at 12:14 pm
    Jun 4, 2001 at 12:04 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Tomasz WegrzanowskiTomasz Wegrzanowski
    May 28, 2001 at 12:16 pm
    Jun 4, 2001 at 12:03 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Paul-Andre PanonPaul-Andre Panon
    May 28, 2001 at 12:17 pm
    May 28, 2001 at 8:17 pm
  • Tom, we're hardly working on multi-key support in GiST and horizon is being closer :-) I'd like to raise several questions: 1. index_getprocid (backend/access/index/idexam.c) doesn't properly ...
    Oleg BartunovOleg Bartunov
    May 23, 2001 at 4:15 pm
    May 25, 2001 at 9:40 am
  • Hi! I try to work with trees in Postgres 7.1.1 My test script is ==================================================================== CREATE TABLE hierarchy parent INTEGER, child INTEGER ); INSERT ...
    Alexander ZagrebinAlexander Zagrebin
    May 22, 2001 at 12:24 pm
    May 24, 2001 at 9:13 am
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Krzysztof GajdemskiKrzysztof Gajdemski
    May 18, 2001 at 12:20 pm
    May 18, 2001 at 4:12 pm
  • Yes, and you'll need to double quote the trigger name. try drop trigger "RI_ConstraintTrigger_44349" on users; How did you drop the table? Did you reload a dump file (like the one that referenced it)?
    Stephan SzaboStephan Szabo
    May 16, 2001 at 10:14 pm
    May 16, 2001 at 11:32 pm
  • Howdy, I'm getting a segfault from psql when a createdb is attempted. Postgresql is configured with: ./configure --prefix=/opt/pgsql --enable-syslog and seems to compile without trouble (gcc 2.95.2), ...
    Paul McGarryPaul McGarry
    May 15, 2001 at 5:06 am
    May 15, 2001 at 1:53 pm
  • Your name : Gabor Z. Papp Your email address : gzp@gmx.net System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium Celeron Operating System (example: Linux ...
    Gabor Z. PappGabor Z. Papp
    May 7, 2001 at 1:19 pm
    May 11, 2001 at 12:14 pm
  • I extracted from Ayal the info that he was using timezone 'Asia/Jerusalem'. That zone has the interesting property that the DST transitions happen *at midnight*, not at a sane hour like 2AM. I ...
    Tom LaneTom Lane
    May 2, 2001 at 3:01 am
    May 10, 2001 at 1:55 pm
  • INSERT INTO "ObjectLog1" VALUES (1, '2001-05-02 13:48:59.999', 0, 10, 1, 1, 9, 0, 0, 0, 0); djs=# select "Date" from "ObjectLog1"; Date --------------------------- 2001-05-02 13:48:60.00+03 (1 row) ...
    Alexander BodnarAlexander Bodnar
    May 7, 2001 at 1:16 pm
    May 7, 2001 at 1:16 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Jan BranbergenJan Branbergen
    May 4, 2001 at 5:16 pm
    May 4, 2001 at 8:05 pm
  • Hi I use Postgresql 7.1.1 compiled on a P3 running slackware 7.1 with glibc-2.2.1 make-3.79.1 and gxx-2.95.2 and others dev tools upgraded if needed ask me for more. I create this function: DROP ...
    Frank ContrepoisFrank Contrepois
    May 30, 2001 at 1:46 pm
    May 30, 2001 at 2:46 pm
  • 22 May 2001 Dear Sir; First, thank you for PostGres. It is great! Second, I am puzzled by repeated, apparently pointless calls to memmove() in the function pqReadData, which is in ...
    Brent EwingBrent Ewing
    May 28, 2001 at 12:15 pm
    May 28, 2001 at 3:35 pm
  • The DBD::Pg driver doesn't properly reset "Active" state when all data from a handle is fetched, as specified in the DBI docs under the description of finish(). This program should not report any ...
    Vivek KheraVivek Khera
    May 28, 2001 at 12:18 pm
    May 28, 2001 at 12:18 pm
  • Just tried to update one of my dev boxes to 7.2devel... cc -O -K inline -I../../../src/interfaces/libpq -I../../../src/include -I/usr/local/include -c -o describe.o describe.c UX:acomp: ERROR: ...
    Larry RosenmanLarry Rosenman
    May 27, 2001 at 9:28 pm
    May 27, 2001 at 9:54 pm
  • Hi People I'm planning to upgrade postgresql version 7.0 to 7.1. I tried backuping of my databases using pg_dumpall filename.dump. I'm getting the error as follows: "failed sanity check, table ...
    karthikeyan Vkarthikeyan V
    May 22, 2001 at 2:03 pm
    May 23, 2001 at 2:42 pm
  • I have the following function. When the function is executed and it gets to the 'IF NOT FOUND', the backend gets restarted. I've read that the exception handling is not perfect in Postgres but this ...
    Ondrej PalkovskyOndrej Palkovsky
    May 22, 2001 at 2:03 pm
    May 23, 2001 at 2:37 pm
  • I'm stress testing my application by creating large data sets. This particular query selects rows from the schedule table that have a specific owner_id. (I'll show you the results of explain) ...
    John AugheyJohn Aughey
    May 16, 2001 at 7:54 pm
    May 17, 2001 at 12:53 am
  • Strange date behavior as shown below. create table "holidays" ("date" date NOT NULL,"name" varchar(25)); insert into holidays values ('01-01-2001'::date,'New Years'); insert into holidays values ...
    Jeff PattersonJeff Patterson
    May 16, 2001 at 7:50 pm
    May 16, 2001 at 10:59 pm
  • Hello, I try the procedure explained Techdocs.posgresql.org/installguide.php No problem to configure and make But : make install give me this All of PostgreSQL successfully made. Ready to install. ...
    BvdeBvde
    May 16, 2001 at 7:53 pm
    May 16, 2001 at 8:39 pm
  • Hi, and thank you for a great ORDBMS. The configure.in file erraneous assumes that FreeBSD 1.x and 2.x have ELF capability. While this is true to some extent, this assumption makes it impossible to ...
    Trond EndrestølTrond Endrestøl
    May 14, 2001 at 4:29 pm
    May 16, 2001 at 5:28 pm
  • when executing the code bellow: --- create table test_unique(i1 integer, i2 integer, unique(i1,i2)); insert into test_unique(1,null); insert into test_unique(1,null); insert into test_unique(1,null); ...
    Domingo Alvarez DuarteDomingo Alvarez Duarte
    May 13, 2001 at 12:56 am
    May 13, 2001 at 2:03 am
  • Leonid (leo@rusmedia.net) reports a bug with a severity of 2(?) Short Description Terrible perfomance during nested "... where x in (select ...)" operator Long Description PostgreSQL 7.1, FreeBSD ...
    Черепанов ЛеонидЧерепанов Леонид
    May 11, 2001 at 12:15 pm
    May 11, 2001 at 6:08 pm
  • In short, when I try to restore a database from a pg_dump generated SQL script, then try to insert additional records into the restored datbase, it gives me a duplicate key error. I am using the ...
    Jerry DavisJerry Davis
    May 11, 2001 at 12:14 pm
    May 11, 2001 at 3:08 pm
  • I have a problem I have a function in plpgsql: create function add_one (integer) returns integer as ' begin return $1+1; end; ' language 'plpgsql'; When I create in psql monitor this function the ...
    Vinicio LlumiquingaVinicio Llumiquinga
    May 11, 2001 at 12:19 pm
    May 11, 2001 at 2:16 pm
  • Hi I'm using postgres 7.1.1 version tar format. I've compiled and installed with the default option 1) ./configure 2) make 3) make install 4) create a data dir with postgres user permission in ...
    McCoy MunMcCoy Mun
    May 11, 2001 at 12:21 pm
    May 11, 2001 at 1:45 pm
  • Hello: In version 7.1 the man page for pg_ctl does not document -s option. Thanks, -- Arcady Genkin
    AntipodeAntipode
    May 3, 2001 at 4:33 pm
    May 3, 2001 at 5:42 pm
  • albert DURANTONalbert DURANTON
    May 30, 2001 at 1:46 pm
    May 30, 2001 at 1:46 pm
  • "pg_ctl restart" seems to not work as documented in postgresql 7.1.2. bash-2.04$ /usr/bin/pg_ctl restart -w -D /var/lib/pgsql/data -m fast waiting for postmaster to shut down......done postmaster ...
    Trond Eivind GlomsrødTrond Eivind Glomsrød
    May 30, 2001 at 1:45 pm
    May 30, 2001 at 1:45 pm
  • Hi, I'm not quite sure where I should be asking the following questions so if this is the wrong place please let me know where I should send it. I'm using PostGre on Windows N/T (sp6). I'm connecting ...
    Petermackie5Petermackie5
    May 28, 2001 at 12:17 pm
    May 28, 2001 at 12:17 pm
  • Thanks! That did it: tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth; dayofmonth ------------ 31 (1 row) tbs=# SET TIMEZONE = 'GMT' ; SET VARIABLE tbs=# SELECT DATE_PART('DAY', ...
    Peter KellyPeter Kelly
    May 28, 2001 at 12:16 pm
    May 28, 2001 at 12:16 pm
  • Here are operational details: RedHat Linux 7.0: Linux version 2.2.17-14 (root@porky.devel.redhat.com) (gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) #1 Mon Feb 5 15:25:12 EST 2001 ...
    Peter KellyPeter Kelly
    May 28, 2001 at 12:16 pm
    May 28, 2001 at 12:16 pm
  • Hi, Re. Making Pgsql on SCO Open Server Version 7.1.1 Firstly, "make" blows with undefined symbol "NOFILE" in "src/backend/storage/file/fd.c". I temporarily changed this to a hard-coded value. After ...
    Roger WhileRoger While
    May 28, 2001 at 12:16 pm
    May 28, 2001 at 12:16 pm
Group Navigation
period‹ prev | May 2001 | next ›
Group Overview
grouppgsql-bugs @
categoriespostgresql
discussions65
posts261
users81
websitepostgresql.org
irc#postgresql

81 users for May 2001

Tom Lane: 79 posts : 38 posts Peter Eisentraut: 25 posts Bruce Momjian: 22 posts Thomas Lockhart: 12 posts Vivek Khera: 8 posts Robert Hentosh: 7 posts Stephan Szabo: 6 posts Chris Storah: 4 posts J.R. Onyschak: 3 posts Paul-Andre Panon: 3 posts Todd R. Eigenschink: 3 posts Alexander Bodnar: 2 posts Alexander Zagrebin: 2 posts And. Andruikhanov: 2 posts Arcady Genkin: 2 posts Gabor Z. Papp: 2 posts Glenn Trewitt: 2 posts Jon: 2 posts Jonathan Ellis: 2 posts
show more
Archives