Re: [GENERAL] Master - slave replication?

2016-10-26 Thread Bjørn T Johansen
On Wed, 26 Oct 2016 13:59:02 +0200 Thomas Kellerer wrote: > Bjørn T Johansen schrieb am 26.10.2016 um 13:17: > > I have a database that I would like to replicate in case of hardware > > failure on this server. So I gather I just need a streaming replication > > (warm >

[GENERAL] Master - slave replication?

2016-10-26 Thread Bjørn T Johansen
get a working master - slave replication? (It just looks too easy... :) ) Do I need to enable archive mode for this to work or? Never done this before, so just trying to be sure I understand this right... :) Regards, BTJ -- ----------

Re: [GENERAL] Strange? BETWEEN behaviour.

2016-10-20 Thread Bjørn T Johansen
On Thu, 20 Oct 2016 15:16:20 +0200 Francisco Olarte wrote: > On Thu, Oct 20, 2016 at 1:51 PM, Bjørn T Johansen wrote: > > I have the following SQL: > > SELECT * from table WHERE date BETWEEN to_timestamp('20.10.2016 > > 00:00:00','DD.MM. HH24:MI:SS'

Re: [GENERAL] Strange? BETWEEN behaviour.

2016-10-20 Thread Bjørn T Johansen
On Thu, 20 Oct 2016 14:04:51 +0200 vinny wrote: > On 2016-10-20 13:51, Bjørn T Johansen wrote: > > I have the following SQL: > > > > SELECT * from table WHERE date BETWEEN to_timestamp('20.10.2016 > > 00:00:00','DD.MM. HH24:MI:SS') AND to_

Re: [GENERAL] Strange? BETWEEN behaviour.

2016-10-20 Thread Bjørn T Johansen
Yes, that's what I am doing now but I was just wondering why the other way did not work... BTJ On Thu, 20 Oct 2016 12:02:14 + William Ivanski wrote: > You could try: > > select * from table where date = '2016/10/20'::date > > Em qui, 20 de out de 2

[GENERAL] Strange? BETWEEN behaviour.

2016-10-20 Thread Bjørn T Johansen
rds that had datepart = 20.10.2016 but I am not getting that.. What am I missing? Regards, BTJ -- ------- Bjørn T Johansen b...@havleik.no ---

Re: [GENERAL] Slow SQL?

2016-07-12 Thread Bjørn T Johansen
On Tue, 12 Jul 2016 14:34:50 +0200 hubert depesz lubaczewski wrote: > On Tue, Jul 12, 2016 at 10:23:24AM +0200, Bjørn T Johansen wrote: > > I am trying to move a small system from Oracle to PostgreSQL and > > I have come upon a sql that runs really slow compared to on the Oracle &

Re: [GENERAL] Slow SQL?

2016-07-12 Thread Bjørn T Johansen
On Tue, 12 Jul 2016 09:12:23 + Albe Laurenz wrote: > haman...@t-online.de wrote: > Bjørn T Johansen wrote: > >> I am trying to move a small system from Oracle to PostgreSQL and I have > >> come upon a sql that runs > >> really slow compared to on the Ora

[GENERAL] Slow SQL?

2016-07-12 Thread Bjørn T Johansen
Appreciate any pointers on where to look... :) Regards, BTJ -- --- Bjørn T Johansen b...@havleik.no --

Re: [GENERAL] Collation problem?

2015-04-26 Thread Bjørn T Johansen
On Sun, 26 Apr 2015 12:43:57 +0200 Oliver Elphick wrote: > On Sun, 2015-04-26 at 12:39 +0200, Bjørn T Johansen wrote: > > > > CREATE COLLATION nb_NO (LOCALE = nb_NO.utf8) > > > > But then I get this: > > > > ERROR: could not create locale &quo

Re: [GENERAL] Collation problem?

2015-04-26 Thread Bjørn T Johansen
On Sun, 26 Apr 2015 11:48:37 +0200 Oliver Elphick wrote: > On Sun, 2015-04-26 at 11:09 +0200, Bjørn T Johansen wrote: > > Ok, tried to run: > > > > alter table medlem alter column fornavn varchar(50) collate nb_NO.utf8 > > > > But I just get: > > > &

