FAQ

PostgreSQL > pgsql-hackers > January 1999

Search Discussions

187 discussions - 739 posts

  • Oh? Aren't the CVS versions considered the master copies? If not, where *are* the master copies? regards, tom lane
    Tom LaneTom 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 MackintoshTerry 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 VerdonPatrick 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 ZottoMassimo 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 MikheevVadim 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 WetzelDavid 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 MikheevVadim 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 MomjianBruce 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 VixiePaul 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"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 MomjianBruce Momjian
    Jan 23, 1999 at 9:36 pm
    Jan 26, 1999 at 1:00 pm
  • 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. LockhartThomas 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, DeJuanJackson, 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"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 HornbergerCharles Hornberger
    Jan 30, 1999 at 2:09 am
    Jan 31, 1999 at 7:36 pm
  • 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 MomjianBruce 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 VossUlrich 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 IshiiTatsuo 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"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 MeskesMichael Meskes
    Jan 18, 1999 at 5:01 pm
    Jan 20, 1999 at 7:48 pm
  • 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"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 MomjianBruce 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"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. LockhartThomas 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 LaneTom 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 InoueHiroshi 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 MikheevVadim 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 ElphickOliver 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 MeskesMichael 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 MeskesMichael 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 ...
    TaralTaral
    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 SnyderHal 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 LaneTom 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 WieckJan 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 LaneTom 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 MeskesMichael Meskes
    Jan 21, 1999 at 6:37 pm
    Jan 22, 1999 at 7:09 pm
  • 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 MomjianBruce 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 MeskesMichael 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 MilliganBrook 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 MomjianBruce 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 HaganderMagnus Hagander
    Jan 6, 1999 at 3:41 pm
    Jan 10, 1999 at 1:43 am
  • All, I've just read in DBMS magazine that Oracle, Informix, etc... are replacing there proprietary Procedural Language's (PL/SQL) with JVMs (JAVA virtual machine). Apparently according to the ...
    Dan GowinDan Gowin
    Jan 4, 1999 at 2:16 pm
    Jan 6, 1999 at 11:25 pm
  • 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 TerekhovMikhail 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 VielhaberVince 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 LaneTom 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"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é SoaresJosé Soares
    Jan 18, 1999 at 3:59 pm
    Jan 22, 1999 at 6:59 pm
  • 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. AycockMatthew 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 BrownStan 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. LockhartThomas G. Lockhart
    Jan 9, 1999 at 6:52 pm
    Jan 10, 1999 at 1:47 am
Jan 1999
1234
Group Navigation
period‹ prev | Jan 1999 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions187
posts739
users96
websitepostgresql.org...
irc#postgresql

96 users for January 1999

Bruce Momjian: 137 posts Tom Lane: 78 posts Thomas G. Lockhart: 62 posts Vadim Mikheev: 49 posts The Hermit Hacker: 43 posts Jan Wieck: 33 posts Michael Meskes: 27 posts "D'Arcy" "J.M." Cain: 25 posts : 19 posts Oleg Broytmann: 17 posts Jackson, DeJuan: 16 posts Goran Thyni: 13 posts Tatsuo Ishii: 11 posts Taral: 10 posts Brook Milligan: 9 posts Magnus Hagander: 9 posts Vince Vielhaber: 9 posts Clark Evans: 8 posts Hal Snyder: 8 posts Hiroshi Inoue: 8 posts
show more
Archives