Re: [BUGS] BUG #5370: Shortcut for currently connected users

2010-03-12 Thread Igor Moiseev
Thank you Bruce! This solution is even more flexible! But how is it possible to know if the docs gives almost nothing http://search.postgresql.org/search?u=/docs/8.4/static/&q=psqlrc Thank you. 2010/3/12 Bruce Momjian > Igor Moiseev wrote: > > > > The following bug has been logged online: >

[BUGS] BUG #5373: Crash at the first time system bootup

2010-03-12 Thread Bhavin
The following bug has been logged online: Bug reference: 5373 Logged by: Bhavin Email address: rahul_bhav...@yahoo.com PostgreSQL version: postgresSQL 8.4 Operating system: windows xp Description:Crash at the first time system bootup Details: Hello, My postgreSQL 8

[BUGS] Cannot create UTF-8 database

2010-03-12 Thread Carlson, Jacob
Hello, I am trying to create a UNICODE schema and am getting an error. Is there a configuration file I need to update to except Unicode schemas? I am using this version of software - postgresql-8.3.8-S10.i386-64.tar. To note, I am able to create an ASCII encoded schema with no problem. Unicod

Re: [BUGS] BUG #5373: Crash at the first time system bootup

2010-03-12 Thread Kevin Grittner
"Bhavin" wrote: > PostgreSQL version: postgresSQL 8.4 > Operating system: windows xp > Description:Crash at the first time system bootup > My postgreSQL 8.4 crashes everytime at the first bootup of my > system. It works fine after first system bootup. > > What could be the possible

Re: [BUGS] log : bad file dscriptor????

2010-03-12 Thread Tom Lane
Gurjeet Singh writes: > It seems this commit never made it to the release notes. A customer came > asking for the fix to this very problem, and although we know that the issue > has been fixed, we could not refer him to the release notes. All we could > suggest was to do the minor upgrade. We som

Re: [BUGS] BUG #5370: Shortcut for currently connected users

2010-03-12 Thread Robert Haas
On Fri, Mar 12, 2010 at 4:59 AM, Igor Moiseev wrote: > Thank you Bruce! This solution is even more flexible! > But how is it possible to know if the docs gives almost nothing > > http://search.postgresql.org/search?u=/docs/8.4/static/&q=psqlrc The first of those two hits is an extremely long and

Re: [BUGS] BUG #5371: Error 193: 0xc1

2010-03-12 Thread Robert Haas
On Thu, Mar 11, 2010 at 11:59 AM, Alexey wrote: > > The following bug has been logged online: > > Bug reference:      5371 > Logged by:          Alexey > Email address:      mansell...@gmail.com > PostgreSQL version: 8.4 > Operating system:   Windows XP Pro > Description:        Error 193: 0xc1 >

Re: [BUGS] BUG #5364: citext behavior when type not in public schema

2010-03-12 Thread Robert Haas
On Fri, Mar 5, 2010 at 5:24 AM, Markus Wichitill wrote: > > The following bug has been logged online: > > Bug reference:      5364 > Logged by:          Markus Wichitill > Email address:      ma...@gmx.de > PostgreSQL version: 8.4.2 > Operating system:   Linux, Win7 > Description:        citext be

Re: [BUGS] Cannot create UTF-8 database

2010-03-12 Thread Tom Lane
"Carlson, Jacob" writes: > I am trying to create a UNICODE schema and am getting an error. Is there a > configuration file I need to update to except Unicode schemas? I am using > this version of software - postgresql-8.3.8-S10.i386-64.tar. > To note, I am able to create an ASCII encoded schem

Re: [BUGS] BUG #5372: insert into fails with integer expression type char error

2010-03-12 Thread Tom Lane
"Gray Watson" writes: > I have 2 tables which have the same schema (as far as I can see) but when I > try to do the following in psql: > INSERT INTO old_log SELECT * FROM log WHERE time < '2010-02-01'; > I get the error: > ERROR: column "port" is of type integer but expression is of type charac

Re: [BUGS] BUG #5372: insert into fails with integer expression type char error

2010-03-12 Thread gray . pg
Ok. I've reproduced this but I now think that it isn't a bug. My schemas initially weren't the symetric when I was using select *. Alas, when I did align my schemas later, I had already switched to specifying a column list which then did not match the column list in the table. An improvement

[BUGS] BUG #5374: NULLed SERIAL improperly dumped

2010-03-12 Thread Wojciech Scigala
The following bug has been logged online: Bug reference: 5374 Logged by: Wojciech Scigala Email address: postgresql@wojtus.net PostgreSQL version: 8.1.18 Operating system: Linux 2.6.18 Description:NULLed SERIAL improperly dumped Details: If a SERIAL type is modi

Re: [BUGS] BUG #5374: NULLed SERIAL improperly dumped

2010-03-12 Thread Tom Lane
"Wojciech Scigala" writes: > If a SERIAL type is modified by ALTER TABLE .. DROP NOT NULL, backups made > with pg_dump does not contain this change. > Test were done on (unsupported) 8.1.18, I've checked release notes for > 8.1.19 - no fix regarding this found. Yeah, this is one of a number of r