[BUGS] Polymorphism in the PostgreSQL object model

2001-07-10 Thread Ganesh Prasad
Let's try to use polymorphism in PostgreSQL. This could be quite a useful feature in many situations. We create two tables, one inheriting from the other, then define functions with the same name on both of them, but with different internal logic. When we call the function on all records of the

[BUGS] Compilation on Solaris 2.8

2001-07-10 Thread Manoj Nair
Hi : I am having problems in compiling Postgres 7.1. I am using the following compilers on Solaris 2.8 on a Sparc Ultra 60 machine. Sun WorkShop 6 update 1 C++ 5.2 2000/09/11 Sun WorkShop 6 update 1 C 5.2 2000/09/11 Is there a port available for this configuration ? Thanks, Manoj Nair

[BUGS] Corrupted index/unique column after vacuuming

2001-07-10 Thread William M. Shubert
Hi. I was running a postgres script that made modifications to a database with a column tagged as UNIQUE, and in the middle ran "vacuumdb --analyze" from another console. "vacuumdb" reported an error along the lines of "duplicate key" (sorry, I did not save the exact error!). After that, all att

Re: [BUGS] Referential Integrity corrupted sometimes by Rules

2001-07-10 Thread José María Fernández González
Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > -- Rule over the referenced table > > -- which breaks referential integrity > > create rule nodelrel > > as on delete to rel > > where old.ref > 3 and user = 'prueba' > > do instead nothing; > Hi Tom, first of all, my congratulations to

[BUGS] shared library compile error

2001-07-10 Thread Carl Anderson
version 7.1.2 using gcc3.0 under solaris 2.7 Compile completes without error but the shared libraries are not realy shared libs. If i link against them (with package such as php or tcl) I get the message "symbol main not found". an inspection using nm -a shows and undefined symbol "main" FIX

Re: [BUGS] sql query cursor problem

2001-07-10 Thread Tom Lane
Risko Peter <[EMAIL PROTECTED]> writes: > It seems we've found a bug in PostgreSQL handling of cursored queries. > I assume that it's legal to do 'fetch backward all in xxx' and then > 'fetch 1 in xxx' afterwards. Backwards scan doesn't work right for any but the simplest sorts of queries (no j

[BUGS] order by and union

2001-07-10 Thread Benoit Lion
In postgres 7.0.2 i have an "order by" with column names like this : select colonne1,colonne2 from A union select colonne1,colonne2 from B order by colonne1,colonne2 In postgres 7.1 this simple example works. But with i have a more difficult select that doesn't work, and i had to use

[BUGS] Databases in Belgium

2001-07-10 Thread Nico Vaes
Hello, I'm looking for people in Belgium, who have any experience in working with Databases, so we can exchange views and experiences. Do you know such people (or maybe it's you), please contact me at [EMAIL PROTECTED] . Greetings Nico Vaes ---(end of broadcast)---

[BUGS] ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found

2001-07-10 Thread pgsql-bugs
Kristis Makris ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found Long Description Using Postgres 7.1.2, I'm executing a plpgsql function that is expected to

Re: [BUGS] pg_ctl restart just appends to command line instead of regeneratingoriginal cmd

2001-07-10 Thread Bruce Momjian
I have applied the following patch based on Peter's fix. The forced -D in the old code clearly was error-prone. This should fix the reported problem. > > Patricia Holben ([EMAIL PROTECTED]) reports a bug with a severity of 3 > > > Then when "pg_ctl restart" is executed, the "pg_ctl status" w