[BUGS] BUG #4166: Alter table add column from PgAdminIII

2008-05-14 Thread Mike Gagnon
The following bug has been logged online: Bug reference: 4166 Logged by: Mike Gagnon Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1-1 Operating system: Windows XP Description:Alter table add column from PgAdminIII Details: Hi Postgres Experts, I used PGA

Re: [BUGS] BUG #4166: Alter table add column from PgAdminIII

2008-05-14 Thread Heikki Linnakangas
Mike Gagnon wrote: I used PGAdmin III to add a character varying column(400) length, not null default ''. I get the column displayed in psql when I do a simple query like SELECT * from MyTable limit 1; When I try to do Update MyTable set NewColumn='something'; I get the error saying that the

Re: [BUGS] BUG #4166: Alter table add column from PgAdminIII

2008-05-14 Thread Tom Lane
"Mike Gagnon" <[EMAIL PROTECTED]> writes: > I used PGAdmin III to add a character varying column(400) length, not null > default ''. I get the column displayed in psql when I do a simple query > like SELECT * from MyTable limit 1; > When I try to do Update MyTable set NewColumn='something'; I g

[BUGS] Problem with TOAST tables when removing TOASTable column

2008-05-14 Thread Wojciech Strzałka
I've found some strange behavoiur of TOAST'able tables. 1. Lets create table with toastable column CREATE table toastable ( x int , y text ); 2. Check toast size - as the table is empty it's size 0 - OK SELECT relname, pg_relation_size(oid) FROM pg_class where oid=(select reltoastrelid from

[BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread nicoanto
The following bug has been logged online: Bug reference: 4167 Logged by: nicoanto Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1.0 Operating system: Windows Description:When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows Details:

Re: [BUGS] Problem with TOAST tables when removing TOASTable column

2008-05-14 Thread Tom Lane
=?iso-8859-2?Q?Wojciech_Strza=B3ka?= <[EMAIL PROTECTED]> writes: > In my opinion the fact that dropping column doesn't release it's toastable > resources is a bug. To make that happen would require (at least) a full table scan. I think most people are more interested in DROP COLUMN being a cheap

Re: [BUGS] Problem with TOAST tables when removing TOASTable column

2008-05-14 Thread Wojciech Strzałka
> To make that happen would require (at least) a full table scan. I think > most people are more interested in DROP COLUMN being a cheap operation > than in having the space be reclaimed quickly. > For a comparison point: large field values that don't happen to get > toasted don't vanish immedia

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Peter Eisentraut
Am Mittwoch, 14. Mai 2008 schrieb nicoanto: > I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on > order to generate UUID values using the UUID-OSSP module > The code of the function is the following one : > >     CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS $$ >        BEGIN

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Alvaro Herrera
Peter Eisentraut wrote: > Am Mittwoch, 14. Mai 2008 schrieb nicoanto: > > I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on > > order to generate UUID values using the UUID-OSSP module > > The code of the function is the following one : > > > >     CREATE FUNCTION uuidgen() R

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Heikki Linnakangas
Peter Eisentraut wrote: Am Mittwoch, 14. Mai 2008 schrieb nicoanto: I am using the 8.3.1 version of PostgreSQL. I wrote a simple function on order to generate UUID values using the UUID-OSSP module The code of the function is the following one : CREATE FUNCTION uuidgen() RETURNS CHAR(36) AS

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Peter Eisentraut
Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera: > Hmm, surely the problem is unrelated? He gets the same numbers on > _Windows_, whereas Ubuntu shows the good behavior. Oh, I read it backwards. So then the random number generator on Windows is the problem in this case. > Also, OOSP-UUID does

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Alvaro Herrera
Peter Eisentraut wrote: > Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera: > > Hmm, surely the problem is unrelated? He gets the same numbers on > > _Windows_, whereas Ubuntu shows the good behavior. > > Oh, I read it backwards. So then the random number generator on Windows is > the problem i

Re: [BUGS] BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows

2008-05-14 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Am Mittwoch, 14. Mai 2008 schrieb Alvaro Herrera: >> Hmm, surely the problem is unrelated? He gets the same numbers on >> _Windows_, whereas Ubuntu shows the good behavior. > Oh, I read it backwards. So then the random number generator on Windows is

Re: [BUGS] Problem with TOAST tables when removing TOASTable column

2008-05-14 Thread Tom Lane
=?iso-8859-2?Q?Wojciech_Strza=B3ka?= <[EMAIL PROTECTED]> writes: >> To make that happen would require (at least) a full table scan. I think >> most people are more interested in DROP COLUMN being a cheap operation >> than in having the space be reclaimed quickly. >> For a comparison point: large

[BUGS] BUG #4168: ECPG refuses datestyle SQL

2008-05-14 Thread Francisco Leovey
The following bug has been logged online: Bug reference: 4168 Logged by: Francisco Leovey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: SuSE Linux 9.2 Description:ECPG refuses datestyle SQL Details: if you write EXEC SQL SET datestyle