[ADMIN] trouble with table creation

[pmiranda]

Hi, fellows!

I'm getting crazy with a stupid question. I have just created a Database
using pgadmin.exe, then I've created a table named "tabCliente" and, of
course, wanted to populate it. Everything was working fine since I tried to
use pgadmin's sql tool. An idiot sentence like "insert into tabCliente
(iCodCliente, nomCliente) values (NextVal('sqCliente'), 'Nome do Cliente')
resulted in an error message like this:

"Error: -2147467259
Error while executing the query (non-fatal);
ERROR: Relation 'tabcliente' does not exist

function: frmSQL, cmdExecute_Click"

Please! Anyone know what have I missed? Is that a problem with pgadmin?
Help me, please!

The user has total privileges over the database.

Thanks in advance for any advice.

Regards,


Paulo



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[ADMIN] RE: Can't I do that?

[pmiranda]

Hi,

I'd like to thank you all, for your kind responses. Now, I think I can do
the job.

If I can be of any service, please, be my guests.

As we say here, in Brazil,

"Abraços", (hugs)


Paulo


- Forwarded by Paulo Miranda/RJ/VMCS on 07/08/01 09:17 -
   
  
"Henshall, Stuart - WCP"   
  
,  
ons.co.uk> [EMAIL PROTECTED]  
  
Sent by:   cc: 
  
[EMAIL PROTECTED]Subject: [ADMIN] RE: 
Can't I do that? 
g  
  
   
  
   
  
07/08/01 06:33 
  
   
  
   
  




Try using a select query.
(eg SELECT func_name(arg1,arg2) AS result)
- Stuart

> -Original Message-
> From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent:   Friday, August 03, 2001 4:30 PM
> To: [EMAIL PROTECTED]
> Subject: Can't I do that?
>
> Hi, all!
>
> I'm pretty novice in using PostgreSql and I have many dummy questions.
> Please forgive me for that!
>
> I intend to use it with Delphi 6, and I was trying to call a function
that
> I have just created.
>
> So, I dropped an StoredProc to the DataModule's application, and changed
> the DataBaseName property to the one who represents the ODBC connection
to
> Postgres.
>
> When I tried to set the StoredProcName propertie, Delphi IDE's told me :
> "Capability not supported".
>
> Does this mean that I can't use stored procedures with Postgres?
>
> Does anyone of you know some source of information about using Delphi
with
> Postgres ?
>
> I'll be very grateful for any advice.
>
> Thanks in advance,
>
> Paulo
>
>

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Top

[pmiranda]

Hi,

Please, does anyone know if is there in Postgres's SQL language an
equivalent for Oracle's TOP ?

Thanks again,


Paulo



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

RE: [ADMIN] Re: Top

[pmiranda]

- Forwarded by Paulo Miranda/RJ/VMCS on 08/08/01 15:39 -
   

Paulo Miranda  

 To: "Michael Ansley (UK)" 
<[EMAIL PROTECTED]>  
08/08/01 15:34   cc:   

 Subject: RE: [ADMIN] Re: Top(Document 
link: Paulo Miranda)
   




Mike,

Thank you very much. After writing the first message, (cause I'm behind
schedule) I tried that and it worked fine. Thanks for the other tips,
they'll be very useful for me.

I wanna thank Colin, too, and ask him to forgive my mistake. TOP is, in
fact, a SQLSERVER's SELECT clause (or whatever they call it). I don't even
know if there's something that compares to this in Oracle.

In portuguese, we say "obrigado" for "thank you". From now on, I ask you to
allow me to use this expression instead of the one in english. (I know I'll
make some many questions to you...)

:)


Paulo




   
   
"Michael Ansley (UK)"  
   
  <[EMAIL PROTECTED]>   
   
Sent by:cc:
   
[EMAIL PROTECTED]Subject: RE: [ADMIN] 
Re: Top  
   
   
   
   
08/08/01 05:54 
   
   
   
   
   






-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Anyway, it's a combination of ORDER BY and LIMIT:

SELECT * FROM table1 ORDER BY field1 DESC LIMIT 10;

or, if you want the bottom ten:

SELECT * FROM table1 ORDER BY field1 LIMIT 10;

Or, if you want the next ten:

SELECT * FROM table1 ORDER BY field1 LIMIT 10, 10;

or something to that effect.

MikeA

>> -Original Message-
>> From: Colin 't Hart [mailto:[EMAIL PROTECTED]]
>> Sent: 08 August 2001 08:17
>> To: [EMAIL PROTECTED]
>> Subject: [ADMIN] Re: Top
>>
>>
>> > Please, does anyone know if is there in Postgres's SQL language
>> > an equivalent for Oracle's TOP ?
>>
>> Ummm, Oracle's SQL doesn't have a TOP.
>>
>> Are you thinking of SQL Server?
>>
>>
>> Cheers,
>>
>> Colin
>>
>>
>>
>>
>> ---(end of
>> broadcast)---
>> TIP 1: subscribe and unsubscribe commands go to
>> [EMAIL PROTECTED]
>>

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use 

