On Tue, Sep 15, 2009 at 03:55, Vikram Patil vpa...@actuate.com wrote:
Thanks Magnus for help.
Is there any way to start pg_ctl without creating postgres user? I am trying
to use same logged in user to run initdb and start service. As per
documentation it seems to be allowed after 8.3. We
Hello!
I need PG 8.4 built from source code for WinXP. So I got archive
postgresql-8.4.1.tar.gz, unpacked it and built postgres by MinGW, as usual:
configure --witout-zlib
make
make install
Everything seeds to be fine until we tried to test pg_dump. It failed (not
always but often).
Command:
2009/9/15 el dorado do_ra...@mail.ru:
Hello!
I need PG 8.4 built from source code for WinXP. So I got archive
postgresql-8.4.1.tar.gz, unpacked it and built postgres by MinGW, as usual:
configure --witout-zlib
make
make install
Everything seeds to be fine until we tried to test pg_dump.
On 2009-09-09, 纪晓曦 sheep...@gmail.com wrote:
--001636834258521c91047319fd34
Content-Type: text/plain; charset=ISO-8859-1
Can I save images in the postgres?
yes.
How to define?
a bytea column it probably a good start
Does the format matters?
not to postgres.
base64 or hex encoding and
On 2009-09-09, John R Pierce pie...@hogranch.com wrote:
纪晓曦 wrote:
Can I save images in the postgres? How to define? Does the format
matters? Can I save JPG/PNG?How?
you can save images as BYTEA data, and the format is totally up to your
application, as postgres just treats it as a block
On Tue, Sep 15, 2009 at 03:55, Vikram Patil vpa...@actuate.com wrote:
Thanks Magnus for help.
Is there any way to start pg_ctl without creating postgres user? I am
trying to use same logged in user to run initdb and start service. As per
documentation it seems to be allowed after 8.3. We
Hello all..
I'm using PostgreSQL 8.3..
How can I get information about the hardware utilization:
- CPU usage.
- Disk space.
- Memory allocation.
thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi:
How could I define a constraint on a colum who's value I want to restrict to a
static list of strings? For example, a column colled gender which cannot be
NULL and must be either 'M' or 'F'. I can do it with a check constraint, but
I can't defer those constraints (the reason I'm asking
On Tue, Sep 15, 2009 at 08:01:19AM -0700, Gauthier, Dave wrote:
How could I define a constraint on a colum who's value I want to
restrict to a static list of strings? For example, a column colled
gender which cannot be NULL and must be either 'M' or 'F'. I can do
it with a check constraint,
CHECK( foo IN ('bar1', 'bar2'));
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Sep 15, 2009 at 08:01:19AM -0700, Gauthier, Dave wrote:
Hi:
How could I define a constraint on a colum who's value I want to
restrict to a static list of strings? For example, a column colled
gender which cannot be NULL and must be either 'M' or 'F'. I can
do it with a check
On Mon, Sep 14, 2009 at 7:13 PM, David Kerr d...@mr-paradox.net wrote:
My oracle experience tells me that I want to go with 64 bit postgres
so that i can have faster disk and memory access.
If not faster memory access, but you can get more memory in a 64-bit
address space. My primary DB
How can I alter domain, to allow it to be null ?
I can set it to be NOT NULL, but there's now way to achieve the opposite effect.
At least I can't find a way. Any ideas please ? (8.3+)
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
nvm. I figured it out seconds after sending that email (despite
spending 10 mins on it prior to).
for the record:
alter DOMAIN xxx DROP NOT NULL ;
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
So its not possible thats our parser.
And
Second:string:Not really: thats the orignal string, and its a string:
Look again. Where is the null character in the original string? Why does
your encoded string end with \0? In what character set is null a legal
character?
Your encoder is
Yes, you'r correct with the \0 at the end. The problem is that the
rtf-object returns wrong terminated string. i can fix the problem with a
trim.
but look here:
X=# UPDATE art SET ak_auftxt= '*', ak_auftxt_rtf=
'{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset0
nm...@netcourrier.com (Saleem EDAH-TALLY) writes:
OK guys, I would never have thought about modifying libpq to steal
confidential
data, and I have never used debuggers in this respect at all.
So super gurus can yet do the bad thing.
Since this thread was published, anyone capable of
On Mon, Sep 14, 2009 at 07:39:47PM +0200, Saleem EDAH-TALLY wrote:
OK guys, I would never have thought about modifying libpq to steal
confidential data, and I have never used debuggers in this respect
at all.
So super gurus can yet do the bad thing.
It doesn't take any kind of guru to use
std pik wrote:
Hello all..
I'm using PostgreSQL 8.3..
How can I get information about the hardware utilization:
- CPU usage.
- Disk space.
- Memory allocation.
what operating system are you on? If its Linux or some flavor of Unix,
I'd use a combination of ps(1),
On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce pie...@hogranch.com wrote:
std pik wrote:
Hello all..
I'm using PostgreSQL 8.3..
How can I get information about the hardware utilization:
- CPU usage.
- Disk space.
- Memory allocation.
what operating system are you on?
Best Regards,
Ed Koch
Principal
Addison Search
212-378-1634
1350 Broadway NY,NY suite 810, 10018
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate,
On Tue, Sep 15, 2009 at 2:10 PM, dennis jenkins
dennis.jenkins...@gmail.com wrote:
On Tue, Sep 15, 2009 at 3:03 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce pie...@hogranch.com wrote:
std pik wrote:
Hello all..
I'm using PostgreSQL 8.3..
On Tue, Sep 15, 2009 at 3:03 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce pie...@hogranch.com wrote:
std pik wrote:
Hello all..
I'm using PostgreSQL 8.3..
How can I get information about the hardware utilization:
- CPU usage.
-
Probably best posted on the jobs list:
http://archives.postgresql.org/pgsql-jobs/
--
Postgresql php tutorials
http://www.designmagick.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you can pay
any of your bills
keep in mind that a studio *starts* at 2500/month this doesnt include parking
which is ANOTHER 250-500/month ..taxis are a min of 20$ to go 1 block..meals
are a min of 50$/per
you could actually be
On Sep 15, 2009, at 20:48 , Martin Gainty wrote:
NYC/NYstate/Federal income taxes gobble up 1/2 your check BEFORE you
can pay any of your bills
keep in mind that a studio *starts* at 2500/month this doesnt
include parking which is ANOTHER 250-500/month ..taxis are a min of
20$ to go 1
how many PBJ did you make before arriving there?
any restaurant in NYC but mickey D's does COST that much
this is decidedly O/T so lets take this discussion offline
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist
anyone on the PG team privvy to Sun Solaris patches for postgres? like
patch 138826-04 is Postgres 8.3.7 for Solaris10 Sparc... 138827-04 is
the same for Sol10 x86...
I'm curious if anyone has a clue how long before Sun releases PG 8.4.x
in Solaris 'patch' format ...
--
Sent via
This guy have any friends?
- Original Message -
From: Martin Gainty mgai...@hotmail.com
To: dmag...@gmail.com dmag...@gmail.com; Ed Koch
Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org
Sent: Tue Sep 15 19:48:12 2009
Subject: RE: [GENERAL] I need a Postgres Admin $130K + 20K
29 matches
Mail list logo