[BUGS] BUG #5581: Fail to start.

[Francesco]

The following bug has been logged online:

Bug reference:  5581
Logged by:  Francesco
Email address:  mauricep...@gmail.com
PostgreSQL version: 9.0 beta 3
Operating system:   windows XP Professional
Description:Fail to start.
Details: 

Most of the time when I turn on the PC in the morning the  it fail to start
and I cannot start it neither from inside the pgAdmin. So I have to
reinstall it, then it works well.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Selecting from a Subquery Fails

[Francesco Pari]

Hello, i have this big isuue:


i have 2 table referenced by this columns 
codiceregistrazione=riferimentoesame;



select tipoesame,count(*) from righeaccettazione,registrazione where 
codiceregistrazione=riferimentoesame and validita='VALIDO' and 
dataesame  between timestamp '2008-01-01 00:00:00' and '2008-12-31 
23:58:59' and eseguitonellasegreteria=1 and ticket <> 2 and 
repartoprovenienza=81   group by tipoesame order by tipoesame;



this query works fine (4 seconds to run as it is a large data set) and 
produces 245 rows of values in 2 columns



if i try


select * from (

select tipoesame,count(*) as tot from righeaccettazione,registrazione 
where codiceregistrazione=riferimentoesame and validita='VALIDO' and 
dataesame  between timestamp '2008-01-01 00:00:00' and '2008-12-31 
23:58:59' and eseguitonellasegreteria=1 and ticket <> 2 and 
repartoprovenienza=81   group by tipoesame order by tipoesame)


as ciao where ciao.tipoesame=615 ;


The query Hangs 

can this be a bug or a misconfiguration?

thanks in advance


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Please help On Alternative Database Location

[Francesco Protano]

it's sure that this email should to be write to
anywhere but here, but the various requests to help
done in some mailings lists about postgresqk are
failed.So i write you, in the hope to receive an
response.
Briefly the question.
I work under Linux platform, Mandrake 7.2
distribution, and i need to create a postgres
database, for example called "mydb", in alternative
location, for example "/home/username". In the
official documentation this is very simple to do, but
in the reality i have failed.
This is my steps
1) su - username
2) set PGDATA2 = "/home/username" (but i tried
relatives path too)
3) initlocation $PGDATA2
4) createdb -D $PGDATA2 mydb

Finally an error message appears like this
"The database path '/home/username' is invalid. This
may be due to a character that is not allowed or
because the chosen path isn't permitted for databases"


I tried the relatives paths "~" and "." too, but the
message is the same.
Please help me
I like to know the right procedure step by step
Thanck you so much


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] character varying as boolean !!! help

[Francesco Andreozzi]

I think thi is a bug, I've a lot of db up with same structure and I don't have
any prioblem..
I'm using psql 7.4.2

the problem is that
i've a table

sportellounico=# \d cfp
  Tabella "public.cfp"
 Colonna  |   Tipo|   Modificatori
--+---+--
 cod_cfp  | integer   | not null default
nextval('public.cfp_cod_cfp_seq'::text)
 cod_procedimento | bigint|
 testo| character varying |


if I try to insert something it works but the update no

sportellounico=# UPDATE cfp SET testo='test' AND cod_procedimento='82' where
cod_cfp='2';
ERROR:  invalid input syntax for type boolean: "test"

?

so i've try to update with a boolean value, just for test and offcourse .

sportellounico=# UPDATE cfp SET testo=true AND cod_procedimento='82' where
cod_cfp='2';
ERROR:  column "testo" is of type character varying but expression is of type
boolean

I've try to drop the field and recreate... but nothing...
any suggestion?

Thankyou Francesco





-- 
Francesco Andreozzi 
Tel. 347-3757481


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings