Re: [HACKERS] Ideas needed: How to create and store collation

2002-11-18 Thread Tatsuo Ishii
> 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

Re: [HACKERS] mislaid reference to update script for after 7.3 upgrade

2002-11-18 Thread Joe Conway
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

[HACKERS] mislaid reference to update script for after 7.3 upgrade

2002-11-18 Thread Oliver Elphick
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

Re: [HACKERS] [pgsql-advocacy] Looking for a "Linux on Playstation 2" person

2002-11-18 Thread Robert Treat
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

[HACKERS] Looking for a "Linux on Playstation 2" person to compile PostgreSQL RPM's

2002-11-18 Thread Justin Clift
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

Re: [HACKERS] Ideas needed: How to create and store collation tables

2002-11-18 Thread Tom Lane
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

Re: [HACKERS] Ideas needed: How to create and store collation tables

2002-11-18 Thread Stephan Szabo
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
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 ? > > > > > >

[HACKERS] Final Release Scheduale ...

2002-11-18 Thread Marc G. Fournier
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

Re: [HACKERS] char(n) to varchar or text conversion should strip

2002-11-18 Thread Tom Lane
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

Re: [HACKERS] char(n) to varchar or text conversion should strip trailing spaces

2002-11-18 Thread Tom Lane
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

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-18 Thread Peter Eisentraut
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)---

Re: [HACKERS] char(n) to varchar or text conversion should strip

2002-11-18 Thread Peter Eisentraut
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)--

[HACKERS] Ideas needed: How to create and store collation tables

2002-11-18 Thread Peter Eisentraut
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

Re: [HACKERS] Getting float8 data into cube?

2002-11-18 Thread Bruno Wolff III
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Haris Peco
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.

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Haris Peco
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Haris Peco
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

Re: [HACKERS] CLUSTER ALL syntax

2002-11-18 Thread Bruce Momjian
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

Re: [HACKERS] PREPARE and parameter types (Re: [INTERFACES] DBD::PostgreSQL)

2002-11-18 Thread David Wheeler
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

[HACKERS] PREPARE and parameter types (Re: [INTERFACES] DBD::PostgreSQL)

2002-11-18 Thread Tom Lane
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Zeugswetter Andreas SB SD
> > 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

Re: [HACKERS] btree shrinking again

2002-11-18 Thread Curtis Faith
> 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

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-18 Thread Bruce Momjian
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

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-18 Thread Jason Tishler
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
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

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-18 Thread Bruce Momjian
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Haris Peco
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Tom Lane
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

Re: [HACKERS] char(n) to varchar or text conversion should strip trailing spaces

2002-11-18 Thread Tom Lane
"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

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-18 Thread S. L.
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

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-18 Thread Richard Pais
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

Re: [HACKERS] pg_dump in 7.4

2002-11-18 Thread Rod Taylor
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

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread snpe
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

Re: [HACKERS] [CYGWIN] ipc-daemon

2002-11-18 Thread Jason Tishler
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

Re: [HACKERS] char(n) to varchar or text conversion should strip trailing spaces

2002-11-18 Thread Zeugswetter Andreas SB SD
> 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