iQA/AwUBO3D+BXympNV/C086EQLevwCgpxcbIiA4OWcjmXQhirB0g4Ts4wEAnjSv
WxaprcluB2uhv5gmtaM6rCbI
=jPE0
-END PGP SIGNATURE-


_
This e-mail and any attachments are confidential and may also be privileged
and/or copyright
material of Intec Telecom Systems PLC (or its affiliated companies).  If
you are not an
intended or authorised recipient of this e-mail or have received it in
error, please delete
it immediately and notify the sender by e-mail.  In such a case, reading,
reproducing,
printing or further dissemination of this e-mail is strictly prohibited and
may be unlawful.
Intec Telecom Systems PLC. does not represent or warrant that an attachment
hereto is free
from computer viruses or other defects. The opinions expressed in this
e-mail and any
attachments may be those of the author and are not necessarily those of
Intec Telecom
Systems PLC.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
__






---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Problems with remote access

[pmiranda]

Hi,

I've been using Postgres locally in an Win95 + Delphi environment.
Everything is fine. Now, I wanted to access the database remotelly. I
installed the ODBC driver in another micro and tried to insert a record in
a table. It didn't work at all. I can see records on a grid, but the system
doesn't allow me to make any changes (INSERT, DELETE or UPDATE). Can anyone
of you tell me why and what can I do to fix this strange behavior ?

Thanks in advance,

Paulo


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Problems with remote access

[pmiranda]

Hi Andre,

I wanna thank you so much for the valuable information. It's now working
very well.

Thanks a lot!

Regards,

Paulo



   

A_Schnabel@t-  

online.deTo: <[EMAIL PROTECTED]>, 
<[EMAIL PROTECTED]>
(Andre   cc:   

Schnabel)Subject: Re: [ADMIN] Problems with remote 
access  
   

28/08/01   

02:48  

   

   





- Original Message -
From: <[EMAIL PROTECTED]>
Subject: [ADMIN] Problems with remote access


> a table. It didn't work at all. I can see records on a grid, but the
system
> doesn't allow me to make any changes (INSERT, DELETE or UPDATE). Can
anyone
> of you tell me why and what can I do to fix this strange behavior ?
>

Hi Paulo,

check the settings of the ODBC-Driver. There are two buttons (driver and
datasource). For both there is an ReadOnly-Option, true per default. Set
this to false an your INSERTs should work.






---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[ADMIN] pg_dump & Win 9X/NT

[pmiranda]

Hi,

Does anyone know how can I make a copy of a database to another machine
(I'm using Postgres under Win95)?

I tried to use pg_dump + pg_restore, but I don't know the correct usage of
them under Win 9X/NT. I'd appreciate any tips in that matter.

Thanks in advance.


Paulo



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[ADMIN] pg_dump & windows (what a mess...!)

[pmiranda]

Hi,

I think I'm closer than yesterday to solving my troubles, but still need
some help (remember I couldn't start pg_dump from DOS' command line? well,
I still can't).

As I couldn't what I was trying to, I tried to connect to Postgres via psql
(from the command line) and I got the message:

connectDB() -- connect() failed: No such file or directory
Is the postmaster running at 'localhost' and accepting connections on Unix
socket '5432'?

I figured that, although through Windows clients everything works fine,
maybe from the command line it's not recognizing where Postgres is. Maybe,
I missed some configuration parameter or something else (TCP/IP perhaps
what's pg_hba.conf for? How can I change it?)

Can anyone of you, please, give me some advice? I'm getting crazy! My boss
will eat my liver, if I don't have this thing fixed right away

Thanks in advance, for your patience.


Regards from Brazil

Paulo

A last question: Is there anybody in this crazy world as innocent as myself
using Postgres & Windows?


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [ADMIN] pg_dump & windows (what a mess...!)

[pmiranda]

Hi, Stephan!

No, unfortunately, not. It doesn't work at all.

But I'm not lost anymore. Our buddy Tony Reina asked me to do a few things,
among them, setting some variables like pghost and pgdata, and, now
everything is okay.

I wanna thank all of you who kindly answered my post.

I'm working hard to be as good as yourselves and can help others like me
who are initiating with Postgres. I choose a platform which is not likely
to be very popular in open-source's world, so... who knows, can I, in the
future, get there?!

Thank you, very much, again.


Greetings from Brazil,

Paulo




   
 
Stephan Szabo  
 
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]   
 
panda.com>cc:  
 
  Subject: Re: [ADMIN] pg_dump & 
windows (what a mess...!)  
06/09/01 21:06 
 
   
 
   
 





On Thu, 6 Sep 2001 [EMAIL PROTECTED] wrote:

> Hi,
>
> I think I'm closer than yesterday to solving my troubles, but still need
> some help (remember I couldn't start pg_dump from DOS' command line?
well,
> I still can't).
>
> As I couldn't what I was trying to, I tried to connect to Postgres via
psql
> (from the command line) and I got the message:
>
> connectDB() -- connect() failed: No such file or directory
> Is the postmaster running at 'localhost' and accepting connections on
Unix
> socket '5432'?
>

Hmm, do
psql -h localhost
pg_dump -h localhost
work?

I think that'll force tcp connections rather than trying for a local unix
socket.  I haven't worked with postgres under windows, but that might help
you.






---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl