On Wed, 2011-08-31 at 17:24 +0530, Adarsh Sharma wrote:
Dear all,
Is there any open source ERD Tool for Postgresql Database.
I find some paid tools but looking for free tools.
If you can compile pgAdmin, it offers a database designer tool. It's in
its early stages, and still has rough
Tested in 8.2 and 9.0.1
In plpgsql, if you have a function parameter and a variable of the
same name, it ignores the value passed in and initializes the
variable to null.
The correct action, IMO, would be to raise an error.
create or replace function test1(x
On 09/01/2011 01:39 AM, Marcos Hercules Santos wrote:
hi guys
I'm newbie in Psql and I'm trying to build one function in order to
count the products for each supplier. So i'm gonna put it quite simply
though this example
Please, consider a table called books with the
On 09/01/2011 09:58 AM, Pavel Stehule wrote:
2011/9/1 Sim Zacks s...@compulab.co.il:
Tested in 8.2 and 9.0.1
In plpgsql, if you have a function parameter and a variable of the same
name, it ignores the value passed in and initializes the variable to null.
Is there a way to get an md5 or other hash of an entire table?
I want to be able to easily compare 2 tables in different databases.
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each query result, which is a pain in the butt.
If I could return
On Thu, Sep 01, 2011 at 11:47:24AM +0300, Sim Zacks wrote:
Is there a way to get an md5 or other hash of an entire table?
I want to be able to easily compare 2 tables in different databases.
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each
md5 has size limitations, the second approach seems more practical.
Στις Thursday 01 September 2011 12:30:45 ο/η Karsten Hilbert έγραψε:
On Thu, Sep 01, 2011 at 11:47:24AM +0300, Sim Zacks wrote:
Is there a way to get an md5 or other hash of an entire table?
I want to be able to easily
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1
postgres=# select md5(array_to_string(array_agg(md5(tt::text)),'')) from tt;
md5
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1
postgres=# select
Hello,
I have two large tables in a database, one containing original data and
the other one derived from the first table. The first table contains
several columns and indexes, while the second table has less columns and
only one index. Both tables have the same number of rows. Nevertheless,
I am not sure if this will work, but you can try it
http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks#Cast_to_varchar
Pavel
I appreciate your help, but UDTs don't have input/ouput functions
unless you define them manually and I need this for all of
On Thu, Sep 1, 2011 at 4:32 AM, Rik Bellens rik.bell...@telin.ugent.be wrote:
Hello,
I have two large tables in a database, one containing original data and the
other one derived from the first table. The first table contains several
columns and indexes, while the second table has less
On 09/01/2011 01:35 PM, Grzegorz Jaśkiewicz wrote:
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
Op 01-09-11 13:31, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 4:32 AM, Rik Bellensrik.bell...@telin.ugent.be wrote:
Hello,
I have two large tables in a database, one containing original data and the
other one derived from the first table. The first table contains several
columns and
Op 01-09-11 14:22, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 6:05 AM, Rik Bellensrik.bell...@telin.ugent.be wrote:
Op 01-09-11 13:31, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 4:32 AM, Rik Bellensrik.bell...@telin.ugent.be
wrote:
Hello,
I have two large tables in a database, one
On Thu, Sep 1, 2011 at 6:38 AM, Rik Bellens rik.bell...@telin.ugent.be wrote:
Op 01-09-11 14:22, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 6:05 AM, Rik Bellensrik.bell...@telin.ugent.be
wrote:
Op 01-09-11 13:31, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 4:32 AM, Rik
On Thu, Sep 1, 2011 at 6:38 AM, Rik Bellens rik.bell...@telin.ugent.be wrote:
Op 01-09-11 14:22, Scott Marlowe schreef:
Yeah, could be. Take a look at this page:
http://wiki.postgresql.org/wiki/Show_database_bloat and see if the
query there sheds some light on your situ.
thanks for this
On Thu, Sep 1, 2011 at 3:48 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
md5 has size limitations, the second approach seems more practical.
Really? I was not aware of size limits of md5, what are they?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Is there any open source ERD Tool for Postgresql Database.
I find some paid tools but looking for free tools.
Free or open source? ;-
http://pgdesigner.sourceforge.net/en/index.html
http://www.db-main.eu/
http://sourceforge.net/projects/dbdesigner-fork/
And a list of a lot of others:
Στις Thursday 01 September 2011 15:50:21 ο/η Scott Marlowe έγραψε:
On Thu, Sep 1, 2011 at 3:48 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
md5 has size limitations, the second approach seems more practical.
Really? I was not aware of size limits of md5, what are they?
2011/9/1 Grzegorz Jaśkiewicz gryz...@gmail.com:
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert into tt values(10,'hello');
INSERT 0 1
On Aug 31, 7:39 pm, Marcos Hercules Santos mhe...@gmail.com wrote:
hi guys
I'm newbie in Psql and I'm trying to build one function in order to
count the products for each supplier. So i'm gonna put it quite simply
though this example
Please, consider a table called books with the following
Hi all,
I'm running one of my programs with valgrind to check for memory leaks
and I'm seeing something like this:
==13207== 4 bytes in 1 blocks are still reachable in loss record 1 of 256
==13207==at 0x4026864: malloc (vg_replace_malloc.c:236)
==13207==by 0x43343BD: ??? (in
OP:
I thought about using dblink and the EXCEPT query, but then I need to know the
field list of each query result, which is a pain in the butt.
That is not correct. As long as the table definitions are precisely
the same, you can move records across dblink without specifying
fields. You
Rik Bellens wrote:
I have two large tables in a database, one containing original data
and
the other one derived from the first table. The first table contains
several columns and indexes, while the second table has less columns
and
only one index. Both tables have the same number of rows.
Antonio Vieiro anto...@antonioshome.net writes:
I'm running one of my programs with valgrind to check for memory leaks
and I'm seeing something like this:
==13207== 4 bytes in 1 blocks are still reachable in loss record 1 of 256
These are not bugs; they are just permanent allocations that are
Hi
I want to add information to multiple columns (20 – 40) by employing a loop.
Each pass of the loop will populate one column with an array.
I have tried and I have read that variables can not be used to control column
names.
Is there a means of working around this restriction other than
In response to Bob Pawley rjpaw...@shaw.ca:
I want to add information to multiple columns (20 – 40) by employing a loop.
Each pass of the loop will populate one column with an array.
I have tried and I have read that variables can not be used to control column
names.
Is there a means
-Original Message-
From: Bill Moran
Sent: Thursday, September 01, 2011 7:59 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name
In response to Bob Pawley rjpaw...@shaw.ca:
I want to add information to multiple columns (20 – 40) by employing a
loop. Each
On Sep 1, 2011, at 9:04 AM, Bob Pawley wrote:
Would it be possible for you to point me to an example??
The EXECUTE command is what you want.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list
On Thursday, September 01, 2011 8:04:49 am Bob Pawley wrote:
-Original Message-
From: Bill Moran
Sent: Thursday, September 01, 2011 7:59 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name
In response to Bob Pawley rjpaw...@shaw.ca:
I want to add
In response to Bob Pawley rjpaw...@shaw.ca:
From: Bill Moran
In response to Bob Pawley rjpaw...@shaw.ca:
I want to add information to multiple columns (20 - 40) by employing a
loop. Each pass of the loop will populate one column with an array.
I have tried and I have read that
2011/9/1 Merlin Moncure mmonc...@gmail.com:
2011/9/1 Grzegorz Jaśkiewicz gryz...@gmail.com:
On Thu, Sep 1, 2011 at 11:14 AM, Sim Zacks s...@compulab.co.il wrote:
On 09/01/2011 12:26 PM, Pavel Stehule wrote:
Hello
postgres=# create table tt(a int, b varchar);
CREATE TABLE
postgres=# insert
Thank you for that. Sure enough, at character 36202 I have found \\ 51. I
assume that the space should be a zero. That appears to be the only error. How
odd!
--- On Wed, 31/8/11, Tom Lane t...@sss.pgh.pa.us wrote:
From: Tom Lane t...@sss.pgh.pa.us
Subject: Re: [GENERAL] invalid input syntax
Op 01-09-11 14:43, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 6:38 AM, Rik Bellensrik.bell...@telin.ugent.be wrote:
Op 01-09-11 14:22, Scott Marlowe schreef:
Yeah, could be. Take a look at this page:
http://wiki.postgresql.org/wiki/Show_database_bloat and see if the
query there sheds some
2011/9/1 Sim Zacks s...@compulab.co.il:
OP:
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each query result, which is a pain in the butt.
That is not correct. As long as the table definitions are precisely
the same, you can move records
On Thu, Sep 1, 2011 at 10:04 AM, Rik Bellens rik.bell...@telin.ugent.be wrote:
after running reindex on the stats_count_pkey, the disk size of this index
was reduced with about 2 gigs, but the size of the table itself was still
very large.
running 'vacuum full' also reduced the table size
Hi,
I have tables on my various computers that looks like:
Table public.registrations
Column | Type | Modifiers | Storage | Description
--+--+---+--+-
software | text | | extended |
id | text | | extended |
On Thu, Sep 1, 2011 at 7:56 AM, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
Στις Thursday 01 September 2011 15:50:21 ο/η Scott Marlowe έγραψε:
Really? I was not aware of size limits of md5, what are they?
sorry, i was wrong. i dont know why i had this impression,
just checked
example:
$ create schema x;
CREATE SCHEMA
$ create table x.y as select * from pg_class;
SELECT 294
$ explain select * from x.y limit 1;
QUERY PLAN
Limit (cost=0.00..0.04 rows=1
Hi,
From the documentation:
Whenever a new session is subsequently started in that database, the
specified value becomes the session default value.
Is there some way to get existing sessions to see the new search_path
without forcing them to reconnect.
Thanks,
David J.
Now am able to access it. But for sometime I was not able to access it.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Fri, Sep 2, 2011 at 3:34 AM, Raghavendra
raghavendra@enterprisedb.com wrote:
Hi All,
Am unable to access pgfoundry.org site.
On 1 September 2011 19:08, hubert depesz lubaczewski dep...@depesz.comwrote:
example:
$ create schema x;
CREATE SCHEMA
$ create table x.y as select * from pg_class;
SELECT 294
$ explain select * from x.y limit 1;
QUERY PLAN
I'm doing an UPDATE something like this:
UPDATE
slots
SET
a = 'a'
,b = (SELECT uuid_generate_v1())
WHERE
c = TRUE;
Each updated row in slots is getting the same value for b. Is there a
way of getting a per-row value from uuid_generate_v1() without
On Thu, Sep 1, 2011 at 1:24 PM, David Johnston pol...@yahoo.com wrote:
Hi,
From the documentation:
“Whenever a new session is subsequently started in that database, the
specified value becomes the session default value.”
Is there some way to get existing sessions to see the new
FYI, also, yesterday, I fixed a pg_upgrade bug when upgrading from 8.3
--- I suggest you wait for 9.0.5 or pull git head for the release you
want.
---
Tom Lane wrote:
I wrote:
I think it'd be a lot safer to modify (or
On Thu, Sep 01, 2011 at 04:39:06PM -0400, Tom Lane wrote:
hubert depesz lubaczewski dep...@depesz.com writes:
On Thu, Sep 01, 2011 at 04:24:59PM -0400, Tom Lane wrote:
The non-plain-text output formats provide that sort of detail, if you
need it.
Which is great, but why can't we have it
On Thu, Sep 01, 2011 at 04:24:59PM -0400, Tom Lane wrote:
hubert depesz lubaczewski dep...@depesz.com writes:
$ explain select * from x.y limit 1;
QUERY PLAN
Limit
hubert depesz lubaczewski dep...@depesz.com writes:
$ explain select * from x.y limit 1;
QUERY PLAN
Limit (cost=0.00..0.04 rows=1 width=189)
- Seq Scan on y (cost=0.00..13.70
Hi All,
Am unable to access pgfoundry.org site. Does anyone facing the same problem
?
Oops! Google Chrome could not connect to pgfoundry.org
Try reloading: pgfoundry.org http://pgfoundry.org/
Additional suggestions:
- Access a **cached
hubert depesz lubaczewski dep...@depesz.com writes:
On Thu, Sep 01, 2011 at 04:24:59PM -0400, Tom Lane wrote:
The non-plain-text output formats provide that sort of detail, if you
need it.
Which is great, but why can't we have it in plain text too?
It's frequently unnecessary, and horizontal
On 01/09/11 22:08, Antonio Vieiro wrote:
Hi all,
I'm running one of my programs with valgrind to check for memory leaks
and I'm seeing something like this:
You only get the one report, though, right? No matter how many times
PQconnectdb is run in a loop?
It's internal stuff within OpenSSL.
Mmm... maybe if you can dump them as inserts you'll be able to restore
them in one DB only. Important: make the restore connection autocommit
(i.e. don't put the --single-transaction flag). That way individual
INSERTs will fail without affecting the other data if that INSERT
violates the PK. This
Hi,
On 2 September 2011 03:09, Jerry LeVan jerry.le...@gmail.com wrote:
I keep registration numbers for software and login/passwords for
various organizations, etc…
As time goes by the tables on the various computers get out of
sync.
Is there an elegant way I can get all of the differences
Hi all -
I'm on openSuse running the latest stable release of Gnome3 (Just
trying it out, so far the fact I can't minimize windows is perhaps
more than my old school brain can handle)..
I've noticed in pgAdmin, basically no popup works. If I right click
on the Databases branch and select
Hi all -
I'm on openSuse running the latest stable release of Gnome3 (Just
trying it out, so far the fact I can't minimize windows is perhaps
more than my old school brain can handle)..
I've noticed in pgAdmin, basically no popup works. If I right click
on the Databases branch and select New
Rory Campbell-Lange r...@campbell-lange.net writes:
I'm doing an UPDATE something like this:
UPDATE
slots
SET
a = 'a'
,b = (SELECT uuid_generate_v1())
WHERE
c = TRUE;
Each updated row in slots is getting the same value for b.
That's Postgres'
Craig Ringer ring...@ringerc.id.au writes:
Even better, add a valgrind suppressions file for the warnings and
ignore them. They are leaks only in the sense that a static variable
is a leak, ie not at all.
Yeah, the bottom line here is that valgrind will warn about many things
that are not
Hi,
I have tables on my various computers that looks like:
Table public.registrations
Column | Type | Modifiers | Storage | Description
--+--+---+--+-
software | text | | extended |
id | text | | extended |
Yeah, all hub.org hosted services had a rather long downtime again
yesterday. They seem to be back up now.
/Magnus
On Sep 2, 2011 1:25 AM, Raghavendra raghavendra@enterprisedb.com
wrote:
Now am able to access it. But for sometime I was not able to access it.
---
Regards,
Raghavendra
60 matches
Mail list logo