Re: [BUGS] 7.3 pg_atoi action

2003-03-04 Thread Tom Lane
[EMAIL PROTECTED] writes: > My first and only complaint is the recent modification to the action > pg_atoi( ) takes on empty string sets. (7.3 modification). > If possible, could we rollback this change on 7.4 with maybe a compilation > option? Now that we've bitten the bullet of making it do w

Re: [BUGS] Installtion error

2003-03-04 Thread alex avriette
[Mahesh-Ss-Computer:~] ampleuser% /Library/PostgresqL/bin/pg_ctl -D /users/ampleuser/data -l logfile start postmaster successfully started Postgres will actually be spitting the error to a file called "logfile", while saying it was successful to STDOUT. Your error is in there. Alex -- alex a

[BUGS] 7.3 pg_atoi action

2003-03-04 Thread mlane
PG Development Team,   I would first like to commend all of you on the fantastic service you provide the general public. My first and only complaint is the recent modification to the action pg_atoi( ) takes on empty string sets.  (7.3 modification).    If possible, could we rollba

[BUGS] Installtion error

2003-03-04 Thread dinu paul
Dear sir, Sir last one week i am try to install PostgreSQL in Mac os x 10.2 .I dowm loaded PostgreSQL 7.3 from net and i installed it in 'ampleuser', my login (in dir:Library/PostgreSQL). After that i set the paths in follwing manner.And it successfully starting the postmaster also.But when

Re: [BUGS] setting time zone during a transaction causes time warp

2003-03-04 Thread Robert Haas
Thanks for the quick response!  I haven't had a chance to test the patch yet (this is being built by an automated system, so hand-patching is a bit tough, but I'll adapt the patch to apply cleanly when I have some spare time...  or just upgrade to the latest version), but I just wanted you to know

Re: [BUGS] Default values for nulls not being set.

2003-03-04 Thread Donald Fraser
> "Donald Fraser" <[EMAIL PROTECTED]> writes: > > What would be nice is when you don't specify a default on the view, the default > > from the table is used. > > What table? You seem to have an extremely narrow-minded concept of what > a view is. > > regards, tom lane In the above I was referring

Re: [BUGS] Default values for nulls not being set.

2003-03-04 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > What would be nice is when you don't specify a default on the view, the default > from the table is used. What table? You seem to have an extremely narrow-minded concept of what a view is. regards, tom lane --

Re: [BUGS] Default values for nulls not being set.

2003-03-04 Thread Donald Fraser
> "Donald Fraser" <[EMAIL PROTECTED]> writes: > > I have a major problem with DEAFAULT values: > > Consider attaching a default to the view column. As-is, its default > is NULL (and I can't see any good argument for the factory default > being anything else). What would be nice is when you don't