[BUGS] BUG #1245: Postgres won't start

2004-09-08 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1245 Logged by: Windows Admin Bug Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Windows 2000 Description:Postgres won't start Details: PostgreSQL won't start because I'm

Re: [BUGS] BUG #1245: Postgres won't start

2004-09-08 Thread Harald Armin Massa
> PostgreSQL won't start because I'm logged on as a user with administrative > rights. That has be discussed in great detail during the pre-beta period. All the arguments you do provide are quite correct and all of them have been considered and discussed. I myself did argue for "PostgreSQL as Adm

[BUGS] BUG #1246: not exist pltcl.so in postgresql rpm package

2004-09-08 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1246 Logged by: Christian Gonzalez Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.3 Operating system: Redhat 9 and Redhat EL 3 Description:not exist pltcl.so in postgresql rpm package Details: H

Re: [BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-08 Thread Tom Lane
Rafael Martinez <[EMAIL PROTECTED]> writes: > I send you the information you ask for. This is really interesting. Looking at tuple 44 in the pg_filedump output: > Item 44 -- Length: 88 Offset: 4016 (0x0fb0) Flags: USED > XID: min (34365810) CMIN|XMAX: 0 CMAX|XVAC: 0 > Block Id: 174

Re: [BUGS] BUG #1246: not exist pltcl.so in postgresql rpm package

2004-09-08 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Where I can find the pltcl.so library?... Should be in the postgresql-pl RPM. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] BUG #1246: not exist pltcl.so in postgresql rpm package

2004-09-08 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 8 Sep 2004, "PostgreSQL Bugs List" <[EMAIL PROTECTED]> wrote: Where I can find the pltcl.so library?... [EMAIL PROTECTED] devrim]$ rpm -ql postgresql-pl|grep pltcl.so /usr/lib/pgsql/pltcl.so It's in the postgresql-pl rpm. Regards, - -- Dev

[BUGS] BUG #1247: pltcl.so does not exist in postgresql-pl RPM package

2004-09-08 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1247 Logged by: Christian Gonzalez Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.3 Operating system: Redhat 9 and rhel3.0 Description:pltcl.so does not exist in postgresql-pl RPM package Details:

Re: [BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-08 Thread Tom Lane
Kjetil Torgrim Homme <[EMAIL PROTECTED]> writes: > [Tom Lane]: >> So somehow, the byte at page offset 0fff got changed >> from 00 to 2f in memory, though not on disk. > indeed interesting. IMHO 0x0fff sounds more like a write to -1 > (relative to the next page) than a random memory error. Note t

[BUGS] BUG #1248: pg_dump produces grants with concatonated elements

2004-09-08 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1248 Logged by: Timothy LoGrasso Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.5 Operating system: SunOS 5.9 Description:pg_dump produces grants with concatonated elements Details: pg_dump prod

Re: [BUGS] BUG #1247: pltcl.so does not exist in postgresql-pl RPM

2004-09-08 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 8 Sep 2004, PostgreSQL Bugs List wrote: PostgreSQL version: 7.4.3 Operating system: Redhat 9 and rhel3.0 Description:pltcl.so does not exist in postgresql-pl RPM package Details: I am executing "rpm -qpl postgresql-pl-7.4.5-1PGDG.i

Re: [BUGS] BUG #1248: pg_dump produces grants with concatonated elements

2004-09-08 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > pg_dump produces the following grants: > GRANT INSERTSELECTUPDATE ON TABLE camp_score TO mn; Doesn't happen for anybody else... > Obviously there are no commas or spaces seperating the different privs. I'm > actually running the following ver

Re: [BUGS] PosgreSQL is crashing with a signal 11 - Bug?

2004-09-08 Thread Kjetil Torgrim Homme
[Tom Lane]: > > Kjetil Torgrim Homme <[EMAIL PROTECTED]> writes: > > indeed interesting. IMHO 0x0fff sounds more like a write to -1 > > (relative to the next page) than a random memory error. > > Note though that that offset is only special with respect to > locations on disk; it was

[BUGS] 8.0 incompatibility

2004-09-08 Thread Gaetano Mendola
Hi all, I'm observing that this piece of code doesn't work anymore in postgres 8.0 DECLARE quota RECORD; BEGIN FOR quota IN SELECT quota FROM foo LOOP END LOOP; the table foo have the field quota The error reported is: ERROR: record "quota" is not

[BUGS] Build failure: TIMEZONE_GLOBAL undeclared

2004-09-08 Thread Michael Fuhr
A build of the latest CVS sources fails when compiling pgtz.c: gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes -Wmissing-declarations -DFRONTEND -I../../src/include -I/usr/local/ssl/include -c -o pgtz.o pgtz.c pgtz.c: In function `get_timezone_offset': pgtz.c:99: error: `TIMEZONE_GLO

Re: [BUGS] Permissions problem with sequences

2004-09-08 Thread Michael Fuhr
On Mon, Sep 06, 2004 at 11:41:48PM -0400, Tom Lane wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > >> Given that pg_dump does put out GRANT/REVOKE operations on the sequence, > >> it's certainly aware that the sequence exists. I suspect this is just a > >> fixable bug (ie, suppressi

Re: [BUGS] Permissions problem with sequences

2004-09-08 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > ... DROP TABLE cascades to implictly-created sequences -- why > shouldn't ALTER TABLE OWNER TO cascade as well? Hmm ... I hadn't thought of that approach, but it seems pretty reasonable offhand ... comments? regards, tom lane --

Re: [BUGS] Permissions problem with sequences

2004-09-08 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: >> Hmm ... I hadn't thought of that approach, but it seems pretty >> reasonable offhand ... comments? > What if they change the owner of the serial sequence independently > anyway? I suppose a complete solution would involve forbidding that. W

Re: [BUGS] Permissions problem with sequences

2004-09-08 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > I've got a mostly working fix for the bug that involves alter owner on > the sequence, but let me know if you want me to finish it. Please. We need to see the alternatives ... regards, tom lane --

Re: [BUGS] Build failure: TIMEZONE_GLOBAL undeclared

2004-09-08 Thread Bruce Momjian
Michael Fuhr wrote: > A build of the latest CVS sources fails when compiling pgtz.c: > > gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes -Wmissing-declarations > -DFRONTEND -I../../src/include -I/usr/local/ssl/include -c -o pgtz.o pgtz.c > pgtz.c: In function `get_timezone_offset': >