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
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
=?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
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
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
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
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 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
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
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
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
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
> "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,
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
31 matches
Mail list logo