Re: [GENERAL] Collation problem?

2015-04-26 Thread Bjørn T Johansen
On Sun, 26 Apr 2015 10:59:10 +0200 Bjørn T Johansen wrote: > On Sun, 26 Apr 2015 10:31:37 +0200 > "Gunnar \"Nick\" Bluth" wrote: > > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > Am 26.04.2015 um 10:02 schrieb

Re: [GENERAL] Collation problem?

2015-04-26 Thread Bjørn T Johansen
On Sun, 26 Apr 2015 10:31:37 +0200 "Gunnar \"Nick\" Bluth" wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen: > > My databases looks like this...: > > > > > > List of

[GENERAL] Collation problem?

2015-04-26 Thread Bjørn T Johansen
databases or initialize PGSQL? Regards, BTJ -- --- Bjørn T Johansen b...@havleik.no --- Someone wrote: &q

Re: [GENERAL] Any changes in Java and PGSQL 9.4?

2015-01-18 Thread Bjørn T Johansen
On Sun, 18 Jan 2015 20:25:48 +0100 Thomas Kellerer wrote: > Bjørn T Johansen wrote on 18.01.2015 20:20: > > Just noticed that a column field of type bigint containing a null, becomes > > a 0 when retrieving it from the resultset using JDBC. > > If I run the same applicati

Re: [GENERAL] Any changes in Java and PGSQL 9.4?

2015-01-18 Thread Bjørn T Johansen
On Sun, 18 Jan 2015 20:20:35 +0100 Bjørn T Johansen wrote: > Just noticed that a column field of type bigint containing a null, becomes a > 0 when retrieving it from the resultset using JDBC. > If I run the same application against my old 9.3 database, the value > retriev

[GENERAL] Any changes in Java and PGSQL 9.4?

2015-01-18 Thread Bjørn T Johansen
-- --- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To whi

[GENERAL] Does not use index on query using "field is null"?

2010-11-10 Thread Bjørn T Johansen
ards, BTJ -- ------- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand that if you play a Windows CD bac

Re: [GENERAL] Does not use index on query using "field is null"?

2010-11-10 Thread Bjørn T Johansen
On Wed, 10 Nov 2010 10:00:43 -0500 Tom Lane wrote: > =?ISO-8859-1?Q?Bj=F8rn?= T Johansen writes: > > I have a query that looks like this...: > > select * from table where field is null > > > And when I run explain, it tells me that it uses seq scan... Is this > > because pg thinks that seq sca

Re: [GENERAL] Analyze tool?

2010-10-01 Thread Bjørn T Johansen
On Fri, 1 Oct 2010 11:30:59 +0100 Thom Brown wrote: > 2010/10/1 Bjørn T Johansen : > > We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5 > > Navigator, where one can enable logging of SQL statements and then it > > will recommed indexes that shoul

[GENERAL] Analyze tool?

2010-10-01 Thread Bjørn T Johansen
-- --- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand that if you play a Windows CD backwards you hear st

[GENERAL] Creating indexes?

2010-04-22 Thread Bjørn T Johansen
combined index? Regards, BTJ -- --- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand th

Re: [GENERAL] 64bits or 32 bits on ESX?

2010-01-21 Thread Bjørn T Johansen
On Thu, 21 Jan 2010 13:01:29 +0100 Magnus Hagander wrote: > On Thu, Jan 21, 2010 at 12:45, A. Kretschmer > wrote: > > In response to Magnus Hagander : > >> 2010/1/21 Bjørn T Johansen : > >> > We are going to be setting up a PostgreSQL server on a guest under &g

Re: [GENERAL] 64bits or 32 bits on ESX?

2010-01-21 Thread Bjørn T Johansen
On Thu, 21 Jan 2010 10:43:31 +0100 Magnus Hagander wrote: > 2010/1/21 Bjørn T Johansen : > > We are going to be setting up a PostgreSQL server on a guest under VMWare > > ESX 4... Is there any performance improvement by choosing 64bits Linux > > over 32bits Linux as the gue

[GENERAL] 64bits or 32 bits on ESX?

