Hello
I am afraid, so this isn't possible. You have to use a explicit cast
"int to bool"
select coalesce(true, 0::bool)
regards
Pavel Stehule
2010/11/23 David Frankson :
> Is it possible to extend the COALESCE() function? I would like to support
> for coalescing an int into a Boolean, but I g
Hello,
>
> Server: OS X 10.5
> PostgreSQL version: 8.3
>
> We experience this connection maxing out once in the full moon.
> The request from client reaches to the server but client never
> receive response back.
> The queries are very simple update on one record or select one
> record using p
Hello,
>
> I saw a reference to run a command "show hba_file" but there hasn't been
any
> clue as to WHERE one runs that command. Please hold my hand. Whichuser
(root
> or postgres) and which program?
Please try the command from psql.
postgres=# select user;
current_user
--
po
Hi,
I'm using Pg for bioinformatic work and I want to be able to insert,
uniquely, biological sequences into a table returning the sequence id -
this part is fine. However, if the sequence already exists in the table
I want to return to id.
At the moment it seems to me that I should do a
SELECT
Is it possible to extend the COALESCE() function? I would like to support for
coalescing an int into a Boolean, but I get syntax errors if I don't wrap
coalesce in quotes.
CREATE OR REPLACE FUNCTION coalesce(boolean,int) RETURNS boolean AS $$
SELECT CASE WHEN $1 IS NOT NULL THE
I get an error:
psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database
"template1"
when I try to run "psql template1" (which I have been doing successfully for
several years)
version 8.4.5 compiled with no switches
centos 5.5
It worked last week, not this week.
I saw
Hello all,
I'm not sure if this would be considered off topic, but I'd like to
point out this week's issue of the Chicken Gazette in which I describe
integration of array and "ROW" composite type handling with the
PostgreSQL library for the Chicken Scheme compiler:
http://gazette.call-cc.org/issue
Tom Lane wrote on 22.11.2010 20:36:
I had the idea that the Windows version of psql was smart enough to
set client_encoding based on the console encoding it finds itself
running under, but I might be wrong about that. Or maybe you did
something that overrode its default?
I changed to "chcp 125
On 22 November 2010 19:36, Tom Lane wrote:
> I had the idea that the Windows version of psql was smart enough to
> set client_encoding based on the console encoding it finds itself
> running under, but I might be wrong about that. Or maybe you did
> something that overrode its default?
Apparentl
Server: OS X 10.5
PostgreSQL version: 8.3
We experience this connection maxing out once in the full moon.
The request from client reaches to the server but client never receive response
back.
The queries are very simple update on one record or select one record using
primary key (checked curre
"Raymond O'Donnell" writes:
> On 22/11/2010 19:01, Thomas Kellerer wrote:
>> Tom Lane wrote on 22.11.2010 19:25:
>>> It looks to me like your console is not in fact producing UTF8;
>>> it's representing ö as 0xf6, which I think is right for Latin1.
>>> Select the proper client_encoding.
>> I assu
On 22/11/2010 19:01, Thomas Kellerer wrote:
Tom Lane wrote on 22.11.2010 19:25:
Thomas Kellerer writes:
I'm curious why the following is not working:
postgres=# show client_encoding;
client_encoding
-
UTF8
(1 row)
postgres=# create table umlaut_test_ö (id integer);
ERROR:
Tom Lane wrote on 22.11.2010 19:25:
Thomas Kellerer writes:
I'm curious why the following is not working:
postgres=# show client_encoding;
client_encoding
-
UTF8
(1 row)
postgres=# create table umlaut_test_ö (id integer);
ERROR: invalid byte sequence for encoding "
Thomas Kellerer writes:
> I'm curious why the following is not working:
> postgres=# show client_encoding;
> client_encoding
> -
> UTF8
> (1 row)
> postgres=# create table umlaut_test_ö (id integer);
> ERROR: invalid byte sequence for encoding "UTF8": 0xf6202869
It looks t
Hi,
I'm curious why the following is not working:
c:\psql postgres postgres
psql (9.0.1)
Type "help" for help.
postgres=# select version();
version
-
PostgreSQL 9.0.1, compiled by Visual C++ build 1500, 32-bi
This is what I did to get PGXS on Windows XP:
- built pg 9.0 from source using MinGW/MSYS
- also installed binary version of pg 9.0
- copied the PGXS tree from source into the corresponding path on
the binary install
Note: I had to use the binary install since the AV software on
Magnus Hagander wrote:
> On Sat, Nov 20, 2010 at 16:54, Bruce Momjian wrote:
> > Elliot Chance wrote:
> >> > Also, if someone registers on the forum, do they get a major domo
> >> > registration email? ?And if so, would this be set to receive no emails
> >> > upon registration? ?I'm not clear as
You could create a function calling that query with "Security Definer"
(the function will be called with the privileges of the user that
created the function) :
CREATE OR REPLACE FUNCTION stop_query(myprocpid int)
RETURNS BOOLEAN AS $$
DECLARE
b boolean;
BEGIN
SELECT pg_cancel_backend(myprocpid
On Sat, Nov 20, 2010 at 12:41 AM, Rob Brown-Bayliss
wrote:
> I am trying to catch time outs etc, basically after a set amount of
> time I am assuming something has failed.
Just set a statement timeout before running your potentially long
queries. Your client code will return an error which you c
Hmm. That's a simple SEC_E_LOGON_DENIED. Simply meaning
usedname/password is incorrect. The security eventlog on the server
(or domain controller) might have more information around it. If not,
I'm not sure what's wrong there - if it happens only in npgsql it must
be related to that. Or perhaps - b
Here's the log output for a failed connection:
2010-11-22 13:25:54 CET FATAL: could not accept SSPI security context
2010-11-22 13:25:54 CET DETAIL: The logon attempt failed
(8009030c)
2010/11/22 Magnus Hagander
> Plase don't drop the mailinglist from the thread.
>
>
> On Mon, Nov 22, 2010
On 22/11/2010, at 10:22 PM, Gurjeet Singh wrote:
> On Fri, Nov 19, 2010 at 1:07 AM, Thom Brown wrote:
>
> As has been said previously, an unlinked forum (one which has no
> interaction with the mailing list) is destined to fail, as others have
> in the past. It's creates a fragmented community
On Fri, Nov 19, 2010 at 1:07 AM, Thom Brown wrote:
>
> As has been said previously, an unlinked forum (one which has no
> interaction with the mailing list) is destined to fail, as others have
> in the past. It's creates a fragmented community and poor support on
> such a forum would reflect bad
Plase don't drop the mailinglist from the thread.
On Mon, Nov 22, 2010 at 11:57, Reto Schöning wrote:
> Thanks for the hint. The full error message from npgsql including that
> detail row is
> Npgsql.NpgsqlException was unhandled
> Message="FATAL: XX000: could not accept SSPI security context"
On Mon, Nov 22, 2010 at 10:21, Reto Schöning wrote:
> Hi,
>
> I've set up 8.3 to use SSPI for authentication (clients and server on
> windows XP). I can successfully connect from clients using psql and another
> db client using SSPI authentication. However when trying to connect with
> Npgsql (2.0
Hi,
I've set up 8.3 to use SSPI for authentication (clients and server on
windows XP). I can successfully connect from clients using psql and another
db client using SSPI authentication. However when trying to connect with
Npgsql (2.0.11) as the same user, the following error occurs:
"could no
On Mon, Nov 22, 2010 at 12:26 AM, Andreas wrote:
> Am 22.11.2010 08:32, schrieb Adarsh Sharma:
>>
>> I am reading about Dialects of different databases. Yet I can't understand
>> what is the need of dialect in Postgres or any other like Hibernate uses
>> Dialect of all Databases for ORM.
>> What i
Am 22.11.2010 08:32, schrieb Adarsh Sharma:
I am reading about Dialects of different databases. Yet I can't
understand what is the need of dialect in Postgres or any other like
Hibernate uses Dialect of all Databases for ORM.
What is it &
As far as I know, the term dialect is used to express
If I understand your question correctly, a Dialect is an abstraction
layer that allows Hibernate to talk with different database backends
(MySQL, PG, Oracle, SQLServer, etc). Since different databases have
different syntaxes, various features, etc. This seems more of a
Hibernate question though,
29 matches
Mail list logo
