Search Discussions
-
It seems current source is broken if MB is enabled. gcc -c -I../../../src/interfaces/libpq -I../../../src/include -I../../../src/interfaces/libpq -O2 -Wall -Wmissing-prototypes -Wmissing-declarations ...
Tatsuo Ishii
Sep 13, 2000 at 4:03 am
Oct 20, 2000 at 3:51 pm -
Where are we in subj? Oid.version or UniqueId? If noone is going to implement it soon then I'll have to change code to OID file naming for WAL. Vadim
Mikheev, Vadim
Sep 12, 2000 at 4:22 pm
Sep 15, 2000 at 12:26 am -
Hello, I recently spoke about extending index scan to be able to take data directly from index pages. I wanted to know whether should I spend my time and implement it. So that I hacked last pgsql a ...
Devik
Sep 26, 2000 at 9:25 am
Oct 17, 2000 at 2:28 pm -
Well at least two, unless you like the following: zzz=# select * from pg_views; ERROR: cache lookup of attribute 1 in relation 3450464 failed ...
Philip Warner
Sep 18, 2000 at 11:44 pm
Sep 20, 2000 at 5:35 pm -
Postgres has an 'ascii' function that converts characters to ascii, values, but it appears to be a one way street. I can't find a way to convert ascii values to characters, like 'chr' in Oracle. ...
Alex Sokoloff
Sep 17, 2000 at 2:11 am
Sep 19, 2000 at 6:34 pm -
Hi, while I'm doing more accurate test I just want to ask if somebody test locale in 7.0.2 under FreeBSD ? the point is that I usually compile postgres with --enable-locale --enable-multibyte and ...
Oleg Bartunov
Sep 16, 2000 at 10:55 am
Dec 4, 2000 at 8:36 pm -
I'm sure your aware of these limitations, but I'd thought I'd mention them just in case, and to see if you have plans to sort them out: I have a query of the form: SELECT * FROM .... WHERE ...
Jules Bean
Sep 11, 2000 at 12:26 pm
Sep 19, 2000 at 1:29 am -
Well, I was interested in binary operators on integers and as Peter suggested that I should look into it myself, so I did it. Choice of operators: ~ - not & - and # - xor - I like it :) Things I am ...
Marko Kreen
Sep 20, 2000 at 7:07 pm
Oct 24, 2000 at 9:30 pm -
No response to this one on -general, so here goes... The documentation for initdb says that the "-t" (== "--template") option recreates the template1 database but doesn't touch anything else. But it ...
Richard Poole
Sep 25, 2000 at 5:33 pm
Jan 24, 2001 at 12:55 pm -
I had another thought about fixing our problems with deriving index bounds for LIKE patterns in non-ASCII locales. (If you don't remember the gory details here, please re-read thread Sigh, LIKE ...
Tom Lane
Sep 2, 2000 at 5:39 pm
Oct 16, 2000 at 5:10 pm -
I've brought this up before, but maybe if I sell it as a bug someone will agree. :-) It would be desirable for several reasons that PostgreSQL can be installed safely with --prefix=/usr/local, or ...
Peter Eisentraut
Sep 27, 2000 at 10:40 am
Oct 4, 2000 at 8:10 pm -
Hi, I experience a strange error with 7.0.2. I cannot get any results with certain queries. For example, a foo table is defined with a few columns, it has a id_string varchar(100) column, too. I ...
Kovacs Zoltan
Sep 12, 2000 at 12:29 pm
Sep 15, 2000 at 12:08 am -
Under both 6.5 and 7.0: ---------------------- stocks=# create table test (key int4); CREATE stocks=# create function crap(int4) returns int4 as 'select sum(key) from test' language 'sql'; CREATE ...
Mike Mascari
Sep 12, 2000 at 11:57 am
Sep 12, 2000 at 4:39 pm -
I have a database where, periodically, I get a query that is producing pg_noname files that are 1gig in size ... according to syslog, for that process: Sep 7 18:36:39 pgsql postgres[47078]: DEBUG: ...
The Hermit Hacker
Sep 7, 2000 at 11:56 pm
Sep 8, 2000 at 2:59 pm -
I was just doing some huge operations with PostgreSQL and it all crashed out with a "too many files open" message plastered all over the place.. Now in /proc/sys/fs/file-max there is only 4096, that ...
Mitch Vincent
Sep 13, 2000 at 8:01 pm
Oct 17, 2000 at 1:59 pm -
It recently came to my attention that pg_dump dumps 'CREATE SEQUENCE' and 'SELECT NEXTVAL' commands for both data-only and schema-only output. This results in problems for users who do the two in ...
Philip Warner
Sep 28, 2000 at 8:08 am
Sep 28, 2000 at 3:29 pm -
Has something happened to the list server ? I am only subscribed to the general list, but after two days of nothing I'm now getting the hackers list stuff. Steve -- thorNET - Internet Consultancy, ...
Steve Heaven
Sep 14, 2000 at 8:06 am
Sep 14, 2000 at 1:03 pm -
With latest CVS, rules regress test is failing with -- Test for constraint updates/deletes -- insert into rtest_system values ('orion', 'Linux Jan Wieck'); + ERROR: You can't change view relation ...
Tom Lane
Sep 12, 2000 at 8:14 pm
Oct 26, 2000 at 11:51 am -
Do other people have a comment on this. I am inclined to leave it along. This is the first complaint I have heard, and elog(PGDEBUG) just looks funny. We don't prefix NOTICE or ERROR. -- Bruce ...
Bruce Momjian
Sep 30, 2000 at 2:37 am
Oct 10, 2000 at 1:45 pm -
Peter Eisentraut
Sep 20, 2000 at 5:35 pm
Oct 4, 2000 at 5:19 pm -
Just going through Peter's new 'mk-snapshot' script, and found a problem: gmake[4]: Entering directory `/home/projects/pgsql/snapshot/pgsql/postgresql-snapshot/src/backend/parser' byacc -d gram.y ...
The Hermit Hacker
Sep 25, 2000 at 2:02 pm
Sep 25, 2000 at 10:04 pm -
Hello, I have encountered problems with particular query so that a started to dug into sources. I've two questions/ideas: 1) when optimizer computes size of join it does it as ...
Devik
Sep 12, 2000 at 11:58 am
Sep 15, 2000 at 12:17 am -
Am I right in thinking that the WHERE clause of a query must logically be applied *after* any joins specified in the FROM clause? For example, suppose that we have table t1 (x int) containing the ...
Tom Lane
Sep 1, 2000 at 8:47 pm
Sep 5, 2000 at 2:28 pm -
Hi, I have a question... why RULE call nexval() and data in RULE statement are differend than data in original stmt. An example: create sequence a; create table aa (id int DEFAULT nextval('a'), data ...
Karel Zak
Sep 4, 2000 at 10:09 am
Sep 4, 2000 at 1:30 pm -
Right, that's exactly how we've been planning to fix the problems with grouped views and so forth. I am beginning to think that this may have to happen for 7.1, else view inside ISO-style JOIN ...
Tom Lane
Sep 1, 2000 at 1:28 pm
Sep 2, 2000 at 4:12 am -
It seems that foreign key does not work in current, if specified with primary key definition. Take a look at following example(works in 7.0.2.): test=# CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ...
Tatsuo Ishii
Sep 15, 2000 at 11:51 am
Oct 17, 2000 at 1:42 am -
The "rule" regression test gets stuck in an infinite loop in optimizer/prep/prepunion.c:find_inheritable_rt_entry. It seems to be a coding mistake; from what I can tell the loop can't ever exit if ...
Peter Eisentraut
Sep 30, 2000 at 12:15 am
Oct 8, 2000 at 2:56 am -
I'm thinking about changing the way that access permission checks are handled for rules. The rule mechanism provides that accesses to tables that are mentioned within rules are done with the ...
Tom Lane
Sep 26, 2000 at 2:54 pm
Sep 28, 2000 at 8:52 am -
Can someone add something to the docs that gives an example of what should be used from the command line to reindex a database's system tables? All the man page says is use th e-O an d-P options :( ...
The Hermit Hacker
Sep 26, 2000 at 6:07 pm
Sep 26, 2000 at 9:08 pm -
I am working on designing some new datatypes and could use some guidance. Along with each data item, I must keep additional information about the scale of measurement. Further, the relevant scales of ...
Brook Milligan
Sep 22, 2000 at 11:05 pm
Sep 23, 2000 at 4:37 pm -
Hi, I encountered the following problem: ./configure --enable-debug --prefix=/opt/postgres Edit config.h: BLCKSZ 32768 postgres=# select version(); version ...
Jeroen van Vianen
Sep 21, 2000 at 3:42 pm
Sep 22, 2000 at 5:03 pm -
I just did a cvsup to get up-to-date again after I hadn't found time to work on ecpg for some months and found out that I cannot even compile anymore: make[3]: Entering directory ...
Michael Meskes
Sep 15, 2000 at 12:07 pm
Sep 18, 2000 at 11:30 am -
Does anyone have the Sept issue of Linux Magazine? According to a notification we just received, PostgreSQL got 4th place in the editor's choice awards. I wanna know what was in first, second and ...
Vince Vielhaber
Sep 15, 2000 at 6:27 pm
Sep 16, 2000 at 10:03 am -
I thought I would test the latest changes to pg_dump on the regression db, and got the following output for an aggregate: CREATE AGGREGATE newcnt (BASETYPE = opaque, SFUNC = int4inc, STYPE = int4, ...
Philip Warner
Sep 13, 2000 at 3:54 pm
Sep 14, 2000 at 3:12 am -
I have a script that dumps the content of a 7.0.2 database using pg_dump. I dump the data using the -acD flags, then the schema using the -scD flags. For databases with no user defined types, this ...
Brook Milligan
Sep 11, 2000 at 2:37 pm
Sep 11, 2000 at 9:20 pm -
I always thought that an OID was unsigned ... pgsql=# SELECT oid FROM projects WHERE oid < 0; oid ------------- -1727061152 -548634912 -548593248 -886806784 -1001235776 -1196613696 -1198068800 ...
The Hermit Hacker
Sep 1, 2000 at 1:58 pm
Sep 1, 2000 at 9:40 pm -
Continuing to try to use format_type to output all types, I get the following in the regression database: CREATE AGGREGATE newavg ( BASETYPE = integer, SFUNC = int4_accum, STYPE = "numeric[]", ...
Philip Warner
Sep 14, 2000 at 10:08 am
Oct 22, 2000 at 11:56 pm -
I was bemused to notice this afternoon that the backend does not build if you have not defined HAVE_TEST_AND_SET; furthermore, this has been true at least since 6.4. (slock() is compiled anyway, and ...
Tom Lane
Sep 2, 2000 at 7:06 pm
Oct 16, 2000 at 5:09 pm -
It seems -S option for postmaster (detaching ttys) does not exist in postgresql.conf. Is there any reason for this? -- Tatsuo Ishii
Tatsuo Ishii
Sep 20, 2000 at 12:20 am
Oct 8, 2000 at 9:29 am -
I've committed the announced unified regression test driver. (See Sep.20 message for list of features.) You can invoke it via `make check', either in the top level directory, or directly in ...
Peter Eisentraut
Sep 29, 2000 at 5:21 pm
Oct 5, 2000 at 8:28 pm -
Two routines do eccentric things when they can't find required supporting data: pg_get_userbyid returns 'unknown (UID=<uid-number )' when the UID does not exist. pg_get_viewdef returns 'Not a view' ...
Philip Warner
Sep 24, 2000 at 2:14 am
Sep 27, 2000 at 10:09 am -
I just read across the code in command/trigger.c:ExecCallTriggerFunc() and apparently the trigger function is called unconditionally even if the "strict" flag is set. Perhaps this should be amended ...
Peter Eisentraut
Sep 8, 2000 at 5:14 pm
Sep 17, 2000 at 5:52 pm -
There seems to a race condition somewhere where that if you're running let's say pg_dumpall and happen to drop a table mid-dump pg_dumpall will die because it looses the table. Would it make sense to ...
Alfred Perlstein
Sep 11, 2000 at 8:54 pm
Sep 12, 2000 at 8:34 am -
There's two problems here that kept me up all night hacking in order to keep my system from crashing an burning so bear with me if you can. If you define a table and then create a select query rule ...
Alfred Perlstein
Sep 2, 2000 at 4:42 pm
Sep 2, 2000 at 7:12 pm -
psql has some problems with views in current CVS: \d doesn't show views, and if you do \d on a specific view, it doesn't identify it as a view and doesn't show the view definition rule. I assume this ...
Tom Lane
Sep 24, 2000 at 12:03 am
Oct 17, 2000 at 3:42 am -
Hi, we tried to switch the log on by lauching the postmaster with -d 5 redirected to a file but this file is deseperatly empty, what it's wrong ? is the process writing to an other file or do we made ...
Jean-Christophe Pazzaglia
Sep 29, 2000 at 4:44 pm
Oct 8, 2000 at 12:06 am -
Hi, we've suddenly started getting this error message out of postgres (7.0.2). Does anybody know where it comes from? ERROR: UNLockBuffer: buffer 0 is not locked Any help appreciated, Adriaan
Adriaan Joubert
Sep 29, 2000 at 2:51 pm
Oct 2, 2000 at 6:22 am -
Can anyone explain why I must make / a character class in case-insensitive query in order to match / ? and then why does it work in plain ~ ? hannu= select * from item where path ~* '^/a'; path ...
Hannu Krosing
Sep 26, 2000 at 11:05 pm
Sep 27, 2000 at 10:48 am -
Ops. Ok... Vadim
Mikheev, Vadim
Sep 26, 2000 at 11:17 pm
Sep 27, 2000 at 5:46 am -
Hi, Is there a way to make postgre insensitive about field name cases? Like "initdb --fields-are-case-insensitive --compares-are-case-insensitive" Yes I know about "CaseIsKept" and CaseIsNotKept ...
Jarmo Paavilainen
Sep 26, 2000 at 8:09 am
Sep 26, 2000 at 10:57 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 180 |
posts | 633 |
users | 101 |
website | postgresql.org... |
irc | #postgresql |
101 users for September 2000
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)