[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

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

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

[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] 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? etc?

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 sense,

[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, mennyi

[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 |

[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

[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] 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

[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] 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, and it

[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. Also,

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