Hi all,
I often come across tables with either a unique index or a unique
constraint on them, and psql isn't helpful at showing the difference
between the two. Normally, I don't care which is which, except for
when I have to manually drop and recreate the index or constraint to
speed up a bulk loa
On Fri, Apr 09, 2010 at 10:08:38AM -0700, arya6000 wrote:
> Connection refused. Check that the hostname and port are correct and that
> the postmaster is accepting TCP/IP connections.
Running the following on your server:
netstat -tnl
will tell you if PG is actually listening on the port you e
Ivan Voras wrote:
Ok, but I imagine there should be a difference between COMMITs
returning before or after the actual data is sent over the network
(though admittedly socket buffering could make it hard to
distinguish).
To be clear here: there is no direct connection whatsoever between the
On Fri, 9 Apr 2010 10:08:38 -0700 (PDT)
arya6000 wrote:
>
>
> Connection refused. Check that the hostname and port are correct and
> that the postmaster is accepting TCP/IP connections.
>
Are you sure that your firewall is allowing connections to port
5432/tcp?
Best regards
Rodrigo Gonzalez
On Fri, Apr 9, 2010 at 1:08 PM, arya6000 wrote:
>
> Hello
>
> I have spent hours trying to make this work, but its still not working. I
> tried to connect using my Java program and using pgAdmin III. Postgre is
> hosted on a Debian 5 64 bit vps and here are the changes I made.
>
> I edited postgr
Hello
I have spent hours trying to make this work, but its still not working. I
tried to connect using my Java program and using pgAdmin III. Postgre is
hosted on a Debian 5 64 bit vps and here are the changes I made.
I edited postgresql.conf
and changed
listen_addresses = 'local'
to
listen
On 9 April 2010 18:21, Greg Smith wrote:
> Ivan Voras wrote:
>>
>> I'd like to ask about the asynchronous nature of upcoming replication
>> implementation in 9.0 - what guarantees does it give with regards to
>> delays and latency? E.g. do COMMITs "finish" and return to the caller
>> before or aft
Ivan Voras wrote:
I'd like to ask about the asynchronous nature of upcoming replication
implementation in 9.0 - what guarantees does it give with regards to
delays and latency? E.g. do COMMITs "finish" and return to the caller
before or after the data is sent to the slave? (being asynchronous, th
Alan Millington wrote:
However, every language that I have ever used will implicitly convert
an integer 1 to a smallint (or short) 1 when required to do so. How
can such a cast be called "surprising behaviour", or produce
"misleading results", to quote the first article?
SELECT ' 1'=(' 1'
Hi Corin
It looks like you have it working correctly, however you are expecting the
FTS to do a task it does not. The FTS will not automattically correct a
spelling error.
If the FTS auto corrected search tokens, this would likely lead to
undesirable results. I believe you are approaching the
Thank you for that helpful information. I thought I was going mad!
It would never have occurred to me to write a join which relied on an implicit
cast between int and string. However, every language that I have ever used will
implicitly convert an integer 1 to a smallint (or short) 1 when requi
Hi,
Le 09/04/2010 16:10, Ivan Voras a écrit :
> [...]
> I'd like to ask about the asynchronous nature of upcoming replication
> implementation in 9.0 - what guarantees does it give with regards to
> delays and latency? E.g. do COMMITs "finish" and return to the caller
> before or after the data is
Hello,
I'd like to ask about the asynchronous nature of upcoming replication
implementation in 9.0 - what guarantees does it give with regards to
delays and latency? E.g. do COMMITs "finish" and return to the caller
before or after the data is sent to the slave? (being asynchronous, they
probably
Alan Millington wrote:
As far as I remember, when I was using Postgres 8.1.4 that worked, but
under Postgres 8.4.1 it results in the errors "Returned type integer
does not match expected type smallint" and "Returned type unknown does
not match expected type character".
There was a major b
Hi,
nobody here who knows how to get the postgre fulltext working with
ispell and stemming? :-(
So that when I search for 'gitar' also records containing 'guitar',
'guitars', ... will be found.
Any help would be really appreciated! :)
Thanks,
Corin
--- Begin Message ---
On 08.04.2010 21:2
Leif Biberg Kristensen writes:
> On Monday 5. April 2010 22.00.41 Peter Geoghegan wrote:
>> similar they sound. How can that actually be applied to get the
>> functionality that I've described?
>
> I've got a similar problem in my 18th century research, when clerks usually
> took pride in being a
I am using Postgres 8.4.1 on Windows XP Professional Service Pack 3.
I have a PL/pgSQL function which is defined as "returns record". The record
contains three values. In one execution path, the values are read from a table,
the selected columns being of types int, smallint and char(1). In anot
On 09/04/2010 03:47, Craig Ringer wrote:
> Make sure no Pg processes are running, then *delete* the program
> directory. Then clean up the registry entries Windows uses to track
[Jumping into this thread so this may have been said already]
Don't forget that on Windows the installer by default pu
On Fri, Apr 9, 2010 at 3:47 AM, Craig Ringer
wrote:
> On 8/04/2010 2:01 PM, Jeffrey Ottery wrote:
>>
>> Running Windows XP Pro. Have been successfully using and deploying
>> postgres for 2 years.
>>
>> When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove
>> Programs I get this message:
19 matches
Mail list logo