2010-01-20 Thread Bjørn T Johansen
-- --- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied:

[GENERAL] Upgrading from 8.3 to 8.4 and Integer datatimes?

2009-07-28 Thread Bjørn T Johansen
Will a dump and restore take care of this change or do I have to do some manual converting when upgrading? Regards, BTJ -- --- Bjørn T Johansen b...@havleik.no

Re: [GENERAL] ERROR: could not access status of transaction 2495690984

2009-07-23 Thread Bjørn T Johansen
On Tue, 21 Jul 2009 15:32:07 -0400 Merlin Moncure wrote: > 2009/7/21 Bjørn T Johansen : > > I have had som problem with my filesystem and now I get these error > > messsages when trying to access my database..: > > > > ERROR:  could not access status of transaction 24

[GENERAL] ERROR: could not access status of transaction 2495690984

2009-07-21 Thread Bjørn T Johansen
d a backup? Regards, BTJ -- ------- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand tha

[GENERAL] ERROR: could not access status of transaction 2495690984

2009-07-21 Thread Bjørn T Johansen
d a backup? Regards, BTJ -- ------- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand tha

Re: [GENERAL] HINT: Please REINDEX it?

2009-03-26 Thread Bjørn T Johansen
On Thu, 26 Mar 2009 15:32:46 + Sam Mason wrote: > On Thu, Mar 26, 2009 at 09:00:53AM +0100, Bjørn T Johansen wrote: > > ERROR: index "connect_idx" contains unexpected zero page at block 208 > > HINT: Please REINDEX it. > > > > What does this mean? >

[GENERAL] HINT: Please REINDEX it?

2009-03-26 Thread Bjørn T Johansen
ards, BTJ -- ------- Bjørn T Johansen b...@havleik.no --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's

Re: [GENERAL] How do I set the schema search path in a datasource config for a connection pool?

2009-02-15 Thread Bjørn T Johansen
On Sun, 15 Feb 2009 08:47:36 -0700 Scott Marlowe wrote: > On Sun, Feb 15, 2009 at 5:58 AM, Bjørn T Johansen wrote: > > I can't find a way to do this, what am I missing? > > You can either issue the command when you open the connection, alter > the user the connec

[GENERAL] How do I set the schema search path in a datasource config for a connection pool?

2009-02-15 Thread Bjørn T Johansen
I can't find a way to do this, what am I missing? Regards, BTJ -- --- Bjørn T Johansen b...@havle

Re: [GENERAL] Strange limit and offset behaviour....

2009-02-07 Thread Bjørn T Johansen
On Sat, 7 Feb 2009 22:03:37 + Grzegorz Jaśkiewicz wrote: > On Sat, Feb 7, 2009 at 9:57 PM, Bjørn T Johansen wrote: > >> > SELECT * from table order by dato asc > > is the field 'dato' the same in both cases ? if so - you're goood > just compare: &g

Re: [GENERAL] Strange limit and offset behaviour....

2009-02-07 Thread Bjørn T Johansen
On Sat, 7 Feb 2009 15:49:49 -0600 "Adam Rich" wrote: > > > > I have the following sql: > > > > SELECT * from table order by dato asc limit 20 offset 0 > > > > > > This gives me different rows than the 20 first rows when running the > > following sql: > > > > SELECT * from table order by dato

[GENERAL] Strange limit and offset behaviour....

2009-02-07 Thread Bjørn T Johansen
t is returned in the first statement or am I missing something? Regards, BTJ -- --- Bjørn T Johansen b...@havle

[GENERAL] How good is the default values for autovacuum?

2009-01-15 Thread Bjørn T Johansen
Just wondering if I need to change the defalt values for autovacuum in version 8.3.5? Regards, BTJ -- --- Bjørn T Johansen b...@havleik.no

Re: [GENERAL] Target lists can have at most 1664 entries?

2008-07-05 Thread Bjørn T Johansen
On Sat, 5 Jul 2008 08:17:37 -0700 David Fetter <[EMAIL PROTECTED]> wrote: > On Wed, Jul 02, 2008 at 09:22:50AM +0200, Bjørn T Johansen wrote: > > On Wed, 02 Jul 2008 03:04:04 -0400 > > Tom Lane <[EMAIL PROTECTED]> wrote: > > > =?UTF-8?Q?Bj=C3=B8rn?= T

