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

2006-06-03 Thread Tomi NA
On 6/2/06, Rich Shepard [EMAIL PROTECTED] wrote: On Fri, 2 Jun 2006, Michael Dean wrote: a caveat: I don't believe, from my reading of the license, that this is an open source software product. May not be. I don't recall. Neither is Java. But, if you're using it for your own purposes,

Re: [GENERAL] How to do a CREATE DATABASE and then connect to it?

2006-06-03 Thread Terry Lee Tucker
On Saturday 03 June 2006 04:07 am, Joseph Brenner [EMAIL PROTECTED] thus communicated: -- -- Joshua D. Drake [EMAIL PROTECTED] wrote: -- -- Joseph Brenner wrote: -- -- After you do a CREATE DATABASE, how do you programatically -- connect to what you just created? -- -- In the psql

Re: [GENERAL] How to do a CREATE DATABASE and then connect to it?

2006-06-03 Thread Frank Finner
On Sat, 3 Jun 2006 04:36:59 -0400 Terry Lee Tucker [EMAIL PROTECTED] thought long, then sat down and wrote: On Saturday 03 June 2006 04:07 am, Joseph Brenner [EMAIL PROTECTED] thus communicated: -- -- Joshua D. Drake [EMAIL PROTECTED] wrote: -- -- Joseph Brenner wrote: -- -- After

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

2006-06-03 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: Anyone know if DIA will generate CREATE TABLE statements from an ER diagram? I'd like to have a program where I can create my db design, then be able to instantiate the design in PostgreSQL as well as MySQL. I'll pay

[GENERAL] Using postgresql as desktop DB

2006-06-03 Thread Nicholay Ryzhov
We are using postgresql in desktop database role. We cannot demand from our users high-quality and stable hardware. So, we have frequent problems with database in cases of unexpected power interruption or software errors. All this problems has one kind - postgresql says invalid page header block

Re: [GENERAL] Querying for strings that match after prefix

2006-06-03 Thread badlydrawnbhoy
Hi there, I think I need to explain a bit further. I tried simply using update people replace(address, 'mailto:',''); but unfortunately that produced a duplicate key error as some of the addresses prefixed with 'mailto:' are already present (unprefixed) in the table. So what I need to do is

Re: [GENERAL] Using postgresql as desktop DB

2006-06-03 Thread Martijn van Oosterhout
On Fri, Jun 02, 2006 at 03:50:47PM +0400, Nicholay Ryzhov wrote: We are using postgresql in desktop database role. We cannot demand from our users high-quality and stable hardware. So, we have frequent problems with database in cases of unexpected power interruption or software errors. All

Re: [GENERAL] Querying for strings that match after prefix

2006-06-03 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2006-06-02 05:18:08 -0700: I think I need to explain a bit further. I tried simply using update people replace(address, 'mailto:',''); but unfortunately that produced a duplicate key error as some of the addresses prefixed with 'mailto:' are already present

Re: [GENERAL] psql: krb5_sendauth: Bad application version was sent (via sendauth) - Windows 2000, MIT Kerberos, PG v 8.1.1

2006-06-03 Thread Magnus Hagander
I'm trying to setup Kerberos authentication with PG on Windows 2000. I have installed the MIT Kerberos Windows dlls into the PG bin directory - replacing the krb5_32.dll and comerr32.dll from the PG install. I did this because the PG install did not have the krbcc32.dll, which is needed

[GENERAL] Performance difference between char and int2 columns

2006-06-03 Thread Yavuz Kavus
hi everybody. i have two table as : CREATE TABLE public.tb_section_phones ( section_id INTEGER NOT NULL, ptype_id INTEGER NOT NULL, country_code SMALLINT DEFAULT 90, domain_code SMALLINT, number CHAR(7) NOT NULL, extension VARCHAR(6), CONSTRAINT tb_section_phones_fk FOREIGN KEY

Re: [GENERAL] Using postgresql as desktop DB

2006-06-03 Thread Harald Armin Massa
Nicholas, in a transition period I did use PostgreSQL Win 32 8.0 and above on high quality server hardware. Which did not help, because of subtil problems with Windows, VMware and some HP Server tools. Result: we had around 3 blue screens of death every week. Sometimes even more. On a database

Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Bruce Momjian
Stuart Bishop wrote: -- Start of PGP signed section. Arnaud Lesauvage wrote: Hi list ! I have a small enterprise network (~15 workstations, 1 server), all running windows OSes. Most of our work is done on a PostgreSQL DB (on the windows server). I am the only IT here, and my boss

[GENERAL] Can't get pgsql 8.1.4 to password protect roles.

2006-06-03 Thread Will Buik
I'm trying to password protect both the superuser role and another role that I created later with less privileges but I can't seem to get it to work. I have tried using the command ALTER USER user WITH PASSWORD 'password'; and it responds with ALTER ROLE but it seems to have no effect at all.

Re: [GENERAL] Can't get pgsql 8.1.4 to password protect roles.

2006-06-03 Thread Tom Lane
Will Buik [EMAIL PROTECTED] writes: I'm trying to password protect both the superuser role and another role that I created later with less privileges but I can't seem to get it to work. I have tried using the command *ALTER USER user WITH PASSWORD 'password';* and it responds with *ALTER

Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Joshua D. Drake
Bruce Momjian wrote: Stuart Bishop wrote: -- Start of PGP signed section. Arnaud Lesauvage wrote: Hi list ! I have a small enterprise network (~15 workstations, 1 server), all running windows OSes. Most of our work is done on a PostgreSQL DB (on the windows server). I am the only IT here, and

Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Bruce Momjian
Joshua D. Drake wrote: Bruce Momjian wrote: Stuart Bishop wrote: -- Start of PGP signed section. Arnaud Lesauvage wrote: Hi list ! I have a small enterprise network (~15 workstations, 1 server), all running windows OSes. Most of our work is done on a PostgreSQL DB (on the windows