Search Discussions
-
Oh? Aren't the CVS versions considered the master copies? If not, where *are* the master copies? regards, tom lane
Tom Lane
Jan 17, 1999 at 8:01 pm
Jul 7, 1999 at 1:30 pm -
Hi all In looking for how to do table constraints psql help says: software= \h create table Command: create table Description: create a new table Syntax: CREATE TABLE class_name (attr1 type1 [DEFAULT ...
Terry Mackintosh
Jan 26, 1999 at 12:38 am
Jul 7, 1999 at 1:50 am -
Hi, I sent the following message to the pgsql-general list on the 24th but haven't received any answers from PostgreSQL developers, only from other people who are experiencing the same problems. I ...
Patrick Verdon
Jan 28, 1999 at 11:40 pm
Feb 1, 1999 at 12:46 pm -
Hi, it seems that the year handling in pgsql dates is not very consistent: dz= create table a (n int, x date); CREATE dz= insert into a values (1,'02-02-0'); INSERT 259246 1 dz= insert into a values ...
Massimo Dal Zotto
Jan 8, 1999 at 4:09 pm
Jan 14, 1999 at 6:59 am -
Ok, in multi-version systems readers never lock selected rows and so never block writers. Nice but cause problems in some cases: if you want to implement referential integrity at the application ...
Vadim Mikheev
Jan 5, 1999 at 1:38 pm
Jan 6, 1999 at 8:01 am -
Hi, insert a few row in a table ( 50000) and do delete from mytable; vacuum verbose analyze; Why is this that slow? [I am not on hackers@postgreSQL.org] --- _ _(_)(_)_ David Wetzel, Turbocat's ...
David Wetzel
Jan 6, 1999 at 8:06 pm
Jul 7, 1999 at 12:33 am -
and this is now the DEFAULT isolevel. I run some tests to ensure how it works, but not so much. Unfortunately, currently it's not possible to add such tests to regression suit because of they require ...
Vadim Mikheev
Jan 29, 1999 at 5:55 pm
Feb 2, 1999 at 10:02 am -
I am feeling the need to jump into the code and add some of the easier things that people have been asking for. However, I have a 7-month old baby, and just can't seem to get any free time to do ...
Bruce Momjian
Jan 18, 1999 at 5:30 am
Jan 18, 1999 at 10:42 pm -
you're all wrong. 6.4 was late because of me. i didn't know the postgresql development process or political process, and that combined with some real life issues made me unresponsive and/or ...
Paul A Vixie
Jan 8, 1999 at 5:20 pm
Jan 14, 1999 at 8:09 pm -
I am sending this patch to hackers because I think it needs some discussion before being added. I'm not 100% sure that there isn't some internal issue with making these changes but so far it seems to ...
"D'Arcy" "J.M." Cain
Jan 23, 1999 at 12:42 pm
Feb 5, 1999 at 4:28 am -
It came from someone, not sure who. Can someone comment? If not, let's back it out. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard ...
Bruce Momjian
Jan 23, 1999 at 9:36 pm
Jan 26, 1999 at 1:00 pm -
10
Time zones
I'm writing up the full set of allowed date/time formats, and thought I'd include the recognized time zones. I want to confirm that AHST, Alaska-Hawaii Std Time, should have the same value as ...Thomas G. Lockhart
Jan 15, 1999 at 5:36 am
Jan 20, 1999 at 2:59 am -
So, could someone send me the SQL92 constraints syntax as well as the definition of what a deferrable constraint is supposed to be? ADVthanksANCE -DEJ
Jackson, DeJuan
Jan 11, 1999 at 7:42 pm
Jan 15, 1999 at 6:00 am -
Does this seem right? druid= SELECT COUNT(*) FROM acctrans; count ----- (1 row) druid= SELECT client_id, SUM(tramount) FROM acctrans GROUP BY client_id; client_id|sum ---------+--- (1 row) If there ...
"D'Arcy" "J.M." Cain
Jan 8, 1999 at 5:40 pm
Jan 14, 1999 at 10:38 am -
Hello. I just sent this note to the pgsql-general list, but I thought it probably deserved to land on the hackers list as well. My apologies if I'm wrong. Charlie ...
Charles Hornberger
Jan 30, 1999 at 2:09 am
Jan 31, 1999 at 7:36 pm -
9
NAN code
I have changed the NAN code, so if NAN is not defined, we just use 'num' as NAN, since we only get here if num is NAN. Seems like a good fix for platforms that can't assign a NAN to a variable. ...Bruce Momjian
Jan 1, 1999 at 4:16 am
Jan 4, 1999 at 6:31 pm -
Hi, FYI regarding the recent performance issues. This lib is ported to win32. I don't know, how many unixes are supported. Perhaps it's better to reuse something and not to reimplementit from ...
Ulrich Voss
Jan 28, 1999 at 11:05 am
Jul 7, 1999 at 1:32 am -
Included patches make some enhancements to the multi-byte support. o allow to use Big5 (a Chinese encoding used in Taiwan) as a client encoding. In this case the server side encoding should be EUC_TW ...
Tatsuo Ishii
Jan 27, 1999 at 7:23 am
Mar 15, 1999 at 2:36 pm -
After recent changes I find an error with SUM when summing more than one column. Here is the test sequence. DROP TABLE x; CREATE TABLE x (a int, b int); INSERT INTO x VALUES (1, 5); INSERT INTO x ...
"D'Arcy" "J.M." Cain
Jan 27, 1999 at 12:51 pm
Jan 28, 1999 at 7:45 pm -
Since FOR UPDATE is not allowed with UNION I suppose it is also not allowed with INTERSECT and EXCEPT. Is that correct? Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | ...
Michael Meskes
Jan 18, 1999 at 5:01 pm
Jan 20, 1999 at 7:48 pm -
7
Patches
A few days ago I sent some patches in to complete primary key support. I haven't seen them and I was wondering if you had to be subscribed to the pathes list in order to submit like the others. -- ..."D'Arcy" "J.M." Cain
Jan 20, 1999 at 1:52 pm
Jan 31, 1999 at 6:39 pm -
I assume you are running the snapshot, and not 6.4.*. You are actually using FOR UPDATE, so I think it is the snapshot. This is normal behavior, I think. I believe the issue with SELECT FOR UPDATE is ...
Bruce Momjian
Jan 20, 1999 at 11:31 am
Jan 21, 1999 at 6:16 am -
really hesitate to make this criticism given all the work people are doing on the system and all the great features and fixes that are being added but could we please make it a hard and fast rule ...
"D'Arcy" "J.M." Cain
Jan 18, 1999 at 5:18 am
Jan 18, 1999 at 4:40 pm -
OK, I give up :) How do I use the numeric type? postgres= create table n1 (n numeric(10,5), d decimal(10,5)); CREATE postgres= insert into n1 values ('1.23456', '1.23456'); ERROR: overflow on numeric ...
Thomas G. Lockhart
Jan 6, 1999 at 2:29 am
Jan 6, 1999 at 4:50 pm -
printtup() does a SearchSysCache call for each attribute of each tuple in order to find the appropriate output routine for the attribute's type. (Up till yesterday it did *two* such calls per ...
Tom Lane
Jan 25, 1999 at 1:06 am
Jul 7, 1999 at 1:02 am -
Hello all, It seems that SPI_prepare() doesn't work well in some cases. Pawel Pierscionek [pawel@astercity.net] reported about the following case 1([SQL] drop table in pgsql). Michael Contzen ...
Hiroshi Inoue
Jan 20, 1999 at 10:51 am
Mar 15, 1999 at 2:31 pm -
regression= SELECT 1 AS two UNION SELECT 2; NOTICE: equal: don't know whether nodes of type 600 are equal two --- 1 2 (2 rows) gdb: #0 equal (a=0x179f10, b=0x1c1490) at equalfuncs.c:746 #1 0x7bf4d in ...
Vadim Mikheev
Jan 29, 1999 at 7:07 am
Feb 7, 1999 at 10:04 pm -
At release 6.4.2, COPY does not respect column defaults: junk= create table testbed ( junk- f1 int4 default 5, junk- f2 float default 7.34, junk- f3 datetime default now(), junk- f4 text default ...
Oliver Elphick
Jan 28, 1999 at 1:28 pm
Jan 28, 1999 at 8:06 pm -
I still wonder if the for-update-tests in SelectStmt: are okay. Shouldn't the test check for intersect_present=TRUE instead of intersectClause != NULL? Michael -- Michael Meskes | Go SF 49ers! ...
Michael Meskes
Jan 21, 1999 at 6:59 pm
Jan 25, 1999 at 7:28 am -
I just checked the ecpg docs. There are ecpg.1 and ecpg.sgml, a man page and a converted texinfo file. I remember Tom saying something like the manpages shall be computed from the sgml source. Is ...
Michael Meskes
Jan 21, 1999 at 6:37 pm
Jan 24, 1999 at 8:26 am -
Seems at some point someone decided not to be machine-independent in backend/utils/adt/float.c Redhat 5.2 system with gcc 2.8.1 doesn't define NAN unless _GNU_SOURCE is defined first. Although ...
Taral
Jan 16, 1999 at 5:29 am
Jan 19, 1999 at 2:42 am -
The blizzard hitting the Chicago area makes today ideal for hacking - as long as the power stays on! A thousand pardons if this is a known problem - I'm just getting started with the current CVS set. ...
Hal Snyder
Jan 2, 1999 at 10:35 pm
Jan 4, 1999 at 2:29 pm -
There have been related discussions before on pg-hackers mail list; you might care to check the list archives. The conclusion I recall is that it's not real clear how the combination of SELECT ...
Tom Lane
Jan 29, 1999 at 5:04 pm
Feb 2, 1999 at 3:56 pm -
Hi, 1. I've just committed some changes to PL/pgSQL and the SPI manager. It's a speedup of PL/pgSQL execution by calling ExecEvalExpr() in the executor directly for simple expressions that return one ...
Jan Wieck
Jan 27, 1999 at 5:01 pm
Jan 28, 1999 at 12:24 pm -
I've been doing some more backend profiling, and observe that in a large SELECT from a table with lots of columns, nocachegetattr (the guts of heap_getattr) is at the top of the list, accounting for ...
Tom Lane
Jan 24, 1999 at 5:54 pm
Jan 24, 1999 at 9:00 pm -
See attached file. Now accepts "exec sql whenever sqlwarning". Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian ...
Michael Meskes
Jan 21, 1999 at 6:37 pm
Jan 22, 1999 at 7:09 pm -
5
KPGsql
New interface. IMHO, not as nice as pgaccess. http://home.primus.baynet.de/mgeisler/kpgsql/ -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a ...Bruce Momjian
Jan 18, 1999 at 5:17 pm
Jan 20, 1999 at 7:16 pm -
I tried inserting 15000 tuples each in two tables via pgsql and timed it. After insertion I also created btree indeces on both tables. Some results: First try was with a 6.4.1 version without -F ...
Michael Meskes
Jan 18, 1999 at 5:01 pm
Jan 20, 1999 at 2:04 am -
pg_dump won't drop stuff before trying to create it; this makes dropping a single table (say) and recreating it difficult to automate since it is subject to error if all the stuff doesn't get dropped ...
Brook Milligan
Jan 15, 1999 at 9:08 pm
Jan 18, 1999 at 4:55 am -
I just received this via e-mail. I am boucing the whole posting to the patches list. I am going to need help understanding the issues here. -- Bruce Momjian | http://www.op.net/~candle ...
Bruce Momjian
Jan 8, 1999 at 4:30 pm
Jan 18, 1999 at 12:12 am -
Hi! I was just poking around a bit in the libpq (server side this time) files, and noticed a few things. For example, the StreamOpen() function is defined there (pqcomm.c), but it is _never_ used (at ...
Magnus Hagander
Jan 6, 1999 at 3:41 pm
Jan 10, 1999 at 1:43 am -
It seems that pg_dump (in 6.4.2) still has problem with quoting \ and ' when they appears together. The following example illustrates this. terekhov= create table test (i int, t text); CREATE ...
Mikhail Terekhov
Jan 13, 1999 at 7:50 pm
Mar 15, 1999 at 3:27 pm -
Is there a workaround for an undeclared NAN in backend/utils/adt/float.c on FreeBSD? I thought I compiled this before, but right now I don't see any evidence that I did. If I did, the only difference ...
Vince Vielhaber
Jan 27, 1999 at 11:45 pm
Jan 28, 1999 at 2:43 am -
Is anyone else seeing major breakage of the regression tests with today's (Monday's) CVS checkins? Or did I break something myself? I'm seeing wrong answers in tests numerology and select_having; ...
Tom Lane
Jan 26, 1999 at 6:56 am
Jan 27, 1999 at 2:24 am -
Recently I have started seeing this error when starting the server. shell-init: could not get current directory: getcwd: cannot access parent directories Here is the command I use to start ...
"D'Arcy" "J.M." Cain
Jan 22, 1999 at 1:26 pm
Jan 22, 1999 at 11:34 pm -
Hi all, I have a question about rules. I create a rule to insert data into a view that works fine, but when I add a row to the view, PostgreSQL replies INSERT 0 0 if the row is added and it replies ...
José Soares
Jan 18, 1999 at 3:59 pm
Jan 22, 1999 at 6:59 pm -
4
CVS....
Okay, after a long fight with modula3 I know have a working version of cvsup for Solaris 7 SPARC. Know, what I would like to do is to use cvsup to update my local cvs repoistory. How would I go about ...Matthew C. Aycock
Jan 14, 1999 at 8:36 pm
Jan 16, 1999 at 2:22 am -
could soemeone explain to me how the tcl/tk configure stuff is suposed to worl? I built 6.4.2 on my HP-UX machine a week or so agao, and had to do some _really_ strange things to get it working. ...
Stan Brown
Jan 10, 1999 at 12:41 am
Jan 10, 1999 at 5:51 pm -
Yes. Depending on the size of your database and the loading on the web server, I would expect that performance is acceptable now. If you can tell us the approximate size of your intended databases ...
Thomas G. Lockhart
Jan 9, 1999 at 6:52 pm
Jan 10, 1999 at 1:47 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 187 |
posts | 739 |
users | 96 |
website | postgresql.org... |
irc | #postgresql |
96 users for January 1999
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)