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 SQL.
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
int
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.
>
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 want
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
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:
> http://postgresql.1045698.n5.nabble.com/Tool-to-c
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 m
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.
best
way to encourage it.
David
>
> 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
integrity you
> >> cannot use delete 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'
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 domain/s
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 dumpfi
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 man
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 '-'
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
sl
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
> &g
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
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
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 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.
Al
On Tuesday 05 December 2006 10:57, Bernd Helmle wrote:
> On Tue, 5 Dec 2006 10:18:21 +0000, 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 les
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:
> &g
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 a
http://developers.slashdot.org/article.pl?sid=06/12/13/1515217&from=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 Lin
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 firs
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 lead
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 generat
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 and
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 = 'd
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
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
> > co
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 orde
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 da
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
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 se
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 nerve.co
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 ta
37 matches
Mail list logo
