We used power architect but not really satisfied with it.
Currently using Mogwai ERDesigner but still early to make an evaluation
even if seems really promising.
http://mogwai.sourceforge.net/?Welcome:ERDesigner_NG
Peter Hunsberger ha scritto:
> Check out Power Architect. Pre-major release, it ha
Ricky Tompu Breaky wrote:
> Dear my friends,
>
> I want to install PostgreSQL in my Debian Lenny box.
>
> I can't install PostgreSQL with aptitude:
> "
> aptitude install postgresql
> ".
What Peter said, but you might also want to do "aptitude search
postgresql". That should find packages includ
rr04 wrote:
I am an MIT student doing a project on schema-less database usage and would
greatly appreciate if you guys can fill out a quick survey on this (should
take < 5 mins)
http://bit.ly/nosqldb
Hi,
even when I think that most of the people on this list will answer the
same way to your
On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq wrote:
>
> Hi,
> I am looking for a way to get the OUT parameters of a FUNCTION/PROCEDURE
> in my application (C++) using C libpq library. I can get the result set of an
> OUT parameter having REFCURSOR data type through an explicit FETCH ALL from
Hi:
Is it possible to define a constraint that checks all elements of an array type
column?
Example...
create table foo (asset text, owner_uids text[]);
I also have a plperlu function that checks to see if a given uid is valid
(returns a 0/1). It's called validate_uid(text), This function
NTPT wrote on 11.09.2009 03:06:
Hi all. is there available some freeware and/or opensource visual
database design tool for postgresql ? Something like commercial microOLAP ?
thanx for help
I like Power*Architect although it does have some quirks.
I recently discovered another one, which als
Hi all,
I have a FUNCTION queried like this:
SELECT * FROM f_authorize_check_query2('%{SQL-User-Name}','%{User-Password}'
[...];
Built this way:
CREATE FUNCTION f_authorize_check_query2(...) RETURNS radcheck
AS $_$
DECLARE
[...]
v_ret radcheck%ROWTYPE;
[...]
09/11/2009 05:53 PM, Rakotomandimby Mihamina:
Is SELECTing INTO a second time OK?
But I dont know how...
Any hint?
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+261 34 29 155 34
--
Sent via pgsq
On 11/09/2009 15:53, Rakotomandimby Mihamina wrote:
>
> It returns only one row, like this:
> ++--+++---+
> | id | UserName | Attribute | op | Value |
> ++--+++---+
> | 1 | bartek | Cleartex
On Fri, Sep 11, 2009 at 10:34 AM, Gauthier, Dave
wrote:
> Hi:
>
> Is it possible to define a constraint that checks all elements of an array
> type column?
>
> Example...
>
>
>
> create table foo (asset text, owner_uids text[]);
>
>
>
> I also have a plperlu function that checks to see if a given
After updating to 10.6.1 this morning the postgresql 8.3 server (from
a macports installation) refuses to start.
It's stops with the message
"FATAL: incorrect checksum in control file"
Yesterday I was running postgresql server successfully the whole day
under 10.6 with no problems at all. I upgr
Hi,
We are developing a web application that will work on Postgresql. My
doubt is about the hardware that I can use for postgresql.
What HW is more important to postgresql performance?
Assuming that the database will have some load, what hardware must i
buy?
Thanks
Best regards
--
Sent via pg
On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk wrote:
> What HW is more important to postgresql performance?
> Assuming that the database will have some load, what hardware must i
> buy?
Generally, you put as much RAM as you can afford, and then buy the
fastest disks you can afford.
Any advice bey
erik writes:
> After updating to 10.6.1 this morning the postgresql 8.3 server (from
> a macports installation) refuses to start.
> It's stops with the message
> "FATAL: incorrect checksum in control file"
> Yesterday I was running postgresql server successfully the whole day
> under 10.6 with
In response to Vick Khera :
> On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk
> wrote:
>
> > What HW is more important to postgresql performance?
> > Assuming that the database will have some load, what hardware must i
> > buy?
>
>
> Generally, you put as much RAM as you can afford, and then buy t
Hi,
We are running Pg 8.2.6 on sparc-sun-solaris2.9 compiled by gcc 3.4.6.
We are planning a server software upgrade to Solaris 10 (binaries and
kernel, etc).
Has anyone done this, and were there problems when trying to start up
postmaster after the upgrade?
Thank you in advance,
Mike
--
S
How much reading? Writing? Concurrent transactions? How much data will
you have? These are some of the things you need to provide to get a
reasonable answer.
Psicopunk wrote:
Hi,
We are developing a web application that will work on Postgresql. My
doubt is about the hardware that I can use fo
On 11 Set, 17:59, vi...@khera.org (Vick Khera) wrote:
> On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk
> wrote:
> > What HW is more important to postgresql performance?
> > Assuming that the database will have some load, what hardware must i
> > buy?
>
> Generally, you put as much RAM as you can affo
> How can i take some measurements to understand what bottlenecks will
> appear?
For long-term / ongoing I'm very happy so far with a package called
munin. Google it and join their mailing list for help setting it up.
But it takes snapshots at 5 minute intervals and this is not configurable.
Fo
Purchase solid equipment and fairly current machines.
We buy referbished system at a fraction of the cost of new.
For example;
IBM 3650 with 8 x 300g SAS drives and controller, 4 slot dual with the
following specs. 16 gb memory.
model name : Intel(R) Xeon(R) CPU E5345
Dear Peter Eisentraut.
My aptitude still can not find it.
Please keep telling me.
Thank you very much in advance.
Here is the output of my postgres installation attempt with aptitude and
my current '/etc/apt/sources.list':
"
lenny:/etc/apt# dpkg-reconfigure gforge-db-postgresql
lenny:/etc/apt#
On Fri, Sep 11, 2009 at 12:35 PM, Chris Barnes
wrote:
>
>
> Purchase solid equipment and fairly current machines.
> We buy referbished system at a fraction of the cost of new.
>
> For example;
> IBM 3650 with 8 x 300g SAS drives and controller, 4 slot dual with the
> following specs. 16 gb memory.
On Fri, Sep 11, 2009 at 3:53 PM, Scott Marlowe wrote:
> For about $8000 more you can get a 16 drive machine with 146G drives
> and same basic setup, which I would recommend over the 8 drive
> machine. With 2 hot spares, and 2 in a mirror for the OS/xlog you
> still have 12 drives for a RAID-10 of
Hi,
I have a loop of the form:
FOR rec IN SELECT code FROM staff WHERE shiftgroup = NEW.groupe ORDER
BY code LOOP
WHILE sdate <= NEW.todate LOOP
SELECT INTO starty,endy,nday resumetime,closetime,nextday FROM
shifts WHERE shift = NEW.shift;
restim
Hello Folks,
On windows 2003 server , if I try to run initdb with -D , -U ,
-A password & --pwfile = password file options it fails.At the time of
try , I was logged in as Domain \ username . My aim is to initialize db
with using same domain user which is currently logged in. Same att
Hi,
I still don't get. How can I get the varchar OUT parameter in the
application? For Example
CREATE OR REPLACE
Function getOutVarchar(outvarchar OUT varchar2) RETURN NUMBER
IS
BEGIN
outvarchar:='This is Out String';
RETURN 1;
END getOutVarchar;
iris=> SELECT getOutVarchar('
Hello Folks,
So I have following problem as I logged in Windows 2003 with
domain\user. I am basically trying to create installer for postgres. So
I need to keep in mind that person who is going to install can be the
one who is currently logged in.
So I tried to change permissions o
Hi,
I have a simple function that returns a set of rows:
CREATE OR REPLACE FUNCTION foo()
RETURNS SETOF record AS
$$
BEGIN
RETURN QUERY SELECT * FROM people WHERE last_name = 'jones';
END
$$
LANGUAGE 'plpgsql'
In a separate function, I call the function and store the results in a
temp tabl
On Sat, Sep 12, 2009 at 12:51 AM, Postgres User
wrote:
> Hi,
>
> I have a simple function that returns a set of rows:
>
> CREATE OR REPLACE FUNCTION foo()
> RETURNS SETOF record AS
> $$
> BEGIN
> RETURN QUERY SELECT * FROM people WHERE last_name = 'jones';
> END
> $$
> LANGUAGE 'plpgsql'
>
> I
29 matches
Mail list logo
