Re: [HACKERS] Verbosity of column definition mismatch error

2005-01-11 Thread Tom Lane
Brendan Jurd <[EMAIL PROTECTED]> writes: > While I was playing around in nodeFunctionscan.c, I noticed what seems > to be a minor bug in the latest CVS version. If you get the column > definition wrong in your query, the error displays twice. Not here. I think you've got postmaster stderr poin

Re: [HACKERS] problem with casts dump/restore

2005-01-11 Thread John Hansen
I have not had time to install RC4 / RC5 yet, but have anyone tried this: Createdb -Eunicode test Psql test -c 'create table foo (bar text); Then connect using libpq, and in your software application (C) pqexec something like: 'set client_encoding=ascii' Insert into foo(bar) values('some text w

Re: [HACKERS] problem with casts dump/restore

2005-01-11 Thread Merlin Moncure
> "Merlin Moncure" <[EMAIL PROTECTED]> writes: > > The reason why I did that to begin with was to be able to do some > > in-query processing on a xid. Is it intentional that oid has a built in > > cast to integer and xid does not? > > I'm not sure how intentional it is, but doing integer arithmet

[HACKERS] PostgreSQL 8.0.0 Release Candidate 5

2005-01-11 Thread Marc G. Fournier
Due to several small, and one fairly large, bugs that were found in Release Candidate 4, we have been forced to release our 5th Release (and hopefully last) Candidate so that we can get some proper testing in on the changes before release. A current list of *known* supported platforms can be fo

Re: [HACKERS] problem with casts dump/restore

2005-01-11 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > The reason why I did that to begin with was to be able to do some > in-query processing on a xid. Is it intentional that oid has a built in > cast to integer and xid does not? I'm not sure how intentional it is, but doing integer arithmetic on XIDs s

[HACKERS] buildfarm switching servers

2005-01-11 Thread Andrew Dunstan
The buildfarm server has changed to a new (bigger, faster, better) server. There might be odd discrepancies, which will be resolved in a day or two when I reconcile and merge the two databases. Thanks for your patience andrew ---(end of broadcast)-

Re: [HACKERS] problem with casts dump/restore

2005-01-11 Thread Merlin Moncure
> "Merlin Moncure" <[EMAIL PROTECTED]> writes: > > I just noticed that pg_dump does not seem to be exporting at least one > > of my user defined casts...In particular, this one: > > > CREATE CAST (xid AS oid) > > WITHOUT FUNCTION; > > This is per design, more or less: > > /* > * As pe

Re: [HACKERS] problem with casts dump/restore

2005-01-11 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > I just noticed that pg_dump does not seem to be exporting at least one > of my user defined casts...In particular, this one: > CREATE CAST (xid AS oid) > WITHOUT FUNCTION; This is per design, more or less: /* * As per discussion we dump c

Re: [HACKERS] RC5 Bundled ...

2005-01-11 Thread Michael Fuhr
On Tue, Jan 11, 2005 at 11:25:54AM -0500, Bruce Momjian wrote: > Tom Lane wrote: > > > > The latest bug report reminded me that our standard test suite doesn't > > exercise pg_dump at all. Please do try to beat on RC5's pg_dump over > > the next week and see if it does the right things. > > The

[HACKERS] problem with casts dump/restore

2005-01-11 Thread Merlin Moncure
I just noticed that pg_dump does not seem to be exporting at least one of my user defined casts...In particular, this one: CREATE CAST (xid AS oid) WITHOUT FUNCTION; On a sort of related note, I noticed that pgAdmin 2.0 generates this code in the SQL window for the above cast... CREATE CAST (x

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Bruce Momjian
Darcy Buskermolen wrote: > On January 11, 2005 08:34 am, Alvaro Herrera wrote: > > On Tue, Jan 11, 2005 at 08:13:01AM -0800, Joshua D. Drake wrote: > > > Darcy Buskermolen wrote: > > > >IBM has just announced they are waving all rights and providing access > > > > to 500 patents. In the list of 50

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
On January 11, 2005 08:34 am, Alvaro Herrera wrote: > On Tue, Jan 11, 2005 at 08:13:01AM -0800, Joshua D. Drake wrote: > > Darcy Buskermolen wrote: > > >IBM has just announced they are waving all rights and providing access > > > to 500 patents. In the list of 500 there are several that relate RDB

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
On January 11, 2005 08:32 am, Darcy Buskermolen wrote: > On January 11, 2005 08:13 am, you wrote: > > Darcy Buskermolen wrote: > > >IBM has just announced they are waving all rights and providing access > > > to 500 patents. In the list of 500 there are several that relate RDBMS > > > and query op

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Alvaro Herrera
On Tue, Jan 11, 2005 at 08:13:01AM -0800, Joshua D. Drake wrote: > Darcy Buskermolen wrote: > > >IBM has just announced they are waving all rights and providing access to > >500 patents. In the list of 500 there are several that relate RDBMS and > >query optimizations, it may be worth a look. >

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
On January 11, 2005 08:13 am, you wrote: > Darcy Buskermolen wrote: > >IBM has just announced they are waving all rights and providing access to > > 500 patents. In the list of 500 there are several that relate RDBMS and > > query optimizations, it may be worth a look. > > > > > >http://www.ibm.co

Re: [HACKERS] RC5 Bundled ...

2005-01-11 Thread Bruce Momjian
Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > And available on the main FTP server ... > > The latest bug report reminded me that our standard test suite doesn't > exercise pg_dump at all. Please do try to beat on RC5's pg_dump over > the next week and see if it does the ri

Re: [HACKERS] Returning multiple rowsets from a function

2005-01-11 Thread Bruno Wolff III
On Mon, Jan 10, 2005 at 14:30:36 -0800, David Fetter <[EMAIL PROTECTED]> wrote: > Kind people, > > I've got an issue that must have come up before. Here's the use case: > > Middleware sends in a person_id. > Back-end returns several rowsets: address, email, phone, each of > independent, variab

Re: [HACKERS] IBM releases 500 patents

2005-01-11 Thread Joshua D. Drake
Darcy Buskermolen wrote: IBM has just announced they are waving all rights and providing access to 500 patents. In the list of 500 there are several that relate RDBMS and query optimizations, it may be worth a look. http://www.ibm.com/news/us/en/2005/01/patents.html Except in the event of a

[HACKERS] IBM releases 500 patents

2005-01-11 Thread Darcy Buskermolen
IBM has just announced they are waving all rights and providing access to 500 patents. In the list of 500 there are several that relate RDBMS and query optimizations, it may be worth a look. http://www.ibm.com/news/us/en/2005/01/patents.html -- Darcy Buskermolen Wavefire Technologies Corp. ph

Re: [HACKERS] tsearch2 portability bug

2005-01-11 Thread Oleg Bartunov
Tom, we think we could return to this issue later, because doing such change without careful testing would be risky. Of course, it's attractive to combine changes with upcoming release, because people would initdb in anyway, but currently we couldn't give enough attention to testing. Oleg On