FAQ

Search Discussions

183 discussions - 1,302 posts

  • We have less than two weeks to feature freeze. Win32 is still in an uncompleted state, and I haven't been able to return to it recently. Jan is working on getting exec() working, and hopefully ...
    Bruce MomjianBruce Momjian
    Jun 18, 2003 at 8:15 pm
    Jun 28, 2003 at 4:01 pm
  • There is a problem which occurs from time to time and which is a bit nasty in business environments. When the shared memory is eaten up by some application such as Apache PostgreSQL will refuse to do ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Jun 11, 2003 at 3:35 pm
    Jun 16, 2003 at 4:21 pm
  • Well, correct solution is to implement tablespaces on which objects like databases, tables and indexes can be put. There was a long discussion on this and there was a tablespaces patch. It was agreed ...
    Shridhar DaithankarShridhar Daithankar
    Jun 25, 2003 at 6:37 am
    Jul 19, 2003 at 3:21 am
  • I noticed this in the FreeBSD 5.1 release notes: "A new DIRECTIO kernel option enables support for read operations that bypass the buffer cache and put data directly into a userland buffer. This ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 17, 2003 at 6:21 am
    Jun 29, 2003 at 11:12 pm
  • Is there any point using pg_get_triggerdef in pg_dump to generate trigger definitions? We'd still have to keep the old code so that we can dump pre 7.4, but it might mean we don't have to touch that ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 17, 2003 at 2:01 am
    Jun 29, 2003 at 12:13 am
  • Folks, Last we talked (before the mail server went down) Tom had agreed in principle to a re-ordering of postgresql.conf.sample and the "Run-Time Configuration" docs page based on the attached ...
    Josh BerkusJosh Berkus
    Jun 5, 2003 at 3:25 pm
    Jun 10, 2003 at 9:40 pm
  • Hi there ... I have spent some time working on an Oracle version of dblink. It works quite nicely for me and I hope it does for others. It already supports some basic features such as persistent ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Jun 13, 2003 at 7:51 pm
    Jul 25, 2003 at 8:36 am
  • Some nice advances to SQL standard array support were made, but there are a few things that don't work yet in the sense of feature S091 "Basic array support". Joe, do you want to take on some of ...
    Peter EisentrautPeter Eisentraut
    Jun 27, 2003 at 7:47 pm
    Jul 20, 2003 at 3:12 am
  • I am inclined to rename plpython to plpythonu, by analogy to pltclu. The advantage of doing so is that (a) the name change makes it somewhat more obvious that there's a fundamental behavioral change, ...
    Tom LaneTom Lane
    Jun 22, 2003 at 10:29 pm
    Jun 30, 2003 at 8:54 pm
  • There are a number of things that need to be done in psql before feature freeze. Any comments on the following points? * We need a client-side autocommit-off implementation to substitute for the one ...
    Tom LaneTom Lane
    Jun 25, 2003 at 5:49 pm
    Jul 20, 2003 at 12:31 am
  • I was looking at this some more and now think there is something wrong with the references to ss_family rather than a missing inlcude file. Perhaps those were supposed to be references to sa_family ...
    Bruno Wolff IIIBruno Wolff III
    Jun 17, 2003 at 8:29 pm
    Jun 25, 2003 at 4:06 pm
  • I took a quick glance at this. It boils down to essentially an: 1) ALTER TABLE .. ADD COLUMN <column DEFAULT <default <constraints 2) UPDATE .. SET <column = <default IF <default IS NOT NULL; 3) Add ...
    Rod TaylorRod Taylor
    Jun 19, 2003 at 2:09 am
    Jun 21, 2003 at 5:03 am
  • Hi all, I am currently implementing an experimental middleware based replicator for a set of fully replicated databases. Do be able to handle all sorts of failures I needed two functions: - A ...
    Christian PlattnerChristian Plattner
    Jun 19, 2003 at 3:10 pm
    Jun 20, 2003 at 2:04 pm
  • I'm looking at representing privileges granted to groups in the information schema. For that purpose I would like to use the views that the standard defines for "roles". Therefore I ask whether ...
    Peter EisentrautPeter Eisentraut
    Jun 6, 2003 at 7:17 pm
    Jun 18, 2003 at 9:06 pm
  • Attached is a patch that provides *VERY* limited support for multiple slave servers. I haven't tested it very well, so use at your own risk (and I recommend against using it in production). ...
    Michael A NachbaurMichael A Nachbaur
    Jun 20, 2003 at 2:36 am
    Jun 26, 2003 at 1:46 am
  • gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -Wall -Wmissing-prototypes -Wmissin g-declarations -I../../../../src/include -c -o printtup.o printtup.c -MMD In file included from ...
    Rod TaylorRod Taylor
    Jun 12, 2003 at 1:30 pm
    Jun 13, 2003 at 2:22 am
  • On cygwin sa_family_t was undeclared, adding the following line: typedef unsigned short sa_family_t; to both: src/port/getaddrinfo.c src/include/libpq/pqcomm.h seemed to compile ok but with make ...
    DeststarDeststar
    Jun 15, 2003 at 3:53 pm
    Jun 24, 2003 at 12:10 pm
  • I realise large objects are liked anymore and that the wire protocol is changing in 7.4 but I've just posted this message into the PHP documentation: -- begin Using php 4.3.0 and PostgreSQL 7.3.1 I ...
    Nigel J. AndrewsNigel J. Andrews
    Jun 5, 2003 at 1:38 pm
    Jun 23, 2003 at 4:00 am
  • I have searched the lists archives for the words "commit", "autocommit" and "transaction" but couldn't find any discussion on wheter to give a database administrator the option to turn automatic ...
    Rasmus Resen AmossenRasmus Resen Amossen
    Jun 1, 2003 at 3:50 pm
    Jun 6, 2003 at 2:52 pm
  • Hi every one, Is it normal that mirro site now all redirect to www.postgresql.org? It also seem that rsync is doing nothing when updating www... Regards -- Olivier PRENANT Tel: +33-5-61-50-97-00 ...
    OhpOhp
    Jun 13, 2003 at 2:19 pm
    Jul 4, 2003 at 10:32 am
  • I wonder if there's a way to read all allowed user/database variables that can be set/reset. I'd like to have this self-configured in pgAdmin3 instead of hard-coded. Can you give a hint? Regards, ...
    Andreas PflugAndreas Pflug
    Jun 18, 2003 at 9:29 pm
    Jun 25, 2003 at 1:53 pm
  • I have started playing with the pre7.4 code to see if I can compile a win32 version with PostGIS support. So far, finding it a little hard. Is there a wee guide to compiling 7.4 native win32 around? ...
    Paul RamseyPaul Ramsey
    Jun 13, 2003 at 10:18 pm
    Jun 14, 2003 at 4:29 pm
  • Hi, I noticed the patch: http://archives.postgresql.org/pgsql-patches/2003-06/msg00366.php isn't in the patch queue. Is the patch OK? If not please say what is wrong with it. Thank you, - Stuart
    DeststarDeststar
    Jun 30, 2003 at 12:15 pm
    Jul 31, 2003 at 12:38 am
  • I had originally planned to spend the next week editing all the elog() calls in the backend to convert them to ereport() format where helpful, add SQLSTATE values, and update wording to match the ...
    Tom LaneTom Lane
    Jun 25, 2003 at 6:50 pm
    Jun 25, 2003 at 11:35 pm
  • Why does the interval type not print seconds when they are zero? This leads to inconsistent reading of the information. 7.3.3: ler=# select '13 minutes'::interval; interval ---------- 00:13 (1 row) ...
    Larry RosenmanLarry Rosenman
    Jun 21, 2003 at 9:07 pm
    Jun 24, 2003 at 9:12 pm
  • We are 5 days away from the feature freeze date, but with the almost week of downtime we have had, I don't think we can stick to that date. Do we choose July 1 as feature freeze and July 15 as beta, ...
    Bruce MomjianBruce Momjian
    Jun 10, 2003 at 7:25 pm
    Jun 11, 2003 at 3:58 am
  • I was researching on cache replacement strategy as well. 2Q has one disadvantage see this exellent paper: http://www.almaden.ibm.com/cs/people/dmodha/#ARC see the paper "ARC: A Self-Tuning, Low ...
    XororXoror
    Jun 24, 2003 at 10:21 am
    Jun 29, 2003 at 3:37 am
  • I created a domain with text as the data_type. When I get the row description message from the backend for a column using this domain, the type OID provided is for text (25) rather than the OID of ...
    John DeSoiJohn DeSoi
    Jun 26, 2003 at 1:13 am
    Jun 27, 2003 at 12:52 pm
  • With Peter's latest commit, there aren't any actual scripts left in src/bin/scripts; only C programs. Does that bother anyone? I was wondering about renaming to something like src/bin/misc. (Not that ...
    Tom LaneTom Lane
    Jun 18, 2003 at 5:02 pm
    Jun 24, 2003 at 2:54 am
  • Tom, AFAIK, MS SQL Server's two-phase commit works like this ... if both servers prepare, and one crashes, the transaction is screwed up. Somewhat unreliable considering the frequence with which ...
    Josh BerkusJosh Berkus
    Jun 23, 2003 at 4:01 pm
    Jun 24, 2003 at 2:02 am
  • Lee, I have a question about this code: char *pqStrerror(int errnum, char *strerrbuf, size_t buflen) { #if defined HAVE_STRERROR_R /* reentrant strerror_r is available */ strerror_r(errnum, ...
    Bruce MomjianBruce Momjian
    Jun 13, 2003 at 3:54 pm
    Jun 14, 2003 at 7:19 pm
  • When we considered outervar1 as a constant, we could do the aggregate in the subquery using computations, but when SUM(outervar1) is computed in an above query, combining that with anything that is ...
    Bruce MomjianBruce Momjian
    Jun 5, 2003 at 3:13 pm
    Jun 10, 2003 at 5:25 am
  • Hi Peter, We have a server side GUI utility that among other things let us configure GUC variables. We badly need to know what variables exist in the specific backend version, which are the min and ...
    Fernando NasserFernando Nasser
    Jun 26, 2003 at 5:28 pm
    Jun 27, 2003 at 6:21 pm
  • Hi all: I write a use define type (UUID) typedef struct uuid { uint32 time_low; uint16 time_mid; uint16 time_hi_and_version; uint8 clock_seq_hi_and_reserved; uint8 clock_seq_low; uint8 node[6]; } ...
    Wang MikeWang Mike
    Jun 22, 2003 at 1:46 am
    Jun 27, 2003 at 3:10 am
  • I get the errors below when compiling on a RH 6.1 system. I used the following config paramters: ./configure --prefix=/usr/local/pgsql --enable-integer-datetimes --with-pgport=5433 hba.c: In function ...
    Bruno Wolff IIIBruno Wolff III
    Jun 16, 2003 at 4:45 pm
    Jun 17, 2003 at 4:32 pm
  • modifying pg_config.h to NOT define GETOPT_LONG fixes it. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX ...
    Larry RosenmanLarry Rosenman
    Jun 7, 2003 at 7:42 pm
    Jun 16, 2003 at 7:07 pm
  • Hi there, I've managed to get postgresql working with UTF8 and KOI8. Here is some mini-howto: http://www.sai.msu.su/~megera/postgres/utf8.html Regards, Oleg Oleg Bartunov, sci.researcher, hostmaster ...
    Oleg BartunovOleg Bartunov
    Jun 13, 2003 at 6:02 pm
    Jun 16, 2003 at 5:58 am
  • Just a side bar to the whole thread about PHP/MySQL ... I realize that libpq is intwined with the backend right now, but if anyone could think of a way of at least adding a make target that would ...
    The Hermit HackerThe Hermit Hacker
    Jun 25, 2003 at 2:30 am
    Jul 2, 2003 at 7:37 am
  • Greets, Just a thought for a psql enhancement, afiak, it is not easily possible for persistent connections to a database in a shell script.. The ability for psql to remain in the background reading ...
    James PyeJames Pye
    Jun 27, 2003 at 7:21 am
    Jun 30, 2003 at 1:39 am
  • (cross-posting to HACKERS) Reuven M. Lerner wrote: ^^^^^^^^ [...snip...] ^^^^^^^^^^^^^^^^^^^^ more importantly, you call the function (below) with a varchar here, not integer You found a real bug, I ...
    Joe ConwayJoe Conway
    Jun 24, 2003 at 6:45 am
    Jun 25, 2003 at 9:14 pm
  • Hi! For some reason I wish to write C-function for SQL which returns set of composite type, but this type is defined function itself and composite type can be changed from call to call. So I can't ...
    Teodor SigaevTeodor Sigaev
    Jun 10, 2003 at 12:45 pm
    Jun 11, 2003 at 4:38 pm
  • As you can see below, after a rename the check constraint still refers to 'col' and not 'newname' as pg_constraint.consrc is not updated. Of course, this functions fine (conbin is still valid) but ...
    Rod TaylorRod Taylor
    Jun 2, 2003 at 5:00 pm
    Jun 6, 2003 at 3:55 pm
  • (moving to HACKERS) Mike Mascari wrote: I was thinking something similar. This exact question has come up at least three times in the last three months. I doubt we'd want a special keyword like ...
    Joe ConwayJoe Conway
    Jun 24, 2003 at 9:11 pm
    Jun 27, 2003 at 3:05 pm
  • This change (I'm sure this will wrap poorly -- sorry): http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/libpq/pqcomm.h.diff?r1=1.85&r2=1.86 modified SockAddr, but no corresponding ...
    Joe ConwayJoe Conway
    Jun 21, 2003 at 2:51 am
    Jun 25, 2003 at 1:22 am
  • Hello, I reported bug #943 (I found in 7.3.2) and you checked in some change against integer overflow. Now I upgraded to 7.3.3 and I'm not happy with this. The exact error as I described is fixed, ...
    Enke, MichaelEnke, Michael
    Jun 19, 2003 at 1:39 pm
    Jun 24, 2003 at 6:32 pm
  • Hi, I would like to participate to PostgreSQL under Windows platform. What can i do to help ? x04001
    P.MP.M
    Jun 17, 2003 at 7:52 am
    Jun 18, 2003 at 6:51 pm
  • Fernando Nasser of Red Hat pointed out to me that we are not quite spec-compliant on the FLOAT(p) datatype notation. We interpret P as the number of decimal digits of precision, and hence translate P ...
    Tom LaneTom Lane
    Jun 16, 2003 at 10:15 pm
    Jun 17, 2003 at 6:43 pm
  • Tatsuo, recently I tried to understand why I can't get sorting works properly with cyrillic characters in UTF8 datbase. I figure out the reason of my confusion - I thought I could specify different ...
    Oleg BartunovOleg Bartunov
    Jun 16, 2003 at 6:15 pm
    Jun 17, 2003 at 12:31 pm
  • Is it really necessary to block reads on a table that is affected by adding a foreign key constraint? I can see why you wouldn't want UPDATES or INSERTS on the child table or DELETEs on the parent, ...
    Jim C. NasbyJim C. Nasby
    Jun 11, 2003 at 6:39 pm
    Jun 16, 2003 at 2:08 pm
  • Does Postgres garantee repeatable-read (RR) during transactions? And does it implement ARIES/KVL? If so, why is the following possible? T1: begin; T1: select * from table; (notice the row with id = ...
    Rasmus Resen AmossenRasmus Resen Amossen
    Jun 5, 2003 at 12:48 am
    Jun 5, 2003 at 4:19 pm
Group Navigation
period‹ prev | Jun 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions183
posts1,302
users153
websitepostgresql.org...
irc#postgresql

153 users for June 2003

Tom Lane: 220 posts Bruce Momjian: 188 posts Peter Eisentraut: 58 posts The Hermit Hacker: 56 posts Christopher Kings-Lynne: 50 posts Rod Taylor: 48 posts Josh Berkus: 31 posts Joe Conway: 29 posts Jan Wieck: 24 posts Andreas Pflug: 22 posts Dann Corbit: 20 posts Alvaro Herrera Munoz: 19 posts Andrew Dunstan: 19 posts Robert Treat: 19 posts Sean Chittenden: 19 posts Bruno Wolff III: 17 posts Kurt Roeckx: 16 posts Scott.marlowe: 16 posts Larry Rosenman: 14 posts Shridhar Daithankar: 14 posts
show more
Archives