mid to end October ...
On Wed, 10 Sep 2003, Nigel J. Andrews wrote:
>
> Just wondering what the feeling is regarding when the end of beta might be.
>
>
> --
> Nigel Andrews
>
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your fre
What is the size limit of bytea, I thought it was 8K?
How do you dump your database when you have bytea, do you need to do a
binary dump?
What are you using to insert the binary data?
Thank you in advance.
Guy
Jonathan Bartlett wrote:
For the education of me and maybe others too, why was
tha
Quoting Andrew Ayers <[EMAIL PROTECTED]>:
> Network Administrator wrote:
> > I'd actually like to get some comments on this too because for
> compatibility and
> > throughput issues, I would think that storing the file path in the
> database
> > instead of the actually file would be "better". I'v
I think that is what someone mentioned earlier in this thread. I guess you can
do that with a "text" type which according to the docs doesn't have an upper
limit (although there is that 1Gb limit for a single character string. The way
that entire paragraph reads would have me to believe that it m
Bruno Wolff III wrote:
> On Tue, Sep 09, 2003 at 21:02:21 -0700,
> Alex Martinoff <[EMAIL PROTECTED]> wrote:
> > I'm wondering if it's possible to have a query construct a column
> > where the value of the column at each row is taken from another field
> > in that same row. For example, suppose y
Thanks that is extremely helpfull.
Guy
Jonathan Bartlett wrote:
What is the size limit of bytea, I thought it was 8K?
No limit that I've found. Some are several meg.
How do you dump your database when you have bytea, do you need to do a
binary dump?
Nope. pg_dump automagicall
On Wed, 10 Sep 2003, Vivek Khera wrote:
> > "AR" == Andrew Rawnsley <[EMAIL PROTECTED]> writes:
>
> AR> Anyone out there using beta 2 in production situations? Comments on
> AR> stability? I am rolling out a project in the next 4 weeks, and really
> AR> don't want to go though an upgrade soon
Sorry if this is obvious to you, but it's not obvious to me.
In 7.4 this
psql -h 127.0.0.1 test and
psql -h localhost test
will be authenticated as ipv6 addresses. As long as you know, it's OK, but is
this intentional?
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 258
Again, we have an odd performance problem with PGSQL, 7.4b2.
Here is the query:
delete from numplan where pkid in
(select numplan.pkid from numplan
left outer join pilothuntgroup on
numplan.pkid=pilothuntgroup.fknumplan
left outer join devicenumplanmap
Alessandro GARDICH <[EMAIL PROTECTED]> writes:
> with setittimer and SIGALRM i do an explicit COMMIT every 10 seconds,
> update loop have a random delay from 0 to 500 msec using usleep().
> I have problems using SIGALRM and libpq (libpqxx exactly), does libpq
> use select or other signal ???
Are
I am doing to large dataset performance tests with 7.3.4b2 today and I noticed an
interesting phenomenon. My shared memory buffers are set at 128MB. Peak postmaster
usage appears to be around 90MB.
My test app performs inserts across 4 related tables, each set of 4 inserts
representing a sing
Hi,
I think both ways can be used. For editing/working pictures can
be stored in db - easy interface and others... For speed of reading
files should be stored outside db.
Regards,
Michał Zaborowski (TeXXaS)
---(end of broadcast)---
TIP 5: Have
Darko Prenosil wrote:
There is no need for manually storing files on filesystem, because large
objects are doing that for You. I am storing whole binary files in
blobs(synonym for large objects from some other platforms), and I do not
remember that I had a single problem with that. Do not forget th
This discussion provides an opportunity to capture the
essentials of how to store and retrieve images using
PostgreSQL, and the issues (performance,
administration etc.) associated with each possible
method.
A discussion article on Techdocs (or even General
Bits?) would be a fine thing. My observ
Hi,
FWIW, I walked into this one when changing an int[ ] into a numeric(5,1)[ ] :
IF ( 0::int ) => interpreted as false
IF ( 0.0::numeric(5,1) ) => interpreted as true
Yes, there should have been used some expression that evaluated to a boolean
to begin with, but 'if (int)' is not all that u
On Wed, 10 Sep 2003, D. Stimits wrote:
> D. Stimits wrote:
>
> > I'm using a Redhat version of PostgreSQL 7.2.3 with the C API. Mostly
> > things work right, but I need more debug output, as I have a query that
> > works fine from psql, but fails with the C API (perhaps this is because
> > I use P
Richard Huxton wrote:
On Wednesday 10 September 2003 08:34, Stéphane Cazeaux wrote:
Client 1:
BEGIN;
SELECT count FROM test_count FOR UPDATE; --> returns the only entry "1"
Client 2 :
BEGIN;
SELECT count FROM test_count FOR UPDATE; --> this query is blocked, ok
On Wednesday 10 September 2003 17:17, Derrick Betts wrote:
> Is the size limit 8K for 'text' field types as well?
>
> > What is the size limit of bytea, I thought it was 8K?
Not for some time now - the TOAST system (Tom Lane's work IIRC) means you can
store large text fields in a table. By large
> "AR" == Andrew Rawnsley <[EMAIL PROTECTED]> writes:
AR> Anyone out there using beta 2 in production situations? Comments on
AR> stability? I am rolling out a project in the next 4 weeks, and really
AR> don't want to go though an upgrade soon after its released on an
AR> Unsuspecting Client,
How do you deal with backing up the images? Right now i can remote
backup my filesystem using rsync to an offsite location many times a
day, only taking a very small amount of I/O, bandwidth and time.
Dealing with the backup scared me away from using postgres in the first
place. The idea
Alessandro GARDICH <[EMAIL PROTECTED]> writes:
> the program is quite simple, a loop do UPDATE on a random entry on a
> table. Server is without autocommit.
>
> with setittimer and SIGALRM i do an explicit COMMIT every 10 seconds,
> update loop have a random delay from 0 to 500 msec using usleep
D. Stimits wrote:
I'm using a Redhat version of PostgreSQL 7.2.3 with the C API. Mostly
things work right, but I need more debug output, as I have a query that
works fine from psql, but fails with the C API (perhaps this is because
I use PQescapeString). The only way to know there is an error is t
Hello everybody,
Someone helped me earlier with this TCL trigger function:
create or replace function tlow() returns trigger as '
set NEW($1) [string tolower $NEW($1)]
return [array get NEW]'
language 'pltcl';
I use it to force lowercase of values inserted in the db. There is one
problem th
On Wednesday 10 September 2003 14:27, Jules Alberts wrote:
>
> I use it to force lowercase of values inserted in the db. There is one
> problem though, if the parameter is absent, the function will give an
> error message. I would like it to rather check for null before tolower
> is applicated. In
Kaare Rasmussen <[EMAIL PROTECTED]> writes:
> Sorry if this is obvious to you, but it's not obvious to me.
> In 7.4 this
> psql -h 127.0.0.1 test and
> psql -h localhost test
> will be authenticated as ipv6 addresses.
Only if your libc and/or kernel preferentially treats them as ipv6.
CVS tip con
On Wednesday 10 September 2003 12:54, Stéphane Cazeaux wrote:
> Richard Huxton wrote:
> >
> >Client2's first SELECT started before you commited the INSERT, the second
> >SELECT started after you commited. Since you are using READ COMMITTED you
> > can read the results of transactions committed *bef
Christopher,
You did not quite understand.
The counts in question is the actual counts (deltas) for the
transtactions.
the tuple should be something like:
xid, reltype, insert_count, update_count, delete_count
When a COUNT(*) is issued the commited tuples are totaled up stored as
xid 0 or wha
Alex Martinoff wrote:
> I'm wondering if it's possible to have a query construct a column
> where the value of the column at each row is taken from another field
> in that same row. For example, suppose you have a table like:
>
> create table users (
> uid serial,
> nickname varchar(2
=?ISO-8859-1?Q?St=E9phane_Cazeaux?= <[EMAIL PROTECTED]> writes:
> I'm ok about this, but, if I try exactly the same scenario, where I
> replace the INSERT by a DELETE, the first SELECT of the client 2 won't
> return any row. This is the same behaviour with an UPDATE. If client 1
> updates the ro
Network Administrator wrote:
I'll have to research that base64 encoding part because I'll
only every do text dumps.
Then the base64 storage in the database is perfect.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregi
Is the size limit 8K for 'text' field types as well?
- Original Message -
From: "Guy Fraser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 9:40 AM
Subject: Re: [GENERAL] Picture with Postgres and Delphi
> What is the size limit of bytea, I thought it wa
31 matches
Mail list logo
