FAQ

PostgreSQL > pgsql-hackers > September 2000

Search Discussions

180 discussions - 633 posts

  • 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 IshiiTatsuo 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, VadimMikheev, 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 ...
    DevikDevik
    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 WarnerPhilip 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 SokoloffAlex 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 BartunovOleg 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 BeanJules 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 KreenMarko 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 PooleRichard 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 LaneTom 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 EisentrautPeter 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 ZoltanKovacs 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 MascariMike 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 HackerThe 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 VincentMitch 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 WarnerPhilip 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 HeavenSteve 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 LaneTom 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 MomjianBruce Momjian
    Sep 30, 2000 at 2:37 am
    Oct 10, 2000 at 1:45 pm
  • Peter EisentrautPeter 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 HackerThe 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 ...
    DevikDevik
    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 LaneTom 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 ZakKarel 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 LaneTom 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 IshiiTatsuo 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 EisentrautPeter 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 LaneTom 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 HackerThe 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 MilliganBrook 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 VianenJeroen 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 MeskesMichael 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 VielhaberVince 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 WarnerPhilip 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 MilliganBrook 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 HackerThe 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 WarnerPhilip 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 LaneTom 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 IshiiTatsuo 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 EisentrautPeter 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 WarnerPhilip 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 EisentrautPeter 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 PerlsteinAlfred 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 PerlsteinAlfred 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 LaneTom 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 PazzagliaJean-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 JoubertAdriaan 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 KrosingHannu Krosing
    Sep 26, 2000 at 11:05 pm
    Sep 27, 2000 at 10:48 am
  • Ops. Ok... Vadim
    Mikheev, VadimMikheev, 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 PaavilainenJarmo Paavilainen
    Sep 26, 2000 at 8:09 am
    Sep 26, 2000 at 10:57 pm
Sep 2000
1234
Group Navigation
period‹ prev | Sep 2000 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions180
posts633
users101
websitepostgresql.org...
irc#postgresql

101 users for September 2000

Tom Lane: 130 posts Peter Eisentraut: 45 posts Philip Warner: 41 posts The Hermit Hacker: 41 posts Bruce Momjian: 26 posts Mikheev, Vadim: 26 posts Thomas Lockhart: 26 posts Hiroshi Inoue: 22 posts Andreas Zeugswetter: 19 posts Tatsuo Ishii: 19 posts Alfred Perlstein: 14 posts Hannu Krosing: 13 posts Michael Meskes: 13 posts Devik: 11 posts Jan Wieck: 10 posts Stephan Szabo: 10 posts Karel Zak: 9 posts Brook Milligan: 7 posts Jules Bean: 7 posts Oleg Bartunov: 7 posts
show more
Archives