Search Discussions
-
61
cidr
i didn't realize that anybody else was working on an IP address data type or i'd've posted this six months ago when i first wrote it. it lacks only the stuff needed to make it usable as a UNIQUE KEY. ...Paul A Vixie
Jul 19, 1998 at 7:27 pm
Aug 11, 1998 at 8:59 pm -
I said the days would be fewer, not gone. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ ...
Bruce Momjian
Jul 15, 1998 at 2:44 pm
Sep 19, 1999 at 2:57 pm -
(I'm back on-line, I think...) I committed several changes to the development source tree this morning (~15 hours ago). The changes affect the following areas: 1) There is an 8-byte integer data ...
Thomas G. Lockhart
Jul 9, 1998 at 5:38 am
Jul 15, 1998 at 5:04 pm -
I have succeeded in making OR clauses use indexes. I have not dealt with some of the more complex issues like x=3 or y=5 as Vadim mentioned, but at least it works. test= select * from test where ...
Bruce Momjian
Jul 31, 1998 at 5:32 am
Aug 1, 1998 at 1:21 am -
Hi, compilation of the current snapshot 4137013 Jul 25 07:02 postgresql.snapshot.tar.gz dies on linux with the following error: make[2]: Entering directory ...
Edmund Mergl
Jul 25, 1998 at 7:21 pm
Jul 28, 1998 at 10:07 am -
Dear PostgreSQL gurus, first of all, many thanks to everyone involved in writing and enhancing PostgreSQL! It has grown enourmously during the last months and is a most impressive system. Sorry if ...
Ernst Molitor
Jul 29, 1998 at 3:04 pm
Aug 2, 1998 at 9:56 am -
Ok, I'm not sure that LLL will appear in 6.4 but it's good time to discuss about it. First, PostgreSQL is multi-version system due to its non-overwriting storage manager. And so, first proposal is ...
Vadim Mikheev
Jul 15, 1998 at 11:47 pm
Jul 27, 1998 at 6:16 pm -
Hello Sorry for asking the hackers directly, but I think my question will be very implementation specific so I think only one of yor can give me the answer or thow me out the door. First some ...
Dr. Armin Schloesser
Jul 8, 1998 at 7:37 am
Jul 10, 1998 at 8:15 am -
Things I'd like to see get in there before 6.4: 1. On HPUX, the new no-exec method of starting the backend means that all the backends claim to be "postmaster"; there's no way to tell 'em apart via ...
Tom Lane
Jul 8, 1998 at 11:26 pm
Aug 22, 1998 at 3:31 am -
This is said in Oracle7 Server Concepts Manual, Data Concurrency, Additional Considerations for Serializable Isolation: --- Both read committed and serializable transactions use row-level locking, ...
Vadim Mikheev
Jul 14, 1998 at 11:05 am
Jul 30, 1998 at 7:41 pm -
With fairly current sources (last cvs update on 7/20), I am seeing occasional occurrences of NOTICE: Non-functional update, only first update is performed I think this is a bug. The update commands ...
Tom Lane
Jul 25, 1998 at 11:38 pm
Jul 30, 1998 at 1:17 am -
Is there an HPUX port of Postgres SQL ? Hi, David
Davide Libenzi
Jul 13, 1998 at 2:14 pm
Jul 14, 1998 at 2:11 pm -
Hi, I was having trouble with user authentication, so I submerged myself in the source (UTSL ie. Use The Source luke ;) to see if I could figure out what I was doing wrong: While using passwords ...
Maarten Boekhold
Jul 31, 1998 at 7:23 pm
Aug 2, 1998 at 7:55 pm -
DROP INDEX fails on overlength table names: tgl= CREATE UNIQUE INDEX MarketOrderHistory_sequenceNo_Index tgl- ON MarketOrderHistory USING btree (sequenceNo); CREATE tgl= DROP INDEX ...
Tom Lane
Jul 26, 1998 at 3:10 pm
Aug 29, 1998 at 2:57 am -
We should develop (or at least prominently promote _and_ document) some kind of file/package format or tool (maybe like illustra datablades), that would standardize the layout of contrib types. Also, ...
Hannu Krosing
Jul 21, 1998 at 3:08 pm
Jul 21, 1998 at 4:36 pm -
I am trying to finish off my Python interface with some extra helper functions and I need to find the primary key in a table if it exists. I have two questions. Although I can't imagine doing so, ...
D'Arcy J.M. Cain
Jul 20, 1998 at 1:22 pm
Jul 21, 1998 at 1:33 pm -
I want to remove the recipe, tioga, and Tee node code from the system. They are all interdependant. I don't believe any of the code is useful. It was designed for a special tioga application that ...
Bruce Momjian
Jul 19, 1998 at 10:30 am
Jul 19, 1998 at 7:00 pm -
I still cannot get postgres 6.3.2 libpq to build under Solaris 2.6 ... this means I can't test any of my apps using postgres on my deployment platform. can anyone help? gcc version 2.7.2.3 looks like ...
De Clarke
Jul 2, 1998 at 9:45 pm
Jul 3, 1998 at 7:49 am -
Hi, Below is an example of my query, which returns no plan and produces FATAL 1: palloc failure: memory exhausted while postgres 'eats' almost 113 Mb of RAM. This happens with pgsql 6.3.2+patches ...
Oleg Bartunov
Jul 30, 1998 at 11:52 pm
Jul 31, 1998 at 2:27 am -
I tried the following to find out whether a table has any records with field1 < X (for a constant X): tgl= SELECT EXISTS(SELECT * FROM table WHERE field1 < X); ERROR: internal error: do not know how ...
Tom Lane
Jul 14, 1998 at 10:33 pm
Jul 15, 1998 at 4:02 am -
Jan, I remember you steering away from rewrite cleanups because we were so close to 6.3. Any chance you can make those changes for 6.4, or are you already working on them? We really need cleanup in ...
Bruce Momjian
Jul 5, 1998 at 12:01 am
Aug 12, 1998 at 8:51 am -
Do you mean using two indices in one access plan, or the decision which index to use ? I think the case Bruce has fixed was the most important for those "alien MS Access users" among us. Thanks Bruce ...
Andreas Zeugswetter
Jul 31, 1998 at 8:53 am
Aug 1, 1998 at 5:14 am -
I've just noticed that libpq doesn't cope very gracefully if the backend exits when not in the middle of a query (ie, because the postmaster told it to quit after some other BE crashed). The behavior ...
Tom Lane
Jul 28, 1998 at 5:23 pm
Jul 29, 1998 at 3:02 pm -
After a lot of changes I've compiled,linked and tested (regression) my PostgreSQL installation no HPUX 9.*. I've also built and installed the ODBC driver and I get Ms Access error which the ...
Davide Libenzi
Jul 23, 1998 at 5:02 pm
Jul 23, 1998 at 8:14 pm -
Hi David. Do you have access to the latest cvs development tree for Postgres? I'm seeing backend crashes from the "junkfilter" regression test, and have been for some time. I (just this morning) ...
Thomas G. Lockhart
Jul 9, 1998 at 4:42 am
Jul 19, 1998 at 4:30 am -
... because the conditional structure assumes that pgsql will only be built with non-gcc compilers on HPUX. This is an entirely bogus assumption not only for HPUX, but for any other architecture that ...
Tom Lane
Jul 6, 1998 at 8:03 pm
Jul 18, 1998 at 3:00 pm -
Hmm. I find that SIGUSR1 and SIGUSR2 are both already in use for communication between backends. We can't really commandeer SIGURG, either, because it's apparently the same as SIGUSR1 on SCO (see ...
Tom Lane
Jul 6, 1998 at 10:18 pm
Jul 9, 1998 at 9:20 pm -
Yes, master would be a better name than template1. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) ...
Bruce Momjian
Jul 24, 1998 at 4:32 pm
Jul 24, 1998 at 8:20 pm -
Backends fetch 1024 XIDs now and place them in shmem. There is space in VariableCache struct for OIDs as well but I didn't change GetNewObjectId() due to the CheckMaxObjectId() stuff... Bruce ? All ...
Vadim Mikheev
Jul 21, 1998 at 6:31 am
Jul 21, 1998 at 5:46 pm -
Enybody knows as to receive the information about the users transmitting inquiries as: - username, - string of sql-request, transmitted by him. Thank you for your answer.
Alexzander Blashko
Jul 6, 1998 at 9:29 am
Jul 21, 1998 at 4:17 am -
The weekend's hacking on s_lock.h broke it for all platforms that need non-default definitions of S_UNLOCK or S_INIT_LOCK (hpux, alpha, a couple others). Someone put unconditional definitions of ...
Tom Lane
Jul 20, 1998 at 5:12 pm
Jul 20, 1998 at 7:43 pm -
It looks to me like pgsql-announce has found its way onto the spammers' target lists. Since the announce list was switched to unmoderated status at the beginning of May, my mail logs show its traffic ...
Tom Lane
Jul 16, 1998 at 3:54 pm
Jul 17, 1998 at 2:38 pm -
I'm almost back on-line (I hope) after massive hacker activity took out the alumni pop server at Caltech. From looking through the hackers mhonarc archive (hmm, don't much like that name "hackers" ...
Thomas G. Lockhart
Jul 7, 1998 at 3:09 pm
Jul 7, 1998 at 11:04 pm -
I have applied this fine patch to allow WIN32 compiles of libpq. Nice job, and a good feature for us. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 ...
Bruce Momjian
Jul 3, 1998 at 4:30 am
Jul 3, 1998 at 4:22 pm -
Can an SQL database (PostgreSQL) be connected to shell in a way that if a directory is changed on shell it will update the database with the changes? If so how? A prompt reply would be appreciated. ...
Gregory Holston
Jul 1, 1998 at 2:13 pm
Jul 1, 1998 at 4:40 pm -
New 6.4 psql help will show: test= \h select Command: select Description: retrieve tuples Syntax: SELECT [DISTINCT [ON attrN]] expr1 [AS attr1], ...exprN [INTO [TABLE] class_name] [FROM from_list] ...
Bruce Momjian
Jul 25, 1998 at 12:18 am
Jul 25, 1998 at 4:04 am -
I've successfully ported PostgreSQL to HPUX 9.0.* but there is a strange behaviour with the datetime data type. If do do this sequence : $ createdb mydb [OK] $ psqk mydb mydb== create table foo (ffoo ...
Davide Libenzi
Jul 23, 1998 at 12:45 pm
Jul 23, 1998 at 4:56 pm -
I need in help: let's say you have serialized transaction in one session... Now, some other user drops a table that was in data base when serialized transaction began but does it before this ...
Vadim Mikheev
Jul 23, 1998 at 3:50 am
Jul 23, 1998 at 6:59 am -
I have found cvs creating many directories that I know were removed from the source tree. I now use the -P option to cvs update/checkout to prevent this from happening. -P Prune (remove) directories ...
Bruce Momjian
Jul 20, 1998 at 8:45 pm
Jul 21, 1998 at 3:14 pm -
After shying away from the Linux platform for several months, Informix Corp. will do an about face at its international users conference in Seattle this week. Archrival Oracle Corp. is expected to ...
Thomas G. Lockhart
Jul 21, 1998 at 5:15 am
Jul 21, 1998 at 12:06 pm -
Hello, Sorry to disturb the hacker list for a question that seems not so hard. But I got no answers elsewhere... Is is definitively impossible to use C++ to define new SQL functions or operators in ...
David Gross
Jul 17, 1998 at 8:59 am
Jul 20, 1998 at 2:48 pm -
I have applied this fine patch from Stephan. It fixes many problems with Having, and some other problems that exist. Vadim, can you check on the psort_end() issue, and see where that should go. I am ...
Bruce Momjian
Jul 19, 1998 at 5:49 am
Jul 19, 1998 at 10:06 am -
Hi all, I got strange result with PQgetisnull, say for empty table(I think that it's empty so null) I guess that after fetch some selection PQgetisnull(result, 0, 0) should give me "1 or true" But it ...
Park, Chul-Su
Jul 16, 1998 at 8:06 am
Jul 16, 1998 at 3:51 pm -
I'm planning to use a "sequence" object to allow multiple clients of a shared database to label table records with guaranteed-increasing serial numbers. (The underlying problem is to let all the ...
Tom Lane
Jul 13, 1998 at 8:30 pm
Jul 13, 1998 at 10:02 pm -
Well, I've got this new code running, and it works. Sort of. The postmaster and backend seem to be fine ... but psql has a tendency to coredump right after sending a cancel request. After digging ...
Tom Lane
Jul 7, 1998 at 10:56 pm
Jul 8, 1998 at 1:56 pm -
does anyone have any idea how difficult it would be to implement, and perhaps point me in the right direction?
Brett McCormick
Jul 3, 1998 at 2:33 am
Jul 3, 1998 at 4:08 am -
select max(ccorderseq) from ccorder; max --- 603 (1 row) icv= select * From the_view where ccorderseq = 603; [ I get the row back ] select * From the_view where ccorderseq = (select max(ccorderseq) ...
Brett McCormick
Jul 23, 1998 at 2:03 am
Aug 22, 1998 at 4:24 am -
I. First, we need not in long-term page/row locking unlike systems using locks for concurrency/consistency control. All what we need we already have: xmax. When UPDATE/DELETE will like to change row ...
Vadim Mikheev
Jul 30, 1998 at 6:28 pm
Jul 31, 1998 at 2:46 am -
Hi David. I see that Informix now has a no-cost developers version of a database available for Linux (Informix-SE; sounds sort of light-weight). I am planning on installing it to see what it can do ...
Thomas G. Lockhart
Jul 29, 1998 at 2:51 pm
Jul 29, 1998 at 4:33 pm -
I have posted to the general news group but need a more definitive response. I am running Postgresql 6.1 on SunOS 5.5.1. We are presently looking into upgrading to Postgresql 6.3.2, but are having a ...
J Christopher Bower
Jul 27, 1998 at 3:32 pm
Jul 28, 1998 at 2:42 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 121 |
posts | 482 |
users | 75 |
website | postgresql.org... |
irc | #postgresql |
75 users for July 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)