[BUGS] porting on ITANIUM2 platform under HP-UX

2003-02-14 Thread Baffa Mario
System Configuration - Architecture: Itanium2 64bits Operating System: HP-UX 11i v. 1.6 (equivalent 11.22) PostgreSQL version : 7.3.1 Compiler used : gcc 3.0 Please enter a FULL description of your problem:

Re: [BUGS] should be on MacOS

2003-02-14 Thread Bruce Momjian
I have made the attached change to look for pam/pam_appl.h as well as security/pam_appl.h. Fix will appear in 7.4. --- Aaron Hillegass wrote: > I decided to build 7.3.1 on MacOS 10.2.3 with PAM support. > > % ./conf

[BUGS] unsubscribe

2003-02-14 Thread John Liu
unsubscribe ---(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] porting on ITANIUM2 platform under HP-UX

2003-02-14 Thread Tom Lane
Baffa Mario <[EMAIL PROTECTED]> writes: > gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -c tas.s > tas.s: Assembler messages: > tas.s:2: Error: Unsupported variable size or fill value > tas.s:2: Error: Rest of line ignored. First ignored character is `='. > tas.s:3: Error: Unknown pseud

[BUGS] porting on ITANIUM2 platform under HP-UX.

2003-02-14 Thread Baffa Mario
System Configuration - Architecture: Itanium2 64bits Operating System: HP-UX 11i v. 1.6 (equivalent 11.22) PostgreSQL version : 7.3.1 Compiler used : gcc 3.0 Please enter a FULL description of your problem:

[BUGS] Problems with insert rule called from plpython

2003-02-14 Thread Pavel Hanak
Hello, I've noticed one problem by upgrading from postgresql-7.3.1 to 7.3.2. The example of this problem looks like this: create table test (a int, b text); create view testview as select * from test; create or replace rule testview_ins as on insert to testview do instead ( ins

Re: [BUGS] Problems with insert rule called from plpython

2003-02-14 Thread Tom Lane
Pavel Hanak <[EMAIL PROTECTED]> writes: > Now calling "select testfun()" shows this fatal error: >FATAL: SPI: improper call to spi_dest_setup Hm, I'm glad I put in that test --- it exposed a problem. Here is the patch for 7.3. regards, tom lane *** src/backend/exec

[BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Josh Berkus
Affects: 7.1.3, 7.2.1 to 7.2.3, not tested on 7.3.x or 7.4dev Frequency: 100% Reproducable Effect When Occurring: Object Missing from Backup Difficulty of Fix: Unknown For some time, I've been noticing that one of my database projects fails to back up a few functions every time I run pg_dump

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > For some time, I've been noticing that one of my database projects fails to > back up a few functions every time I run pg_dump.I've seen this since > 7.1.3. Finally, I have a sample of the database that invariably refuses to > back up one function

Re: [BUGS] porting on ITANIUM2 platform under HP-UX

2003-02-14 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Ah, seems we need Itanium2-specific test-and-set functions for HPUX, or > perhaps our problem is that HPUX is assumed to be PA-RISC. Both. But until someone contributes some Itanium assembly code, there's little point in generalizing the HPUX config set

Re: [BUGS] porting on ITANIUM2 platform under HP-UX

2003-02-14 Thread Bruce Momjian
Ah, seems we need Itanium2-specific test-and-set functions for HPUX, or perhaps our problem is that HPUX is assumed to be PA-RISC. The problem appears to be coming from /pg/backend/port/hpux/tas.s.template. However, I have to say I don't see any fancy assembly in there. I am confused.

Re: [BUGS] No migration path for MONEY

2003-02-14 Thread Bruce Momjian
Could we use DOMAIN to make MONEY an alias for NUMERIC, perhaps using locale to make it customized, somehow? --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > we need someone to get MONEY working as an extented NUME

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Josh Berkus
Tom, > > For some time, I've been noticing that one of my database projects fails to > > back up a few functions every time I run pg_dump.I've seen this since > > 7.1.3. Finally, I have a sample of the database that invariably refuses to > > back up one function. > > What do you m

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> What do you mean by "refuses"? > The function is silently dropped from the pg_dump file. Is it possible that the function's owner has been dropped from pg_shadow? How about dropped return type, etc? pg_dump used to use inner joins to collect info about

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Josh Berkus
Tom, > Is it possible that the function's owner has been dropped from pg_shadow? No, the function owner is the database owner ... and also the same user calling pg_dump. > How about dropped return type, etc? pg_dump used to use inner joins to > collect info about database objects, meaning it