Hi
Try Mogwai ERDesignerNG. it can reverse engineer databases like
Postgres, Oracle, MySQL, MSSQL, stores its model as XML files and can
also generate DDL from it.
Supporting schema comparison, schema evolution and data dictionaries.
Regards
Mirko
fe...@crowfix.com schrieb:
I'd like to
Greets,
I must be missing something here:
SELECT '1.1.1.1' ~ E'^\d+';
returns FALSE, when I would expect TRUE, as for:
SELECT '1.1.1.1' ~ E'^[[:digit:]]+';
ie, '[[:digit:]]' != '\d'
In config, regex_flavor = advanced.
Any ideas?
Thanks
Henry
pgptxHPEfsSfe.pgp
Description: PGP
Richard Huxton wrote:
test= SELECT date_part('timezone_hours', timestamp with time zone
'2009-06-26 10:05:57.46624+11');
date_part
---
2
(1 row)
2 being the offset of my local time zone.
Now an EXPLAIN shows that this is due to the fact that the timestamp
In response to Henry :
Greets,
I must be missing something here:
SELECT '1.1.1.1' ~ E'^\d+';
returns FALSE, when I would expect TRUE, as for:
Try:
test=*# SELECT '1.1.1.1' ~ E'^\\d+';
?column?
--
t
(1 row)
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz:
Henry schrieb:
I must be missing something here:
SELECT '1.1.1.1' ~ E'^\d+';
returns FALSE, when I would expect TRUE, as for:
SELECT '1.1.1.1' ~ E'^[[:digit:]]+';
ie, '[[:digit:]]' != '\d'
In config, regex_flavor = advanced.
Any ideas?
Yes; you have to escape the backslash character:
On Tue, Jun 30, 2009 at 4:40 AM, Greg Starkgsst...@mit.edu wrote:
On Mon, Jun 29, 2009 at 2:31 PM, Scott Meadscott.li...@enterprisedb.com
wrote:
As with many different types of security (i.e. the 3 foot high fence) this
is really just a deterrent to most people who either aren't capable of
On Mon, Jun 29, 2009 at 2:08 PM, littlesuspenselittlesuspe...@web.de wrote:
Hi Volk,
Note that the word outer is just noise in pgsql, i.e. it's not needed.
What you've got are left outer, right outer, and full outer joins.
All can be called just left, right, or full joins. Note that
Albe Laurenz wrote:
Richard Huxton wrote:
test= SELECT date_part('timezone_hours', timestamp with time zone '2009-06-26
10:05:57.46624+11');
I like your suggestion of absolute time, which makes PostgreSQL's
timestamptz much easier to understand.
What worries me a bit is that the SQL
On Tue, Jun 30, 2009 at 2:00 AM, Waldemar
Bergstreiserlittlesuspe...@web.de wrote:
On Mon, Jun 29, 2009 at 2:08 PM, littlesuspenselittlesuspe...@web.de wrote:
Hi Volk,
Note that the word outer is just noise in pgsql, i.e. it's not needed.
What you've got are left outer, right outer, and
Hi!
2009.06.29. 18:26 keltezéssel, Craig Ringer írta:
On Mon, 2009-06-29 at 13:36 +0200, durumdara wrote:
I wanna ask something. I came from IB/FB world.
InterBase / FireBird ?
Yes, sorry for short descriptions.
In this world I was everytime in transaction, because of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All,
Could someone please tell me why when I click on a cluster pgAdmin
exhibits a dialog stating:
Column not found in pgSet: no_spool ?
- - pgAdmin version 1.10.0 Beta2 rev. 7749
- - Master on a remote server
- - Slony-I not installed on
Hi!
2009.06.29. 15:34 keltezéssel, A. Kretschmer írta:
In response to durumdara :
Hi!
Can I check with something that I'm in in-transaction or in autocommit
mode?
I wanna avoid the notices I got when I'm also in mode I need...
For example:
begin
begin --- error notice...
Warning,
-Ursprüngliche Nachricht-
Von: Scott Marlowe scott.marl...@gmail.com
Gesendet: 30.06.09 10:17:11
An: Waldemar Bergstreiser littlesuspe...@web.de
CC: pgsql-general@postgresql.org
Betreff: Re: [GENERAL]
On Tue, Jun 30, 2009 at 2:00 AM, Waldemar
Bergstreiserlittlesuspe...@web.de
On Tue, Jun 30, 2009 at 9:58 AM, Waldemar
Bergstreiserlittlesuspe...@web.de wrote:
-- c *= b *= a =* d =* f
select * from a, outer( b, outer c), outer (d, outer f )
where a.b_id = b.id and b.c_id = c.id and a.d_id = d.id and d.f_id = f.id;
from a full join b on (a.id=b.id)
full join c on
In response to durumdara :
Hi!
Can I check with something that I'm in in-transaction or in autocommit
mode?
I wanna avoid the notices I got when I'm also in mode I need...
For example:
begin
begin --- error notice...
Thanks for your help:
dd
You can set client_min_messages:
-- c *= b *= a =* d =* f
select * from a, outer( b, outer c), outer (d, outer f )
where a.b_id = b.id and b.c_id = c.id and a.d_id = d.id and d.f_id =
f.id;
from a full join b on (a.id=b.id)
full join c on (b.id=c.id)
full join d
I guess, you don't get it. Probably so
Dear postgres users,
I would like to set up a table that contains a 3D position, a time and a
measured value, e.g. columns: x, y, z, t, val.
Does
bog-standard postgres (i.e. no PostGIS extension, if possible) provide
a way to index this table to allow the following 2 types of query to
be
Hi,
Thanks for the answer ...
But honestly I think that was a misunderstood.
The memory increase issue is showed in the DATA column.
Look how day by day it increases exponencially.
In a few days PostGres goes out of memory, close the connections and enter
in a recovery mode.
I really don’t
Hi
I am looking for a way to convert a text field from a table into
punycode (IDN).
Are there any buildin functions in Postgres ot in plpgsql.
Best regards,
Kaloyan Iliev
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Richard Huxton d...@archonet.com writes:
The datetime value expression isn't '2009 ... +11', it's the absolute
time that string represents. It doesn't in fact have a time-zone
component except in the context of your locale settings.
I don't know if we do follow the standard here though -
Waldemar Bergstreiser littlesuspe...@web.de writes:
Just try to rewrite query below with left outter joins. I had not found any
compact syntax.
select * from a, outer( b, outer c), outer (d, outer f )
where a.b_id = b.id and b.c_id = c.id and a.d_id = d.id and d.f_id = f.id;
This has got
After a crash, some data disappeared in some tables.
Furthermore, there is a table with an INTEGER as primary key. One of its
row is corrupted.
All global requests (no WHERE clause) succeed, but each request with a
WHERE clause on the primary acts like this values does not exist.
Example :
On Tuesday 30 June 2009, regis.boum...@steria.com wrote:
SELECT * FROM t_table t WHERE t.id=1; = no result
Is there a reason for this?
Is there a way to repair the database?
reindex
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Shut down the postmasters and rsync. (Assuming same architecture build
options...)
--
Scott Ribe
scott_r...@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
regis.boum...@steria.com wrote:
Is there a reason for this?
Is there a way to repair the database?
I guess your primary key index got damaged. You could try to REINDEX the
table or DROP and recreate the index manually. Perhaps you should do a
backup of your data directory before reindexing
Thanks for you help
found that this not connect problem is server wide.
not just Isolated to postgresql.
so tracking down what i did to mess it up
:D
BJ Freeman sent the following on 6/28/2009 8:23 PM:
sorry about the post did not do a reply all and sent a personal replay
yes in the chain I
On Jun 30, 2009, at 6:10 AM, Kaloyan Iliev wrote:
Hi
I am looking for a way to convert a text field from a table into
punycode (IDN).
Are there any buildin functions in Postgres ot in plpgsql.
It'd probably be easiest to use pl/perl and one of the punycode CPAN
modules.
Cheers,
Hi. I'm trying to install Postgresql 8.3 in my computer but a windows appear
asking me a password that i no have... If I click next button no continues... i
don't know what can I do. Yesterday I tried to install pokertracker 3 (the
latest version because i had already another version and
What OS are you running?
What exactly is the window saying? If you could take a snapshot of it
and upload it to a photo site and send the URL to the list, that might
be helpful.
Most OSes allow you to snapshot the active window with CTRL-PRT-SCRN
Then you can use the paste option in your favorite
I have encountered an error that, on the face of it, seems to me to
be inexplicable. I hope that someone here can illuminate the matter
for me.
PGError: ERROR: timestamp out of range: 20080809-01-01
00:00:00
: SELECT * FROM currency_exchange_rates WHERE
(currency_code_base = E'CAD'
On Jun 30, 2009, at 4:14 AM, Waldemar Bergstreiser wrote:
I don't get it either. by *= do you mean the Oracle-style outer
join?
in which case why is this not just
select * from a,
left outer join b on (a.b_id = b.id)
left outer join c on (b.c_id = c.id)
left outer join d on (a.d_id = d.id)
James B. Byrne byrn...@harte-lyne.ca writes:
I have encountered an error that, on the face of it, seems to me to
be inexplicable. I hope that someone here can illuminate the matter
for me.
PGError: ERROR: timestamp out of range: 20080809-01-01
00:00:00
: SELECT * FROM
On Tue, Jun 30, 2009 at 11:45 AM, Alban
Hertroysdal...@solfertje.student.utwente.nl wrote:
On Jun 30, 2009, at 7:17 PM, James B. Byrne wrote:
I have encountered an error that, on the face of it, seems to me to
be inexplicable. I hope that someone here can illuminate the matter
for me.
On Tue, June 30, 2009 13:24, Tom Lane wrote:
No, it's complaining that the constant is out of range --- it's
failing long before it's tried to do any actual BETWEEN comparisons.
Surely you meant something more like 2008-08-09?
regards, tom lane
The column is a
On Tue, Jun 30, 2009 at 11:51 AM, James B. Byrnebyrn...@harte-lyne.ca wrote:
On Tue, June 30, 2009 13:24, Tom Lane wrote:
No, it's complaining that the constant is out of range --- it's
failing long before it's tried to do any actual BETWEEN comparisons.
Surely you meant something more like
James B. Byrne byrn...@harte-lyne.ca writes:
The column is a timestamp value. I expected any time on any given
date to fall between the start and end of that day so the
hh:mm:ss:hh portion does not leap out at me as something that should
cause a problem. Should it?
It's the eight-digit
On Jun 30, 2009, at 7:17 PM, James B. Byrne wrote:
I have encountered an error that, on the face of it, seems to me to
be inexplicable. I hope that someone here can illuminate the matter
for me.
PGError: ERROR: timestamp out of range: 20080809-01-01
00:00:00
: SELECT * FROM
On Tue, June 30, 2009 14:07, Tom Lane wrote:
It's the eight-digit year field that it's unhappy with ...
Duuuh! I suppose that it would...
Thanks,
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited
On Tue, Jun 30, 2009 at 10:22:23AM -0700, Erik Jones wrote:
postgres=# select null = null;
?column?
--
(1 row)
Actually, it's NULL.
shac...@postgres:5432=# SELECT (NULL = NULL) IS NULL;
?column?
--
t
(1 row)
Cheers,
David.
--
David Fetter da...@fetter.org
On Tue, Jun 30, 2009 at 1:22 PM, Erik Jonesejo...@engineyard.com wrote:
and if I have a row in table C where c.id is null? A don't know.
No, it's perfectly clear as 'NULL = NULL' evaluates to false:
postgres=# select null = null;
?column?
--
you can test for that with 'is
added this to iptables
ACCEPT all -- localhostlocalhost
BJ Freeman sent the following on 6/28/2009 8:23 PM:
sorry about the post did not do a reply all and sent a personal replay
yes in the chain I have
ACCEPT all -- anywhere anywherestate
On Mon, Jun 29, 2009 at 2:26 PM, David Kerrd...@mr-paradox.net wrote:
On Sat, Jun 27, 2009 at 08:23:26PM -0400, APseudoUtopia wrote:
- Hey list,
-
- I'm migrating my site away from MySQL to PostgreSQL. So far, it's been
- going great. However, there's one problem I've been having trouble
-
On Jun 30, 2009, at 11:25 AM, David Fetter wrote:
On Tue, Jun 30, 2009 at 10:22:23AM -0700, Erik Jones wrote:
postgres=# select null = null;
?column?
--
(1 row)
Actually, it's NULL.
shac...@postgres:5432=# SELECT (NULL = NULL) IS NULL;
?column?
--
t
(1 row)
Er, yeah, I
On Tue, Jun 30, 2009 at 01:14:10PM +0200, Waldemar Bergstreiser wrote:
I found a good explanation about informix outer joins.
http://savage.net.au/SQL/outer-joins.html
Please take a look at that.
The syntax appears to make the expression of various idioms difficult;
for example, how would
On Tuesday 30 June 2009 10:48:50 am Scott Marlowe wrote:
Oh I so do hope that we won't have to bother with currencies anymore THAT
far into the future!
You laugh, but who will be fixing the Y20M problem, huh?
Not you or I that's for sure.
--
John Fabiani
--
Sent via pgsql-general
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes cbar...@recognia.com wrote:
Sorry if posting twice, wasn’t part of general when sent and didn’t see
it received by group.
I started an online backup of postgres, tar’d my data folder, copy to usb
drive in production
and restored it into my RC
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes cbar...@recognia.com wrote:
Sorry if posting twice, wasn’t part of general when sent and didn’t see
it received by group.
I started an online backup of postgres, tar’d my data folder, copy to usb
drive in production
and restored it into my RC
47 matches
Mail list logo