[BUGS] Error Restoring Large Database

2002-01-24 Thread Mark Rae
System Configuration - Architecture : Dual AMD Athlon MP 1800+ Operating System : Linux dpdev02 2.4.4-64GB-SMP #1 SMP PostgreSQL version : PostgreSQL-7.2b4 and PostgreSQL-7.2rc1 Compiler used : gcc version 2.95.3 20010315 (SuSE) Please enter a FULL de

[BUGS] Bug #567: no way of restricting creation of tables

2002-01-24 Thread pgsql-bugs
Holger Jakobs ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description no way of restricting creation of tables Long Description pg_hba.conf restricts or allows access to a database for a user. As soon as the user has access to the data

Re: [BUGS] Error Restoring Large Database

2002-01-24 Thread Tom Lane
Mark Rae <[EMAIL PROTECTED]> writes: > ERROR: copy: line 26501638, insert_fsm_page_entry: failed to insert entry! Ugh. I think I see the problem: silly oversight in this routine. Please apply the attached patch and see if it fixes the failure. regards, tom lane *** s

[BUGS] Problems with my server...

2002-01-24 Thread Paulo Jorge Gomes Ferreira
Hi, there !! I've got a problem in my PostgreSQL server. Anytime I issue some commands (like vacuum...) I got the following message: prescricoes=> vacuum; ERROR: cannot find attribute 3 of relation pg_views prescricoes=> what can be wrong ?? I think that all my data is there and I have no vie

Re: [BUGS] Problems with my server...

2002-01-24 Thread Tom Lane
"Paulo Jorge Gomes Ferreira" <[EMAIL PROTECTED]> writes: > I've got a problem in my PostgreSQL server. Anytime I issue some commands > (like vacuum...) I got the following message: > prescricoes=> vacuum; > ERROR: cannot find attribute 3 of relation pg_views What Postgres version are you runnin

[BUGS] Bug #568: RULE ON SELECT with old values.

2002-01-24 Thread pgsql-bugs
Vadim Passynkov (Vadim.Passynkov) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description RULE ON SELECT with old values. Long Description # SELECT version(); version -

Re: [BUGS] Bug #568: RULE ON SELECT with old values.

2002-01-24 Thread Tom Lane
[EMAIL PROTECTED] writes: >> From PostgreSQL Documentation: > Within the condition and action, the special table names new and old may be used to >refer to values in the referenced table (the object). new is valid in ON INSERT and >ON UPDATE rules to refer to the new row being inserted or upda

[BUGS] Bug(?) around 'infinity'

2002-01-24 Thread Fduch the Pravking
Operating system: FreeBSD 4.4-STABLE PostgreSQL version: postmaster (PostgreSQL) 7.1.3 psql input: test=> SELECT timestamp 'infinity' - timestamp 'infinity'; psql output: ?column? - -2147483648 days --2147483648:-2147483648:0

Re: [BUGS] Bug(?) around 'infinity'

2002-01-24 Thread Tom Lane
Fduch the Pravking <[EMAIL PROTECTED]> writes: > postmaster (PostgreSQL) 7.1.3 > psql input: > test=> SELECT timestamp 'infinity' - timestamp 'infinity'; > psql output: > ?column? > - > -2147483648 days --2147483648:-2147483648

Re: [BUGS] COPY when 'filename' is a directory

2002-01-24 Thread Bruce Momjian
This has been saved for the 7.3 release: http://candle.pha.pa.us/cgi-bin/pgpatches2 --- Brent Verner wrote: > [2002-01-17 07:08] Brent Verner said: > | [2002-01-16 17:47] Douglas Trainor said: > | | I'd like to rep

Re: [BUGS] libpq not reentrant

2002-01-24 Thread Bruce Momjian
This has been saved for the 7.3 release: http://candle.pha.pa.us/cgi-bin/pgpatches2 --- Federico Di Gregorio wrote: Checking application/pgp-signature: FAILURE -- Start of PGP signed section. > Il ven, 2002-01-18

Re: [BUGS] libpq not reentrant

2002-01-24 Thread Bruce Momjian
This has been saved for the 7.3 release: http://candle.pha.pa.us/cgi-bin/pgpatches2 --- Mario Lorenz wrote: > Tom, > > I originally worked with Federico to get the garbled passwords issue > resolved which hit us