If you use odbc you should be able to use
https://msdn.microsoft.com/en-us/library/hh568451%28v=sql.110%29.aspx
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2015-06-07 1:08 GMT+02:00 Geoff Montee geoff.mon...@gmail.com:
On Mon, May 18, 2015 at 11:24 AM
vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2015-03-17 10:01 GMT+01:00 Deole, Pushkar (Pushkar) pde...@avaya.com:
Hi,
I just tried a POC with PostgreSQL’s streaming replication for the use
case of my product. Since streaming replication is master-slave, when
failover occurs
AS normSum
FROM NormCTE
ORDER BY normSum DESC
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2014-08-03 13:20 GMT+02:00 Tim Smith gb10hkzo-postg...@yahoo.co.uk:
Hi,
I'm on Postgres 9.3.5, however I think my knowledge of Postgres is not
deep enough
Or...
Do you mean to use windowing functions?
http://www.postgresql.org/docs/9.3/static/tutorial-window.html
Or both of course...
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2014-08-04 19:43 GMT+02:00 Serge Fonville serge.fonvi...@gmail.com:
Hi
,
Serge Fonville
http://www.sergefonville.nl
2014-05-07 11:44 GMT+02:00 Geoff Montee geoff.mon...@gmail.com:
On Wed, May 7, 2014 at 12:31 AM, Sameer Kumar sameer.ku...@ashnik.comwrote:
Hi,
I need to setup a replication process for continuously replicating
changes happening in an Oracle
Hi,
ERROR: column reference firewall is ambiguous
LINE 3: ... a WHERE NOT EXISTS (SELECT * FROM upsert b WHERE b.firewall...
set firewal = misses a table
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2013/12/4 Eric Lamer e...@phoenixsecure.com
Hi
into for example Apache Cassandra.
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2013/10/17 Bill Moran wmo...@potentialtech.com
If they pull out the Mongo is faster than PostgreSQL card, I'll state
that
I investigated this for my current employer
to solve.
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
Please don't get rid of the MCM and MCA
programshttps://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table
2013/9/6 Agustin
Hi,
http://www.postgresql.org/docs/9.1/static/functions-conditional.html describes
NULLIF, when combined with COALESCE it should answer your request.
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add TRUNCATE PARTITION
Hi,
I'm not sure if I understand your issue, but could you output
SELECT
COUNT(*)
FROM rmas
WHERE
id = 1008122437
AND status = 'r';
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
implementation, could you share which one that is?
Have you defined things like Foreign Key constraints, Indexes, Statistics?
Also could you share some queries and their plans?
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add
Hi,
Based on my understanding of the problem, would this be possible to solve
with a MERGE statement?
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com
Hmm, nvm :-(
PostgreSQL does not yet support MERGE...
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition
on connecting
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table
2013/1/13 Adrian Klaver
If you use EXISTS in the WHERE clause, you should come closer to what you
want realised.
For further help it would make it easier if you shared the whole queries
and perhaps a more detailed description of the goal you are trying to
accomplish.
HTH
Kind regards/met vriendelijke groet,
Serge
Hi,
Assuming the columns in t2 are fixed, you should be able fairly easy solve
this using a cursor.
HTH
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer
MSSQL uses an index to maintain the cluster.
If a record fits between it places it there, if it doesn't, it considers
either moving data or adding it physically out of order (while maintaining
the index)
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince
The data files contain only one active version of every record. Different
versions of that same record are maintained in a version store.
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https
This indeed is a very interesting question.
At http://wiki.postgresql.org/wiki/CTEReadme it seems to suggest that a CTE
is just rewritten and the resulting query is executed.
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Microsoft!
They need to add
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Google!!
They need to add GAL support on Android (star to agree)
http://code.google.com/p/android/issues/detail?id=4602
2012/2/24 mgo...@isstrucksoftware.net
We are using it on a rather beefy server
Doesn't
http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C_despite_having_capable_hardware
apply?
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
Convince Google
and you have the full power
of PL/SQL at your direct disposal.
This does integrate more, but makes you a lot less flexible imho.
So it depends on where your (or your team's) skills are
For the rest it depends on the criteria for the app.
HTH
Just my 2ct
Kind regards/met vriendelijke groet,
Serge
command, but it did not work:
archive_command = 'if not exist C:\\pgsql\\backup_in_progress || copy
%p C:\\pgsqlarchive\\%f'
The error is:
|| was unexpected at this time.
windows does not support OR in batch files.
if you remove || it should work
HTH
Regards,
Serge Fonville
Hi,
I googled for 'migrate mysql to postgresql' the first 5 results seem
very useful.
The most useful link I found was http://www.raditha.com/mysql/mysql2pgsql.php
HTH
Regards,
Serge Fonville
On Fri, Jan 22, 2010 at 8:15 PM, Erik Jones ejo...@engineyard.com wrote:
Hello,
Given that the EU
outer join
HTH
Regards,
Serge Fonville
On Thu, Sep 17, 2009 at 4:29 PM, Paul M Foster pa...@quillandmouse.comwrote:
Folks:
I can't find a way to do this purely with SQL. Any help would be
appreciated.
Table 1: urls
id | url
--
1 | alfa
2 | bravo
3 | charlie
4 | delta
needing the
information to interpret that data?
After googling for restore corrupted postgresql, I found
http://cobaltfaqs.com/index.php/Rebuilding_corrupt_PostgreSQL_database,
which may be relevant.
Perhaps you need to specify the exact error you get...
HTH.
Regards,
Serge Fonville
steps, settings and output?
That makes it a lot easier to determine the exact issue.
Also, have you checked the event log?
Regards,
Serge Fonville
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
What is the output you are trying to achieve?
However, the same phone number might have a prefix on occasion, example :
name | phone_number
--
james | 123456
james | 00441234556
james | 555666
sarah | 567890
sarah | 567890
as you can see, the first 2 James seems to
with the correct information
Regards,
Serge Fonville
On Fri, Jul 3, 2009 at 11:52 AM, fernstud...@hotmail.com wrote:
Dear Friends:
We are a large wholesaler who mainly sell electrical products
such as laptop,TV,digital camera, mobile, Digital Video, Mp4, GPS, and so
on. And our
has string
functionshttp://developer.postgresql.org/pgdocs/postgres/functions-string.html
,
you can use these in your where clause
Hope this helps.
Regards,
Serge Fonville
database engines do you already have experience with
Why do you want to know this (what is your endgoal)
What have you already researched (googled)
Are you migrating data or is it a new setup.
What do the servers look like
To name a few questions that come to mind
Hope this helps
Regards,
Serge
The only meaningful benchmark is your application, all other benchmarks
only measure the performance of the benchmark.
As a benchmark you can also look into
http://developer.postgresql.org/pgdocs/postgres/pgbench.html
Hope this helps
Regards,
Serge Fonville
start to have an idea about what the best suitable solution is for
my situation.
I was hoping there would be some sort of patch for the PostgreSQL download
instead of an entire rebuild of the sources.
I'll post any updates I find.
Thanks a lot everyone
Regards,
Serge Fonville
Hi,
The swithc -d is for the directory that is populated when running initdb, it
contains logging, configuration and databases
Hope this helps
Regards,
Serge Fonville
On Sat, Feb 14, 2009 at 11:10 PM, Bob Pawley rjpaw...@shaw.ca wrote:
I am attempting to load postmaster.
pg_ctl reload
I
this helps
Regards,
Serge Fonville
I have fear that sufficient increase in number of postgres.exe after one or
two logins on servers may down the speed of the server or even server. Is
there any solution or technique to overcome this overhead.
I did some more searching and foundIs PostgreSQL
in advance,
Serge Fonville
asynchronous replication is just not enough to model a certain
business case.
Therefore Cybertec Schönig Schönig GmbH offers a synchronous multimaster
replication solution for PostgreSQL called Cybercluster.
Thanks,
Serge Fonville
Serge Fonville wrote:
So, DRBD dual primary and Cybercluster multimaster, cannot be combined?
If you have questions on Cybercluster, you should perhaps ask there for
details. For normal PostgreSQL, using DRBD dual primary is not possible.
You are right, thanks
My endgoal
this helps
Regards,
Serge fonville
On Wed, Jan 7, 2009 at 12:41 PM, Donna Rudd do...@therudds.co.uk wrote:
Hi,
All I want to do is 'include' a stored procedure (contained in another
script file) into my main PostgreSQL database creation script file so that
it can get defined/declared before I
On Thu, Dec 4, 2008 at 3:42 PM, Gustavo Rosso [EMAIL PROTECTED] wrote:
I created this table:
create table se (n serial);
Column | Type | Modifiers
-+-+
n | integer| not null default
': No such file or directory
To resolve the lack of 'netinet/in.h' on Windows, take a look at uwin,
gnuwin and libgw32c
Hope this helps.
Regards,
Serge Fonville
': No such file or directory
To resolve the lack of 'netinet/in.h' on Windows, take a look at uwin,
gnuwin and libgw32c
Hope this helps.
Regards,
Serge Fonville
previously configured a similar application (SQL
Server,Exchange,ISA,etc)
Is moving to another OS an option
How long should implementation take
Regards,
Serge Fonville
On Tue, Nov 18, 2008 at 5:09 PM, Pietro Tedesco
[EMAIL PROTECTED] wrote:
We have an instance of PostgreSQL on Windows 2003
previously configured a similar application (SQL
Server,Exchange,ISA,etc)
Is moving to another OS an option
How long should implementation take
Regards,
Serge Fonville
Windows Vista x64 and have mingw-w64 and Visual
Studio 2008 installed
Thanks a lot in advance.
Serge Fonville
To resolve the issue, a little bit more information would be very useful.What
OS are you using
What resource have you used to install the software
(tutorial,howto,reference, guide,etc)
What is the exact error you get and what program gives that error
Regards,
Serge Fonville
On Fri, Nov 14, 2008
: Serge Fonville
A : pgsql-general@postgresql.org, [EMAIL PROTECTED]
Copie à :
Objet : Re: [JDBC] Re : [pgadmin-support] trouble in installing
postgreSQL 8.3
To resolve the issue, a little bit more information would be very useful.
What OS are you using
What resource have you used
Have you checked the logsWhat have you configured
What os are you using
What version of postgresql
Have you run netstat to check for port 5432
Regards,
Serge Fonville
On Wed, Nov 5, 2008 at 4:11 PM, Joshua Tolley [EMAIL PROTECTED] wrote:
On Wed, Nov 05, 2008 at 08:34:55PM +0530, Shashank
, I would really
like to understand why this happens
Thanks in advance,
Serge Fonville
Hi,
Did you check permissions?
Do the pid files exist?
What variables are set?
Regards,
Serge Fonville
On Wed, Oct 29, 2008 at 4:43 PM, Thom Brown [EMAIL PROTECTED] wrote:
Hi,
I've got a development virtual server which matches live exactly
except for the fact that Postgres is running
to the distance
Regards,
Serge Fonville
On Mon, Oct 27, 2008 at 11:50 AM, Andreas Jochem [EMAIL PROTECTED] wrote:
Hello,
I have a table containing x y z coordinates. But I have no geometry column?
Is it possible to find the k nearest neighbors of any point. Is there
something like a kd-tree Index
On Fri, Oct 17, 2008 at 9:26 PM, Serge Fonville [EMAIL PROTECTED]wrote:
Altough I am not sure what the real issue is,I do know that on (for
example) the tomcat mailing list, when I choose reply (in gmail) the to:
field contains the address of the mailing list.
Based on what I know
Recently I started to move from MySQL to PostgreSQL.When I had it set up on
windows, I enabled ssl and everything worked like a charm.
My pg_hba.conf looks like this:
hostsslallpostgres 127.0.0.1/32 md5
hostssl ticketsystem ticketsystem127.0.0.1/32md5
hostsslfaq faq 127.0.0.1/32 md5
hostssl
kept
Is this due to the SSL connection, or is it related to some other error
And is it 'fixable'
I already searched the mailing list and google, but to no avail.
Thanks in advance
Serge Fonville
One thing I forgot.
The errors occur when I use psql.exe with the -U paramter
-- Forwarded message --
From: Serge Fonville [EMAIL PROTECTED]
Date: Fri, Oct 10, 2008 at 3:00 PM
Subject: Fwd: Socket error instead of Access denied
To: pgsql-general pgsql-general@postgresql.org
56 matches
Mail list logo