FAQ

Search Discussions

38 discussions - 152 posts

  • CheckPointer updates system RedoRecPtr before doing anything else. System RedoRecPtr was introduced to force data buffers backup by future XLogInsert-s once CheckPointer started and it *must* be ...
    Mikheev, VadimMikheev, Vadim
    Mar 13, 2002 at 10:34 pm
    Mar 15, 2002 at 6:36 pm
  • Yikes! I have reproduced this bug. My server logs are: LOG: database system was shut down at 2002-03-08 17:30:03 CET LOG: checkpoint record is at 0/46D018 LOG: redo record is at 0/46D018; undo record ...
    Bruce MomjianBruce Momjian
    Mar 11, 2002 at 11:02 pm
    Mar 13, 2002 at 10:32 pm
  • 7.2 crashes with the below function: CREATE OR REPLACE FUNCTION runMaintenance() RETURNS BOOL AS ' VACUUM; SELECT TRUE; ' LANGUAGE sql; I was going to toss a bunch of system maintenance stuff in a ...
    Rod TaylorRod Taylor
    Mar 17, 2002 at 12:56 am
    Apr 16, 2002 at 12:54 am
  • Hi All, I've just compiled and checked version 7.2 of the system on BSDI 4.0 and have noticed the following errors in the regression.diffs file ! psql: PQconnectPoll() -- couldn't send startup ...
    Steven NúñezSteven Núñez
    Mar 2, 2002 at 11:12 pm
    Mar 4, 2002 at 5:44 am
  • Hi, I have been looking at the functions in array_iterator.so. So far they have proved to be very useful. However, I have manage to find a very serious bug where the array_iterator() function causes ...
    Matt PetersonMatt Peterson
    Mar 26, 2002 at 7:32 pm
    Apr 2, 2002 at 8:56 pm
  • To whom it may concern: I found a constraint bug on PostgreSQL lastest version (7.2). Here is how I got the bug. ...
    Eric LuEric Lu
    Mar 7, 2002 at 12:48 am
    Mar 19, 2002 at 2:57 am
  • hi, here i have a problem in comparing null values in plpgsql. this exist in 7.1.x and 7.2 as well. the condition <null value != <valid value fails in plpgsql. consider this function is triggered on ...
    Bhuvan ABhuvan A
    Mar 11, 2002 at 5:18 am
    Mar 14, 2002 at 3:03 pm
  • where did you get this definition of behaviour!? is it applicable only to postgres or ..? its quite strange yaar!
    Bhuvan ABhuvan A
    Mar 11, 2002 at 10:31 am
    Mar 11, 2002 at 5:02 pm
  • Good day. Please reveiew log below. test=# \d subscribers; Table "subscribers" Column | Type | Modifiers ----------+------------------------+---------------------------------------- ----------- sid | ...
    Vlad MarchenkoVlad Marchenko
    Mar 29, 2002 at 12:19 pm
    Apr 2, 2002 at 8:33 pm
  • Hi, from time to time my postmaster crashes with the below mentioned errormessage. I am using PostgreSQL 7.1.2 on sparc-sun-solaris2.5.1, compiled by GCC 2.95 on a 4CPU/4GB UltraSparc II system. The ...
    Michael BeckstetteMichael Beckstette
    Mar 26, 2002 at 5:17 pm
    Mar 26, 2002 at 6:03 pm
  • In current sources: regression=# create table tt1 (i2 int2, i4 int4, f8 float8, regression(# \r Query buffer reset (cleared). regression(# select 2; regression(# -- nothing happens because psql still ...
    Tom LaneTom Lane
    Mar 17, 2002 at 6:12 pm
    Mar 19, 2002 at 12:13 am
  • Hi, When creating a table from psql named 'tblProduct' that is turned into tblproduct. (I'm accessing pg through Qt db classes too and I experience the same thing there too I believe) However, when ...
    Per WinkvistPer Winkvist
    Mar 12, 2002 at 7:34 pm
    Mar 13, 2002 at 11:02 pm
  • But sequences can force WAL record if sequence page LSN is <= than system RedoRecPtr (XLogCtlInsert.RedoRecPtr), ie previously made sequence WAL record is "too old" and would not be played during ...
    Mikheev, VadimMikheev, Vadim
    Mar 13, 2002 at 9:03 pm
    Mar 13, 2002 at 10:31 pm
  • hello i've got the following error: here is the output: ####################################################################### osk= select age('2001-03-29','2001-03-01'); age --------------- 27 days ...
    Konrad GdowskiKonrad Gdowski
    Mar 31, 2002 at 10:18 pm
    Apr 3, 2002 at 2:28 pm
  • I tried to store 700GB of ".tif" images but postgreSQL didn´t support it. Well. Actually I´d like to know if postgreSQL supports it in multiples HD, since today´s HD support up to 200 GB only.
    Daniel Malaquias de FreitasDaniel Malaquias de Freitas
    Mar 14, 2002 at 8:53 pm
    Mar 19, 2002 at 11:56 pm
  • ============================================================================ POSTGRESQL BUG REPORT ============================================================================ Your name :Viacheslav N ...
    Viacheslav N TararinViacheslav N Tararin
    Mar 15, 2002 at 2:10 pm
    Mar 16, 2002 at 3:32 pm
  • Hi, We have a table named "atm" in our database which is uing latest driver of postgresql, it has a column named "location", all records (which are more than 1) of "atm" table have this column value ...
    AwaisAwais
    Mar 14, 2002 at 11:30 am
    Mar 14, 2002 at 3:33 pm
  • hi, Hope you might have came accross this problem earlier. it exists in 7.1.x and 7.2 as well. while creating a table with a column of type 'serial', well a sequence has been created and the default ...
    Bhuvan ABhuvan A
    Mar 14, 2002 at 5:15 am
    Mar 14, 2002 at 5:49 am
  • Hi, I'm building postgresql 7.2 on power pc linux using: gcc-2.95.4-0.20010823.3 glibc-2.2.5-2 binutils-2.11.90.0.19-4 [builder@pld_ppc regress]$ cat /proc/cpuinfo cpu : 740/750 temperature : 45 C ...
    Arkadiusz MiskiewiczArkadiusz Miskiewicz
    Mar 6, 2002 at 9:18 am
    Mar 7, 2002 at 3:44 pm
  • Hi! pgsql 7.2, Linux 2.0.35. procedure to reproduce incorrect result: (1) either initdb -E EUC_TW or initdb -E MULE_INTERNAL (2)createdb database1 (3) psql database1 (4) create table test (f1 ...
    CnliouCnliou
    Mar 1, 2002 at 7:58 am
    Mar 5, 2002 at 1:02 am
  • Is it a known bug if optimizer, that Postgres can't use indexes created on a int8 (bigint) ? This problem exists in 7.1.3 and even in 7.2. test=# CREATE TABLE parent_child ( test(# parent_id int8 NOT ...
    Victor KrasinskyVictor Krasinsky
    Mar 1, 2002 at 1:19 pm
    Mar 4, 2002 at 9:00 pm
  • Hello pgsql-bugs, I cannot install postgresql-7.2 on my Debian Linux I have downloaded postgresql-7.2.tar.gz from http://www.ca.postgresql.org/ftpsite/v7.2/postgresql-7.2.tar.gz and try to install on ...
    UltraMaxUltraMax
    Mar 1, 2002 at 10:27 am
    Mar 1, 2002 at 12:38 pm
  • Inserting text with an apostrophe fails. Updating a record after it's initial creation works fine. PGAccess version: 0.98.7 (as included with Mandrake 8.2). file: pgaccess/lib/tables.tcl fixed lines: ...
    Ryan GrangeRyan Grange
    Mar 31, 2002 at 5:23 pm
    Mar 31, 2002 at 5:23 pm
  • Hello, I am working on Red Hat Linux v7.1 and am trying to install PostgreSQL7.2 on it. I am using the rpms directly rather than installing it from the source code. I see that there are rpm's ...
    Vaishakhi AjmeraVaishakhi Ajmera
    Mar 26, 2002 at 4:09 pm
    Mar 26, 2002 at 4:09 pm
  • Hi, ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name ...
    Sullivan,Deric [CMC]Sullivan,Deric [CMC]
    Mar 19, 2002 at 3:25 pm
    Mar 19, 2002 at 3:25 pm
  • The numbers you see are OID'S, ie the OID of the relation. this is done to prevent name clashing and also makes fo easy lookups by the backend it self.
    Darcy BuskermolenDarcy Buskermolen
    Mar 18, 2002 at 4:54 pm
    Mar 18, 2002 at 4:54 pm
  • Hi, - I tried to execute following SQL alter table PRICEGROUP add FOREIGN KEY ("PARENT") REFERENCES "PRICEGROUP" ON DELETE CASCADE this gives an error ALTER TABLE: column "PARENT" referenced in ...
    Dirk JacobsDirk Jacobs
    Mar 15, 2002 at 12:20 pm
    Mar 15, 2002 at 12:20 pm
  • Hi I am using PostgreSQL version 7.1.2 and the problem that I am facing can be reproduced as below create table numeric_tab (col1 numeric(20)) ; CREATE insert into numeric_tab values(123456789012345) ...
    Sridhar BhamidiSridhar Bhamidi
    Mar 14, 2002 at 8:17 am
    Mar 14, 2002 at 8:17 am
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Ward VandewegeWard Vandewege
    Mar 13, 2002 at 4:47 pm
    Mar 13, 2002 at 4:47 pm
  • Here is the script that I use to build PostgreSQL under Irix. The configure scripts works just fine, and all regression tests past (join gives a compliant but different record order). #!/bin/ksh -x ...
    Robert E. BruccoleriRobert E. Bruccoleri
    Mar 12, 2002 at 7:36 pm
    Mar 12, 2002 at 7:36 pm
  • 0

    Re:

    I think that you are searching for a solution, so, view the COALESCE SQL function in PostgreSQL documentation. It will help you in your compares. Juliano S. Ignacio jsignacio@yahoo.com
    Juliano IgnacioJuliano Ignacio
    Mar 11, 2002 at 8:12 pm
    Mar 11, 2002 at 8:12 pm
  • Happens on: PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96 PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96 -- Pgsql inserts bad timestamp (seconds 60.00): CREATE TABLE ...
    MozillaMozilla
    Mar 11, 2002 at 6:00 pm
    Mar 11, 2002 at 6:00 pm
  • Peter T MountPeter T Mount
    Mar 9, 2002 at 11:48 am
    Mar 9, 2002 at 11:48 am
  • Hello, I got some pb with this configuration database pgsql 7.1 and connect with jdbc driver from 7.2 I notice something that could be a jdbc bugs : when connection is not set to autocommit ...
    Nicolas PaymalNicolas Paymal
    Mar 5, 2002 at 9:56 am
    Mar 5, 2002 at 9:56 am
  • Follow up: PGv7.2 still suffers from the Seg. Fault on exit problem reported below on that system. However, Ran the new v7.2 on a new machine with the following config: Architecture (example: Intel ...
    Riendeau, MikeRiendeau, Mike
    Mar 4, 2002 at 7:13 pm
    Mar 4, 2002 at 7:13 pm
  • Dear Sir/Madam, We have visited your website: shop.juni.gliwice.pl and found that you didn't register it with enough search engines. As a result, this may impede your business expansion. We believe ...
    MelissaMelissa
    Mar 2, 2002 at 10:51 am
    Mar 2, 2002 at 10:51 am
  • Hi All, I've just compiled and checked version 7.2 of the system on BSDI 4.0 and have noticed the following errors in the regression.diffs file ! psql: PQconnectPoll() -- couldn't send startup ...
    Steven NúñezSteven Núñez
    Mar 2, 2002 at 4:02 am
    Mar 2, 2002 at 4:02 am
  • Hi I have two databases and every thing work well , but this morning i don't have any database in pg_database .and when i want to see my tables there is no tables even structure and data is here in ...
    Fouad FezziFouad Fezzi
    Mar 1, 2002 at 9:32 am
    Mar 1, 2002 at 9:32 am
Group Navigation
period‹ prev | Mar 2002 | next ›
Group Overview
grouppgsql-bugs @
categoriespostgresql
discussions38
posts152
users56
websitepostgresql.org
irc#postgresql

56 users for March 2002

Tom Lane: 35 posts : 23 posts Bruce Momjian: 13 posts Stephan Szabo: 11 posts Ben Grimm: 8 posts Peter Eisentraut: 7 posts Steven Núñez: 5 posts Vadim Mikheev: 5 posts Bhuvan A: 4 posts Michael G. Martin: 4 posts Laurent FAILLIE: 3 posts Ron Mayer: 3 posts Juliano Ignacio: 2 posts Justin: 2 posts Michael Beckstette: 2 posts Per Winkvist: 2 posts Reinhard Max: 2 posts Robert E. Bruccoleri: 2 posts Tom Pfau: 2 posts UltraMax: 2 posts
show more
Archives