On 07/17/2011 09:37 PM, mdxxd wrote:
My DB is big, around 5M hands(big is relative of course), I use complex
HUD(if you know what it is), run complex reports and play 12+ tables.
Complex is relatively complex to other PT users, I don't know how it
compared to other tasks.
That is pretty cra
Hello,
I would like to know the effect of alter table rename, I know that the some
things are changed automatcally such as views dependencies and forign keys and
some things remain the same such as function defenesions.
Is there is a place where can I find the exact effect of rename
Regards
Hi all,
I'm building a small C application that uses libpq and I was wondering
if there's an easy way to detect memory leaks in my code.
I think I'm calling PQclear and friends correctly, but I'd like to
double-check it. I was wondering if there's a function in libpq to
check memory-use usage/int
Hi,
We are on 8.3.7 and interested on upgrading to the 9.0.4.
How can I verify that the bug below is fixed for 9.0.4?
( Fix Windows shared-memory allocation code (Tsutomu Yamada, Magnus) This bug
led to the often-reported "could not reattach to shared memory" error message.)
I can tell for sure
On 19/07/2011 6:48 PM, Abraham, Danny wrote:
I can tell for sure, reading the release notes that it is fixed for
8.2.18, 8.3.8 and 8.4.1.
The fix should be in 9.0 too. It might not appear in the 9.0 release
notes explicitly if 9.0 was branched off after the 8.4.1 release,
because then 9.0 wo
On Tue, Jul 19, 2011 at 5:41 AM, Antonio Vieiro wrote:
> Hi all,
>
> I'm building a small C application that uses libpq and I was wondering
> if there's an easy way to detect memory leaks in my code.
>
> I think I'm calling PQclear and friends correctly, but I'd like to
> double-check it. I was wo
Hi there
I'm transferring a database from 8.2 to 8.4 and I have some triggers that
reference liblwgeom.so within the database.
When I restore a dump of the 8.2 database into my 8.4 database it says
that liblwgeom.so does not exist. From various forums on the internet I have
discovered that this h
On 19/07/2011 6:41 PM, Antonio Vieiro wrote:
Hi all,
I'm building a small C application that uses libpq and I was wondering
if there's an easy way to detect memory leaks in my code.
I think I'm calling PQclear and friends correctly, but I'd like to
double-check it. I was wondering if there's a
Thanks Craig
Yes, I am trying to get to a full confidence level.
How can I tell which version was 9.0 branched off?
Any git 101 document?
From: Abraham, Danny
Sent: Tuesday, July 19, 2011 1:49 PM
To: pgsql-general@postgresql.org
Cc: Abraham, Danny
Subject: Identify release contents
Hi,
We ar
Thanks.
I wanted to share some information with you all. There were nearly 80
attendees had attend this conference, most of them are PG relative engineers
from about 20 enterprises. Though there is still a lot of space to be
improved, but this is a first step of our community.
I would like to
On 19/07/11 09:58, MS Rao wrote:
*Programmer ( Postgres), Milwaukee -- offsite-Remote - onsite*
We are looking for Postgres skilled programmer with the following skills:
Skills:
Strong in Postgres SQl ,
Set up of database,
Linux
RDBMS expert and strong in design
Possible to work onsite /offsi
On Tuesday, July 19, 2011 6:36:02 am Abraham, Danny wrote:
> Thanks Craig
>
> Yes, I am trying to get to a full confidence level.
>
> How can I tell which version was 9.0 branched off?
>
> Any git 101 document?
>
There is a browse-able Web site for the Postgres Git repository:
http://git.postg
Finally I got it working. You were right Tom Lane. I actually did not copy the
corrected source file onto the server and thus still had this "mysterious"
failure. So, palloc0 is the solution. Thanks again.
Regards,
Gregor Trefs
-Ursprüngliche Nachricht-
Von: pgsql-general-ow...@postgres
Abraham, Danny wrote:
> How can I verify that the bug below is fixed for 9.0.4?
>
> ( Fix Windows shared-memory allocation code (Tsutomu Yamada, Magnus)
This bug led to the often-
> reported "could not reattach to shared memory" error message.)
>
> I can tell for sure, reading the release notes tha
Hi Gavin
I do'nt believe Rao would discriminate against anyone that speaks the Kings
English.
If you want to stay in NZ Did you try sending a resume to den...@sosnoski.com
http://www.sosnoski.co.nz
Dennis' expertise is web-servicesHTH,
Martin Gainty
_
On Jul 19, 2011, at 9:27 AM, Martin Gainty wrote:
> I do'nt believe Rao would discriminate against anyone that speaks the Kings
> English.
So, what makes you think they won't hire us Americans?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
I'm not sure to whom this specifically should be addressed, but something
that's been bugging me for a while: announcements like this morning's "AnySQL
Maestro 11.7 released", where the announcement mentions nothing about platform
support. And it's not just the lack of that info in announcements
On Jul 19, 2011, at 6:28 AM, Craig Ringer wrote:
> Note that some "leaks" that are reported are _normal_ in most software. There
> is absolutely no harm in not free()ing a structure that's allocated only once
> during init and never messed with afterwards. The OS clears the memory
> anyway, so
On Tuesday 19. July 2011 18.44.46 Scott Ribe wrote:
> I'm not sure to whom this specifically should be addressed, but something
> that's been bugging me for a while: announcements like this morning's
> "AnySQL Maestro 11.7 released", where the announcement mentions nothing
> about platform support.
I'm a bit new to PG, and having troubles with timestamps. The docs list:
timestamp [ (p) ] [ without time zone ] 8 bytes both date and time 4713 BC
5874897 AD 1 microsecond / 14 digits
timestamp [ (p) ] with time zone8 bytes both date and time, with time
zone 4713 BC 58
On Tuesday, July 19, 2011 12:01:19 pm David Salisbury wrote:
> I'm a bit new to PG, and having troubles with timestamps. The docs list:
>
> timestamp [ (p) ] [ without time zone ] 8 bytes both date and time
> 4713
> BC5874897 AD 1 microsecond / 14 digits timestamp [ (p) ] wit
Hi,
Here are a few questions that were asked by a customer, who are trying
to assess the pros and cons of using Postgres and its SR feature. I would
like to get an opinion of someone more involved with the community than me.
.) Will Postgres support Streaming Replication from 9.0.x to 9.1.x;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Jul 19, 2011 at 12:15:54PM -0700, Adrian Klaver wrote:
> On Tuesday, July 19, 2011 12:01:19 pm David Salisbury wrote:
> > I'm a bit new to PG, and having troubles with timestamps. The docs list:
[...]
> > My immediate problem is below..
> >
On 07/19/2011 12:01 PM, David Salisbury wrote:
I'm a bit new to PG, and having troubles with timestamps. The docs list:
timestamp [ (p) ] [ without time zone ]8 bytesboth date and
time4713 BC5874897 AD1 microsecond / 14 digits
timestamp [ (p) ] with time zone8 bytes
Hi all,
Well, thanks for the ideas. I also prefer cleaning things up myself
before exiting.
I was expecting some small statistics from the library (connections
opened/closed, PGresults returned/freed, etc.) but I can do it myself,
before trying out more heavyweight tools such as valgrind.
Cheer
Hi all;
As I understand, utility statements are not generally parameterized, so:
postgres=# alter user test123 with password 'foo' valid until now() +
'1 day'::interval;
ERROR: syntax error at or near "now"
LINE 1: ...lter user test123 with password 'foo' valid until now() + '1...
Is this by de
Hello
2011/7/19 Chris Travers :
> Hi all;
>
> As I understand, utility statements are not generally parameterized, so:
>
> postgres=# alter user test123 with password 'foo' valid until now() +
> '1 day'::interval;
> ERROR: syntax error at or near "now"
> LINE 1: ...lter user test123 with password
On Tue, Jul 19, 2011 at 2:40 PM, Pavel Stehule wrote:
>>
>
> If I understand well , a utility has no plan, and a parameters are
> implemented as plan's parameters.
>
> you can use a dynamic sql in plpgql
>
> DO $$
> BEGIN
> EXECUTE 'ALTER USER test123 WITH PASSWORD 'foo' VALID UNTIL ' ||
> to_ch
Hey folks,
As a reminder, PgWest is in a few months and the CFP closes in two
weeks. Get those talks in!
https://www.postgresqlconference.org/talk_types
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and
Shianmiin wrote:
>
> I thought the Atomic should be at statement level, could anyone tell me
> why PostgreSQL behaves differently?
>
re-state for clarification purpose.
Since SQL is a set language, there is no concept of row order. I thought the
checking should be on a per set operation (i.e.
OK, did I just read Poker Tracker and SSDs in the same email --- my head
is going to explode!
Greg, tell me you didn't get involved with Postgres because of Poker
Tracker. :-O :-)
---
Greg Smith wrote:
> On 07/17/2011 09:
Leif Biberg Kristensen wrote:
> On Tuesday 19. July 2011 18.44.46 Scott Ribe wrote:
> > I'm not sure to whom this specifically should be addressed, but something
> > that's been bugging me for a while: announcements like this morning's
> > "AnySQL Maestro 11.7 released", where the announcement ment
I'm just starting to take a look at Spacewalk as a potential solution
for managing an internal cloud of linux servers... this is the
opensource version of Redhat's Satellite. Traditionally its been
hosted on an Oracle database, but they now also support PostgreSQL, but
with this caveat...
John R Pierce writes:
> I'm just starting to take a look at Spacewalk as a potential solution
> for managing an internal cloud of linux servers... this is the
> opensource version of Redhat's Satellite. Traditionally its been
> hosted on an Oracle database, but they now also support Postg
On 07/19/2011 09:00 PM, Bruce Momjian wrote:
We have the same problem with people posting to pgsql-jobs where they
don't mention the location of the job. I usually email the people
privately about this.
Used to have. pgsql-jobs is now moderated because the junk posts were
starting to out
On 07/18/2011 05:58 PM, MS Rao wrote:
*Programmer ( Postgres), Milwaukee -- offsite-Remote - onsite*
We are looking for Postgres skilled programmer with the following skills:
Job listings are not appropriate for the pgsql-general mailing list.
Please direct them to the pgsql-jobs list in t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Jul 18, 2011 at 03:18:43PM -0700, Shianmiin wrote:
> setup:
>
> drop table if exists t1;
> create table t1 (f1 int);
> create unique index uix_t1 on t1(f1) ;
> insert into t1(f1) values (1), (2), (3);
> select * from t1;
>
> f1
> ---
> 1
On Tue, Jul 19, 2011 at 10:41 PM, wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Mon, Jul 18, 2011 at 03:18:43PM -0700, Shianmiin wrote:
>> setup:
>>
>> drop table if exists t1;
>> create table t1 (f1 int);
>> create unique index uix_t1 on t1(f1) ;
>> insert into t1(f1) valu
Bruce Momjian wrote:
Greg, tell me you didn't get involved with Postgres because of Poker
Tracker. :-O :-)
Nah, both came out of my working on stock trading systems. I just wrote
a bit more about this whole subject at
http://blog.2ndquadrant.com/en/2011/07/pushing-allin-with-postgresql.
Nice to see some poker being discussed on this list. Much more
reputable than Stock Trading.
I was once on the LuckyBum side of this in a Casino Limit game.
Opponent: AT
Stuart the LuckyBum: 88
Flop: ATT
Myself and opponent checked that flop, I bet the turn 8 and was
raised, the river 8 saw
the
On 07/19/11 7:58 PM, Tom Lane wrote:
I'm keeping an eye on it internally to Red Hat, but not really
contributing any significant number of cycles ATM. My understanding of
the status is that the core stuff works but there are still a lot of
Oracle dependencies in lesser-used nooks and crannies of
41 matches
Mail list logo
