Re: [ADMIN] date is not immutable ?

2003-03-12 Thread Tom Lane
"Gaetano Mendola" <[EMAIL PROTECTED]> writes: > I'm trying to create an index on a timestamptz field just extracting the > date: > # create index idx_user_logs_login_time_date on user_logs ( > date(login_time) ); > ERROR: DefineIndex: index function must be marked IMMUTABLE > why date is not mark

Re: [ADMIN] removal from list

2003-03-12 Thread Marc G. Fournier
what sort of errors? On Mon, 10 Mar 2003, Xue-Feng Yang wrote: > --- Brickley Jeff-RA9607 <[EMAIL PROTECTED]> > wrote: > How can I get off this email list. > > unregister 'email address' > > > > Came back with bogus errors! > > > > > > ___

[ADMIN] Largest filesize under Linux

2003-03-12 Thread Partho Bhowmick
I am working on extending the functionality of PostgreSQL on Linux. I need to know what's the largest filesize for a single file that I can have under Linux? Regards, Partho ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Largest filesize under Linux

2003-03-12 Thread Partho Bhowmick
Well, I am running kernel-2.4.18-26. What's the limit on this baby? "Christopher Browne" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Quoth "Partho Bhowmick" <[EMAIL PROTECTED]>: > > I am working on extending the functionality of PostgreSQL on Linux. > > I need to know what's the

Re: [ADMIN] Largest filesize under Linux

2003-03-12 Thread Byron A Jeff
In article <[EMAIL PROTECTED]>, Partho Bhowmick <[EMAIL PROTECTED]> wrote: -I am working on extending the functionality of PostgreSQL on Linux. -I need to know what's the largest filesize for a single file that I can have -under Linux? The answer is definitive: it depends... There are multiple la

Re: [ADMIN] Largest filesize under Linux

2003-03-12 Thread Leigh W3NLB
The following info is from the SuSE 8.1 Administration Guide, page 467 The table lists both maximum file size and maximum file system size: file system file size file system ext2 & 3 (1kB blocks) ~16 GB 2 TB ext2/3 (2kB blocks) 256 G

Re: [ADMIN] Largest filesize under Linux

2003-03-12 Thread Christopher Browne
Quoth "Partho Bhowmick" <[EMAIL PROTECTED]>: > I am working on extending the functionality of PostgreSQL on Linux. > I need to know what's the largest filesize for a single file that I can have > under Linux? That depends. It depends on the size supported by the filesystem. Usually that's at lea

Re: [ADMIN] Largest filesize under Linux

2003-03-12 Thread Christopher Browne
After a long battle with technology,"Partho Bhowmick" <[EMAIL PROTECTED]>, an earthling, wrote: > Well, I am running kernel-2.4.18-26. What's the limit on this baby? Sounds like you didn't read what I wrote. Which filesystem? Which version of GLIBC? By the way, have your applications been comp

Re: [ADMIN] Largest filesize under Linux

2003-03-12 Thread Byron A Jeff
In article <[EMAIL PROTECTED]>, Partho Bhowmick <[EMAIL PROTECTED]> wrote: -Well, I am running kernel-2.4.18-26. What's the limit on this baby? I strongly suggest that you go read my response to you on this subject. As Christopher pointed out the kernel is only on aspect of determination. I also