Search Discussions
-
CORBA in fifty words or less: CORBA is an architecture which specifies how to: - define the method signatures of an object type - obtain a reference to a object instance - invoke a method, with ...
Michael Robinson
Nov 13, 1998 at 5:20 pm
Nov 17, 1998 at 8:55 pm -
It seems that we have a small problem with the operators and functions in the inet and cidr types. If the value in a field is null then the backend crashes when you try to apply one of the operators ...
D'Arcy J.M. Cain
Nov 1, 1998 at 6:19 pm
Jan 7, 1999 at 12:38 pm -
23
Warning!!
Tomorrow afternoon, at ~5pm ADT, I will be tag'ng and releasing v6.4 to the world *muhahahaha* Any last minute "no, don't do it" naysayers out there? :) Marc G. Fournier Systems Administrator @ ...The Hermit Hacker
Nov 3, 1998 at 9:29 pm
Dec 12, 1998 at 8:03 pm -
RedHat 5.1 i386 with PostgreSQL v6.4 final version ./configure --with-tcl after installing libpgtcl , cannot run pgaccess because library crypt hasn't been linked into libpgtcl.so must manually add ...
Constantin Teodorescu
Nov 5, 1998 at 4:50 pm
Dec 7, 1998 at 1:57 pm -
16
Parser bug?
I think this is a bug in 6.4: bray= select rcname, rcsrc from pg_relcheck where rcrelid = '115404'::oid and rcrelid in (select min(rcrelid) from pg_relcheck group by rcname); ERROR: parser: Subselect ...Oliver Elphick
Nov 23, 1998 at 5:18 pm
Dec 5, 1998 at 10:31 pm -
hi. I hope this is not a rehash of anything; a quick look at the mailing list archives turned up similar, but not identical stories. When I use the "-z" option (dump permissions)when dumping a ...
Karl Auer
Nov 24, 1998 at 3:49 pm
Nov 25, 1998 at 2:58 am -
Hi, I have run into a problem dropping and re-creating tables with type SERIAL: CREATE TABLE t ( s SERIAL); DROP TABLE t; CREATE TABLE t ( s SERIAL); gives ERROR: t_s_seq relation already exists This ...
Jan Iven
Nov 27, 1998 at 3:21 pm
Dec 13, 1998 at 3:49 am -
It appears that when a function is called if any of the paramaters are NULL all of the parameters are NULL. try: drop function nvl(int, int); create function nvl(int, int) returns boolean as ' ...
Jackson, DeJuan
Nov 4, 1998 at 7:51 pm
Nov 11, 1998 at 3:15 pm -
With the initial positive response, I dived into the CORBA spec, the ORBit source, and the PostgreSQL source. I have good news to report. - CORBA and PostgreSQL were made for each other. The ...
Michael Robinson
Nov 13, 1998 at 5:37 am
Nov 14, 1998 at 5:38 pm -
Thus spake Jan Wieck Well, this is the first example that I have seen that wouldn't work unless a function with a null argument actually called the function but you do realize that this wouldn't work ...
D'Arcy J.M. Cain
Nov 3, 1998 at 2:06 pm
Nov 4, 1998 at 1:00 pm -
Hi, here are some details I would like to discuss before beeing too deep in the implementation that it's hard to change them later. Point 1 is an extension of the pg_database relation that is ...
Jan Wieck
Nov 27, 1998 at 9:10 pm
Dec 18, 1998 at 12:55 am -
Terry Mackintosh
Nov 15, 1998 at 6:22 pm
Dec 14, 1998 at 5:13 am -
I've never actually installed mysql, so can't really compare the two, but I've been using PostgreSQL for everything I need an RDBMS for since I first took on the project 3 years ago now (wow, time ...
The Hermit Hacker
Nov 27, 1998 at 12:55 pm
Dec 1, 1998 at 11:29 pm -
prova= select * from a; int_2| int_4| int_8 -----+----------+------------------- 32767|2147483647|9223372036620802086 32767|2147483647|9223372036620802086 (2 rows) prova= select avg(int_2), ...
José Soares
Nov 3, 1998 at 8:24 am
Dec 8, 1998 at 6:40 am -
Hi I have the following problem using PostgreSQL 6.4 on RedHat Linux 5.1 on x86 using the following table thplus= \d envelope Table = envelope ...
Hannu Krosing
Nov 18, 1998 at 7:24 pm
Nov 24, 1998 at 4:15 am -
Morning all... Well, v6.4 is branched and in a "released state"...those wanting to start moving on, go for it. Those with committer's access to the source tree, Thomas and I are working up docs for ...
The Hermit Hacker
Nov 4, 1998 at 11:50 pm
Nov 6, 1998 at 12:09 pm -
Until earlier this week, the various snapshots have been working fine on my system, NetBSD 1.3.2/i386. As of a couple of days ago the backend started to crash. I hoped this was a temporary glitch ...
Brook Milligan
Nov 1, 1998 at 4:09 pm
Nov 2, 1998 at 11:40 am -
Hi. I've been doing some more tests with the above configuration, and have noticed the following problems when running the regression tests: 1) THE REGRESSION TEST FOR FLOAT8 IS BROKEN!!! Indeed, the ...
Pedro J. Lobo
Nov 18, 1998 at 6:09 pm
Nov 24, 1998 at 3:56 pm -
I am getting signal 10/bus error on cvs checkouts. Looks like others are having the same problem. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your ...
Bruce Momjian
Nov 23, 1998 at 6:14 am
Nov 24, 1998 at 5:57 am -
I've been banging and banging my head against the specific problem of how to tightly couple the object-relational part of postgres with the object- list processing part of Python. In the midst of ...
Michael Robinson
Nov 11, 1998 at 5:33 am
Nov 12, 1998 at 5:56 pm -
Does this remove the need for vsnprintf? -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be ...
Bruce Momjian
Nov 8, 1998 at 9:44 pm
Dec 12, 1998 at 9:03 pm -
Hi all I'm working on writing a search engine, and need a branching linked list, or tree. When I did the message board there was a similar need which was over come at the application level. But I ...
Terry Mackintosh
Nov 17, 1998 at 12:39 pm
Nov 24, 1998 at 1:39 pm -
Hi all Minor detail, but when I did 'pg_dump -z -f dump.file dbname' and then went to restore it, I found that the grant statments are like: GRANT ALL on "tablename" to "tablename"; instead of GRANT ...
Terry Mackintosh
Nov 15, 1998 at 4:23 am
Nov 15, 1998 at 10:08 pm -
Do any of you sit on IRC somewhere? Sometimes I feel like the discussions would be smoother/faster with real-time... I'm on efnet all the time (as Taral, of course :) Taral
Taral
Nov 15, 1998 at 3:26 am
Nov 15, 1998 at 6:05 pm -
The attached commands crash the backend, which exits with status 11. The backend log (debug level 255) does not show anything that is meaningful to me. It shows a query, which seems to relate to the ...
Oliver Elphick
Nov 4, 1998 at 1:12 pm
Nov 4, 1998 at 10:14 pm -
I'm going to remove subj... buf_internals.h: /* * I padded this structure to a power of 2 (PADDED_SBUFDESC_SIZE) * because BufferDescriptorGetBuffer is called a billion times and it * does an C ...
Vadim Mikheev
Nov 30, 1998 at 5:07 am
Dec 2, 1998 at 1:39 am -
6
6.4.x
I apologize. pgsql-questions has disappeared? (out of the loop, I am)Integration
Nov 25, 1998 at 6:37 am
Dec 1, 1998 at 11:29 pm -
This thing would also handled by subqueries in FROM! Having support in planner/executor for queries like this: select * from A, (select c, max(d) as m from B group by c) SQ where SQ.c = A.x and SQ.m ...
Vadim Mikheev
Nov 24, 1998 at 2:08 pm
Dec 1, 1998 at 5:38 am -
I changed some minor stuff in Thomas Good's man page for ecpg and would like to see this one replace the man page for ecpg we currently have in CVS. It's attached. Or should this one go to patches ...
Michael Meskes
Nov 28, 1998 at 2:56 pm
Dec 14, 1998 at 6:50 pm -
Hi all OK, just built 6.4, a couple of things ... :) When I did make all runtest for the regression tests, I guess stderr used to be sent to /dev/null? but now it goes to the screen with *LOTS* of ...
Terry Mackintosh
Nov 8, 1998 at 1:16 am
Dec 12, 1998 at 8:57 pm -
Pardon the message, I received no responses in the other pgsql lists I posted this too. I'm using a fully updated RedHat 5.1 box flex version 2.5.4 GNU Bison version 1.25 ---------- Forwarded message ...
Dkelson-list-pgsql-hackers
Nov 17, 1998 at 1:43 am
Nov 17, 1998 at 6:41 pm -
Hello! A background postgres porocess gets larger with Abort Transactions. Memory seems to leak. This occurs also on 6.3.2. You can see it with user aborts: ...
SHIOZAKI Takehiko
Nov 13, 1998 at 1:39 am
Dec 13, 1998 at 3:45 am -
Hi, I'm currently hacking around on a solution for logging all database operations at query level that can recover a crashed database from the last successful backup by redoing all the commands. ...
Jan Wieck
Nov 13, 1998 at 6:21 pm
Dec 12, 1998 at 10:40 pm -
Dear all, I have some difficult time in using postgresql 6.4 with chinese BIG5 characters. I am just looking for storing BIG characters in a text field and retrieve correctly. I have --enable-mb when ...
Hui Chun Kit, Jacky
Nov 21, 1998 at 6:35 pm
Dec 3, 1998 at 1:35 am -
Hi all CREATE RULE "_RETmessages" AS ON SELECT TO "messages" DO INSTEAD SELECT "title", "mess", "iurl", "lurl", "posted", "fname", "lname", "email", "uid", "ppid", "pid", "bid" FROM "post", "users" ...
Terry Mackintosh
Nov 25, 1998 at 5:11 pm
Nov 25, 1998 at 5:59 pm -
Still trying to fix the bug with inherited check constraints... I have tried to create a min(oid) aggregate, but when I use it, I get the message `ERROR: fmgr_info: function 108994: cache lookup ...
Oliver Elphick
Nov 20, 1998 at 11:30 pm
Nov 25, 1998 at 12:18 pm -
Just noticed that doc/FAQ_Linux and doc/FAQ_Irix have been zero-length files in the CVS repository since the end of August. They're also that way in the 6.4 distribution tarball. There are still ...
Tom Lane
Nov 22, 1998 at 9:51 pm
Nov 24, 1998 at 3:50 am -
hi! I just checked postgres 6.4 and I have to tell you it was a great work!!! it's 3-4 times faster than 6.3.2 was. more stable. I have a little question: the TEXT fieldtype how many data can store? ...
Zsolt Varga
Nov 13, 1998 at 8:30 am
Nov 21, 1998 at 11:15 am -
Since we're supposedly an "object relational database", is there any chance we might be able to move towards supporting OQL93? Taral
Taral
Nov 16, 1998 at 3:02 am
Nov 17, 1998 at 6:13 pm -
I've gotten part-way toward implementing a CASE construct in Postgres: select case when i = 1 then 10 when i = 2 then 20 end from t; (the other parts of the case clause are supported also). But I'm ...
Thomas G. Lockhart
Nov 12, 1998 at 5:49 am
Nov 13, 1998 at 10:56 am -
6.4 allows to use ORDER BY with a column that does not appear in a target list. This is great. However, following result seems strange to me. Sometimes DISTINCT does not remove duplication. Is this ...
Tatsuo Ishii
Nov 7, 1998 at 11:53 pm
Dec 12, 1998 at 8:35 pm -
Hi all I started with the contrib/spi/*.c stuff and am working toward a function to be used by a trigger to update a datetime field upon doing an UPDATE to a record. It is about ready to test, except ...
Terry Mackintosh
Nov 6, 1998 at 7:25 pm
Dec 12, 1998 at 8:21 pm -
Hi, The subject says all. Regards, Ole Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, ...
Oleg Bartunov
Nov 29, 1998 at 8:36 pm
Nov 30, 1998 at 4:09 am -
3
copy
Hi all, I have a strange behavior while copying from a text file, I don't know if this will be considered a bug or a feature. I have this text file: ------------------------ XXX|QWERTYUIOPASDFGHJKLA ...Sferacarta Software
Nov 27, 1998 at 2:32 pm
Nov 27, 1998 at 7:17 pm -
I noticed that when installing postgres the following directory is formed: ~pgsql/include/port/bsd (presumably the bsd changes with the port upon which it's compiled). This is created as part of the ...
Brook Milligan
Nov 10, 1998 at 3:34 pm
Nov 10, 1998 at 9:14 pm -
I brought my snapshot up-to-date this morning, recompiled everything and tried to connect to my test database that is about a month old. I can ´select * from pg_attribute´ without a problem. But ...
Michael Meskes
Nov 4, 1998 at 11:08 am
Nov 5, 1998 at 6:55 pm -
I'm currently experimenting with the Debian packaging of 6.4. The question arises of how to handle the change in library versions from 1.0 to 2.0. It has been suggested that I should keep libpq.so.1 ...
Oliver Elphick
Nov 4, 1998 at 12:10 am
Nov 4, 1998 at 3:01 pm -
This was reported as a bug with the Debian package of 6.3.2; the same behaviour is still present in 6.4. bray= create table foo ( t text[]); CREATE bray= insert into foo values ( '{"a"}'); INSERT ...
Oliver Elphick
Nov 25, 1998 at 11:48 pm
May 31, 2000 at 9:19 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 156 |
posts | 600 |
users | 98 |
website | postgresql.org... |
irc | #postgresql |
98 users for November 1998
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)