On Thu, Dec 20, 2007 at 11:48:08PM -0800, ivan.hou wrote:
how to update the pg version 8.1.3 to 8.1.10? should i backup and drop my
database , or delete the /usr/local/pgsql directory?
Just install it. Upgrades involving only the third number (the minor
revision) don't require any changes to
how to update the pg version 8.1.3 to 8.1.10? should i backup and drop my
database , or delete the /usr/local/pgsql directory?
--
View this message in context:
http://www.nabble.com/update-pg-question--tp14451672p14451672.html
Sent from the PostgreSQL - general mailing list archive at
Scott Marlowe wrote:
As a secondary question, is there any way I could have answered this
myself, using analyze, the system catalogs, etc? ANALYZE DELETE
doesn't seem to show the FK checking that must go on behind the
scenes.
You could have coded up an example to see if it worked I guess.
John Burger [EMAIL PROTECTED] writes:
Scott Marlowe wrote:
As a secondary question, is there any way I could have answered this
myself, using analyze, the system catalogs, etc? ANALYZE DELETE
doesn't seem to show the FK checking that must go on behind the scenes.
You could have coded up
On Nov 29, 2007 10:51 AM, John Burger [EMAIL PROTECTED] wrote:
Hi -
I know that the foreign key machinery will use an index on the
referring column if one exists. My question is whether it will use a
composite index? For instance:
create table allLemmaSenseMap (
wordID integer
Hi -
I know that the foreign key machinery will use an index on the
referring column if one exists. My question is whether it will use a
composite index? For instance:
create table allLemmaSenseMap (
wordID integer references allLemmas,
senseIDinteger references allSenses,
I'm going to move from v7.4.13 to v8.2.0 (suse-64). I have 2
pre-existing DBs. Do I need to convert or port them to v8 in any way
after I start up with a v8 postmaster?
Thanks
-dave
On Monday 01 October 2007, Gauthier, Dave [EMAIL PROTECTED] wrote:
I'm going to move from v7.4.13 to v8.2.0 (suse-64). I have 2
pre-existing DBs. Do I need to convert or port them to v8 in any way
after I start up with a v8 postmaster?
All major version upgrades require a dump and reload.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gauthier, Dave wrote:
I'm going to move from v7.4.13 to v8.2.0 (suse-64). I have 2
pre-existing DBs. Do I need to convert or port them to v8 in any way
after I start up with a v8 postmaster?
1. v8.2.0 is a mistake, make sure you are running
On Oct 1, 2007, at 12:26 PM, Gauthier, Dave wrote:
I’m going to move from v7.4.13 to v8.2.0 (suse-64). I have 2 pre-
existing DBs. Do I need to “convert” or port them to v8 in any way
after I start up with a v8 postmaster?
Thanks
Moving between major release versions requires that you
Hi all,
I'm sure some of you guys do perl-dbi to access perl. need some
pointers. (pg specific I guess)
1. Possible to execute queries to PG using multiple statemments?
eg:
prepare(A)
bind_param($A)
execute()
prepare(BB)
bind_param($B)
execute()
prepare(CC)
bind_param($B)
execute()
right now,
On Aug 30, 2007, at 4:03 AM, Ow Mun Heng wrote:
2. how do I perform a list of SQL using transactions. eg: like above,
but wrap it into a transaction.
assuming $dbh is your open handle to the database via DBI, then you
do something like this:
$dbh-begin_work() or die;
$sth =
documentation.
Susan Cassidy
Ow Mun Heng [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/30/2007 01:07 AM
To
pgsql-general@postgresql.org
cc
Subject
[GENERAL] accessing PG using Perl:DBI
Hi all,
I'm sure some of you guys do perl-dbi to access perl. need some
pointers. (pg specific I guess)
1
Sic Transit Gloria Mundi writes:
I would like to use Perl, DBI, and DBD::Pg on AIX. As I
understand it, I need a shared lib version of the client libs
for this.
When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it
seems only the static libraries are built. This seems true
with
I would like to use Perl, DBI, and DBD::Pg on AIX. As I understand it, I need
a shared lib version of the client libs for this.
When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it seems only the static
libraries are built. This seems true with either xlc (8.x) or gcc (3.3.2).
Sic Transit Gloria Mundi [EMAIL PROTECTED] writes:
I would like to use Perl, DBI, and DBD::Pg on AIX. As I understand it, I
need a shared lib version of the client libs for this.
When building on AIX5.3 ML04 (powerpc_power5, 64 bit), it seems only the
static libraries are built. This
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's
plenty of SYSV memory available.
The call to
Kevin Murphy [EMAIL PROTECTED] writes:
Tom Lane wrote:
Hmm ... not sure if this is related, but there's something mighty fishy
about that key parameter. I'd expect to see key=5432001, or something
close to that depending on what port number you're using.
But is this the case when doing
Tom Lane wrote:
Kevin Murphy [EMAIL PROTECTED] writes:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's?
creating template1 database in /usr/local/src/postgresql-8.2.3/src/
test/regress/./tmp_check/data/base/1 ... FATAL: \
could not create
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of SYSV
memory available.
I compiled using:
./configure --without-readline
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's plenty
of SYSV memory available.
The call to
Kevin Murphy wrote:
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's plenty
of SYSV memory
A.M. wrote:
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of
SYSV memory available.
The
Kevin Murphy [EMAIL PROTECTED] writes:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of SYSV
memory available.
creating template1
Neal Clark wrote:
my $sth = $dbh-prepare(qq{SOME_QUERY});
$sth-execute;
while (my $href = $sth-fetchrow_hashref) {
# do stuff
}
[...]
So with mysql, I can just say $dbh-{'mysql-use-result'} = 1, and
then it switches so that the fetchrow_hashref calls are actually
fetching
Albe Laurenz [EMAIL PROTECTED] writes:
So there is no automatic way of handling it.
You will probably have to consider it in your code and use
SELECT-Statements
with a LIMIT clause.
Either that, or explicitly DECLARE a CURSOR and use FETCH from that
cursor in batches. You can do this in
On Mon, Mar 12, 2007 at 08:38:52AM -0400, Douglas McNaught wrote:
You are restricted to staying in a transaction while the cursor is
open, so if you want to work outside of transactions LIMIT/OFFSET
is your only way.
http://www.postgresql.org/docs/8.2/interactive/sql-declare.html
If WITH HOLD
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks for all the replies everyone. Not really knowing what a cursor
is, I suppose I have some work to do. I can do the SELECT/LIMIT/
OFFSET approach but that seems like kind of a headache, esp. when its
hard to predict what # of rows will max
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Okay, I don't have any postgresql tables big enough to verify this is
doing what I think it is (namely, only keeping one row from my result
set in memory at a time), and I still don't really know much about
cursors or pg, but this appears to be
Neal Clark [EMAIL PROTECTED] writes:
comments?
Looks like the right idea. If you have a lot of rows to process,
you'll benefit by fetching in batches, e.g.
my $sth = $dbh-prepare(qq{FETCH FORWARD 1000 FROM my_cur});
# iterate through the result set here
-Doug
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi.
I am in the middle of moving a product from MySQL to Postgre. One of
the tables is relatively big, with 100M+ rows and growing, each of
which has a column that usually contains between 1-500k of data (the
'MYD' file it is currently 94G).
Hi,
I have a user who is getting this error on a 8.1.3 server when importing
some data from a dbf file:
PostgreSQL Error Code: (1)
ERROR: date/time field value out of range: 08-01-2006
He says the db is SQL-ASCII and the datestyle is at the default.
Of course on all my test servers the
Tony Caduto [EMAIL PROTECTED] writes:
I have a user who is getting this error on a 8.1.3 server when importing
some data from a dbf file:
ERROR: date/time field value out of range: 08-01-2006
He needs to set DateStyle to match the expected field order.
regression=# show datestyle;
On Wed, 2006-12-13 at 10:37 -0600, Tony Caduto wrote:
Hi,
I have a user who is getting this error on a 8.1.3 server when importing
some data from a dbf file:
PostgreSQL Error Code: (1)
ERROR: date/time field value out of range: 08-01-2006
He says the db is SQL-ASCII and the datestyle
Tom Lane wrote:
He needs to set DateStyle to match the expected field order.
regression=# show datestyle;
DateStyle
---
ISO, MDY
(1 row)
regression=# select '08-01-2006'::date;
date
2006-08-01
(1 row)
regression=# set datestyle TO ymd;
SET
regression=# select
Which stemmer files is one supposed to use with 8.2 Tsearch2?
Trying to compile the output from Gendict with:
stem_UTF_8_german.c
stem_UTF_8_german.h
from:
http://snowball.tartarus.org/dist/libstemmer_c.tgz
gives:
http://hannes.imos.net/make.txt
Thanks!
--
Regards,
Hannes Dorbath
On 07.12.2006 12:42, Hannes Dorbath wrote:
Which stemmer files is one supposed to use with 8.2 Tsearch2?
Found an answer myself. Seems I need:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch_snowball_82.gz
--
Regards,
Hannes Dorbath
---(end of
Hannes,
please download patch tsearch_snowball_82.gz
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
which updates API to snowball.
Oleg
On Thu, 7 Dec 2006, Hannes Dorbath wrote:
Which stemmer files is one supposed to use with 8.2 Tsearch2?
Trying to compile the output from Gendict
Thank you Oleg.
I have a bit more trouble migrating from 8.1.5 TSearch2 + Gin/UTF-8 to
PG 8.2.
First I tried to use existing dict and affix files, which triggered that
oldFormat condition. So I tried to start from scratch. The thing I can't
get to work is compound word support for German
I'm currently using version 1.9.0 of the old Pg interface with
PostgreSQL 8.0.3. Our code needs to be updated to use DBI/DBD::Pg,
but we need to upgrade PostgreSQL before this is going to happen.
Does anyone know of any issues with continuing to use the old Pg
interface with newer versions of
On Oct 16, 2006, at 1:15 PM, Brandon Metcalf wrote:
Does anyone know of any issues with continuing to use the old Pg
interface with newer versions of PostgreSQL?
it is just a rather thin glue layer on top of the libpq interface, so
it should continue to work just as any libpq app would
On Mon, Oct 16, 2006 at 12:15:36PM -0500, Brandon Metcalf wrote:
I'm currently using version 1.9.0 of the old Pg interface with
PostgreSQL 8.0.3. Our code needs to be updated to use DBI/DBD::Pg,
but we need to upgrade PostgreSQL before this is going to happen.
Does anyone know of any issues
I added some compatibility functions and it worked with new PostgreSQL.
Let me know if you need it
Oleg
On Mon, 16 Oct 2006, Brandon Metcalf wrote:
I'm currently using version 1.9.0 of the old Pg interface with
PostgreSQL 8.0.3. Our code needs to be updated to use DBI/DBD::Pg,
but we need to
On Mon, 16 Oct 2006, Oleg Bartunov wrote:
I added some compatibility functions and it worked with new PostgreSQL.
Sorry, I got confused :) I added them to wdb interface
Let me know if you need it
Oleg
On Mon, 16 Oct 2006, Brandon Metcalf wrote:
I'm currently using version 1.9.0 of the old
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.49 of DBD::Pg has been released. This version adds support
for the ParamTypes statment handle attribute, and fixes a small bug in
ParamValues. It strips the final newline (as it did before) from error
messages, so that Perl's die will
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.48 of DBD::Pg has been released. This is mostly
a bug fix version. Another bytea problem was fixed, as well
as an obscure corner case with begin_work() after an error.
The minimum version required for DBI has been raised to 1.45.
CPAN
Martijn van Oosterhout wrote:
Comments inline.
On Wed, Feb 15, 2006 at 09:49:57AM -0500, Tom Lane wrote:
I think defining the problem as let's get rid of australian_timezones
would be a serious mistake. The basic problem here is that we can't
have a one-size-fits-all list of timezone
If someone can make a ppm I would appreciate it. I have VS 2005 not 2003.
Mike
On Thu, Feb 23, 2006 at 02:11:55AM -, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am pleased to announce that version 1.44 of DBD::Pg has
been released. You can find it on
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 15, 2006 5:39 PM
To: [EMAIL PROTECTED]
Cc: 'PostgreSQL pg-general List'
Subject: Re: [GENERAL] Does PG really lack a time zone for India?
Ken Winter [EMAIL PROTECTED] writes:
Yes, that's what
On Wed, Feb 15, 2006 at 12:33:30AM -0500, Tom Lane wrote:
The existence of duplicate timezone abbreviations is certainly a pain
:-(. The solution I would like to see is to factor all the hardwired
timezone abbreviations in datetktbl out into a configuration file that
could be adjusted for
Martijn van Oosterhout kleptog@svana.org writes:
I really wish we could clear up this stuff with the australian
timezones. I'd love a poll as to how often they're used because I don't
think most people want them.
I think defining the problem as let's get rid of australian_timezones
would be a
: Wednesday, February 15, 2006 12:34 AM
To: [EMAIL PROTECTED]
Cc: 'PostgreSQL pg-general List'
Subject: Re: [GENERAL] Does PG really lack a time zone for India?
Ken Winter [EMAIL PROTECTED] writes:
The documentation
(http://www.postgresql.org/docs/7.4/static/datetime-keywords.html) =
doesn't
Ken Winter [EMAIL PROTECTED] writes:
Briefly, what I'm trying to do is build a (web-front-ended) system that
translates a now() entry into a timestamptz column into now at a
specified time zone (which is looked up from the database).
Why? Say there's a payment deadline recorded in a
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 15, 2006 10:25 AM
To: [EMAIL PROTECTED]
Cc: 'PostgreSQL pg-general List'
Subject: Re: [GENERAL] Does PG really lack a time zone for India?
Ken Winter [EMAIL PROTECTED] writes:
Briefly, what I'm
Ken Winter [EMAIL PROTECTED] writes:
Yes, that's what I'm trying to do. My problem has been: how to enter the
equivalent of '2006-02-15 10:22:46-05' when the time I want to enter and
convert to EST is a variable value or now().
This still shows a problem in your grasp of what's going on.
The documentation (http://www.postgresql.org/docs/7.4/static/datetime-keywords.html)
doesnt have an entry for Indian Standard Time, nor for any other time
zone with a GMT+5:30 offset.
Is this just an omission from the documentation? If
so, what are the name and codes of the GMT+5:30
Ken Winter [EMAIL PROTECTED] writes:
The documentation
(http://www.postgresql.org/docs/7.4/static/datetime-keywords.html) =
doesn't
have an entry for Indian Standard Time, nor for any other time zone with =
a
GMT+5:30 offset.
I don't see any such entry in datetktbl in datetime.c, either.
On 1/1/06, Tony Caduto [EMAIL PROTECTED] wrote:
Hi,
Does anyone know of a good resource on how to use Postgresql as a
destination for Syslogd messages?
I am interested in putting all postfix logs to a table rather than a file.
I set this up by using syslog-ng, djb's supervise and psql. I
Hi,
Does anyone know of a good resource on how to use Postgresql as a
destination for Syslogd messages?
I am interested in putting all postfix logs to a table rather than a file.
Thanks in advance,
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
Is there any truth to what this guy is saying?
Yes, some. But not much.
On the other hand, Postgresql claims that Windows
does not support
Unicode and you can't have Unicode fields on
postgresql on Windows.
This is a big mistake. See:
Is there any truth to what this guy is saying?
On the other hand, Postgresql claims that Windows
does not support
Unicode and you can't have Unicode fields on
postgresql on Windows.
This is a big mistake. See:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
What do
On Nov 17, 2005, at 10:12 , CSN wrote:
Is there any truth to what this guy is saying?
[cut hard-to-read quotes regarding support for UTF8 in PostgreSQL on
Windows]
According to the release notes for 8.1:
http://www.postgresql.org/docs/8.1/interactive/release.html#RELEASE-8-1
*
The Nice Spider wrote:
Which version of PG support updatable view?
You have to use rules to make views updatable, and all PG vesions
support those.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is
Which version of PG support updatable
view?
Yahoo! FareChase - Search multiple travel sites in one click.
am 13.11.2005, um 17:04:37 -0800 mailte The Nice Spider folgendes:
Which version of PG support updatable view?
None. Updateable views are a 'TODO'.
http://www.postgresql.org/docs/faqs.TODO.html
You can use Rules instead:
http://www.varlena.com/varlena/GeneralBits/111.php, Issue 82-4
HTH,
On Sun, Sep 11, 2005 at 06:36:26PM +0100, mike dixon wrote:
Tried a couple other places and aren't getting anywhere.
A windows xp program I use uses pgsql; I'd like to create a backup of the db
but from within linux without xp running (I run xp in vmware; and the xp db
backup will be
Tried a couple other places and aren't getting anywhere.
A windows xp program I use uses pgsql; I'd like to create a backup of the db
but from within linux without xp running (I run xp in vmware; and the xp db
backup will be written to an ext* partition). I have the same rev pgsql
installed
THX for Help, but it seems that there is no way get it fixed ...
So long ...
Christian
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Hi!
I've the following Problem and hope someone can help me. My PostgreSQL
Database were running on a Debian Linux. Some day the OS crahsed and -
here's the Problem - there is no dump file from Database. But I still
have the files in base, global, pg_clog. So I did a fresh setup and
copied the
On Thu, Aug 25, 2005 at 08:56:40AM -0700, [EMAIL PROTECTED] wrote:
Hi!
I've the following Problem and hope someone can help me. My PostgreSQL
Database were running on a Debian Linux. Some day the OS crahsed and -
here's the Problem - there is no dump file from Database. But I still
have the
[EMAIL PROTECTED] writes:
Starting PostgreSQL database server: postmaster(FAILED)
ERROR: There is no PostgreSQL database framework in /srv/postgres/data.
Run initdb as the postgres user to create it
There is no such error string in Postgres proper -- I suppose the
complaint is coming from
I have a simple query:
select true,78,'Here is a value' as stringfield, testname from tbltest;
it returns:
true as bool
78 as int4
and the string 'Here is a value' as Unknown
Why is it that all the values besides the string come back with the
correct type?
what is a simple string being
Tony Caduto wrote:
I have a simple query:
select true,78,'Here is a value' as stringfield, testname from tbltest;
it returns:
true as bool
78 as int4
and the string 'Here is a value' as Unknown
Why is it that all the values besides the string come back with the
correct type?
what is a simple
Hi,
I don't think I was clear enough.
I know about using the AS keyword, that is not the problem.
The query in issue is:
select true,78,'Here is a value' as stringfield, testname from tbltest
Is returning the string as TYPE Unknown, not the column name. The
column name comes back as
On Mon, Aug 08, 2005 at 03:05:13PM -0500, Tony Caduto wrote:
Hi,
I don't think I was clear enough.
I know about using the AS keyword, that is not the problem.
The query in issue is:
select true,78,'Here is a value' as stringfield, testname from tbltest
Is returning the string as TYPE
I always thought that single qoutes in a sql statement meant a
string/varchar/text.
Thanks for the info on this.
Single quotes denote an untyped constant, not a string.
Hope this helps,
---(end of broadcast)---
TIP 2: Don't 'kill -9' the
AM Software Design is proud to announce the 1.0
stable release of PG Lightning Admin for PostgreSQL 8.x.
PG Lightning Admin is a Windows GUI (graphical user interface)
administration program which will run on Windows 95,98, ME,NT 4SP6, 2000
and XP.
A full 30 day demo may be downloaded from:
On Jun 22, 2005, at 2:07 PM, Tony Caduto wrote:
AM Software Design is proud to announce the 1.0
stable release of PG Lightning Admin for PostgreSQL 8.x.
Shouldn't this be on pgsql-announce instead? According to its
description, pgsql-announce is an Announcement list pertaining to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Joshua,
you're right. But it's no problem for me, if I change the concept.
Thanks a lot.
Kay-Uwe Genz
-BEGIN PGP SIGNATURE-
Version: PGP 8.0.3 - not licensed for commercial use: www.pgp.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I hope that you are well. Is anybody maintaining a Windows package for
the DBD::Pg driver for ActiveState Perl ? I don't have VC++ and bcc32
isn't going to compile based on the instructions for Win32.
There is an unofficial version you can try
Hello Folks,
I hope that you are well. Is anybody maintaining a Windows package for
the DBD::Pg driver for ActiveState Perl ? I don't have VC++ and bcc32
isn't going to compile based on the instructions for Win32.
If someone has some binaries around and is will to share, I would be
very
My PG running with OpenSSL and I have no problems connecting from my
laptop (running the client) to my desktop (running the server) over
ethernet. But I wish, that PG use certificated connections. I've create
certificates for every user (all user are in pg_hba.conf with hostssl),
but I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi @ all,
I'm need a little bit help on OpenSSL in combination with PG 8.0.2
under Mac OS X, but I think that is the same thing like under BSD or
Linux.
My PG running with OpenSSL and I have no problems connecting from my
laptop (running the
Check it out here:
http://www.amsoftwaredesign.com/
This release adds built in SSH tunnel support right from the server
registration dialog along with the ability to
execute a database dump from the GUI.(restore coming soon).
This release also properly exports text fields with CRLF in them
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Version 1.41 of DBD::Pg, the PostgreSQL database driver for the DBI
module, has been released. This version is primarily a bug fix for
1.40: if you are using that version (or less), you are highly
encouraged to upgrade. COPY support has been
Subject says it all...I've got to do this soon, and since I would
like PG to take over this company like a VIRUS, I'd like this rollout
to go *very* well.
Any comments, caveats, encomiums, exhortations, anecdotes, war stories,
gentle assurances and pointers of all sorts most welcome.
- Ross
At the suggestion of several
people, I have increased the
default settings in postgresql.conf
before continuing my
postgresql vs mysql
performance tests.
To date, I have only been
loading a (roughly) million-row
file, creating indexes
during the load, running a vacuum analyze,
and a
Scott Marlowe wrote:
Method 2 often provides all the protection you need and is quite easy to
program. You basically do something like:
To use this to prevent simultaneous inserts of the same data (for
example if two employees try to insert the same contact into the DB), I
suppose you could use
To use this to prevent simultaneous inserts of the same data (for
example if two employees try to insert the same contact into the DB), I
suppose you could use a constraint (before insert) that checks that
there is no data matching the md5 checksum, right?
CREATE TABLE blah
(
mymd5
I have a question about whether or not I need to do locking to a pg
table being accessed from a php application.
Let's say two users select rows from the table and display them in
their browser. User A clicks on row 1 to edit it. Since this is php,
so far it just selects the current values from
Rick Schumeyer wrote:
I have a question about whether or not I need to do locking to a pg
table being accessed from a php application.
Let's say two users select rows from the table and display them in
their browser. User A clicks on row 1 to edit it. Since this is php,
so far it just selects
Rick Schumeyer [EMAIL PROTECTED] writes:
In the meantime, when User B looks at his web page, there will still
be an 'edit' link for row 1. I'm pretty sure that I don't want User B
to try to edit the row, but as far as I understand the default postgres
locking will not prevent this. When user
On Wed, 2005-02-02 at 10:07, Rick Schumeyer wrote:
I have a question about whether or not I need to do locking to a pg
table being accessed from a php application.
Let's say two users select rows from the table and display them in
their browser. User A clicks on row 1 to edit it. Since
On Tue, 18 Jan 2005 10:38:24 -0800, Chris wrote:
The DBD::Pg man page say's this about cursors. What I don't
understand is the nested selects being in a different transactions.
Can someone clarify for me what is being said here? Does this
basically mean that I can use cursors in DBD::Pg, I
I'm using DBD::Pg under mod perl, and I'm trying to find a way to
workaround the fact that DBD::Pg fetches all the data at once in a
query and sticks it into memory before you execute a fetch. Right now
I'm having to kill the apache child after it's finished running in
certain cases, and I'd
g == greg [EMAIL PROTECTED] writes:
g A new version of DBD::Pg is about to be released (1.32), and we need
g your help to test it out. If you use DBD::Pg, please download
g and test the latest release candidate. At the very least, running
Has my recent bug report on rt.cpan.org been addressed?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Has my recent bug report on rt.cpan.org been addressed? I never got
any ack that it was. See
I tried but could not duplicate that bug when it first came out. I
don't know if others have tried it out or not, but if you could test
with 1.32_2
: [GENERAL] DBD::Pg problem
pg_atoi is the string to int converter. You're trying to insert it into
an integer field.
On Wed, Dec 03, 2003 at 03:45:53PM +0900, Ausrack Webmaster wrote:
Hi
I am trying to insert a simple email address into a text field,
and I get the below error:
DBD::Pg::st
Ausrack Webmaster wrote:
The thing is...I am not. I am inserting it into a varchar field.
Are there any single quotes in the message body? They will wreak havoc
with the rest of the query. And why are you putting single quotes around
'$parent'?
What happens if you move the '$body' to the end:
]
Subject: Re: [GENERAL] DBD::Pg problem
Ausrack Webmaster wrote:
The thing is...I am not. I am inserting it into a varchar field.
Are there any single quotes in the message body? They will wreak havoc
with the rest of the query. And why are you putting single quotes around
'$parent'?
What
301 - 400 of 436 matches
Mail list logo