Re: [GENERAL] Target lists can have at most 1664 entries?

2008-07-02 Thread Bjørn T Johansen
On Wed, 02 Jul 2008 15:24:38 +0800 Craig Ringer <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > =?UTF-8?Q?Bj=C3=B8rn?= T Johansen <[EMAIL PROTECTED]> writes: > >> What does this mean and how can it be fixed? > > > > Reduce the number of columns in your SELECTs? > > > > This whiffs to me of excr

Re: [GENERAL] Target lists can have at most 1664 entries?

2008-07-02 Thread Bjørn T Johansen
On Wed, 02 Jul 2008 03:04:04 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > =?UTF-8?Q?Bj=C3=B8rn?= T Johansen <[EMAIL PROTECTED]> writes: > > What does this mean and how can it be fixed? > > Reduce the number of columns in your SELECTs? > > This whiffs to me of excruciatingly bad schema design. Ho

Re: [GENERAL] Target lists can have at most 1664 entries?

2008-07-02 Thread Bjørn T Johansen
On Wed, 02 Jul 2008 09:03:04 +0200 Magnus Hagander <[EMAIL PROTECTED]> wrote: > Richard Huxton wrote: > > Bjørn T Johansen wrote: > >> What does this mean and how can it be fixed? We are running Hibernate > >> with PostgreSQL 8.3.x... > > > > What q

[GENERAL] Target lists can have at most 1664 entries?

2008-07-01 Thread Bjørn T Johansen
What does this mean and how can it be fixed? We are running Hibernate with PostgreSQL 8.3.x... Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED

Re: [GENERAL] How can I compare sql create script with running database?

2008-06-05 Thread Bjørn T Johansen
On Thu, 05 Jun 2008 15:28:55 +0200 Tino Wildenhain <[EMAIL PROTECTED]> wrote: > Hi, > > Bjørn T Johansen wrote: > > On Thu, 05 Jun 2008 11:06:36 +0100 > > Raymond O'Donnell <[EMAIL PROTECTED]> wrote: > > > >> On 05/06/2008 10:52, Bjør

Re: [GENERAL] How can I compare sql create script with running database?

2008-06-05 Thread Bjørn T Johansen
On Thu, 05 Jun 2008 11:06:36 +0100 Raymond O'Donnell <[EMAIL PROTECTED]> wrote: > On 05/06/2008 10:52, Bjørn T Johansen wrote: > > If I already have a running database, how can I compare the tables in > > the database with the sql script to discover the differences? >

[GENERAL] How can I compare sql create script with running database?

2008-06-05 Thread Bjørn T Johansen
If I already have a running database, how can I compare the tables in the database with the sql script to discover the differences? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED

Re: [GENERAL] Which JDBC version to use with PostgreSQL 8.1.11?

2008-03-20 Thread Bjørn T Johansen
On Thu, 20 Mar 2008 12:29:21 +0900 "- Edwin -" <[EMAIL PROTECTED]> wrote: > Hi, > > On Thu, Mar 20, 2008 at 6:17 AM, Bjørn T Johansen wrote: > > Should I use JDBC version 8.1 Build 412 with this database or > > is it recommended to use JDBC version 8.3 Build

[GENERAL] Which JDBC version to use with PostgreSQL 8.1.11?

2008-03-19 Thread Bjørn T Johansen
Should I use JDBC version 8.1 Build 412 with this database or is it recommended to use JDBC version 8.3 Build 603 or another version? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED

Re: [GENERAL] ER Diagram design tools (Linux)

2008-03-07 Thread Bjørn T Johansen
On Fri, 07 Mar 2008 11:44:38 -0800 Colin Fox <[EMAIL PROTECTED]> wrote: > I've created an XSL stylesheet that works with graphviz to reverse > engineer an ERD from a postgres database. > > If anyone's interested, I can make this available. It works quite well. > It uses a postgres-to-xml extracto

Re: [GENERAL] Should I install PostgreSQL 8.2.5?

