> I'd be inclined to handle it similarly to the way that Tatsuo did with
> conversion_procs: let collations be represented by comparison functions
> that meet some suitable API. I think that trying to represent such a
> table as an SQL table compactly will be a nightmare, and trying to
> access it
Oliver Elphick wrote:
I'm pretty sure I saw a reference within the last 3 or 4 weeks on one of
the mailing lists to a script that would put in place, after an upgrade
to 7.3, dependency information that would have been automatically
created if the schema had been created ab initio in 7.3. However
I'm pretty sure I saw a reference within the last 3 or 4 weeks on one of
the mailing lists to a script that would put in place, after an upgrade
to 7.3, dependency information that would have been automatically
created if the schema had been created ab initio in 7.3. However, I
can't find it in a
I don't have the kit, but I do have a playstation 2. If someone would be
willing to donate a kit I'd be willing to try and get it to compile. :-)
Robert Treat
On Mon, 2002-11-18 at 16:51, Justin Clift wrote:
> Hi everyone,
>
> We know PostgreSQL will compile and run on the Sony Playstation 2, an
Hi everyone,
We know PostgreSQL will compile and run on the Sony Playstation 2, and
we now have the opportunity to include pre-compiled PostgreSQL RPM's
(for the Playstation 2 Linux kit) on the Sony site, as part of the
"Compiled For Your Convenience" collection.
Now, we just need someone with th
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I am trying to figure out which is the best way to store custom collation
> tables on a PostgreSQL server system, and what kind of interface to
> provide to users to allow them to create their own.
> A collation table essentially consists of a mapping
On Mon, 18 Nov 2002, Peter Eisentraut wrote:
> A collation table essentially consists of a mapping 'character code ->
> weight' for every character in the set and some additional considerations
> for one-to-many and many-to-one mappings, plus a few feature flags.
>
> How would a user go about cre
Haris Peco wrote:
> On Monday 18 November 2002 05:46 pm, Bruce Momjian wrote:
> > Haris Peco wrote:
> > > > > great.
> > > > > Is it possible with savepoints next :
> > > > > when am I in transaction and any command is error - only this command
> > > > > is lost and I continue normal ?
> > > >
> >
Morning all ...
Well, we're finally coming to the end of yet another release cycle ...
right now, baring any problems creeping up, we're planning on packaging up
RC2 on Friday morning, with an announcement going out that evening for ppl
to test and confirm everything is okay.
If *no* commits
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Hmm ... now that's an interesting thought. So the input converter would
>> actively strip trailing blanks, output would add them back,
> But how would the output know how many to put back?
The output routine would need access to
I said:
> "Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
>> One alternate possible approach would maybe be to change the on-disk
>> representation to really be binary compatible and change the input
>> output and operator functions ?
> Seems like a great idea to me.
On further thought I
Bruce Momjian writes:
> To get into the FAQ, it should be something that happens _frequently_,
Just check the pgsql-cygwin archives. We really need a separate list of
Constantly Asked Questions for this.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
Tom Lane writes:
> Hmm ... now that's an interesting thought. So the input converter would
> actively strip trailing blanks, output would add them back,
But how would the output know how many to put back?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)--
I am trying to figure out which is the best way to store custom collation
tables on a PostgreSQL server system, and what kind of interface to
provide to users to allow them to create their own.
A collation table essentially consists of a mapping 'character code ->
weight' for every character in th
On Sun, Nov 17, 2002 at 15:19:54 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > For 7.4 I would like to add a function for importing float8 values
> > into cube. But because the cube data type is variable length I am
> > not sure what a good approach
On Monday 18 November 2002 05:46 pm, Bruce Momjian wrote:
> Haris Peco wrote:
> > > > great.
> > > > Is it possible with savepoints next :
> > > > when am I in transaction and any command is error - only this command
> > > > is lost and I continue normal ?
> > >
> > > Yes, that will be part of it.
Haris Peco wrote:
> > > great.
> > > Is it possible with savepoints next :
> > > when am I in transaction and any command is error - only this command
> > > is lost and I continue normal ?
> >
> > Yes, that will be part of it. I am working on my proposal today.
> Fine.What about cursor out of a tr
On Monday 18 November 2002 05:38 pm, Bruce Momjian wrote:
> Haris Peco wrote:
> > On Monday 18 November 2002 03:45 pm, Bruce Momjian wrote:
> > > Haris Peco wrote:
> > > > On Monday 18 November 2002 02:38 pm, Tom Lane wrote:
> > > > > snpe <[EMAIL PROTECTED]> writes:
> > > > > > is it planed curs
Haris Peco wrote:
> On Monday 18 November 2002 03:45 pm, Bruce Momjian wrote:
> > Haris Peco wrote:
> > > On Monday 18 November 2002 02:38 pm, Tom Lane wrote:
> > > > snpe <[EMAIL PROTECTED]> writes:
> > > > > is it planed cursor out of a transaction in 7.4 ?
> > > >
> > > > I do not think we wil
On Monday 18 November 2002 03:45 pm, Bruce Momjian wrote:
> Haris Peco wrote:
> > On Monday 18 November 2002 02:38 pm, Tom Lane wrote:
> > > snpe <[EMAIL PROTECTED]> writes:
> > > > is it planed cursor out of a transaction in 7.4 ?
> > >
> > > I do not think we will allow cross-transaction cursor
Alvaro Herrera wrote:
> On Sun, Nov 17, 2002 at 04:42:01PM -0500, Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > In looking at the CLUSTER ALL patch I have applied, I am now wondering
> > > why the ALL keyword is used. When we do VACUUM, we don't use ALL.
> > > VACUUM vacuums
On Monday, November 18, 2002, at 08:58 AM, Tom Lane wrote:
Thinking about this, it occurs to me that there's no good reason why
we couldn't allow parameter symbols ($n) to be considered type UNKNOWN
initially. The type interpretation algorithms would then treat them
just like quoted literal con
David Wheeler <[EMAIL PROTECTED]> writes:
> On Monday, November 18, 2002, at 08:19 AM, Tom Lane wrote:
>> There are various ways to retrieve the datatypes of the columns of a
>> table, but I'm not sure how that helps you to determine the parameter
>> types for an arbitrary SQL command to be prepar
> > is it planed cursor out of a transaction in 7.4 ?
>
> I do not think we will allow cross-transaction cursors ever.
> What would
> it mean to have a cross-transaction cursor, anyway? Does it show a
> frozen snapshot as of the time it was opened? The usefulness of that
> seems awfully low
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > + Deletions are handled by getting a super-exclusive lock on the target
> >page, so that no other backend has a pin on the page when the deletion
> >starts. This means no scan is pointing at the page. This is OK for
> >deleting leaf it
Jason Tishler wrote:
> Bruce,
>
> On Mon, Nov 18, 2002 at 10:42:30AM -0500, Bruce Momjian wrote:
> > To get into the FAQ, it should be something that happens _frequently_,
> > hence FAQ.
>
> Understood. That is why is said "for consideration."
>
> > Fact is, cygwin may not even be needed in 7.4
Bruce,
On Mon, Nov 18, 2002 at 10:42:30AM -0500, Bruce Momjian wrote:
> To get into the FAQ, it should be something that happens _frequently_,
> hence FAQ.
Understood. That is why is said "for consideration."
> Fact is, cygwin may not even be needed in 7.4 because we are
> working on a native p
Haris Peco wrote:
> On Monday 18 November 2002 02:38 pm, Tom Lane wrote:
> > snpe <[EMAIL PROTECTED]> writes:
> > > is it planed cursor out of a transaction in 7.4 ?
> >
> > I do not think we will allow cross-transaction cursors ever. What would
> > it mean to have a cross-transaction cursor, an
To get into the FAQ, it should be something that happens _frequently_,
hence FAQ. Fact is, cygwin may not even be needed in 7.4 because we are
working on a native port.
---
Jason Tishler wrote:
> Richard,
>
> On Sat, Nov 1
On Monday 18 November 2002 02:38 pm, Tom Lane wrote:
> snpe <[EMAIL PROTECTED]> writes:
> > is it planed cursor out of a transaction in 7.4 ?
>
> I do not think we will allow cross-transaction cursors ever. What would
> it mean to have a cross-transaction cursor, anyway? Does it show a
> frozen
snpe <[EMAIL PROTECTED]> writes:
> is it planed cursor out of a transaction in 7.4 ?
I do not think we will allow cross-transaction cursors ever. What would
it mean to have a cross-transaction cursor, anyway? Does it show a
frozen snapshot as of the time it was opened? The usefulness of that
"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> One alternate possible approach would maybe be to change the on-disk
> representation to really be binary compatible and change the input
> output and operator functions ?
Hmm ... now that's an interesting thought. So the input converter
Richard Pais <[EMAIL PROTECTED]> wrote:
>
>Just an explanation in the FAQ that the ipc-daemon is not running won't suffice.
>Because in my case I had ipc-daemon (version 1.11) running and it still hung (Jason's
>patch reported the IpcMemoryCreate error). Only when I downgraded to version 1.09
Just an explanation in the FAQ that the ipc-daemon is not running won't suffice. Because in my case I had ipc-daemon (version 1.11) running and it still hung (Jason's patch reported the IpcMemoryCreate error). Only when I downgraded to version 1.09 (office) and upgraded to 1.13 (home) did initdb
On Sat, 2002-11-16 at 15:49, Alvaro Herrera wrote:
> On Fri, Nov 15, 2002 at 11:43:47AM -0500, Rod Taylor wrote:
>
> > Below is a summary of what pg_depend tracks that might be useful.
> > Skipped a number of dependencies that are internal only (ie. toast table
> > dependencies) as they will be r
Hello,
is it planed cursor out of a transaction in 7.4 ?
Thanks
Haris Peco
On Monday 18 November 2002 12:30 am, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Let's just fix it and roll an RC2 with the fix. If not, we can just fix
> > it in 7.3.1 but I see little problem in roll
Richard,
On Sat, Nov 16, 2002 at 02:27:22PM -0800, Richard Pais wrote:
> Just an explanation in the FAQ that the ipc-daemon is not running
> won't suffice. Because in my case I had ipc-daemon (version 1.11)
> running and it still hung (Jason's patch reported the IpcMemoryCreate
> error). Only wh
> I've gotten really tired of explaining to newbies why stuff involving
> char(n) fields doesn't work like they expect. Our current behavior is
> not valid per SQL92 anyway, I believe.
>
> I think there is a pretty simple solution now that we have pg_cast:
> we could stop treating char(n) as bin
38 matches
Mail list logo