Re: [BUGS] Error on createuser

2006-06-22 Thread tomas
On Sun, Jun 18, 2006 at 07:38:13PM +0530, vinayak Desai wrote: > [EMAIL PROTECTED] ~]# createuser -a -d -e antonio > createuser: could not connect to database template1: FATAL: user "root" > does not exist This is not a bug. It's just that root is not a known database user. Typically there is an

Re: [BUGS] BUG #2489: Metadata dosen't match tables

2006-06-22 Thread Alvaro Herrera
James A Cole wrote: > mkeB_reports=# \d arrivals > Did not find any relation named "arrivals". > > mkeB_reports=# select * from arrivals where ontime>'2006-6-21'; > [data] > There are many other databases on this server. Most > do not have this problem. Ah, so this is the only one that has suf

Re: [BUGS] BUG #2487: Immutable functions results

2006-06-22 Thread Tom Lane
"Pedro J. Romero" <[EMAIL PROTECTED]> writes: > Sorry if this not a bug, but I think so: This report is useless, since you have not shown us either function. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searche

Re: [BUGS] BUG #2489: Metadata dosen't match tables

2006-06-22 Thread Tom Lane
"James A Cole" <[EMAIL PROTECTED]> writes: > mkeB_reports=# \d arrivals > Did not find any relation named "arrivals". > mkeB_reports=# select * from arrivals where ontime>'2006-6-21'; > [ works ] Looks like XID wraparound in the system catalogs. You can probably get out of it with a database-wid

[BUGS] BUG #2490: '||' and type casting for user defined types

2006-06-22 Thread Nikolay Samokhvalov
The following bug has been logged online: Bug reference: 2490 Logged by: Nikolay Samokhvalov Email address: [EMAIL PROTECTED] PostgreSQL version: CVS Operating system: fedora core 5 Description:'||' and type casting for user defined types Details: Assume that we are

Re: [BUGS] Error on createuser

2006-06-22 Thread Klaus Ita
On Sun, Jun 18, 2006 at 07:38:13PM +0530, vinayak Desai wrote: > [EMAIL PROTECTED] ~]# createuser -a -d -e antonio > createuser: could not connect to database template1: FATAL: user "root" > does not exist > [EMAIL PROTECTED] ~]# > > i logged in as root.. > I tried to create a new user i am getti

Re: [BUGS] BUG #2490: '||' and type casting for user defined types

2006-06-22 Thread Tom Lane
"Nikolay Samokhvalov" <[EMAIL PROTECTED]> writes: > CREATE CAST (aaa AS text) WITHOUT FUNCTION > AS IMPLICIT; > CREATE CAST (text AS aaa) WITHOUT FUNCTION > AS IMPLICIT; > trash=# select ('as' || 'df')::aaa; > aaa > -- > asdf > (1 row) > In the last case, function aaa_in() was

Re: [BUGS] BUG #2488: backup history file is archived doubly

2006-06-22 Thread Tom Lane
"Masao Fujii" <[EMAIL PROTECTED]> writes: > The cause of the problem is that pg_stop_backup creates two *.ready files. > One file is created by pg_stop_backup > RemoveOldBackupHistory > > XLogArchiveIsDone > XLogArchiveNotify. > Another is created by pg_stop_backup > XLogArchiveNotify. Oooh, good

Re: [BUGS] BUG #2486: PANIC when CTRL-C on vacuum full analyze

2006-06-22 Thread Tom Lane
"Ronald" <[EMAIL PROTECTED]> writes: > Description:PANIC when CTRL-C on vacuum full analyze I think we've seen this reported once before. You'd need to hit the window where VACUUM FULL has committed its transaction but is still busy cleaning indexes. Having moved a whole lot of rows woul