"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
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!
> >
> >
>
> ___
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
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
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
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
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
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
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