[BUGS] FATAL 1: LWLockAcquire: can't wait without a PROC structure

2002-09-27 Thread fredrik chabot
Hi, I get the following msg "FATAL 1: LWLockAcquire: can't wait without a PROC structure" in the log file about once a day and every user is kicked out of the database. Running on a single cpu amd with Redhat Linux 7.2 kernel 2.4.7-10 and the postgresql-7.2.1-5 rpm's NB I tried running it o

[BUGS] Bug #784: DROP 7.3b1 - DOMIAN CASCADE can leave a table with no columns

2002-09-27 Thread pgsql-bugs
Tim Knowles ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description DROP 7.3b1 - DOMIAN CASCADE can leave a table with no columns Long Description Hello, I've posted this a few times but my email has been playing up a bit - blame Brit

[BUGS] Nie ma mnie w biurze

2002-09-27 Thread Adam Doligalski
W dniu dzisiejszym jestem na urlopie. Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod numerem telefonu 607225738. Adam Doligalski ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.pos

Re: [BUGS] FATAL 1: LWLockAcquire: can't wait without a PROC structure

2002-09-27 Thread Tom Lane
fredrik chabot <[EMAIL PROTECTED]> writes: > I get the following msg "FATAL 1: LWLockAcquire: can't wait without a > PROC structure" in the log file about once a day and every user is > kicked out of the database. We found the cause of that just a couple days ago. It'll be fixed in 7.3beta3.

[BUGS] Bug #785: 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT

2002-09-27 Thread pgsql-bugs
Tim Knowles ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT Long Description I don't know if this is intended behaviour but as the 7.3 devel docs a

Re: [BUGS] Bug #785: 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT

2002-09-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > CREATE TABLE t1 ( > col_a int, > PRIMARY KEY (col_a) > ); > --DROP INDEX t1_pkey CASCADE WILL NOT CASCADE THE DROP TO DEPENDENT OBJECTS > DROP INDEX t1_pkey CASCADE; > --ALTER TABLE .. DROP .. CASCADE WILL CASCADE THE DROP TO THE FOREIGN KEY CONSTRAINT > ALTER TAB

[BUGS] FATAL 1: Database dialup does not exist in pg_database

2002-09-27 Thread roco
Hello, When I execute the command "psql dialup" , I receive this message: postgres@www:/usr/local/pgsql/data/base/dialup$ psql dialup Connection to database 'dialup' failed. FATAL 1: Database dialup does not exist in pg_database What can I do? -- Best regards, roco

[BUGS] Fwd: FATAL 1: Database dialup does not exist in pg_database

2002-09-27 Thread roco
This is a forwarded message From: roco <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Friday, September 27, 2002, 2:49:47 PM Subject: FATAL 1: Database dialup does not exist in pg_database ===8<==Original message text=== Hello, When I execute the command "psql dialup" ,

[BUGS] Bug #786: simbols in relation names

2002-09-27 Thread pgsql-bugs
Andrew Shubas ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description simbols in relation names Long Description Good afternoon! We use chars as ':' ,or '=' ,or similar in the relations - views - names. Problem is that in the psql do

[BUGS] Nie ma mnie w biurze

2002-09-27 Thread Adam Doligalski
W dniu dzisiejszym jestem na urlopie. Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod numerem telefonu 607225738. Adam Doligalski ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PRO

Re: [BUGS] Bug #786: simbols in relation names

2002-09-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > We use chars as ':' ,or '=' ,or similar in the relations - views - > names. Problem is that in the psql doing select from such views into > the record i can't use relation names if that contains such chars as > described. If i write something like rec."Name:i:20" i get

[BUGS] Bug #787: Backup Files Output Constraints Before Functions

2002-09-27 Thread pgsql-bugs
David Wheeler ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Backup Files Output Constraints Before Functions Long Description Bricolage has a table with a constraint that uses a custom function. The code to build it is funct

[BUGS] Nie ma mnie w biurze

2002-09-27 Thread Adam Doligalski
W dniu dzisiejszym jestem na urlopie. Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod numerem telefonu 607225738. Adam Doligalski ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archiv

Re: [BUGS] Bug #787: Backup Files Output Constraints Before Functions

2002-09-27 Thread Tom Lane
[EMAIL PROTECTED] writes: > Would it be possible for pg_dump to do the right thing here? Not real soon :-(. It's possible that 7.4 pg_dump will be smart enough to handle circular dependencies like this one. The current pg_dump doesn't even know there is a problem, much less have a strategy for

Re: [BUGS] Nie ma mnie w biurze

2002-09-27 Thread Jean-Luc Lachance
Another one who decided to turn on the vacation auto reply. Can some one unsubscribe him temporarely. Adam Doligalski wrote: > > W dniu dzisiejszym jestem na urlopie. > > Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod >numerem telefonu 607225738. > > Adam