How should one escape regular expressions in plperl?
In the following chunk of PlPerl code the date doesn't match the regex:
my $endby = '2009-06-13';
my $t = spi_exec_query(qq|SELECT CASE WHEN '$endby' ~ E'.*\\d\\d\\d\\d
\\-\\d\\d?\\-\\d\\d?.*'
THEN '$endby'::timestamptz ELSE
I can't find it anywhere and we are *compiling* binary, so I can't compile
it without downloading the source...
I mean we are installing binary
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Does anyone have citext.so compiled for postgresql 8.2.* 64 bit?
I can't find it anywhere and we are compiling binary, so I can't compile
it without downloading the source...
Thank you
Sim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Thursday 11 June 2009 21:48:22 Dave Page wrote:
Can you embed the files on the PUGs page like JD suggests? What I want
to avoid is an ad-hoc website springing up on media.postgresql.org
that ends up in Google and being linked from who-knows-where.
While there is a point to that, having the
Toomas Vendelin p...@vendelin.com writes:
In the following chunk of PlPerl code the date doesn't match the regex:
my $endby = '2009-06-13';
my $t = spi_exec_query(qq|SELECT CASE WHEN '$endby' ~ E'.*\\d\\d\\d\\d
\\-\\d\\d?\\-\\d\\d?.*'
THEN '$endby'::timestamptz ELSE
Hi, all.
i have two tables (teste1 and teste2).
i was inserting one million rows on each by a script PHP.
In another process, i have created a view (ct1t2) to count rows on the
tables and started it
then i killed the script (killing the apache server) and in another process
i've executed the
sergio nogueira sergiop...@gmail.com writes:
then i kill the process executing the truncate.
the result:
LOG: server process (PID 3421) was terminated by signal 9:
Killed
Any idea on how to prevent this?
Don't do that. kill -9 is *never* the recommended way to terminate a
query. Next
Hey,
I'm new to using transactions. I'd like to integrate them into my PHP
application to prevent a few issues we've been having. Such as, some
queries in the beginning of the php script running, then an error
occurring, preventing queries toward the bottom of the script from
running. It's
Merlin Moncure wrote:
postgresql 8.1 supports pitr archiving. you can
do continuous backups and restore the database to just before the bad
data.
I tried using point-in-time-recovery to restore the state of the
database immediately before the corruption. It didn't work, but it
was quite a
This may not be the right place for this question but I am going to
start here anyway.
I have installed postgresql in cygwin on a MS-WinXPpro system. I
wish to initialise a database instance. However, I cannot find any
program file called initdb. In /usr/bin I can see files like:
James B. Byrne byrn...@harte-lyne.ca writes:
I have installed postgresql in cygwin on a MS-WinXPpro system. I
wish to initialise a database instance. However, I cannot find any
program file called initdb. In /usr/bin I can see files like:
pg_config.exe, pg_dump.exe and pg_dumpall.exe but
On Sun, June 14, 2009 13:34, Tom Lane wrote:
That sounds suspiciously like a client-only installation. What
package did you install exactly? Was there a -server package
beside it?
The packages that cygwin says I have installed are:
8.2.11-1 postgresql: PostgreSQL Data Base Management
James B. Byrne byrn...@harte-lyne.ca writes:
The packages that cygwin says I have installed are:
8.2.11-1 postgresql: PostgreSQL Data Base Management System 3,707k
8.2.11-1 postgresql-client: Front-end programs for PostgreSQL 8.x 972k
8.2.11-1 postgresql-contrib ... 373k
8.2.11-1
On Sun, Jun 14, 2009 at 11:30 AM, James B. Byrnebyrn...@harte-lyne.ca wrote:
This may not be the right place for this question but I am going to
start here anyway.
I have installed postgresql in cygwin on a MS-WinXPpro system. I
wish to initialise a database instance. However, I cannot
On Sun, June 14, 2009 15:45, Scott Marlowe wrote:
why it would not form part of the cygwin
installation?
Is there a reason you're not using the native windows postgresql
packages?
Because for some reason, processes running in the cygwin environment
could not create databases in the
Found it. The cygwin executables for postgres are installed under
/usr/sbin, which is NOT in the PATH thus the problem, and the
obvious solution.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrnemailto:byrn...@harte-lyne.ca
Harte Lyne Limited
I ahve the following python file that I am running as an external method
in Zope.
def backup():
import os
os.popen(c:/scholarpack/postgres/bin/pg_dump scholarpack
c:/scholarpack/ancillary/scholarpack.sql)
data=open('c:/scholarpack/ancillary/scholarpack.sql','r')
r=data.read()
On Sun, Jun 14, 2009 at 4:06 PM, Garry Saddington
ga...@schoolteachers.co.uk wrote:
I ahve the following python file that I am running as an external method in
Zope.
def backup():
import os
os.popen(c:/scholarpack/postgres/bin/pg_dump scholarpack
Scott Mead wrote:
On Sun, Jun 14, 2009 at 4:06 PM, Garry Saddington
ga...@schoolteachers.co.uk mailto:ga...@schoolteachers.co.uk wrote:
I ahve the following python file that I am running as an external
method in Zope.
def backup():
import os
Garry Saddington ga...@schoolteachers.co.uk writes:
import os
os.popen(c:/scholarpack/postgres/bin/pg_dump scholarpack
c:/scholarpack/ancillary/scholarpack.sql)
scholarpack but no OS user scholarpack, but why should it create a file
then not fill the contents?
Because that's exactly
Hey,
I'm new to using transactions. I'd like to integrate them into my PHP
application to prevent a few issues we've been having. Such as, some
queries in the beginning of the php script running, then an error
occurring, preventing queries toward the bottom of the script from
running. It's
On Sun, 2009-06-14 at 11:14 -0400, APseudoUtopia wrote:
associated forum posts. From what I've read on transactions, they
would be the solution to my problems.
Yes, but proper use of transactions - and a proper understanding of
transactions - will help you a lot more than that.
I very, very
On Sun, 2009-06-14 at 10:32 -0400, Gus Gutoski wrote:
0. Shortly after the corruption on June 9, 2009, I shut down the
server and backed up the entire data directory. The recovery
procedure described herein begins with this file system backup.
1. The most recent non-corrupted snapshot of the
citext is not a new contrib module, I have been using it since 7.4
I believe it is being built into core in 8.4.
I have it compiled on 32 bit 8.2, and 64 bit 8.1 and 8.3
My 8.3 compilation says it is incompatible and the 8.1 compilation says
that it is missing the magic block. It is compiled with
24 matches
Mail list logo
