i've got pgadmin II v 1.2 and postgre 7.1.1 and I'm having trouble
connecting to my database. Pgamin is running on xp and postgre is
running on a redhat linux box.
The error i'm getting happens when i'm trying to connect:
Number: -214721843
Description: No pg_hba.conf entry for host 192.168.0.2,
I'm trying to execute this :
insert into ahepatch(cpccchk,ptcodrel,ptdatins,ptdescri,ptnumpat,ptreleas)
values ('kfdujcqkgp','1.02-A0001',2001-12-04 00:00:00.0,'Aggiornamento
EURO-KIT',1,'1.2');
I obtain an error :"Parse error near or at "00".
What is the problem ? The form 00:00:00.0 is contem
Hi,
I'm working in a database that has over 60 tables/views plus 15 sequences.
Sometimes I want to use the security wizard to grant or revoke permissions
on all tables or all sequences and ... I have to click every checkbox, one
by one (over 75).
What about putting check
Hi
Sometimes I run a query and need to resize the columns of the SQL Output
window. If the data is updated in the database and I want to run the query
again, another SQL output window is opened and I have to resize its columns
again.
What about to put a [Refresh] button o
"Ricardo Canani" <[EMAIL PROTECTED]> wrote:
> Hi
>
> Sometimes I run a query and need to resize the columns of the SQL Output
> window. If the data is updated in the database and I want to run the query
> again, another SQL output window is opened and I have to resize its
columns
> again.
> ...
F
It doesn't know this is a timestamp so I guess it sees 00 and tries to read
as a number. to get it to work try putting it in appostraphes. This should
make it of type text. If this isn;t automatically cast then us the following
(assuming its a timestamp):
CAST ('2001-12-04 00:00:00.0' AS timestam
> -Original Message-
> From: Thomas Sandford [mailto:[EMAIL PROTECTED]]
> Sent: 25 January 2002 14:00
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] [Refresh] button on SQL Output window
>
>
> "Ricardo Canani" <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > Sometimes I run a query
> -Original Message-
> From: Ricardo Canani [mailto:[EMAIL PROTECTED]]
> Sent: 25 January 2002 12:40
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] security wizard enhancements
>
>
> Hi,
>
> I'm working in a database that has over 60 tables/views
> plus 15 sequence
> -Original Message-
> From: Ricardo Canani [mailto:[EMAIL PROTECTED]]
> Sent: 25 January 2002 12:35
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] [Refresh] button on SQL Output window
>
>
> Hi
>
> Sometimes I run a query and need to resize the columns
> of the SQ
