FAQ

Search Discussions

166 discussions - 701 posts

  • Hello, I was wondering if it would be possible, in the Postgres backend, to send back the defined column size for the varchar data type (and possibly the char() type, i.e., bpchar) on a query? ...
    Byron NikolaidisByron Nikolaidis
    Apr 23, 1998 at 3:34 pm
    May 14, 1998 at 11:56 pm
  • Here is a revised proposal that takes into account the discussions of the last few days. Any comments? I propose to revise libpq and modify the frontend/backend protocol to provide the following ...
    Tom LaneTom Lane
    Apr 28, 1998 at 4:22 pm
    Jul 6, 1998 at 1:37 am
  • Here's what I propose to do with libpq to make it more useful for real-time applications. Any comments or better ideas? The point of these changes is first to allow frontend applications to receive ...
    Tom LaneTom Lane
    Apr 17, 1998 at 5:05 pm
    May 16, 1998 at 7:09 am
  • Has anyone looked into this? I'm just getting ready to download it and play with it, see what's involved in using it. From what I can see, its essentially an optimized stdio library... URL is at: ...
    The Hermit HackerThe Hermit Hacker
    Apr 12, 1998 at 3:32 am
    Apr 22, 1998 at 2:31 pm
  • Here is a general comments on maintaining the FAQ, and pointing people to answers. First, the FAQ is a pretty weird way to give people information. It is an almost random list of questions and ...
    Bruce MomjianBruce Momjian
    Apr 19, 1998 at 2:50 am
    Apr 30, 1998 at 3:41 pm
  • Hi, This question was sent to me by a user who uses PostgreSQL 6.3.1. Is this normal? (Note that the patch for src/backend/optimizer/path/prune.c created by Vadim did not help) -- Tatsuo Ishii ...
    T-ishiiT-ishii
    Apr 10, 1998 at 2:14 am
    Apr 22, 1998 at 7:39 am
  • I am thinking about a project that may change a large number of source files. It may also take a fair amount of time, so I expect the main source tree to get changed a fair amount during my work. ...
    David GouldDavid Gould
    Apr 5, 1998 at 8:44 pm
    Apr 7, 1998 at 5:02 am
  • We have several open issues with 6.3.1, which will probably have to be addressed with a mega-patch, separate patches, or a minor release. They are: indexes not used that were used in 6.2 memory leak ...
    Bruce MomjianBruce Momjian
    Apr 2, 1998 at 2:51 am
    Apr 7, 1998 at 10:54 am
  • I am trying to use cvsup to get the latest but keep failing as follows: leslie:~$ cvsup sup.pgsql Connected to postgresql.org Updater failed: Premature EOF from server Will retry at 04:40:54 Here is ...
    David GouldDavid Gould
    Apr 29, 1998 at 5:41 am
    May 1, 1998 at 5:30 am
  • Hi, I added these lines to tcop/postgres.c just before the ReadCommand call (which is in an infinite loop). + printf("Allocount: %ld; FreeCount: %ld; Diff:%ld\n", + getPAllocCount(), + ...
    Maurice GittensMaurice Gittens
    Apr 2, 1998 at 2:42 pm
    Apr 9, 1998 at 6:34 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Jose' Soares Da SilvaJose' Soares Da Silva
    Apr 16, 1998 at 11:19 am
    Apr 30, 1998 at 1:26 pm
  • Ryan KirkpatrickRyan Kirkpatrick
    Apr 10, 1998 at 11:08 pm
    Apr 15, 1998 at 1:49 am
  • I have been doing some thought about memory allocation in postgresql so the above messages are very timely (at least to me). I would like to discuss the idea of replacing the current scheme of ...
    David GouldDavid Gould
    Apr 2, 1998 at 8:45 am
    Apr 3, 1998 at 1:04 pm
  • The postgresql-?.?.?/contrib/linux/postgres.init is meant to start your postmaster at boot time and stop it at halt/reboot. Excelent. But it is made for postgres account running tcsh. I know nothing ...
    Claudiu BalcizaClaudiu Balciza
    Apr 7, 1998 at 9:49 am
    Apr 28, 1998 at 9:25 am
  • Attached is a list of bug reports for the HAVING clause. My question is, "Do we disable the HAVING clause for 6.3.2?" The bugs are serious and cause crashes. I have looked at the issues, and the ...
    Bruce MomjianBruce Momjian
    Apr 16, 1998 at 3:55 am
    Apr 17, 1998 at 4:12 am
  • ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^ Could we use mmap (instead of shmem) with MAP_ANON flag to get more memory for shared buffer pool ? I'm using FreeBSD, man ...
    Vadim B. MikheevVadim B. Mikheev
    Apr 22, 1998 at 5:47 am
    Jun 16, 1998 at 2:39 am
  • Yes, I asked earlier why LINUX_ELF was not being defined, and no Linux user offered an answer. Solutions, folks? When our own pgaccess guy can't get libpgtcl to compile, we have a problem. Do we need ...
    Bruce MomjianBruce Momjian
    Apr 20, 1998 at 6:42 pm
    Apr 22, 1998 at 3:19 pm
  • How about removing LINUX_ELF from all Makefile.in's? Michael -- Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH meskes@topsystem.de | Europark A2, Adenauerstr. 20 meskes@debian.org | ...
    Meskes, MichaelMeskes, Michael
    Apr 21, 1998 at 12:15 pm
    Apr 21, 1998 at 4:20 pm
  • I don't remember if it has been mentioned. Anyhow, I think that it would be nice to change fsync'es into fdatasync'es (of course as an autoconf-igurable option). I don't think it's necessary to ...
    Michal MosiewiczMichal Mosiewicz
    Apr 17, 1998 at 12:24 am
    Apr 19, 1998 at 4:29 am
  • Hi... I want to add the filename (index) to the error message: FATAL 1: btree: BTP_CHAIN flag was expected (access = 0) At least then I can figure out which index to drop and rebuild, instead of ...
    The Hermit HackerThe Hermit Hacker
    Apr 10, 1998 at 8:10 pm
    Apr 11, 1998 at 11:32 pm
  • hi, All! Just installed PG 6.3.1 -- really great job, thank you guys! But this morning I decided to play a bit with aggregate functions on update and got a bit strange(for me, at least :-) result. ...
    Aleksey DashevskyAleksey Dashevsky
    Apr 10, 1998 at 10:31 am
    Apr 27, 1998 at 1:36 pm
  • Hi folks, Hope I'm not making a fool of myself by posting to a list I just joined ... but I couldn't find much about this in the list archives. I'm looking at an application that involves several ...
    Tom LaneTom Lane
    Apr 15, 1998 at 8:25 pm
    Apr 22, 1998 at 9:38 pm
  • Greetings, We are putting the finishing touches on some enhancements to the ODBC driver. One feature, in particular, uses large objects to implement OLE data types. We are rather please with the way ...
    David HartwigDavid Hartwig
    Apr 9, 1998 at 11:33 pm
    Apr 10, 1998 at 6:51 pm
  • When you run postgresql as root, the command it gives for putting in your startup script is a little weird. The main issue is that 2 &1 only works in bash, not tcsh. & works in both, so it seems ...
    Brett McCormickBrett McCormick
    Apr 30, 1998 at 3:08 am
    May 12, 1998 at 8:39 pm
  • Yes, it does. Very inconsistent! Currently, it appears that the authors don't want to change, so it is necessary to specify a postgres user-id when connecting. However there is, as you say in another ...
    Oliver ElphickOliver Elphick
    Apr 28, 1998 at 11:05 am
    Apr 29, 1998 at 1:09 pm
  • I'm still getting the following BTP_CHAIN errors on my btree index. Funny thing is that its the *same* index each time, and this is after dropping and rebulding it... ...where next to investigate? ...
    The Hermit HackerThe Hermit Hacker
    Apr 13, 1998 at 4:00 pm
    Apr 14, 1998 at 8:42 am
  • To report any other bug, fill out the form below and e-mail it to pgsql-bugs@postgresql.org. ============================================================================ POSTGRESQL BUG REPORT ...
    Jose' Soares Da SilvaJose' Soares Da Silva
    Apr 9, 1998 at 3:12 pm
    Apr 13, 1998 at 3:03 pm
  • There are two ways to address this for a fix as far as I can tell: 1) in the parser transformations (and/or in the optimizer), look for unary minus operators on constants, and convert those node ...
    Thomas G. LockhartThomas G. Lockhart
    Apr 1, 1998 at 2:45 am
    Apr 1, 1998 at 5:06 pm
  • Hi, all I have some problems with transactions and locks... I have 5 questions about it... 1. NOTICE: (transaction aborted): queries ignored until END *ABORT STATE* ...
    Jose' Soares Da SilvaJose' Soares Da Silva
    Apr 20, 1998 at 8:09 am
    Dec 7, 1999 at 9:53 am
  • I have tried almost everything I can think of, put postgres keepy dying. I am running on a FreeBSD 2.2.5 system. It was complaining about not enough shared memory. I bumped the shared mem to 16mb ...
    Michael RichardsMichael Richards
    Apr 27, 1998 at 10:31 pm
    Apr 28, 1998 at 12:18 pm
  • Moved to pgsql-hackers@postgresql.org (where the developers hang out) Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Apr 25, 1998 at 5:50 pm
    Apr 28, 1998 at 5:50 am
  • I have a bug reported on the Debian package of 6.3.2: It is, in fact, impossible to create the user www-data: template1= create user www-data; ERROR: parser: parse error at or near "-" template1= ...
    Oliver ElphickOliver Elphick
    Apr 26, 1998 at 7:03 am
    Apr 28, 1998 at 3:48 pm
  • Hello, I have posted a new version of the ODBC driver at our web site. (http://www.insightdist.com/psqlodbc). We are also now including a version number (this one is 06.30.0010). You can click on ...
    Byron NikolaidisByron Nikolaidis
    Apr 27, 1998 at 9:25 pm
    Apr 28, 1998 at 7:42 am
  • I just noticed that there is an operator '=:'. What is it used for? At the moment I have disabled ':' a_expr in the parser since it's not distinguishable from a variable. The same problem appears ...
    Michael MeskesMichael Meskes
    Apr 23, 1998 at 7:38 am
    Apr 23, 1998 at 12:54 pm
  • subscribe
    Toshiaki OkudaToshiaki Okuda
    Apr 8, 1998 at 2:59 am
    Apr 23, 1998 at 11:53 am
  • unsubscribe
    Horng Chi-YiHorng Chi-Yi
    Apr 2, 1998 at 9:46 am
    Apr 23, 1998 at 11:50 am
  • I have noticed that when float types are divided by zero in a query, the the query aborts (via elog(WARN)) with a complaint about divide by zero. Also an integer divide by zero produces a result. On ...
    David HartwigDavid Hartwig
    Apr 14, 1998 at 4:44 pm
    Apr 16, 1998 at 1:16 pm
  • golem$ cd doc golem$ make install make all make[1]: Entering directory `/opt/postgres/pgsql/doc' rm -rf ./admin unpacked/admin if test ! -d unpacked/admin ; then mkdir unpacked/admin ; fi mkdir: ...
    Thomas G. LockhartThomas G. Lockhart
    Apr 13, 1998 at 4:09 am
    Apr 13, 1998 at 2:55 pm
  • Done and committed...please check out the newest cvsup copy and let us know whether this helps... Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: ...
    The Hermit HackerThe Hermit Hacker
    Apr 8, 1998 at 2:36 am
    Apr 8, 1998 at 10:24 pm
  • Cristian GaftonCristian Gafton
    Apr 5, 1998 at 10:18 pm
    Apr 6, 1998 at 1:35 am
  • Just thought I'd try the cluster command. What am I doing wrong. ReadHat 5.0 6.3.1 rpm's [djackson@www]$ psql template1 Welcome to the POSTGRESQL interactive sql monitor: Please read the file ...
    Jackson, DeJuanJackson, DeJuan
    Apr 16, 1998 at 6:56 pm
    Jun 17, 1998 at 2:55 pm
  • For the linux, bsd, i386-solaris and univel ports, ... If I were to try to make foo$(DLSUFFIX) from bar.c and bah.c, I would think the general sequence of events would be: 1. $(CC) $(CFLAGS_SL) -o ...
    Darren KingDarren King
    Apr 23, 1998 at 9:00 pm
    Apr 24, 1998 at 11:38 am
  • I'm leaving my current job at the end of the month and will no longer be able to watch over the aix ports. Not that there aren't other very knowledgable aix people on the list, I just seem to be the ...
    Darren KingDarren King
    Apr 23, 1998 at 10:56 pm
    Apr 24, 1998 at 6:33 am
  • I have had problems with LINUX_ELF and/or PORTNAME *not* being defined and shared libraries *not* being compiled. I would like to make the following observations, based on the Makefiles generated for ...
    Kristofer A. E. PetersonKristofer A. E. Peterson
    Apr 21, 1998 at 5:09 pm
    Apr 22, 1998 at 12:27 am
  • For some reason my system isn't compiling the shared libraries anymore. I tracked this down to the symbol LINUX_ELF being undefined. However, I have no idea where this should be defined. Since I run ...
    Michael MeskesMichael Meskes
    Apr 21, 1998 at 8:46 am
    Apr 21, 1998 at 4:14 pm
  • Hi. I was wondering if you used any leak finding tools in your code? There seems to be a few mallocs that don't get freed, and a few internal buffer overruns. I don't know if it will work for you, ...
    Michael RichardsMichael Richards
    Apr 19, 1998 at 1:12 pm
    Apr 19, 1998 at 10:05 pm
  • Pedro J. LoboPedro J. Lobo
    Apr 16, 1998 at 2:59 pm
    Apr 17, 1998 at 1:25 am
  • Is this patch planned to be included in 6.3.2 release? I do not see in Apr13 snapshot.
    T-ishiiT-ishii
    Apr 16, 1998 at 4:20 am
    Apr 17, 1998 at 1:23 am
  • Oh whoa is me...is that how you spell whoa in this case? *raised eyebrow* Oh well, irrelevant...did some deeper looking inot my local problem, and it turns out I had a postgres process that was just ...
    The Hermit HackerThe Hermit Hacker
    Apr 15, 1998 at 4:08 pm
    Apr 15, 1998 at 7:30 pm
  • Has anyone else noticed that we certainly have a lot of people involved lately? I used to see about 50-75 messages a day. Now if I have not checked in 6 hours, I have that same volume in just six ...
    Bruce MomjianBruce Momjian
    Apr 12, 1998 at 1:30 am
    Apr 12, 1998 at 3:34 am
Group Navigation
period‹ prev | Apr 1998 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions166
posts701
users105
websitepostgresql.org...
irc#postgresql

105 users for April 1998

Bruce Momjian: 154 posts The Hermit Hacker: 82 posts Thomas G. Lockhart: 59 posts David Gould: 35 posts Tom Lane: 35 posts Michael Meskes: 32 posts Vadim B. Mikheev: 24 posts Jose' Soares Da Silva: 20 posts Maurice Gittens: 13 posts Brett McCormick: 11 posts Ocie: 10 posts Zeugswetter Andreas SARZ: 10 posts Byron Nikolaidis: 9 posts Oliver Elphick: 9 posts Ryan Kirkpatrick: 8 posts T-ishii: 7 posts Darren King: 7 posts Peter T Mount: 7 posts Boersenspielteam: 6 posts Cristian Gafton: 6 posts
show more
Archives