[BUGS] script for #6350
Attached script (run as psql -U postgres -f bug_6350.sql) shows the problem. Enjoy! create database problematic; \c problematic -- create three roles create role usr; create role adm; create role new_adm; create table foo (bar integer); alter table foo owner to adm; grant select(bar) on foo to usr; -- all ok so far, usr and adm are referenced in -- the foo.bar column privileges \dp foo -- now change the owner alter table foo owner to new_adm; -- the following drop succeds, although role adm -- is still referenced in the foo.bar column -- privileges. this is a bug. drop role adm; \dp foo -- the column privileges can now not be changed -- due to the stale reference to the deleted role. revoke select(bar) on foo from usr; \dp foo \c template1 drop database problematic; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] script for #6350
Attached script (run as psql -U postgres -f bug_6350.sql) shows the problem. Enjoy! create database problematic; \c problematic -- create three roles create role usr; create role adm; create role new_adm; create table foo (bar integer); alter table foo owner to adm; grant select(bar) on foo to usr; -- all ok so far, usr and adm are referenced in -- the foo.bar column privileges \dp foo -- now change the owner alter table foo owner to new_adm; -- the following drop succeds, although role adm -- is still referenced in the foo.bar column -- privileges. this is a bug. drop role adm; \dp foo -- the column privileges can now not be changed -- due to the stale reference to the deleted role. revoke select(bar) on foo from usr; \dp foo \c template1 drop database problematic; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"
Am 22.01.12 14:22, schrieb Giuseppe Sucameli: > Hi all, > > trying to create a table with a column xmin I get the > following error message: > > test=> create table lx (xmin int); > ERROR: column name "xmin" conflicts with a system > column name > > Instead I get a different (and less understandable) error > message if I try to add a column named xmin to an > existent table: > > test=> create table lx (i int); > CREATE TABLE > test=> alter table lx add xmin int; > ERROR: column "xmin" of relation "lx" already exists. > > The same problem occurs using "xmax" as column name. > > I'm on Ubuntu 11.04. > Tried on both PostgreSQL 8.4.10 and 9.1.2 That is not a bug, but a feature. See section 5.4 of the documentation "System Columns": "Every table has several system columns that are implicitly defined by the system. Therefore, these names cannot be used as names of user-defined columns. (Note that these restrictions are separate from whether the name is a key word or not; quoting a name will not allow you to escape these restrictions.) You do not really need to be concerned about these columns; just know they exist." and further down: "xmin The identity (transaction ID) of the inserting transaction for this row version. (A row version is an individual state of a row; each update of a row creates a new row version for the same logical row.)" -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #6454: Latest x64 msi does not recognize admin account
Am 13.02.12 00:09, schrieb the_r...@yahoo.com: > The following bug has been logged on the website: > > Bug reference: 6454 > Logged by: Paul Peterson > Email address: the_r...@yahoo.com > PostgreSQL version: 9.1.2 > Operating system: Windows 7 home > Description: > > Latest x64 msi does not recognize admin account. There is only one account, > mine and it appears as though Windows took away the XP admin default > account. suggestions? Windows 7 deactivates the Administrator account by default. Well, it rather hides it. To make it visible, use the follow steps (sorry, they are in german, because I took them out of our ticket/FAQ system): Systemsteuereung System und Sicherheit Verwaltung Computerverwaltung Lokale Benutzer und Gruppen wählen Benutzer wählen mit rechter Maustaste auf Administrator, es erscheint ein Fenster Eigenschaften in diesem Fenster Häckchen bei "Konto ist deaktiviert" entfernen mit ok bestätigen mit rechter Maustaste auf Administrator klicken und im Popup-Menu "Kennwort festlegen" anklicken Warnmeldung taucht auf, auf Fortsetzen klicken Kennwort eingeben und ok klicken, fertig -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #6595: can't remote access
Am 17.04.12 12:10, schrieb li...@nway.com.cn: > The following bug has been logged on the website: > > Bug reference: 6595 > Logged by: lihao > Email address: li...@nway.com.cn > PostgreSQL version: 9.1.3 > Operating system: windows xp > Description: > > I has install pg 9.1.3 on windows xp,but it can't accessed by a remote > windows xp. That is not a bug, but a configuration error. I am sure if you read the documentation, you will be able to properly configure your system. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7670: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"
Am 18.11.2012 um 19:36 schrieb Peter Geoghegan : > On 18 November 2012 18:18, Tom Lane wrote: >> Well, we have two reports of people trying such values (assuming that >> #7545 actually is the same thing), and it didn't work for either of >> them. I don't think it's a problem to restrict the value to something >> that will work rather than fail. > > Right. sizeof(int) is very probably 4 on all platforms that we > support. I see no problem with the proposal. Have you cross-checked this on a 64bit platform vs. a 32 bit platform? e.g. on Linux i386 vs. Linux amd64? > > -- > Peter Geoghegan http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training and Services > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs Freundliche Grüsse, micro systems Marc Balmer -- Marc Balmer micro systems, Wiesendamm 2a, Postfach, 4019 Basel fon +41 61 383 05 10, fax +41 61 383 05 12, http://www.msys.ch/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error
Am 22.01.2013 um 14:31 schrieb jan-peter.seif...@gmx.de: > The following bug has been logged on the website: > > Bug reference: 7820 > Logged by: Jan-Peter Seifert > Email address: jan-peter.seif...@gmx.de > PostgreSQL version: 9.1.7 > Operating system: Windows 7 64-bit > Description: > > The statement: > 'CREATE EXTENSION uuid-ossp' > > just gives me a syntax error: > > ERROR: syntax error at or near "-" > LINE 1: CREATE EXTENSION uuid-ossp > ^ > ** Fehler ** > > ERROR: syntax error at or near "-" > SQL Status:42601 > Zeichen:22 > > Obviously "CREATE EXTENSION" expects underscores instead of hyphens. no. Your syntax is wrong. > > I had to replace the hyphen in file names and in the scripts to make the > module work. > That is the wrong "fix". The hyphen has a meaning in SQL. So you need to properly enclose uuid-ossp in quotes. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