2007-10-06 Thread Bjørn T Johansen
On Sat, 6 Oct 2007 15:24:42 -0400 Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Bjørn T Johansen escribió: > > On Sat, 6 Oct 2007 10:52:37 -0500 > > "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > > > > > On 10/6/07, Bjørn T Johansen <[EMAIL P

Re: [GENERAL] Should I install PostgreSQL 8.2.5?

2007-10-06 Thread Bjørn T Johansen
On Sat, 6 Oct 2007 10:52:37 -0500 "Scott Marlowe" <[EMAIL PROTECTED]> wrote: > On 10/6/07, Bjørn T Johansen <[EMAIL PROTECTED]> wrote: > > My customer has just bought a new server with RedHat Enterpris Server 5 64 > > bit and on that box PostgreSQL >

[GENERAL] Should I install PostgreSQL 8.2.5?

2007-10-06 Thread Bjørn T Johansen
grade to your rpm's? Regards, BTJ -- ------- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: &qu

Re: [GENERAL] Is this good spec for a PostgreSQL server?

2007-09-19 Thread Bjørn T Johansen
Ok, thx for the advice :) BTJ On Wed, 19 Sep 2007 10:51:57 -0700 Jeff Davis <[EMAIL PROTECTED]> wrote: > On Wed, 2007-09-19 at 15:32 +0200, Bjørn T Johansen wrote: > > > > Well, it isn't really the largest database or the database that > > > > need the

Re: [GENERAL] Is this good spec for a PostgreSQL server?

2007-09-19 Thread Bjørn T Johansen
Well, it isn't really the largest database or the database that need the most performance... At the moment, the database isn't larger than 15MB and is growing slowly... It is a webapp that is using the database and at the most (at the moment) there is about 12-14 concurrent users and not much dat

Re: [GENERAL] Is this good spec for a PostgreSQL server?

2007-09-19 Thread Bjørn T Johansen
On Wed, 19 Sep 2007 07:59:36 -0500 Ron Johnson <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/19/07 07:33, Bjørn T Johansen wrote: > > Well, it isn't really the largest database or the database that > > need the mos

[GENERAL] Is this good spec for a PostgreSQL server?

2007-09-19 Thread Bjørn T Johansen
ow if this PERC controller is supported under Linux (not heard of it before...) Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROT

Re: [GENERAL] Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?

2007-04-21 Thread Bjørn T Johansen
On Sat, 21 Apr 2007 12:01:46 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > =?UTF-8?Q?Bj=C3=B8rn?= T Johansen <[EMAIL PROTECTED]> writes: > > When I try to compile I get the following error...: > > /usr/bin/ld:exports.list:1: parse error in VERSION script > > collect2: ld returned 1 exit status > > m

[GENERAL] Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?

2007-04-21 Thread Bjørn T Johansen
ocal/src/postgresql-8.2.3/src' make: *** [all] Error 2 How do I fix this? Regards, BTJ -- ------- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand

Re: [GENERAL] Problem writing sql statement....

2007-02-17 Thread Bjørn T Johansen
OTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson > Sent: Friday, February 16, 2007 9:13 AM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Problem writing sql statement.... > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/16/07 01:

Re: [GENERAL] Problem writing sql statement....

2007-02-16 Thread Bjørn T Johansen
Not exactly what I want... I don't know the date or id, I just need to find all rows that have the same date and the same id.. BTJ On Thu, 15 Feb 2007 16:46:21 -0600 Ron Johnson <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On

[GENERAL] Problem writing sql statement....

2007-02-15 Thread Bjørn T Johansen
-- --- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's

Re: [GENERAL] TOAD-like query builder for PostgreSQL?

2006-12-09 Thread Bjørn T Johansen
DbVisualizer works fine with PostgreSQL and also has a query builder http://www.dbvis.com/products/dbvis/ BTJ On Sat, 09 Dec 2006 10:51:50 +0100 Marcus Engene <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] skrev: > > I really like TOAD for building Oracle queries. Is there a TOAD-like, > >

[GENERAL] Can't see what's wrong with this function?

2006-08-28 Thread Bjørn T Johansen
I get the following error if I try to create the function..: [Error Code: 0, SQL State: 42601] ERROR: syntax error at or near "$1" Any hints on what's wrong? Regards, BTJ -- ------

