FAQ

Search Discussions

223 discussions - 1,283 posts

  • From what I know it is possible to simply restore one table file since pg_log keeps all tid's. Of course it cannot guarantee integrity and does not work if the table was altered. In the last proposal ...
    Andreas ZeugswetterAndreas Zeugswetter
    Jun 15, 2000 at 7:31 am
    Jul 2, 2000 at 3:16 pm
  • I am considering making some changes to pg_dump, and would appreciate any suggestions/ideas from the list. The outline is as follows: - Add a flag to modify the output of pg_dump so that it is more ...
    Philip WarnerPhilip Warner
    Jun 22, 2000 at 4:51 pm
    Oct 11, 2000 at 1:07 am
  • I have finished updating about half of Postgres' builtin functions to the new style of fmgr interface. At this point, everything that accepts any pass-by-value datatypes is converted; the remaining ...
    Tom LaneTom Lane
    Jun 14, 2000 at 4:55 pm
    Aug 17, 2000 at 12:02 pm
  • Well, in attempting to build RPMs for 7.0.1, I have unearthed a 26 megabyte problem. 26 megabytes is the difference in the size of an unpacked 7.0.1 source tree versus 7.0. 7.0.1 is 26 MB _smaller_. ...
    Lamar OwenLamar Owen
    Jun 4, 2000 at 4:52 am
    Jun 13, 2000 at 12:52 pm
  • It seems the truncate command deletes all rows from a table even it is referenced by another tables. TRUNCATE is not in the standard any way, so I would not claim this is a bug. However, sometimes it ...
    Tatsuo IshiiTatsuo Ishii
    Jun 8, 2000 at 12:22 pm
    Oct 9, 2000 at 7:42 pm
  • I'd like to change some things about how the code handles the information about its own version number. The version number would be set in configure.in as in VERSION='1.2.3' (Keep it in configure.in ...
    Peter EisentrautPeter Eisentraut
    Jun 29, 2000 at 11:27 pm
    Jul 8, 2000 at 4:04 pm
  • While people are working on that, they might want to add some sanity checking to the multibyte character decoders. Currently they fail to check for "illegal" character sequences (i.e. sequences with ...
    Michael RobinsonMichael Robinson
    Jun 14, 2000 at 9:24 am
    Jun 25, 2000 at 4:38 pm
  • Hello all, This is the result of my 6 days "war" with Linux kernel people... Any usefull comments on this???? ---------- Forwarded Message ---------- Subject: Re: Fwd: Problem with recv syscall on ...
    Denis PerchineDenis Perchine
    Jun 27, 2000 at 4:45 pm
    Jul 5, 2000 at 6:01 pm
  • I'm about halfway done with revising backend memory management per the discussions on pghackers around the end of April (see the just-committed src/backend/utils/mmgr/README for latest version of the ...
    Tom LaneTom Lane
    Jun 28, 2000 at 5:04 pm
    Jul 1, 2000 at 2:57 pm
  • After further thought I think there's a lot of merit in Hiroshi's opinion that physical file names should not be tied to relation OID. If we use a separately generated value for the file name, we can ...
    Tom LaneTom Lane
    Jun 16, 2000 at 5:51 pm
    Jun 20, 2000 at 10:51 pm
  • I have prepared the REL7_0_PATCHES tree for 7.0.1. Here are the changes. --------------------------------------------------------------------------- Release 7.0.1 This is basically a cleanup release ...
    Bruce MomjianBruce Momjian
    Jun 1, 2000 at 5:15 am
    Jun 6, 2000 at 7:34 am
  • I'm in the process of fixing build problems in 7.0.2 for Solaris CC (not GCC). 1. I'm curious why src/template/solaris_sparc_cc contains: -DDISABLE_COMPLEX_MACRO src/templates/solaris_i386_cc does ...
    Pgsql-hackersPgsql-hackers
    Jun 28, 2000 at 3:17 am
    Oct 12, 2000 at 2:42 pm
  • I'm making consistent accessor functions to all of the special file names used in the backend (e.g., "pg_hba.conf", "pg_control", etc.) and I got to the pid file stuff. I'm wondering why you call the ...
    Peter EisentrautPeter Eisentraut
    Jun 23, 2000 at 4:14 pm
    Jun 26, 2000 at 12:44 pm
  • Something changed in 7.02 from 6.3. I used to do this: CREATE FUNCTION make_date() RETURNS opaque AS '/usr/pgsql/modules/make_date.so' LANGUAGE 'c'; CREATE TRIGGER make_edate BEFORE INSERT OR UPDATE ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Jun 16, 2000 at 12:43 pm
    Jun 22, 2000 at 1:59 pm
  • I have committed new warning code to alert users who auto-create relations without knowing it. The new code does not throw a warning for: SELECT pg_language.*; but does throw one for: SELECT ...
    Bruce MomjianBruce Momjian
    Jun 3, 2000 at 4:40 am
    Jun 5, 2000 at 12:15 am
  • Attached is a first attempt at implementing the classoid feature. It works! Can the postgres gurus comment if I've done it right and point out any problems. A lot of it was guess work so I'm sure it ...
    Chris BitmeadChris Bitmead
    Jun 24, 2000 at 3:26 pm
    Oct 10, 2000 at 10:24 pm
  • I've started doing a bit of work on gram.y, and am noticing some new cruftiness in the Makefile: if I add tokens to gram.y/keywords.c then I can't just remake in that directory since parse.h is not ...
    Thomas LockhartThomas Lockhart
    Jun 26, 2000 at 1:36 pm
    Jul 2, 2000 at 3:15 pm
  • The problem here is that given the search pattern '\341%', the planner generates index limit conditions name = '\341' AND name < '\342'; Apparently, in CZ locale it is true that '\341' is less than ...
    Tom LaneTom Lane
    Jun 8, 2000 at 2:22 am
    Jun 9, 2000 at 8:10 pm
  • A minor nasty error I got when trying to improve the query used to disable triggers: create table t1(f1 int4, f2 int4); create table t2(f1 int4, f2 int4); insert into t1 values(1, 0); insert into t1 ...
    Philip WarnerPhilip Warner
    Jun 30, 2000 at 11:55 am
    Dec 5, 2001 at 9:05 pm
  • Can someone give me a TODO summary for this issue? [ Charset ISO-8859-1 unsupported, converting... ] -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your ...
    Bruce MomjianBruce Momjian
    Jun 9, 2000 at 8:31 pm
    Oct 3, 2000 at 4:16 am
  • afaik, no. I've got a Mandrake 7.0.x machine at home, and a 7.0 laptop which is apparently not quite the same thing since one was upgraded from 6.1 and the other was a clean install. But my laptop ...
    Thomas LockhartThomas Lockhart
    Jun 14, 2000 at 12:35 pm
    Jun 23, 2000 at 8:12 pm
  • We have for same questions different answers now: (DAY OF WEEK) test=# select date_part('dow', now()); date_part ----------- 1 (1 row) test=# select to_char(now(), 'D'); to_char --------- 2 (1 row) ...
    Karel ZakKarel Zak
    Jun 5, 2000 at 8:53 pm
    Jun 13, 2000 at 1:15 pm
  • Hi, I know it doesn't show in a patch, but.. there are some rogue spaces at the end of the line containing "usecreatetable". Keith. *** pgsql/src/bin/initdb/initdb.sh Fri Jun 9 18:09:51 2000 --- ...
    Keith ParksKeith Parks
    Jun 9, 2000 at 11:13 pm
    Jun 12, 2000 at 4:08 pm
  • Can someone comment on where we are with DROP COLUMN? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ ...
    Bruce MomjianBruce Momjian
    Jun 8, 2000 at 3:09 am
    Jun 9, 2000 at 12:09 am
  • Hello, newbie here. I need 64-bit sequences. I started looking at sequence.h, sequence.c, and some other files, and I have some questions before I start mucking up your code. :-) (I'd rather do it ...
    Paul CaskeyPaul Caskey
    Jun 23, 2000 at 3:32 am
    Jul 5, 2000 at 9:35 pm
  • I have a query crashing the backend and leaving this message in the server log... What does exit status 139 mean? Better still would be a pointer to some documentation for error codes if such beast ...
    Ed LoehrEd Loehr
    Jun 23, 2000 at 6:11 pm
    Jun 26, 2000 at 11:51 am
  • I've seen a number of RDBMSs that require that an entire database (whatever they call a database) has to be in the same code page. There are disadvantages in this. With those disadvantages in mind ...
    Randall ParkerRandall Parker
    Jun 21, 2000 at 9:23 pm
    Jun 22, 2000 at 10:30 pm
  • I just upgraded to 7.0.2. Everything looks fine, except for one (annoying) change. I have an attribute in a table named "significance_of_anova_for_spike_rates". (I know, I know. I get laughed at all ...
    G. Anthony ReinaG. Anthony Reina
    Jun 14, 2000 at 1:23 am
    Jun 16, 2000 at 2:05 am
  • Hi all, I regularly do a "cvs update" and compile and test PostgreSQL. Recently, since about 1 week, I've had a nasty problem. Doing an "initdb" seems to suck up all available memory and almost kills ...
    Keith ParksKeith Parks
    Jun 1, 2000 at 8:32 pm
    Jun 3, 2000 at 2:50 am
  • Hi all, I've had a table for years to keep radius connections to our NAS. Not havin inet type, I typed ip_adress as text. Now, I'em trying to change this column type to no avail. select ...
    Olivier PRENANTOlivier PRENANT
    Jun 2, 2000 at 4:27 pm
    Jun 2, 2000 at 10:32 pm
  • Hi folks, This is my first post to your list. I've been reading it for about a week. I like the quality of the developers here and think this portends well for the future of Postgres. Anyway, an ...
    Randall ParkerRandall Parker
    Jun 21, 2000 at 8:12 pm
    Jun 22, 2000 at 11:39 am
  • In the following archived email: http://www.postgresql.org/mhonarc/pgsql-admin/2000-05/msg00025.html this was posed as a solutions to modifying the NOT NULL constraint: I didn't find any further ...
    Dan WilsonDan Wilson
    Jun 14, 2000 at 3:27 am
    Jun 14, 2000 at 11:07 pm
  • Hello all, While digging the code I found out quite interesting comment in src/backend/access/heap/hio.c before function RelationPutHeapTupleAtEnd * Eventually, we should cache the number of blocks ...
    Denis PerchineDenis Perchine
    Jun 12, 2000 at 5:38 pm
    Jun 13, 2000 at 3:03 am
  • Is PostgreSQL going to start using odd release numbers for development versions? This is how the Linux kernel is, and some other projects. Version.release.revision/build Like 7.0.x would be the ...
    Robert B. EasterRobert B. Easter
    Jun 6, 2000 at 3:44 pm
    Jun 7, 2000 at 3:13 am
  • Yes, only Bruce and I are of the opinion that it *is* an Error, and I guess we want some consensus. The notice is imho of the sort: notice this syntax is going to be disallowed soon. Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Jun 5, 2000 at 8:03 am
    Jun 6, 2000 at 4:31 pm
  • Hello, This is a report on my attempts to install unixODBC (1.8.9) and postgres odbc driver on IRIX 6.5.7 64bit using the native compiler. There are a number of changes that were necessary to be made ...
    Murad NayalMurad Nayal
    Jun 14, 2000 at 8:27 pm
    Jun 15, 2000 at 7:13 pm
  • Who's maintaining the ODBC configure and build stuff? There's a grave issue with ODBC linking in all kinds of makefiles, templates, header files, etc. from the main Postgres configure process. That ...
    Peter EisentrautPeter Eisentraut
    Jun 5, 2000 at 12:15 am
    Jun 13, 2000 at 3:02 pm
  • Can anyone comment on this work? Karel? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your ...
    Bruce MomjianBruce Momjian
    Jun 13, 2000 at 12:32 am
    Jun 13, 2000 at 9:02 am
  • http://linuxworld.com/linuxworld/lw-2000-06/lw-06-S390-3.html This article, while on the subject of Linux for IBM System/390 mainframes, also notes that PostgreSQL was easily brought up on that ...
    Lamar OwenLamar Owen
    Jun 22, 2000 at 8:17 pm
    Jun 25, 2000 at 2:08 am
  • In looking at the INSTALL/install.sgml files, I see that there are no instructions for removing the /data directory after the backup, so initdb will succeed. Should that be suggested after the backup ...
    Bruce MomjianBruce Momjian
    Jun 5, 2000 at 10:59 am
    Jun 8, 2000 at 5:12 pm
  • Hello all, I did small patch for subj. I am sure that it is not perfect, but it works for me. I will continue its testing. This is my first patch to pgsql. If you will find some obvious mistakes, do ...
    Denis PerchineDenis Perchine
    Jun 10, 2000 at 11:05 pm
    Oct 3, 2000 at 3:45 am
  • Please note that as I've just moved home, my home internet connection is not up at the moment, so it's better to send emails about the JDBC driver to my work's address: petermount@it.maidstone.gov.uk ...
    Peter MountPeter Mount
    Jun 26, 2000 at 8:06 am
    Jul 12, 2000 at 11:36 am
  • I see mention in SQL99 of function definitions which can have IN, OUT, and INOUT arguments. Any thoughts on how this could be supported in Postgres? I assume that we would need to figure out how to ...
    Thomas LockhartThomas Lockhart
    Jun 27, 2000 at 2:39 am
    Jun 27, 2000 at 3:43 pm
  • Please help! Unfortunetely I gave numbers for user names (column "usename" in pg_shadow). Now in 7.0 we have ALTER GROUP, but the statement test=# ALTER GROUP anygroup ADD USER 1234; where 1234 can ...
    Kovacs Zoltan SandorKovacs Zoltan Sandor
    Jun 22, 2000 at 8:45 pm
    Jun 24, 2000 at 10:15 am
  • inside the backend, if I have a TupleTableSlot, can I find out from what basetable it is referring to or not?
    Chris BitmeadChris Bitmead
    Jun 23, 2000 at 12:42 am
    Jun 23, 2000 at 8:33 am
  • Current cvs compiled on Solaris gives the following error... In file included from ../../include/tcop/tcopprot.h:22, from pg_proc.c:26: /usr/include/setjmp.h:70: conflicting types for `jmp_buf' ...
    Chris BitmeadChris Bitmead
    Jun 19, 2000 at 1:43 am
    Jun 19, 2000 at 6:55 am
  • I have 2 tables with indices as follows: Table "activity" (~4000 rows) id serial start_time timestamp not null stop_time timestamp not null ... CREATE INDEX activity_start_time ON activity ...
    Ed LoehrEd Loehr
    Jun 16, 2000 at 5:32 pm
    Jun 16, 2000 at 10:48 pm
  • Maybe Tom Lane can comment on wither it also has setproctitle(). -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
    Bruce MomjianBruce Momjian
    Jun 13, 2000 at 9:00 am
    Jun 14, 2000 at 3:38 am
  • Hi, Can you tell me trim() spec, please ? (This problem has been discussed in pgsql-jp ML. ) In trim(trailing 'abc' from '123cbabc') function, 'abc' means ~'[abc]'. pgbash select trim(trailing 'abc' ...
    SAKAIDA MasaakiSAKAIDA Masaaki
    Jun 3, 2000 at 3:22 am
    Jun 13, 2000 at 3:26 pm
  • Not sure this belongs in the FAQ. Seems more of a web page thing. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
    Bruce MomjianBruce Momjian
    Jun 1, 2000 at 1:23 am
    Jun 2, 2000 at 11:42 pm
Group Navigation
period‹ prev | Jun 2000 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions223
posts1,283
users124
websitepostgresql.org...
irc#postgresql

124 users for June 2000

Tom Lane: 241 posts Bruce Momjian: 234 posts Peter Eisentraut: 85 posts Hiroshi Inoue: 61 posts Andreas Zeugswetter: 52 posts Thomas Lockhart: 46 posts The Hermit Hacker: 38 posts Lamar Owen: 35 posts Philip Warner: 30 posts Karel Zak: 29 posts Chris Bitmead: 26 posts Don Baccus: 24 posts Giles Lean: 20 posts Jan Wieck: 17 posts Tatsuo Ishii: 17 posts Ed Loehr: 16 posts Peter Eisentraut: 14 posts Mikheev, Vadim: 13 posts Peter Mount: 13 posts Ross J. Reedstrom: 12 posts
show more
Archives