[BUGS] what can i do
Hello guys , i have a problem :( I had a postgreSQL before some days but i delete it , and now i cant install it , cause there are 2 message at the end of install when it making account or something like that once it show me that cant make account cause user postrgres already exist but if i delete it with run/cmd , than come "no mapping between ID and ?! Some idea what can i do
Re: [BUGS] what can i do
vladislav DONCHEV wrote: > Hello guys , i have a problem :( I had a postgreSQL before some > days but i delete it , and now i cant install it , cause there are > 2 message at the end of install when it making account or > something like that You haven't told us what operating system you're using, what version of PostgreSQL, how you're trying to install it, or what the messages are. Please read this: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems Then repost, with more information, to the general or novice list. This doesn't sound like a bug. -Kevin -- 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] what can i do
On Wed, Mar 17, 2010 at 12:37 PM, Kevin Grittner wrote: > vladislav DONCHEV wrote: > >> Hello guys , i have a problem :( I had a postgreSQL before some >> days but i delete it , and now i cant install it , cause there are >> 2 message at the end of install when it making account or >> something like that > > You haven't told us what operating system you're using, what version > of PostgreSQL, how you're trying to install it, or what the messages > are. He is on Windows (the run/cmd reference gives that away). I agree this doesn't sound like a bug, though. Here are a few questions though to say for sure: 1) This is Windows, right? Which version? 2) You say you "deleted" it. How? What exactly did you do to delete it? 3) Can you try again and copy the full error messages here? Best Wishes, Chris Travers -- 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] Error when lock conflict on REPLACE function
On Tue, Mar 16, 2010 at 7:02 AM, Peter Eisentraut wrote: > On mån, 2010-03-15 at 14:13 -0700, Josh Berkus wrote: >> 1. Create a function. >> 2. In one session, start an explicit transaction. >> 3. Do a CREATE OR REPLACE on the same function, but do not commit. >> 4. Open a 2nd session, and an explicit transaction in that session. >> 5. Do a CREATE OR REPLACE on the same function in the 2nd session. >> 6. COMMIT the 2nd session. >> 7. COMMIT the 1st session. >> 8. You get: >> >> ERROR: duplicate key value violates unique constraint >> "pg_proc_proname_args_nsp_index" >> SQL state: 23505 >> >> What should have happened: the 2nd replace should have succeeded. Or it >> should have given a user-friendly error message. Opinions? > > There is a whole host of, one might even say a bottomless pit of, > concurrency bugs in schema changes that don't involve tables (because > you can lock tables, but not much else). You should consider yourself > lucky that the schema is still consistent after the operation; it's easy > to do much worse. > > I think as people go more "agile" with their database designs, we will > see increasing demand to fix these sort of things. But right now, it > think it's pretty hopeless to expect this to work right. Perhaps this could be considered the leading edge of such demand... we've had similar complaints before. Unfortunately, it's unclear who is willing to put in the time to fix it. ...Robert -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
