Chris Travers wrote:
Here is a paper I have written for the purposes of providing some
additional educational material for the MySQL crowd.
Here's my contribution:
Why I choose PostgreSQL (PostgreSQL in 21 Seconds)
I choose referential integrity, meaning my lookups always work.
I choose stor
Hi Scott
Firstly, your name rings a bell. I'm sure you're a 4D developer - I was
one too (once, but no more sadly)...
You imply that it should be possible to create an embedded C function that
can access the DB in its own thread, and therefore its own transaction. Is
there a document that would e
On Thursday 04 December 2003 07:57, John Sidney-Woollett wrote:
>
> I'm amazed that nested transactions are still not yet supported. Postgres
> is a mature product (from my understanding), and I can see loads of
> messages asking about nested transaction support.
Loads of messages asking for many
Help!
I have a table that multiple processes must be able to
write to concurrently. However, it for some reason
gets locked in exclusive mode. I narrowed it down to
one SQL statement + some weirdness with foreign keys.
To debug this, I opened two psql sessions and typed in
the sql statements manua
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> On Sun, Nov 30, 2003 at 12:19:34AM -0500, Arturo Pérez wrote:
>
>> Does postgreSQL offer anything similar? And please don't
>> say use cron. Cron has issues that I'd like to avoid.
>
> Huh, just curious: what i
Greetings to pgsql-general list members,
I am configuring a server for my hosting company on which I would like to
offer postgres shared hosting as an option. Postgres has been installed
already but I'm having difficulty sequestering server access by shared
accounts and generally could use some he
Oops! [EMAIL PROTECTED] (Bret Busby) was seen spray-painting on a wall:
> In searching on the Internet, I found various references to the book
> "Teach Yourself PostgreSQL In 21 Days", written by Chris Smith,
> published by SAMS, December 2002 (from the Barnes and Noble web site),
> ISBN 0672324830
Is there a convenient way to tell in postgres if a transaction has been
started or not?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Claudio Lapidus") wrote:
> With regard to precision, it is common in certain applications the need to
> handle very small amounts, especially when used as factors of a larger
> calculation. I've even seen once some rates defined in hund
Michael,
The -t option for ecpg DOES work like a charm
THANK YOU!!
I am also posting this to GENERAL, I noticed 2-3 other people who have been
having the same exact problem!
Thanks Again,
Lynn
Quoting Michael Meskes <[EMAIL PROTECTED]>:
> On Sun, Nov 30, 2003 at 11:08:51PM -0700, [EMAIL
Can Postgres JDBC driver encrypt a password before sending and inserting
it into the password column?
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 1:32 PM
To: Oleg Lebedev
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Storing passwor
[sNip]
> Thanks for all the answers.
> It seems if I wish to make my idea into
> reality I will have to invest in the Profesional
> Microsoft Visual C++ studio.
[sNip]
What about OpenWatcom?
Open Watcom - Portable Compilers and Tools
http://www.openwatcom.
You can create MD5 or SHA-1 digests with java.security.MessageDigest.
They would
be stored as text
On Dec 1, 2003, at 4:01 PM, Oleg Lebedev wrote:
Can Postgres JDBC driver encrypt a password before sending and
inserting
it into the password column?
-Original Message-
From: Peter Eise
I would say you're loosing your disk drive. Have you lately checked for
bad blocks?
Jan
吴德文 wrote:
> Help!
>
> A few days ago, my php page began to complain this:
> --
> Warning: PostgresSQL query failed: pqReadData() -- backend closed the
> channel unexpectedly. This probably means the
Title: Re: [GENERAL] pg_hba.conf change in
7.4
Hi Bruce,
I wonder if there is any recommendation to this ?
Is there a way to configure PostgreSQL to not use
IPv6 ?
We are also wonder if there is a version of Ident server
that the PostgreSQL community knows that will work
with IPv6.
Thanks.
Ga
On Thu, 4 Dec 2003 17:56:33 - (GMT), "John Sidney-Woollett"
<[EMAIL PROTECTED]> wrote:
>It would be nice if nested transactions could be (optionally) decoupled
>from their enclosing transaction.
While I see your point how this could be useful for certain use cases,
unfortunately I don't have a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- -- Dr NoName <[EMAIL PROTECTED]> wrote:
> Help!
you may look in the archives; one day ago there was the same question.
Ciao
Alvar
- --
** Alvar C.H. Freude -- http://alvar.a-blast.org/ -- http://odem.org/
** Berufsverbot? http://odem.org
unsubscribe
---(end of broadcast)---
TIP 8: explain analyze is your friend
Tempest in a teapot.
It's just trivia IMO. But, YMMV.
> -Original Message-
> From: John Wells [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 04, 2003 6:51 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Pronouncing PostgreSQL
>
>
> Devrim GUNDUZ said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
- -- "Joe \"Nuke Me Xemu\" Foster" <[EMAIL PROTECTED]> wrote:
> Here's an alternative which may not perform very well but may
> still be better than risking a full table-scan...
I use exactly this method in a forum software, and it performs VERY
On Thursday 04 December 2003 14:55, 吴德文 wrote:
> Help!
>
> A few days ago, my php page began to complain this:
> --
> Warning: PostgresSQL query failed: pqReadData() -- backend closed the
> channel unexpectedly. This probably means the backend terminated abnormally
> before or while processing
Christopher Browne wrote:
But to get the pennies right on a $10,000 USD transaction converted
into GBP (UK Pounds), you need all the official precision that there
is. And if your calculation is off by 4 cents, some of those
accounting folk are liable to thrash you mercilessly over it. If you
get
Alexander S <[EMAIL PROTECTED]> writes:
> Data in mytable doesn t order in alphabetical russian order
It won't order in russian order unless the database was initdb'd with a
russian locale.
> For db in KOI8 encoding - all looks right.
The encoding is irrelevant.
--
greg
Looks bad. Have you got backups. Seriously!
REINDEX works on system indexes but you have to drop to single user mode in
postgres to do it. Check out the -P option in the manpage.
Good luck!
Hope this helps,
On Thu, Dec 04, 2003 at 12:54:07PM -0700, Ed L. wrote:
> I have a server with 20 pgsql c
On Wed, 2003-12-03 at 17:06, Bruce Momjian wrote:
> Tom Lane wrote:
> > "Chris Travers" <[EMAIL PROTECTED]> writes:
> > > Also, I am a little confused by Tom's statement that we don't have the right
> > > to modify the license.
> >
> > I don't see what's confusing about it. Our implicit contract
Alvar Freude wrote:
I want to change this to bytea to avoid base255 encoding and the character
set problems, but there are still some Bugs with bytea and the like
operator. :-(
Be patient, I'm working on it. Apparently you are the first person to
ever really try to *use* the like operator for byt
> Christian Fowler wrote:
>
> So it seems Materialized Path is my only option, however I am
> concerned about LIKE performance for the right hand side of
> the tree, where the path is 8digits x 6 levels = 48 chars.
> Should I be concerned? I need split-second real-time
> performance, and can't
In the program testlibpq.c, these five SQL statements are executed:
res = PQexec(conn, "BEGIN");
res = PQexec(conn, "DECLARE myportal CURSOR FOR select * from pg_database");
res = PQexec(conn, "FETCH ALL in myportal");
res = PQexec(conn, "CLOSE myportal");
r
On Tue, 2 Dec 2003, Randolf Richardson wrote:
> >>In dealing with web applications and frontends to database or
> >>even just a dynamic web site PHP has every bit the power and ability that
> >>Java does and the development time is way down.
> >
> > Uh, how about threads. I know that you don't n
On Thursday 04 December 2003 22:46, Mark Harrison wrote:
> res = PQexec(conn, "BEGIN");
> res = PQexec(conn, "DECLARE myportal CURSOR FOR select * from
> pg_database"); res = PQexec(conn, "FETCH ALL in myportal");
> res = PQexec(conn, "CLOSE myportal");
> res = PQexec(conn,
Graham Leggett wrote:
Christopher Browne wrote:
But to get the pennies right on a $10,000 USD transaction converted
into GBP (UK Pounds), you need all the official precision that there
is. And if your calculation is off by 4 cents, some of those
accounting folk are liable to thrash you merciless
Richard Huxton wrote:
On Thursday 04 December 2003 22:46, Mark Harrison wrote:
res = PQexec(conn, "BEGIN");
res = PQexec(conn, "DECLARE myportal CURSOR FOR select * from
pg_database"); res = PQexec(conn, "FETCH ALL in myportal");
res = PQexec(conn, "CLOSE myportal");
32 matches
Mail list logo
