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,
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
On Mon, Nov 22, 2010 at 12:26 AM, Andreas maps...@gmx.net 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.
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
On Mon, Nov 22, 2010 at 10:21, Reto Schöning reto.schoen...@gmail.com 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
Plase don't drop the mailinglist from the thread.
On Mon, Nov 22, 2010 at 11:57, Reto Schöning reto.schoen...@gmail.com 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
On Fri, Nov 19, 2010 at 1:07 AM, Thom Brown t...@linux.com 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
On 22/11/2010, at 10:22 PM, Gurjeet Singh wrote:
On Fri, Nov 19, 2010 at 1:07 AM, Thom Brown t...@linux.com 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
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 mag...@hagander.net
Plase don't drop the mailinglist from the thread.
On
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 -
On Sat, Nov 20, 2010 at 12:41 AM, Rob Brown-Bayliss
r.brown.bayl...@gmail.com 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
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)
Magnus Hagander wrote:
On Sat, Nov 20, 2010 at 16:54, Bruce Momjian br...@momjian.us 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
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
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-bit
Thomas Kellerer spam_ea...@gmx.net 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
Tom Lane wrote on 22.11.2010 19:25:
Thomas Kellererspam_ea...@gmx.net 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
On 22/11/2010 19:01, Thomas Kellerer wrote:
Tom Lane wrote on 22.11.2010 19:25:
Thomas Kellererspam_ea...@gmx.net writes:
I'm curious why the following is not working:
postgres=# show client_encoding;
client_encoding
-
UTF8
(1 row)
postgres=# create table umlaut_test_ö
Raymond O'Donnell r...@iol.ie 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 assume
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
On 22 November 2010 19:36, Tom Lane t...@sss.pgh.pa.us 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
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
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:
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 a
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
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
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
--
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 primary
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 david.frank...@infinitecampus.com:
Is it possible to extend the COALESCE() function? I would like to support
for coalescing
29 matches
Mail list logo