FAQ

Search Discussions

72 discussions - 218 posts

  • Peter, I hope this long and boring message can shed some light on my difficulties getting jdbc & postgres6.5b1(current snapshot) to work with blobs. I have NO problem with text, numeric, etc. Just ...
    Brian P MillettBrian P Millett
    Apr 29, 1999 at 4:40 pm
    May 11, 1999 at 6:04 pm
  • I need to debug this connection problem I am having with Access97. My question is how can I get the new Postgres backend that starts up for Access into debug (gdb)? I can get the PostMaster open in ...
    Michael J DavisMichael J Davis
    Apr 28, 1999 at 4:09 pm
    Apr 30, 1999 at 12:02 am
  • Hello all, The following example causes the hang of concurrent transactions(99/04/26 snapshot). session-1 = create table tt (id int4); session-1 = begin; session-1 = insert into tt values (1); ...
    Hiroshi InoueHiroshi Inoue
    Apr 27, 1999 at 3:45 am
    Apr 29, 1999 at 12:29 pm
  • I know some people thinks mico is great but I have some concerns: * I can't even get it to compile on my workstation at work, upgraded both g++ to egcs and libg++/libstd++. Still it does not compile ...
    Goran ThyniGoran Thyni
    Apr 26, 1999 at 3:52 pm
    Apr 27, 1999 at 7:54 pm
  • As D'Arcy did ask...which oid would you want used? The one from table a, or from Table b? They are two distinctly different numbers...the VIEW itself doesn't have an OID assigned to its rows, only ...
    The Hermit HackerThe Hermit Hacker
    Apr 26, 1999 at 2:38 pm
    May 11, 1999 at 12:09 am
  • I thought numeric data type on 6.5 allows a very large precision. Am I missing something? -- Tatsuo Ishii test= create table t1(n numeric(100,0)); CREATE test= \d t1; Table = t1 ...
    Tatsuo IshiiTatsuo Ishii
    Apr 27, 1999 at 9:10 am
    May 6, 1999 at 6:32 am
  • For some reason (dunno why) the parser ignores the precision for DECIMAL. atttypmod is set hardcoded to -1. So the above is identical to a CREATE TABLE test (n numeric(10,3), d decimal); I'll test ...
    Jan WieckJan Wieck
    Apr 27, 1999 at 1:27 pm
    May 11, 1999 at 3:02 am
  • Last night I was looking into optimizer misbehavior on the sample query explain select * from pg_class, pg_description where pg_class.oid = pg_description.objoid; As of yesterday the system was ...
    Tom LaneTom Lane
    Apr 30, 1999 at 3:55 pm
    May 1, 1999 at 7:19 pm
  • This is on the TODO list. I actually have a solution that seems to work fine, but I wanted to run it past the backend guru's after we have finished the 6.5 beta. Sorry I din't get it finished before ...
    Ryan BradetichRyan Bradetich
    Apr 25, 1999 at 7:42 pm
    May 10, 1999 at 4:41 pm
  • Hello, this night we discovered here a strange behaviour on our servers. Somebody managed to get access to the UNIX shell using the 'postgres' db administrator account. He logged in some machines ...
    Matthias SchmittMatthias Schmitt
    Apr 27, 1999 at 4:22 pm
    Apr 28, 1999 at 1:04 pm
  • This implies that the "group by" clause is not supported in views. I have created views that use the group by clause and they appear to work. I have not verified the content of the records. I would ...
    Michael J DavisMichael J Davis
    Apr 26, 1999 at 11:10 pm
    May 10, 1999 at 6:05 pm
  • June 1st. Plan'd release date for v6.5. Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Apr 28, 1999 at 12:07 pm
    Apr 29, 1999 at 5:15 pm
  • Moved to hackers. It's probably the best place. As to the comparison, I just started looking into that this mourning with a question from someone else - with luck we'll have something there around ...
    Vince VielhaberVince Vielhaber
    Apr 27, 1999 at 1:06 am
    Apr 27, 1999 at 4:31 pm
  • Hello, I am trying to run the ImageViewer.java example that is part of the src/interfaces/jdbc/ examples. I have a database test which has two images loaded into it with the ImageVIewer app. I am ...
    Brian P MillettBrian P Millett
    Apr 23, 1999 at 7:36 pm
    Apr 26, 1999 at 8:58 pm
  • I just received this. Any ideas ? -- Peter T Mount peter@retep.org.uk Main Homepage: http://www.retep.org.uk PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres Java PDF Generator: ...
    Peter T MountPeter T Mount
    Apr 29, 1999 at 5:55 am
    Apr 29, 1999 at 2:59 pm
  • Hello! Long awaited rumor that EGCS will become GCC someday... Finally it happened. RMS announces it: http://lwn.net/daily/gcc.html Is Postgres rady to EGCS, I wonder? I remember people had some ...
    Oleg BroytmannOleg Broytmann
    Apr 28, 1999 at 7:30 am
    Apr 29, 1999 at 5:47 am
  • Hopefully this won't bounce 'cuze of your quotes that my mailer for some reason doesn't like.. but anyway... I had something like this earlier today. Assuming your system has something like ipcs, ...
    Vince VielhaberVince Vielhaber
    Apr 23, 1999 at 7:06 pm
    Apr 24, 1999 at 4:09 pm
  • i've posted to general mailing list, but no clear answer, so i ask to you. i hope this is right. what are max db and table size under Linux x86 and Linux Alpha. Are there other Limitations? If yes, ...
    ValterValter
    Apr 23, 1999 at 6:46 pm
    Apr 23, 1999 at 8:57 pm
  • I don't know nothing about ROWCOUNT. SET ROWCOUNT doesn't work for me. hygea= set rowcount = 10; ERROR: parser: parse error at or near "10" PostgreSQL still accepts SET QUERY_LIMIT but it doesn't ...
    José SoaresJosé Soares
    Apr 29, 1999 at 1:58 pm
    Apr 29, 1999 at 6:13 pm
  • I refreshed my 6.5 source last night (last time was early April). This had some patches to case and coalesce that I needed. This is working great except for the following two areas: 1) The \g option ...
    Michael J DavisMichael J Davis
    Apr 27, 1999 at 9:35 pm
    Apr 29, 1999 at 1:30 am
  • Psql displays twice tables, views, indices, sequences etc. prova= \d Database = prova +------------------+----------------------------------+----------+ ...
    José SoaresJosé Soares
    Apr 26, 1999 at 1:42 pm
    Apr 27, 1999 at 8:20 am
  • Is the LIMIT feature very efficient? I want to start using it for quite a few things, but I'm wondering, what happens when I have a zillion records and I want the first 10, is that going to be an ...
    Chris BitmeadChris Bitmead
    Apr 25, 1999 at 8:17 am
    Apr 27, 1999 at 1:53 am
  • Hi all, I have two tables MOVIMENTAZIONI with 7650 rows CAPI with 7650 rows, when I try to join this two tables PostgreSQL takes more than 107 minutes to retrieve rows, the same query in: I have ...
    José SoaresJosé Soares
    Apr 29, 1999 at 8:32 am
    May 12, 1999 at 4:08 am
  • Folks, No one on general or novice have had any insight into the following problem. I have a very large table (10Gb, 20 million records each with 54 fields) with both float, integer and text values. ...
    Martin WeinbergMartin Weinberg
    Apr 29, 1999 at 3:21 pm
    May 10, 1999 at 4:41 pm
  • Any objection to the pacthes below? Seems they solve problems reported by a user in Japan (both on 6.4.2 and current). -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Apr 26, 1999 at 2:53 am
    May 1, 1999 at 4:16 pm
  • I posted the following message in [GENERAL] and still haven't been able to resolve the problem. The file permissions are set to postgres and postgres is authorized to access /usr/local/pgsql/lib. ...
    Andy LewisAndy Lewis
    Apr 29, 1999 at 6:27 pm
    Apr 29, 1999 at 11:23 pm
  • I'm using the 990329 snap shot. I was doing this query... SELECT story.approved, story.oid FROM story, webuser, category* WHERE story.webuser = webuser.oid AND story.category = category.oid; ...
    Chris BitmeadChris Bitmead
    Apr 27, 1999 at 5:15 am
    Apr 28, 1999 at 12:38 am
  • I have a table in which the first four variables are the unique primary key. Recently, I ran a vacuum and was told that the number of tuples did not equal the number in the heap for the primary key ...
    G. Anthony ReinaG. Anthony Reina
    Apr 27, 1999 at 1:17 am
    Apr 27, 1999 at 5:16 pm
  • Hi, I have some patches for the current snapshot (1999-04-28): 1) an old patch I had already posted and which has never applied. *** src/backend/tcop/postgres.c.orig Tue Mar 23 09:03:08 1999 --- ...
    Massimo Dal ZottoMassimo Dal Zotto
    Apr 30, 1999 at 3:55 pm
    May 1, 1999 at 5:20 pm
  • gcc -I../../../include -I../../../backend -O2 -m486 -pipe -Wall -Wmissing-prototypes -ggdb3 -I../.. -c lock.c -o lock.o lock.c: In function `LockResolveConflicts': lock.c:832: `lockQueue' undeclared ...
    Vadim MikheevVadim Mikheev
    Apr 30, 1999 at 5:43 am
    Apr 30, 1999 at 4:23 pm
  • I like the logo. Every open source project needs a mascot. If the elephant is yet nameless, might I suggest: Pasquale the Pachyderm? He might have been descended of one that survived Hanibal's drive ...
    Charles C. Bennett, Jr.Charles C. Bennett, Jr.
    Apr 30, 1999 at 2:56 pm
    Apr 30, 1999 at 4:13 pm
  • It seems that postgres does not accept -T option. Checking the source, I found that T is not given to getopt() while there is a code to parse the -T option. Is there any reason for this? --- Tatsuo ...
    Tatsuo IshiiTatsuo Ishii
    Apr 30, 1999 at 1:03 am
    Apr 30, 1999 at 1:57 pm
  • Since this is a rewrite rule, the whole statement gets rewritten, thus leading to different results, when one statement inserts many rows (insert into ... select) or one statement only inserts one ...
    Zeugswetter Andreas IZ5Zeugswetter Andreas IZ5
    Apr 28, 1999 at 8:04 am
    Apr 28, 1999 at 2:19 pm
  • Hmm, this sounds very similar to a problem I was looking at on Sunday: select sum(quantity), ID+1 from aggtest1 group by ID+1; ERROR: replace_agg_clause: variable not in target list The error message ...
    Tom LaneTom Lane
    Apr 27, 1999 at 2:51 pm
    Apr 27, 1999 at 4:22 pm
  • Thanks for your reply. I'm using apache 1.3.6 (DSO), PHP 3.0.6 and PG 6.4.2. I was able to successfully run apache/php/pg under LinuxPPC R4 and haven't had any probs under i386 Linux distros, however ...
    JP RosevearJP Rosevear
    Apr 27, 1999 at 1:29 pm
    Apr 27, 1999 at 3:07 pm
  • This is not something that can be added in for v6.5...it doesn't fix a bug...sounds like something good for v6.6 though ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ ...
    The Hermit HackerThe Hermit Hacker
    Apr 23, 1999 at 7:31 pm
    Apr 27, 1999 at 3:29 am
  • Hey folks, still looking for a little help on this. I can insert data and (obviously create tables). Further, I've discovered PHP with pg support yields an unknown symbol 'lo_unlink' when Apache ...
    JP RosevearJP Rosevear
    Apr 24, 1999 at 10:28 pm
    Apr 27, 1999 at 1:32 am
  • Hi, You can ask denn@unicorn.micex.ru about his Vinsent - E-R data modelling. It has support for Informix and Postgres, it's free and requires python, tcl/tk to run. I don't have right now an URL for ...
    Oleg BartunovOleg Bartunov
    Apr 26, 1999 at 7:46 am
    Apr 26, 1999 at 7:48 am
  • The following works in psql: SELECT MemberID, InvoiceID, sum(quantity * unitprice) as InvAmount, si_InventoryCategory(InventoryID) as CategoriesID FROM InvoiceLines WHERE memberid = 685 GROUP BY ...
    Michael J DavisMichael J Davis
    Apr 25, 1999 at 9:13 pm
    Apr 26, 1999 at 12:47 am
  • Hi to all I have a problem to join a table and a view. My table and view each has 150000 records. When I join these it takes about 30sec. How can improve performance. Regards Hossein
    PourrezaPourreza
    Apr 24, 1999 at 7:29 am
    Apr 24, 1999 at 4:10 pm
  • If you get elog(ERROR), can't you just abort the current message, and send the elog(), or is it very involved. Yes, I vaguelly remember that. -- Bruce Momjian | http://www.op.net/~candle ...
    Bruce MomjianBruce Momjian
    Apr 23, 1999 at 7:53 pm
    Apr 23, 1999 at 9:40 pm
  • Are you out of disk space? -- 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 your backup. | ...
    Bruce MomjianBruce Momjian
    Apr 23, 1999 at 7:37 pm
    Apr 23, 1999 at 7:58 pm
  • Please note that Advocacy is what http://www.pgsql.com is being formed around...offering Commercial Support is just one aspect of it... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems ...
    The Hermit HackerThe Hermit Hacker
    Apr 23, 1999 at 6:52 pm
    Apr 23, 1999 at 7:42 pm
  • Morning all... I'm trying to see if I can improve mail propogation for the mailing lists, and one way of doing it is to setup 'relay' sites...basically, using a software package called 'tlb', I can ...
    The Hermit HackerThe Hermit Hacker
    Apr 30, 1999 at 3:00 pm
    Apr 30, 1999 at 3:00 pm
  • The following worked with version 6.5 before 4/5/99 but now fails (I pull new 6.5 source last night): insert into si_tmpVerifyAccountBalances select invoiceid+3, memberid, 1, TotShippingHandling from ...
    Michael J DavisMichael J Davis
    Apr 29, 1999 at 8:50 pm
    Apr 29, 1999 at 8:50 pm
  • The following web site contains a set mathematical functions that looks interesting: http://www.boic.com/numintro.htm <http://www.boic.com/numintro.htm Maybe you should consider using this to ...
    Michael J DavisMichael J Davis
    Apr 29, 1999 at 4:54 pm
    Apr 29, 1999 at 4:54 pm
  • unsubscribe
    Atsushi ManoAtsushi Mano
    Apr 29, 1999 at 10:12 am
    Apr 29, 1999 at 10:12 am
  • Please give us output of: explain SELECT movimentazioni.azienda Andreas PS: what it should do is seq scan on movimentazioni and index path on capi what it could do if it was implemented is full index ...
    Zeugswetter Andreas IZ5Zeugswetter Andreas IZ5
    Apr 29, 1999 at 8:59 am
    Apr 29, 1999 at 8:59 am
  • Well, I thought the explanation (visibility of rows) was clear and that I understood rules. My tests make me more confused, though, because it doesn't seem to explain everything. Here is the relevant ...
    Brook MilliganBrook Milligan
    Apr 28, 1999 at 3:39 pm
    Apr 28, 1999 at 3:39 pm
  • I have created a table/view/rule combination (see script below) that should enable insertion into the view in a manner that pretty much parallels Jan's documentation of the rule system. I think the ...
    Brook MilliganBrook Milligan
    Apr 28, 1999 at 6:54 am
    Apr 28, 1999 at 6:54 am
Group Navigation
period‹ prev | Apr 1999 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions72
posts218
users52
websitepostgresql.org...
irc#postgresql

52 users for April 1999

Bruce Momjian: 30 posts Tom Lane: 25 posts The Hermit Hacker: 16 posts Michael J Davis: 13 posts Jan Wieck: 10 posts Vadim Mikheev: 9 posts José Soares: 8 posts Tatsuo Ishii: 8 posts Brian P Millett: 7 posts Taral: 7 posts Thomas Lockhart: 6 posts Vince Vielhaber: 6 posts Chris Bitmead: 5 posts Hiroshi Inoue: 5 posts Todd Graham Lewis: 5 posts Brook Milligan: 4 posts "D'Arcy" "J.M." Cain: 3 posts Oleg Bartunov: 3 posts Peter T Mount: 3 posts Ryan Bradetich: 3 posts
show more
Archives