Re: [BUGS] "ERROR: Query-specified return tuple and actual function

2003-01-14 Thread Adam Buraczewski
On Mon, Jan 13, 2003 at 02:52:25PM -0500, Tom Lane wrote:
> Joe Conway <[EMAIL PROTECTED]> writes:
> > Hmmm, looks like nodeFunctionscan.c:tupledesc_mismatch needs to be
> > taught about attisdropped. I'll submit a patch this evening if no one
> > else gets to it first.
> 
> Actually, I believe I deliberately left it like that because I was
> concerned about what would happen in this scenario.

Notice, please, that the bug does not only affect existing functions
returning table rows, it also prevents new functions from being
created.  I think this should not take place.  I can agree that one
should not be able to drop columns when there are some functions using
the table as an argument or return type, but it should be possible to
drop these functions, then drop some columns and create completely new
functions.  And now it ends with an error. :(

Best regards,

-- 
Adam Buraczewski <[EMAIL PROTECTED]> * Linux registered user #165585
GCS/TW d- s-:+>+:- a- C+++() UL$ P++ L E++ W+ N++ o? K? w--
O M- V- PS+ !PE Y PGP+ t+ 5 X+ R tv- b+ DI? D G++ e+++> h r+>++ y?

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[BUGS] Bug #874: Install pgsql on solaris 8 error

2003-01-14 Thread pgsql-bugs
yuxia ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Install pgsql on solaris 8 error 

Long Description
When I have run "initdb -D /sur/local/pgsql/data",it occured "create conversion --core 
dump"

Sample Code


No file was uploaded with this report


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [BUGS] Bug #874: Install pgsql on solaris 8 error

2003-01-14 Thread Justin Clift
Hi Yuxia,

Which version of PostgreSQL is this with, and did you compile PostgreSQL 
yourself?

Regards and best wishes,

Justin Clift


[EMAIL PROTECTED] wrote:
yuxia ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Install pgsql on solaris 8 error 

Long Description
When I have run "initdb -D /sur/local/pgsql/data",it occured "create conversion --core dump"

Sample Code


No file was uploaded with this report


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html