Re: [GENERAL] Convert time to millisec?

2006-08-28 Thread Bjørn T Johansen
On Mon, 28 Aug 2006 07:20:02 -0600 Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Mon, Aug 28, 2006 at 10:48:47AM +0200, Bjørn T Johansen wrote: > > select sum(Til - Fra) as total from Log_stop where OrdreID = 3434 > > > > but I would like the result to be in millisecon

[GENERAL] Convert time to millisec?

2006-08-28 Thread Bjørn T Johansen
-- --- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages"

Re: [GENERAL] Help making a plpgsql function?

2006-07-05 Thread Bjørn T Johansen
5 Jul 2006 16:32:10 -0400 John DeSoi <[EMAIL PROTECTED]> wrote: > > On Jul 5, 2006, at 3:51 PM, Bjørn T Johansen wrote: > > > Yes, but I need to return n fields from one table and n fiels from > > another, and n fields from yet another > > table, etc... and re

Re: [GENERAL] Help making a plpgsql function?

2006-07-05 Thread Bjørn T Johansen
That looks like the features I am looking for... I'll check it out more tomorrow, thx... :) BTJ On Wed, 5 Jul 2006 16:32:10 -0400 John DeSoi <[EMAIL PROTECTED]> wrote: > > On Jul 5, 2006, at 3:51 PM, Bjørn T Johansen wrote: > > > Yes, but I need to return n fields

Re: [GENERAL] Help making a plpgsql function?

2006-07-05 Thread Bjørn T Johansen
July 2006 16:46, Bjørn T Johansen wrote: > > I need to make a funtion that take one parameter and then returns a > > "record" with x number of fields, collected from x no. of tables, i.e. I > > need to run several sql statemtents to collect all the needed values from x &

[GENERAL] Help making a plpgsql function?

2006-07-05 Thread Bjørn T Johansen
rking for 7.4 first...) Regards, BTJ -- ------- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I under

Re: [GENERAL] Best open source tool for database design / ERDs?

2006-06-08 Thread Bjørn T Johansen
On 8 Jun 2006 04:30:38 -0700 [EMAIL PROTECTED] wrote: > Here's one Druid "annoyance" > > One real pain with the ER Diagram is that it seems to insist on > including, and often inconveniently repositioning, a little non-entity > yellow box that says Unamed. I think it's a color legend. Anyone know

Re: [GENERAL] Best open source tool for database design / ERDs?

