Re: [GENERAL] Postgress latest Windows Version

[Tony Reina]

[EMAIL PROTECTED] (Praveen) wrote in message news:<[EMAIL PROTECTED]>...

> Can anybody tell from where i can download the latest Postgress Windows version?
> 

http://www.hagander.net/pgsql/win32snap/

---(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

[GENERAL] Can connection pointer be obtained from PGresult?

[Tony Reina]

I inherited some C code that works as a series of libraries using
libpq. One of the libraries has an input to it of a PGresult pointer,
but not of a PGconnect pointer. Within the library, the code tries to
determine the host name of the connection by doing the following
trick:

 strcpy (host,PQhost(((PGresult*)*pgresult)->xconn));

This worked fine in the past (v. 7.0) despite being warned against in
the documentation since directly accessing the structures in PGresult
seems to be off limits (I suppose in case its structure changes with
PG version).

I'm trying to think of a workaround that would do things right without
having to explicitly pass PGconn pointer into the code. Perhaps this
can't be done, but I thought I'd throw out the question and wait for
the verbal abuse.

-Tony

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

Re: [GENERAL] can't build libpq with beta 2

[Tony Reina]

You've probably done this, but I should ask anyway. 

Did you run the vcvars.bat to set the environment variables for MS VC?

I know I've run into this is previous versions, but IIRC it was operator error.

-Tony

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

[GENERAL] Re: Coursor keys don't work in "psql"

[Tony Reina]

Stuart Grimshaw <[EMAIL PROTECTED]> wrote in message 
news:<81x97.56$O34.7220@wards>...
> Can anyone explain why my cursor keys don't work in psql?
> 
> When I press one I get Up = ^[[A down = ^[[B etc.
> 
> The last company I used to work for had the cursor keys working OK to 
> scroll back through queries and cycle up & down through the last queries 
> executed, so what might my problem be?

It sounds like your version of Postgres wasn't compiled with readline
libraries. You (or your system administrator) will need to re-compile
and make sure that the libraries are installed on your system and
found by the Postgres configure script during installation.

-Tony

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

[GENERAL] Re: is this possible? it should be!

[Tony Reina]

> select a,b,c from a where d=2 order by e limit 10;
> select count(*) from a where d=2;
> 
> The point is that I want to know the total number
> of matches and I also want to use "limit".  And
> I don't want to do two queries.
>

Perhaps GROUP BY will get you where you want to go:

select count(*), a, b, c from a where d=2 group by a, b, c order by e limit 10;


-Tony

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

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

Re: [GENERAL] [HACKERS] not on .hackers

[Tony Reina]

"Colin 't Hart" <[EMAIL PROTECTED]> wrote in message news:<9oo6en$qr8$[EMAIL PROTECTED]>...
> August Zajonc:
> 
> > I tend to follow the mailing list through news.postgresql.org, and it
>  seems
> > like all the -hackers messages are ending up in the .general group rather
> > than .hackers.
> 
> I also follow the mailing list(s) through news.postgresql.org and now that
> you mention it ...
> 
> It hasn't always been like this.

I'm getting the same thing. Almost nothing is going to the Hackers
list on Google groups (old Dejanews). They all seem to be sent to
other lists with the [HACKERS] id in the subject.

-Tony

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