Re: [HACKERS] Open 7.1 items

2001-01-30 Thread Peter Mount
At 15:02 29/01/01 -0500, Bruce Momjian wrote: >LAZY VACUUM (Vadim) >Runtime btree recovery (Vadim) >JDBC setMaxRows() is global variable affecting other objects Now fixed. When called from within a Statement it uses its maxrows value, but internal queries don't have a restriction. >JDBC LargeOb

[HACKERS] Re: Re: [GENERAL] Trouble porting postgreSQL to WinNT

2001-01-30 Thread Peter Mount
At 14:07 30/01/01 -0600, Fred Yankowski wrote: >On Tue, Jan 30, 2001 at 09:41:11AM -0800, Barry Lind wrote: > > Yes I had the same problem, but for me the reason was that I forgot to > > start the ipc-daemon before running initdb. Last night I had no > > problems installing beta4 on WinNT 4.0. >

Re: [HACKERS] Size of TODO.detail

2001-01-30 Thread Lamar Owen
Bruce Momjian wrote: >Lamar Owen wrote: > > Yow! Nice stuff in there, that is for sure. Of course, that's alot of > > space. What to do? Remove all the unnecessary e-mail headers? > I just tried 'printmail' that strips off most of the unused stuff: [...] > Doesn't seem like it saves enough,

[HACKERS] Re: Re: [GENERAL] Trouble porting postgreSQL to WinNT

2001-01-30 Thread Fred Yankowski
On Tue, Jan 30, 2001 at 09:41:11AM -0800, Barry Lind wrote: > Yes I had the same problem, but for me the reason was that I forgot to > start the ipc-daemon before running initdb. Last night I had no > problems installing beta4 on WinNT 4.0. Also, AFAICT, ipc-daemon must be running under the same

Re: [HACKERS] pg_shadow overusage

2001-01-30 Thread Rod Taylor
My mistake. The index on pg_shadow breaks nearly everything. I can have triggers maintain this effectively enough for my needs however. However, whether or not the number of users I want to add is going to be too much is still a question. -- Rod Taylor There are always four sides to every st

[HACKERS] pg_shadow overusage

2001-01-30 Thread Rod Taylor
I'd like to keep a complete history of everything that users of the system does from the database level (as there are a number of applications, and backend workers). I've done this through various rules, triggers. The next step is to try to tie a name to it. getpgusername() supplies that perfec

[HACKERS] Like vs '=' bug with indexing

2001-01-30 Thread m w
I am reposting this because I'm not sure it actually made it to the list. I have a function to transform text into a pseudo-metaphone variable, take this example: cddbsql=# select song, metatext(song) from cdsongs where metatext(song) like metatext('born to run') limit 3 ; song | metate

[SQL] Re: [HACKERS] 7.1beta4 bug creating a certain table

2001-01-30 Thread Stephan Szabo
On Tue, 30 Jan 2001, Kovacs Zoltan wrote: > > It appears to me that this is correct, since there is no constraint > > on the first column that says that those three columns form a unique > > key *by themselves*. I believe there were bugs in the code that checked > > for this error before ... > >

Re: [HACKERS] Re: [GENERAL] Trouble porting postgreSQL to WinNT

2001-01-30 Thread Barry Lind
Peter, Yes I had the same problem, but for me the reason was that I forgot to start the ipc-daemon before running initdb. Last night I had no problems installing beta4 on WinNT 4.0. thanks, --Barry Peter T Mount wrote: > > Quoting Tom Lane <[EMAIL PROTECTED]>: > > > This doesn't make any sen

Re: [HACKERS] Size of TODO.detail

2001-01-30 Thread Bruce Momjian
> Bruce Momjian wrote: > > > > pgsql/docs/TODO.detail now is 1.1MB. I just removed 'subquery' which > > shrunk it from 1.5MB. Comments? > > Yow! Nice stuff in there, that is for sure. Of course, that's alot of > space. What to do? Remove all the unnecessary e-mail headers? > Signatures? e

[SQL] Re: [HACKERS] 7.1beta4 bug creating a certain table

2001-01-30 Thread Kovacs Zoltan
On Mon, 29 Jan 2001, Tom Lane wrote: > Kovacs Zoltan <[EMAIL PROTECTED]> writes: > > CREATE TABLE pakolas_cikktetel ( > > pakolas int4 not null, > > cikk int4 not null, > > minoseg int4 not null, > > sorszam int4 check (sorszam > 0), > > helyrol int4, > > helyre int4, > >

[HACKERS] I'm off

2001-01-30 Thread Jan Wieck
Hi, headed for LinuxWorld now. Will be back on the lists on Monday 5th. Take care. Jan -- #==# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me.

Re: [HACKERS] Like vs '='

2001-01-30 Thread m w
In 7.1 the row limit is not as big a deal because of tuple toaster. I had a 7.0 database that needed the row limit change, in 7.1 it does not seem too. But if you want to chang it anyway, in config.h, look for this line: #define BLCKSZ 8192 It can be made as large as 32768. --- Manuel Cabido

Re: [HACKERS] BLOB HOWTO??

2001-01-30 Thread Franck Martin
I'm interested by TOAST, and I have asked several questions on the subject... I haven't tested them yet... First I thought that the type bytea allows storing of binary data, a BSOB (Binary Small OBject). Secondly that by using a binary cursor you have access to the raw data as it is stored in the

[HACKERS] Re: [GENERAL] Trouble porting postgreSQL to WinNT

2001-01-30 Thread Peter T Mount
Quoting Tom Lane <[EMAIL PROTECTED]>: > This doesn't make any sense, since genbki.sh has nothing to do with > creating the fmgr.h file. I think your rebuild probably cleaned up > something else ... hard to tell what though. On a similar vein, is anyone seeing initdb hanging under NT? So far eve