2006-06-06 Thread Bjørn T Johansen
Have you tried Druid (http://druid.sourceforge.net/index.html) ? It does anything a good ERD designer do and it's free... BTJ On 5 Jun 2006 16:54:56 -0700 [EMAIL PROTECTED] wrote: > tedia2sql for DIA seems pretty strange, in that it seems to require you > to use UML diagrams, rather than ER Di

Re: [GENERAL] Best open source tool for database design / ERDs?

2006-05-29 Thread Bjørn T Johansen
On Mon, 29 May 2006 14:43:19 +0200 "Tomi NA" <[EMAIL PROTECTED]> wrote: > On 5/29/06, Bjørn T Johansen <[EMAIL PROTECTED]> wrote: > > Druid works ok > > > > http://druid.sourceforge.net/index.html > > Are there a couple of screenshots avail

Re: [GENERAL] Best open source tool for database design / ERDs?

2006-05-28 Thread Bjørn T Johansen
Druid works ok http://druid.sourceforge.net/index.html BTJ On 28 May 2006 05:19:04 -0700 [EMAIL PROTECTED] wrote: > What open source tool do people here like for creating ER diagrams? > > > ---(end of broadcast)--- > TIP 3: Have you checked

Re: [GENERAL] Postgresql with Hibernate issues

2006-05-25 Thread Bjørn T Johansen
k?, whileas same application+ Hibernate with mysql > > Works perfectly fine? > > > > Thanks a lot for your advices. > > > > Shemy > -- --- Bjørn T Johansen [EMAIL PROTECTED] -

[GENERAL] Creating a trigger on n tables?

2006-04-07 Thread Bjørn T Johansen
Is there an easier way to create the same trigger for n tables or do I need to run create trigger n times? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED

Re: [GENERAL] Logging of sql statements?

2006-03-23 Thread Bjørn T Johansen
On Thu, 23 Mar 2006 15:01:17 -0600 Scott Marlowe <[EMAIL PROTECTED]> wrote: > > > > If I try the same from a client, I get the same result.. But when running > > from my webapp (using > > Hibernate), only question marks appear? > > Again, I'm pretty sure this is a known issue with the JDBC

Re: [GENERAL] Logging of sql statements?

2006-03-23 Thread Bjørn T Johansen
On Thu, 23 Mar 2006 17:21:38 +0100 Andreas Kretschmer <[EMAIL PROTECTED]> wrote: > Bjørn T Johansen <[EMAIL PROTECTED]> schrieb: > > > Set in your postgresql.conf: > > > > > > log_statement = all > > > > > > Since 8.0 o

Re: [GENERAL] Logging of sql statements?

2006-03-23 Thread Bjørn T Johansen
On Thu, 23 Mar 2006 14:25:52 +0100 "A. Kretschmer" <[EMAIL PROTECTED]> wrote: > am 23.03.2006, um 14:07:11 +0100 mailte Bjørn T Johansen folgendes: > > Is it possible to log the actual statement that the server runs? At the > > moment, the statement that is &g

[GENERAL] Logging of sql statements?

2006-03-23 Thread Bjørn T Johansen
BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand that if you play a Windows CD

Re: [GENERAL] Hardware recommendation for PostgreSQL on Windows?

2006-01-06 Thread Bjørn T Johansen
Qingqing Zhou wrote: > ""Bjørn T Johansen"" <[EMAIL PROTECTED]> wrote >> I an planning to make a small Windows application and need a nice >> database I am used to using PostgreSQL >> under Linux and I am thinking about using this under Windo

[GENERAL] Hardware recommendation for PostgreSQL on Windows?

2006-01-05 Thread Bjørn T Johansen
db is supported? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand t

[GENERAL] Logging prepared statements in 8.1?

2005-11-23 Thread Bjørn T Johansen
parameters).. Is there a way to see the actual statements in 8.1? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED

[GENERAL] Logging prepared statements in 8.1?

2005-11-23 Thread Bjørn T Johansen
Trying again, since it appears that my mail never reached the list... Original Message Subject: Logging prepared statements in 8.1? Date: Wed, 23 Nov 2005 07:32:37 +0100 From: Bjørn T Johansen <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org I am upgrading from 7.4

Re: [GENERAL] Help trying to write my first plpgsql function...

2005-09-20 Thread Bjørn T Johansen
I am not sure why I used subselect, I just saw an example and followed it.. But now it's working as it should... Thx for all the help! :) BTJ On 9/19/05, Bjørn T Johansen wrote: CREATE OR REPLACE FUNCTION trykkStatus (pressID INTEGER) RETURNS SetOf trykkstatus_type AS '

Re: [GENERAL] Help trying to write my first plpgsql function...

2005-09-19 Thread Bjørn T Johansen
LANGUAGE 'plpgsql'; What am I missing? BTJ hubert depesz lubaczewski wrote: > On 9/15/05, *Bjørn T Johansen* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> > wrote: > > Yes, I did and I found an answer... :) > > > > you did what? read

Re: [GENERAL] Help trying to write my first plpgsql function...

