[HACKERS] SnapshotNow == (Snapshot) NULL, seems bad

2004-09-05 Thread Tom Lane
With the current definitions of the "special" snapshot values: #define SnapshotNow ((Snapshot) 0x0) #define SnapshotSelf ((Snapshot) 0x1) #define SnapshotAny ((Snapshot) 0x2) #define SnapshotToast((Snapshot) 0x3) it is not possible

Re: [HACKERS] AIX and v8 beta1

2004-09-05 Thread Rod Taylor
On Sun, 2004-09-05 at 13:43, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > collect2: ld returned 254 exit status > > That's a fairly unhelpful error message, isn't it? > > I'm thinking that this may be due to having added the timezone > library to the backend link, but I really don

[HACKERS] Indexed views?

2004-09-05 Thread Tiago Wright
Are there any plans to support indexed views, or cross-table indexes, or any form of "materialized views" in postgresql? How complex would the implementation be? Indexed views are sometimes the best way to improve the performance of complex queries. -Tiago ---(end of broad

Re: [HACKERS] AIX and v8 beta1

2004-09-05 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > collect2: ld returned 254 exit status That's a fairly unhelpful error message, isn't it? I'm thinking that this may be due to having added the timezone library to the backend link, but I really don't see just how. Afraid you're on your own to identify the

Re: [HACKERS] APR 1.0 released

2004-09-05 Thread Bruce Momjian
Gaetano Mendola wrote: [ PGP not available, raw data follows ] > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Tom Lane wrote: > > | Gaetano Mendola <[EMAIL PROTECTED]> writes: > |>I don't know if APR provide a spin lock mechanism, > | > | > | You don't even know that, but you're confident

Re: [HACKERS] contrib/start-scripts/linux on Debian

2004-09-05 Thread Ryan Kirkpatrick
On Fri, 27 Aug 2004, Peter Eisentraut wrote: > Thomas F.O'Connell wrote: > > I'd love to see a comment added to the linux start-script included in > > contrib that referenced update-rc.d. It's useful to note because > > Debian has different runlevels from Red Hat, and update-rc.d will > > intellig

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-09-05 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greg Stark wrote: > Well there's always \dtS and \dvS I don't see why typing \dfS is any harder. > > It would be nice for this to be more visible in the documentation and the \? > output though. I've only just found it after months of pulling hair

Re: [HACKERS] Adding columns in the middle of tables

2004-09-05 Thread Gaetano Mendola
Christopher Kings-Lynne wrote: I want to clarify this. The point of the core is they won't do it because they have things more important to do, or, the feature will never be part of the postgresql even if someone else contribute it. Maybe i am not capable of contribute it but i will try if the feat

Re: [HACKERS] invalid string enlargment PG 7.4.5 ( SOLVED )

2004-09-05 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola <[EMAIL PROTECTED]> writes: | |>|> ERROR: invalid string enlargement request size 1476395004 |>|> DEBUG: AbortCurrentTransaction |>|> WARNING: AbortTransaction and not in in-progress state |>|> ERROR: could not send

Re: [HACKERS] Developers page is down

2004-09-05 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shahbaz Javeed wrote: | I've always considered a table definition to be an unordered hash so | the concept of putting something in the "middle of a table" from that | view doesn't seem to have a point. | | Just my $0.02 I already wrote my motivation, an