On Thursday 21 April 2016 13:36:54 Guyren Howe wrote:
> Anyone familiar with the issue would have to say that the tech world would
> be a significantly better place if IBM had developed a real relational
> database with an elegant query language rather than the awful camel of a
> thing that is
On Friday 28 Dec 2012, nevillekb wrote:
Hi,
Can anyone tell me which free GUI based tools are available for creating
database diagrams for my database in postgresql.
Thanks,
Neville.
--
View this message in context:
cascades.
The most efficient way is to have a separate backend module per
database
(or db version) supported. The quickest way is to write code that will
work on any db but won't take advantage of db-specific features.
David Goodenough wrote:
This is what I am trying to encourage. I am
On Sunday 20 June 2010, Peter Eisentraut wrote:
On lör, 2010-06-19 at 22:56 +0100, David Goodenough wrote:
These projects need help to realise that adding Postgresql is not a
big
job, especially for those using JDBC which can already connect to all
DBs. It strikes me that if the project
On 6/20/2010 12:08 PM, David Goodenough wrote:
On Sunday 20 June 2010, Peter Eisentraut wrote:
On lör, 2010-06-19 at 22:56 +0100, David Goodenough wrote:
These projects need help to realise that adding Postgresql is not a
big
job, especially for those using JDBC which can already connect
I happened across (yet) another open source project which supports
MySql and Derby (its a Java app) and is thinking about supporting
Oracle (they have actually bought a licence) but does not support
Postgresql. This particular project is onehippo.org, but there are many
others. Another perhaps
On Monday 15 June 2009, Gnanam wrote:
Hi,
I'm designing a database schema in which I should allow user to create
custom fields at the application level. My application is a web-based
system and it has multiple companies in a single database. So this means
that each company can create
I have a database which was created as LATIN1 (the machine has the
wrong locales installed when I set up PG). It is running 8.3.
So I found various places which said the way to do this was to do
a pg_dumpall -f dump_file, get rid of the entire database, init_db -E UTF-8,
and then psql -f
On Thursday 22 January 2009, Vladimir Konrad wrote:
Is there a definative HOWTO that I can follow, if not does someone
have a set of instructions that will work?
What about running iconv command on the dumped .sql file and transform
it to the utf8?
Vlad
PS: man iconv for manual
iconv
On Thursday 22 January 2009, Vladimir Konrad wrote:
iconv does not change the database encodings embedded in the file
(and it is quite large).
Have you read the manual?
file A pathname of an input file. If no file operands are
specified, or if a file operand is '-', the
On Friday 15 August 2008, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
Working on the zone file data and I am getting close but keep running
into the differences between MX records (with a priority) and the others
that can hold either a
What is the proper way to attach additional information about users of
a database. That is to say I am using their DB login as their application
ID, and I need to have one or more tables which remember preferences and
other application level things, but the key is their current userid and
I
I have a table that consists of a set of regular expressions, a priority
and a result. I need to be able to match field in another table against
the set of regular expressions (ordered by priority) and use the first result.
Reading the documentation I can see how to put the regular expression
On Friday 22 June 2007, David Goodenough wrote:
I have a table that consists of a set of regular expressions, a priority
and a result. I need to be able to match field in another table against
the set of regular expressions (ordered by priority) and use the first
result.
Reading
This may seem like a question unrelated to Postgresql, but I have recently
noticed a project that is having a discussion about how their code should
be developed. They are (unfortunately) developing first with MySQL, because
that is what they are familiar with (I assume), but that inevitably
I have a servlet which gets its data through a DataSource (Tomcat 5.5)
and starts each request as a new SQL transaction and either commits
the transaction or rolls it back at the end of each request.
In one of the requests I do a SELECT ... INTO TEMPORARY t1 ..., which
works just fine when I
http://developers.slashdot.org/article.pl?sid=06/12/13/1515217from=rss
MySQL quietly deprecated support for most Linux distributions on October 16,
when its 'MySQL Network' support plan was replaced by 'MySQL Enterprise.'
MySQL now supports only two Linux distributions — Red Hat Enterprise
The following appeared this afternoon on the DbMail list. As someone
replied the MySql used is old, and the newer one is faster, but then
8.2 is faster than the older Postgresql versions.
This was posted by:- Justin McAleer [EMAIL PROTECTED]
I figured I would go ahead and toss this out for
I have an application running on a Tomcat cluster talking to a cluster of
Postgresql DBs using HA-JDBC. If one of the members drop out of the cluster
it is necessary to get that member back into sync with the rest of the
cluster, and I have an application specific piece of code that does that.
On Tuesday 05 December 2006 10:57, Bernd Helmle wrote:
On Tue, 5 Dec 2006 10:18:21 +, David Goodenough
[EMAIL PROTECTED] wrote:
[...]
The first bits of the sync are done without locking the source tables,
and I do these until I find less than some suitable threshold of records
On Tuesday 05 December 2006 12:03, Richard Huxton wrote:
David Goodenough wrote:
On Tuesday 05 December 2006 10:57, Bernd Helmle wrote:
On Tue, 5 Dec 2006 10:18:21 +, David Goodenough
[EMAIL PROTECTED] wrote:
The statements issued to lock each table is:-
LOCK TABLE table
I have a process that is hitting deadlocks. The message I get talks about
relation and database numbers, not names. How do I map the numbers back
into names?
David
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an
I realise this is not strictly a Postgresql problem but I wondered if anyone
here was using ha-jdbc. I have tried asking on their mailing list but
apart from two of my questions there has been no traffic for 24 hours
and it appears to be a dead list.
I have a sngle instance of ha-jdbc working
On Sunday 30 April 2006 12:01, Tony Lausin wrote:
Hello all,
I'm working on a CMS which requires an open source database capable of
handling hundreds of thousands of users simultaneously, with a high
rate of database writes, and without buckling. We're talking somewhere
between
I have some generic code to which I pass a series of values to be inserted
into a PostgreSQL table which includes a field which is defined as a timestamp
and which I wish to populate with a string of the form
-MM-dd hh:mm:ss.SSS. Under pg 8 and before this worked fine
but now with 8.1 I
I have a DB (PostgreSQL of course) which has in the definition of one of
its tables that the default is nextval(public.rr_id_seq'::text). When I look
in the sequence I see that the last_value column is 40, but the largest
value in the relevant column is 45. I tried using the SQL update command
On Thursday 02 February 2006 09:07, Leif B. Kristensen wrote:
On Thursday 02 February 2006 09:05, Michael Glaesemann wrote:
For people I'm more or less stumped. I can't think of a combination
of things that I know I'll be able to get from people that I'll want
to be able to add to the
On Friday 16 September 2005 20:37, Josh Berkus wrote:
People:
The Eclipse project is interested in having PostgreSQL people contribute to
their Data Services plug in. Do we have any java hackers in the
community using Eclipse? Anyone interested?
Well I use Eclipse and PostgreSQL, but
On Thursday 25 August 2005 13:03, William Yu wrote:
As far as I know, nobody has a generic solution for multi-master
replication where servers are not in close proximity. Single master
replication? Doable. Application specific conflict resolution? Doable.
Off the shelf package that somehow
I was looking at an application recently which was written in Java and used
Postgresql as it DB. In it extensive use had been made of PreparedStatements
both for SELECTs and for INSERT, UPDATE and DELETE statements. Some of
the routines had multiple UPDATEs doing much the same thing but with
On Friday 05 August 2005 11:57, Martijn van Oosterhout wrote:
On Fri, Aug 05, 2005 at 10:08:42AM +0100, David Goodenough wrote:
I was looking at an application recently which was written in Java and
used Postgresql as it DB. In it extensive use had been made of
PreparedStatements both
I realise this is not strictly a Postgreslql question, but if the best way to
solve it involves using PG extensions, such as the PG procedural languages
I am only going to do this on PG and so I am happy to use them.
I have an address table, with all the normal fields and a customer name
field
On Friday 11 February 2005 11:31, Matt K wrote:
David Goodenough wrote:
I could do this by doing a select * from addresses where customer = ?
and type = 'billing', looking to see if there is a result row and if not
repeating the query with type = 'default', but that seems inelegant to
me
On Friday 11 February 2005 11:46, Richard Huxton wrote:
David Goodenough wrote:
I realise this is not strictly a Postgreslql question, but if the best
way to solve it involves using PG extensions, such as the PG procedural
languages I am only going to do this on PG and so I am happy to use
On Friday 11 February 2005 11:41, Janning Vygen wrote:
Am Freitag, 11. Februar 2005 12:07 schrieb David Goodenough:
I have an address table, with all the normal fields and a customer name
field and an address type. There is a constraint that means that the
combination of customer and type
On Friday 11 February 2005 13:39, Bruno Wolff III wrote:
On Fri, Feb 11, 2005 at 11:07:24 +,
David Goodenough [EMAIL PROTECTED] wrote:
I thought of using an inner select for the join, and using limit 1 to
get just the one, and forcing the order by to give me the billing
address
On Tuesday 07 December 2004 22:42, Chris Smith wrote:
[EMAIL PROTECTED] wrote:
Does anyone know how to connect javascript to a postgresql database
You can't connect javascript to any sort of database. You need something
like php, python etc - it can connect to your database and generate
37 matches
Mail list logo