2005-09-15 Thread Bjørn T Johansen
Yes, I did and I found an answer... :) But I am trying to use this function in a report designer and the result from the select is in the way of the real data from the fetch... Is there a way around this? BTJ hubert depesz lubaczewski wrote: > On 9/15/05, *Bjørn T Johansen* <[EMAIL PRO

Re: [GENERAL] Help trying to write my first plpgsql function...

2005-09-15 Thread Bjørn T Johansen
the select? BTJ Bjørn T Johansen wrote: > Yes, of course > > But this function does not do what I need it to do... I want x rows returned, > but > instead I just get a stringname... > Either how do I use this name or how do I return x rows? > > > BTJ > > Gna

Re: [GENERAL] Help trying to write my first plpgsql function...

2005-09-15 Thread Bjørn T Johansen
Yes, of course But this function does not do what I need it to do... I want x rows returned, but instead I just get a stringname... Either how do I use this name or how do I return x rows? BTJ Gnanavel S wrote: > 'IF' block is not ended. > > On 9/15/05, *Bjørn

[GENERAL] Help trying to write my first plpgsql function...

2005-09-15 Thread Bjørn T Johansen
his function do what I expect it to do? And instead of rasing an error when no rows is found, can I return an "empty" cursor instead? Regards, BTJ -- --------

Re: [GENERAL] Could not convert UTF-8 character to ISO8859-1?

2005-07-24 Thread Bjørn T Johansen
Yes, that did the trick... I tried to execute the same statement at the same time as I did the insert, but it needed to be in a separate statement Thx :) BTJ John DeSoi wrote: > > On Jul 24, 2005, at 1:52 PM, Bjørn T Johansen wrote: > >> I don't think you are co

Re: [GENERAL] Could not convert UTF-8 character to ISO8859-1?

2005-07-24 Thread Bjørn T Johansen
gt; So I think you have to search on the MSSQL side, not PostgreSql... > > You can also use UNICODE encoding on postgres, creating your DB with > CREATE DATABASE mydb ENCODING='UNICODE'; > > Hope this will give you some hints to solve the problem > > Regards, >

[GENERAL] Could not convert UTF-8 character to ISO8859-1?

2005-07-24 Thread Bjørn T Johansen
not... Is this some default setting in pgodbc or? I can't find any place to change this value Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROT

Re: [GENERAL] Windows version of PostgreSQL 8?

2005-07-13 Thread Bjørn T Johansen
ations on Windows Server > 2000 and 2003 for web-mapping applications and they are running well for > the last 8 months. > > Bjørn T Johansen wrote: > >> How stable is the windows version of pgsql 8? Is it as stable as the >> Linux version or >> should I look e

[GENERAL] Windows version of PostgreSQL 8?

2005-07-12 Thread Bjørn T Johansen
How stable is the windows version of pgsql 8? Is it as stable as the Linux version or should I look elsewehere after a good sql srv for Windows? Regards. BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED

Re: [GENERAL] Windows version of PostgreSQL 8.x?

2005-07-12 Thread Bjørn T Johansen
> On Tue, 2005-07-12 at 11:29, Bjørn T Johansen wrote: >> How stable is the Windows version of PGSQL 8? Is it as stable as the >> Linux >> version or should I be looking for something else? > > For certain values of stable, yes, it is. > > However, if for no other reason than the fact the the port

[GENERAL] Windows version of PostgreSQL 8.x?

2005-07-12 Thread Bjørn T Johansen
How stable is the Windows version of PGSQL 8? Is it as stable as the Linux version or should I be looking for something else? Regards, BTJ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Changing password for the postgres user?

2005-06-23 Thread Bjørn T Johansen
Aaahh, of course I forgot about the trust settings I have there... BTJ Gavin Love wrote: > > Bjørn T Johansen wrote: > >> I am trying to change the password for the postgres user but it >> doesn't work... I >> have tried changing it from pgAdmin, EMS Postgre

[GENERAL] Changing password for the postgres user?

2005-06-23 Thread Bjørn T Johansen
ssing? Regards, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand that if

[GENERAL] Building a "complex" select?

2005-04-18 Thread Bjørn T Johansen
ards, BTJ -- ------- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand that if you play a Windows CD backwards you hear

Re: [GENERAL] Error in trigger after upgrading to 8.0.1?

2005-02-05 Thread Bjørn T Johansen
Bjørn T Johansen wrote: I have just upgraded to 8.0.1 from 7.4.6 and now my triggers doesn't work. When I insert a row in a table that has an insert trigger, I get the following error msg: ERROR: INSERT is not allowed in a non-volatile function What does this mean? Regards, BTJ It would a

[GENERAL] Error in trigger after upgrading to 8.0.1?

2005-02-05 Thread Bjørn T Johansen
, BTJ -- --- Bjørn T Johansen [EMAIL PROTECTED] --- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic me

  1   2   >