On 07 Mar 2013, at 1:05 AM, Ian Lawrence Barwick wrote:
>> Can anyone explain what might be going wrong, and what I should do instead?
>>
>> patricia=# \set content `cat /tmp/certificates.txt`
>> patricia=# update property set value = :'content' where key =
>> 'patricia.home.security.cacerts';
Hi all,
I have a text file, and I need to update the value of an element in a table
with the contents of this text file. Following the instructions at
http://stackoverflow.com/questions/10968039/postgresql-inserting-value-of-a-column-from-a-file
I tried this, but get the error below, which I do
On 09 Nov 2010, at 7:30 PM, David Boreham wrote:
Sorry but this is 100% not true. It may be true for a 3rd party (you
release something under the GPL, I enhance it, therefore I am
required to release my enhancement under the GPL). But Oracle owns
the copyright to the MySql code and therefor
On 09 Nov 2010, at 7:16 PM, Gauthier, Dave wrote:
Think upgrades
This is covered by the GPL license. Once you have released code under
the GPL, all derivative code - ie upgrades - have to also be released
in source form, under the GPL license.
Regards,
Graham
--
--
Sent via pgsql-gener
On 12 Oct 2010, at 2:27 AM, Darren Duncan wrote:
Some people would say that "NoSQL" is a contrast with relational
databases but I would say that in fact these things are orthogonal.
You can in fact use the relational model of data over both an ACID
database as over a "NoSQL" database, just
On 04 Jul 2010, at 12:49 AM, Tom Lane wrote:
I'd bet that you are using a client-side driver that feels a need to
fetch metadata about the tables it's working with. JDBC or ODBC
maybe?
A reasonable driver would cache such information, so if there are
enough
of these to present a performa
Hi all,
I am currently trying to analyse some performance problems within my
postgresql v8.4.4 database, and after successfully turning sql
statement logging on, I discover thousands and thousands of queries
being made what looks like an internal postgresql set of tables in a
database cal
Christopher Browne wrote:
But to get the pennies right on a $10,000 USD transaction converted
into GBP (UK Pounds), you need all the official precision that there
is. And if your calculation is off by 4 cents, some of those
accounting folk are liable to thrash you mercilessly over it. If you
get
Hi all,
I am trying to do a query that returns all rows that are _not_ part of
a join, and so far I cannot seem to find a query that doesn't take 30
minutes or more to run.
The basic query is "select * from tableA where tableA_id NOT IN (select
tableA_id from tableB)".
Is there a more efficient w
Barry Lind wrote:
> I am guessing from the error that you are using JDBC as your client.
> This looks like a known issue with the 7.0 jdbc driver. Have your tried
> the 7.1 jdbc driver? (as long as you don't use the DatabaseMetadata
> object too much, the 7.1 driver should work fine against a 7
Martijn van Oosterhout wrote:
> > vendirza=# SHOW DATESTYLE;
> > NOTICE: DateStyle is ISO with US (NonEuropean) conventions
> >
> > vendirza=# SHOW DATESTYLE;
> > NOTICE: DateStyle is ISO with US (NonEuropean) conventions
>
> Looks the same machine to me.
That's because both machines are conf
11 matches
Mail list logo
