Adam Haberlach <[EMAIL PROTECTED]> writes:
> I was, a few minutes ago, stunned to discover that as far as I can
> tell, the postgres server is not part of Red Hat Server ES
Feel free to let Red Hat know that you're unhappy about this.
(Not totally unbiased here ... I'm getting *very* tired
On Tuesday 11 Nov 2003 9:02 pm, Dennis Gearon wrote:
> This is something I've been wondereing about for quite awhile - does
> pgsql measure bytes or chars when using UTF for varchars. It looks like
> bytes, which is counter intuitive. What are the byte codes for those 15
> chars. I think the maximu
On Mon, Nov 10, 2003 at 08:56:03AM -0800, Scott Chapman wrote:
> I talked with the author or SQLObject about this recently and I thnk
> he's implementing this correctly, by querying the cursor for the last
> OID?:
That won't scale unless you index oid. And your tables will all need
oids, which
How come pgsql7.3.4 Was allowing me to delete the master record while
referencing records were present in slave table?
The problem was detected when the database was migrated to 7.4 and
deletions were being refused.
Regards
Mallah
tradein_clients=# \d user_services
Table "public.user_serv
On Tue, 2003-11-11 at 21:22, Ed L. wrote:
> $ createlang plperl template1
> ERROR: Load of file /opt/pgsql/installs/postgresql-7.3.4/lib/plperl.so
> failed: libperl.so: cannot open shared object file: No such file or
> directory
> createlang: language installation failed
I had the exact proble
Mark Harrison <[EMAIL PROTECTED]> writes:
> Since these are all unique things, and will only be tested for
> equality, I am guessing that making a hash index will be better
> than making a btree index.
You are mistaken. If there were any real value in that, we'd offer
an easier way to do it.
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> select tablename.fieldname.currval;
That syntax would be problematic, it would mean to select all rows from
tablename and evaluate fieldname.currval for each one. Actually it's worse, it
would be confused with schemas I think.
The postgres-ish way t
Christopher Browne wrote:
In the last exciting episode, [EMAIL PROTECTED] (Jan Wieck) wrote:
I look forward to your comments.
It is not evident from the paper what approach is taken to dealing
with the duplicate key conflicts.
The example:
UPDATE table SET col1 = 'temp' where col = 'A';
UPDAT
Jan Wieck wrote:
Rajesh Kumar Mallah wrote:
Hi ,
I noticed that an entry in pg_stat_activity was existing for a
long duration > 2 mins while its backend ( process corresponding
to that procpid) was not running.
how can it be possible ?
version: 7.3.4
There was a bug that caused a crashing bac
Scott Chapman <[EMAIL PROTECTED]> writes:
> On Wednesday 12 November 2003 11:29, Doug McNaught wrote:
> > Scott Chapman <[EMAIL PROTECTED]> writes:
> > > It would be nice if PostgreSQL could return the primary key it
> > > inserted with but that may not be a fool-proof solution either. Is
> > > t
Scott Chapman <[EMAIL PROTECTED]> writes:
> It would be nice if PostgreSQL could return the primary key it inserted
> with but that may not be a fool-proof solution either. Is there a nice
> way to handle this situation?
Write a database function that inserts the record and returns the
primary
Greetings,
I've got a fairly simple function that I'm trying to return a set, but
seem to have come across a stumbling block. When I execute the function
below (the input params are not used at the moment) I get this:
chris=# select htdig('foo', 'foo');
ERROR: set-valued function called in cont
On Nov 12, 2003, at 11:04 AM, Brett Maton wrote:
Hi NG,
How do I find out the size of a column ?
I am retrieving large objects from the pg_largeobject table and
creating a
files, I would like to know the length of the data column so that I can
implement buffering instead of writing hundreds
Ma Siva Kumar <[EMAIL PROTECTED]> writes:
> On Tuesday 11 Nov 2003 9:02 pm, Dennis Gearon wrote:
>> This is something I've been wondereing about for quite awhile - does
>> pgsql measure bytes or chars when using UTF for varchars. It looks like
>> bytes, which is counter intuitive.
The measurement
Is this correct?
vacuum by itself just cleans out the old extraneous tuples so that they
aren't in the way anymore
vacuum analyze rebuilds indexes. If you add an index to a table it won't be
used until you vacuum analyze it
vacuum full actually compresses the table on disk by reclaiming the space
Actually, in your case it's probably the new optimisation regarding the use
of IN (subquery). They're now optimised to the same lavel as EXISTS IIRC.
On Wed, Nov 12, 2003 at 05:46:23PM -0800, Reece Hart wrote:
> On Wed, 2003-11-12 at 09:04, jake johnson wrote:
>
> > I also posted about the perfo
Hi all:
I have here a table with the following schema:
Table "todocinetv"
Column|Type | Modifiers
-+-+--
id | integer | not null default '0'
dates
Hi NG,
How do I find out the size of a column ?
I am retrieving large objects from the pg_largeobject table and creating a
files, I would like to know the length of the data column so that I can
implement buffering instead of writing hundreds of small chunks to disk.
Any help would be apprec
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
How come pgsql7.3.4 Was allowing me to delete the master record while
referencing records were present in slave table?
The only explanation I can think of is that the referencing row shown as
being in user_
Paulo Jan <[EMAIL PROTECTED]> writes:
> -> Seq Scan on todocinetv (cost=0.00..37768.90 rows=28792
> width=8)
The estimated cost seems to be more than one disk page read per row
returned. This suggests to me that you have a huge amount of dead space
in that table --- try a VACUUM FULL
I was wondering if there was a reliable method to get the last id
inserted into a serial column in a table. I believe previous
recommendations given were to use a sequence, have your app get the
nextval for the sequence and then use that in the insert. I was
wondering if things had changed or if
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi.
I have the following little stored proc:
CREATE OR REPLACE FUNCTION public.ib_nextval(varchar)
RETURNS varchar AS
'DECLARE
countername ALIAS FOR $1;
cprefix varchar;
counter integer;
dlen integer;
complet
It is a shame that postgres is not available as an
embedded server unlike mysql database server which
comes in the form of a dll.
However with mysql licence I would have to pay $10,000
if I wish to include it in mysql as an embedded server
in my app.
mysql database server is also a TCP/IP socket
Rajesh Kumar Mallah wrote:
Hi ,
I noticed that an entry in pg_stat_activity was existing for a
long duration > 2 mins while its backend ( process corresponding
to that procpid) was not running.
how can it be possible ?
version: 7.3.4
There was a bug that caused a crashing backend to hang around
Hi,
I am starting a new project where I intend to use
embedded database server in my win32 application.
I intend to use VC++ microsoft studio 6.0 as my
development environment.
The postgres.org website seems to be catering for
people with all sorts of requirements and platforms.
1. Where can I f
In the last exciting episode, [EMAIL PROTECTED] (Jan Wieck) wrote:
> I look forward to your comments.
It is not evident from the paper what approach is taken to dealing
with the duplicate key conflicts.
The example:
UPDATE table SET col1 = 'temp' where col = 'A';
UPDATE table SET col1 = 'A'
jini us wrote:
Hi,
I am starting a new project where I intend to use
embedded database server in my win32 application.
I intend to use VC++ microsoft studio 6.0 as my
development environment.
The postgres.org website seems to be catering for
people with all sorts of requirements and platforms.
1.
Christopher Murtagh <[EMAIL PROTECTED]> writes:
> Thanks to a lot of help on this list, I've managed to get my pl/perl
> function working. However, I have an unexpected result. Here's a simple
> way to reproduce this problem:
>
> CREATE or REPLACE FUNCTION perltest(integer)
> returns integer as
On Wed, Nov 12, 2003 at 05:35:40PM -0500, Christopher Murtagh wrote:
> chris=# select htsearch('sample_return2.txt','dbname');
> htsearch
> --
> {HASH(0x835c298),2100,2113,2114}
> (1 row)
>
> Any obvious thing that I'm doing wrong? I'm using 7.4RC2. A
On Wed, 2003-11-12 at 09:04, jake johnson wrote:
I also posted about the performance increase of 7.4, but I think that
much of the difference you're seeing (because it's such a large
difference) is probably due to the cleanliness of a newly restored
database from backup.
I agree that this s
On Tuesday 11 November 2003 11:57 pm, Tom Lane wrote:
> Adam Haberlach <[EMAIL PROTECTED]> writes:
> > I was, a few minutes ago, stunned to discover that as far as I can
> > tell, the postgres server is not part of Red Hat Server ES
> Feel free to let Red Hat know that you're unhappy about thi
31 matches
Mail list logo
