Re: [BUGS] PGSQL no IP-port assigned

2003-02-13 Thread Lamar Owen
On Thursday 13 February 2003 05:06, Pablo Capeluto wrote: > Your name : Pablo Capeluto > Your email address : [EMAIL PROTECTED] > Mi comando para correr PostgreSQL es rcpostgresql start, funciona bien, > postgresql status me dice "runing" pero las aplicaciones que uso para > hace

[BUGS] postmaster missing

2003-02-13 Thread Greger Burman
Hi! I'm trying to build and install PostgreSQL 7.3 on my intel machine running BeOS 5.0.3 with BONE. 'configure', 'make' and 'make install' all finished without problems, however the 'postmaster' executable is present in the bin-directory only as a broken symbolic link! /Greger ---

Re: [BUGS] Bug #866 related problem (ATTN Tom Lane)

2003-02-13 Thread Florian Wunderlich
Tom Lane wrote: > > Florian Wunderlich <[EMAIL PROTECTED]> writes: > > So can I be sure that every non-aggregate SELECT on tables joined with > > unique indexes works, independent of the WHERE or ORDER BY? > > I would think that backwards scan on a join mostly doesn't work, but > haven't tried it

[BUGS] PGSQL no IP-port assigned

2003-02-13 Thread Pablo Capeluto
Your name : Pablo Capeluto Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : AMD K6-2 400Mhz, 396Mb-RAM 800Mb Free Hdd (4.2Gb Total) Operating System (example: Linux 2

Re: [BUGS] Bug #896: Column Constraint Not Working in ALTER TABLE ADD COLUMN?

2003-02-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > Column Constraint Not Working in ALTER TABLE ADD COLUMN? Yeah, the parser was losing foreign key constraints in this case :-( Patch against 7.3 is attached. regards, tom lane *** src/backend/parser/analyze.c.orig Mon Feb 10 23:13:39 2003 ---

Re: [BUGS] 'update' as action of 'insert' rule: permission denied

2003-02-13 Thread Tom Lane
Tim Burgess <[EMAIL PROTECTED]> writes: > I'm surprised I can't find any descriptions of this in the archive > already, since I had imagined it would be a common action, but > apparently not! I'm surprised too. This bug seems to have escaped notice for quite awhile. Attached is the patch agains

Re: [BUGS] Bug #895: incorrect error message when duplicate index name

2003-02-13 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Long Description > ERROR: relation named "pk_exchange_batch_idx" already exists > Why relation when I create index? An index is a type of relation: other types of relations include tables, views, and sequences. A relation is simply something in