On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes 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 environment. H
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes 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 environment. H
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 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 w
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 m
On Mon, Jun 29, 2009 at 2:26 PM, David Kerr 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
> - solving.
> -
>
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
> RE
On Tue, Jun 30, 2009 at 1:22 PM, Erik Jones 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 distinct from':
sel
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 http://fetter.org/
Phon
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 Limit
"James B. Byrne" 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 year field that it'
On Tue, Jun 30, 2009 at 11:51 AM, James B. Byrne 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 2008-08-09
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:45 AM, Alban
Hertroys 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.
>>
>> PGError: ERROR: timesta
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 "curre
"James B. Byrne" 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 "currency_exchange_r
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)
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'CA
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 favorit
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 everyt
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,
Steve
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 h
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 reinde
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:
http://www
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 subsc
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 :
SELEC
Waldemar Bergstreiser 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 pretty much the same
Richard Huxton writes:
> The 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 - not read it through.
The spec does appea
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:
http://www.post
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
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 perfor
> >> > -- 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
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 clien
On Tue, Jun 30, 2009 at 9:58 AM, Waldemar
Bergstreiser 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 (b.id=c
> -Ursprüngliche Nachricht-
> Von: "Scott Marlowe"
> Gesendet: 30.06.09 10:17:11
> An: Waldemar Bergstreiser
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL]
> On Tue, Jun 30, 2009 at 2:00 AM, Waldemar
> Bergstreiser wrote:
> >> On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense
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...
War
-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 localh
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 re
On Tue, Jun 30, 2009 at 2:00 AM, Waldemar
Bergstreiser wrote:
>> On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense 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 c
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 stan
> On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense 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 inner
> joins are
On Tue, Jun 30, 2009 at 4:40 AM, Greg Stark wrote:
> On Mon, Jun 29, 2009 at 2:31 PM, Scott Mead
> 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
>> reverse engineering or are just not i
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:
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: 03
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
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 Digit
46 matches
Mail list logo
