"Boban Acimovic" <[EMAIL PROTECTED]> writes:
> After lot of tries, it seems I resolved this problem.
So the characterization of the bug seems to be: regular expressions
crash if you build with locale support but not multibyte support?
Seems odd that we'd not have heard about that before. Can yo
"Heather Johnson" <[EMAIL PROTECTED]> writes:
> I have been having trouble getting subselect queries to complete on a Sun E=
> -450 running Solaris 7 and PostgreSQL 7.1.3. Just about any subselect query=
> I try to run will fail to complete execution---Postgres's serverlog indica=
> tes that the
FYI--Here are the table creation statements for the
tables involved in the sample query.
-- user_id_sequenceCREATE SEQUENCE
user_id_sequence INCREMENT 1 START 100;
-- users-- table for basic user
dataCREATE TABLE users (
id
INTEGER NOT NULL PRIMARY KEY --
unique id for
Hello--
I have been having trouble getting subselect
queries to complete on a Sun E-450 running Solaris 7 and PostgreSQL
7.1.3. Just about any subselect query I try to run will fail to complete
execution---Postgres's serverlog indicates that the process associated with the
query gets kille
On Mon, 10 Dec 2001, [utf-8] [EMAIL PROTECTED] wrote:
>
> hi all, i'm trying to do something like this:
>
> CREATE FUNCTION read_table(text) RETURNS int AS '
> DECLARE
> table_name ALIAS FOR $1;
> res
> INTERGER;
> BEGIN
> SELECT INTO res COUNT(id) FROM table_nam
On Fri, 7 Dec 2001, Phill Kenoyer wrote:
> I took your advice and checked the string size using char_length() and
> octet_length(). They are the same.
>
> octet_length | stock| octet_length | inventory_type | client_id
> 5 | 10725 |4 | used |
After lot of tries, it seems I resolved this problem.
First thing what I did is to hack pg_dump not to use SQL queries with
regular expressions. I tried LIKE clause, but it seems it is internally
interpreted as regular expression, so I replaced it with SUBSTR function.
This pg_dump was able to du
Why would this happen?
I had a server where postgres appeared to be running very slowly. Following
some advice I found on-line, I boosted the shared memory max for that
machine and told postgres to take 15200 buffers (about 128 meg of shared
memory). For a while this worked great, but today, the
"David M. Richter" schrieb:
>
> Hello!
>
> Ive got a problem!
> My database has the size of almost 5 Gigabytes.
> So the dump will take at least 2 Gigs of harddisk.
> But my Kernel supports only 2 Gig Files!
>
> Any experiences with big dumpfiles?
>
> Thanks a lot
>
> DAvid
Hello
I guess "s
Does anyone know how to rename a database on postgres 7.1?
Thank you in advance.
Ligia
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hallo,
I`´m newbie in postgreSQL.
Please help me, if you can.
Q: After start postgreSQL on my system (SuSE 7.0) with postgreSQL 7.0 an
creat a new directory /var/lib/pgsql/data I want creat a new db with
createdb Personal.
The system tells me, that it culd not found libpq.so.2.1
That is so ! At m
Hi there,
I'm having a just wonderful Friday at work. Not.
At around 2am this morning, probably in the middle of the nightly
scheduled VACUUM ANALYZE, the UPS on my server failed.
This morning, I have no databases.
The details:
PostgreSQL 7.0.3 on IRIX 6.5.11m.
When I started the machine thi
Ewan Leith <[EMAIL PROTECTED]> writes:
> An example is pg_shadow which is read on both file systems whenever someone
> seems to authenticate, but only updated on the new file system.
I don't believe it for a minute. Please describe the actual problem
you're having, rather than jumping to conclus
Hi all,
we recently upgraded from 6.53 to 7.1.2, and at the same time tried to move
the database to a new filesystem.
However, while the upgrade was 100% successful using pg_dumpall, we see that
postgres is still reading some files from the old file system (though only
updating the new files).
hi all, i'm trying to do something like this:
CREATE FUNCTION read_table(text) RETURNS int AS '
DECLARE
table_name ALIAS FOR $1;
res
INTERGER;
BEGIN
SELECT INTO res COUNT(id) FROM table_name;
RETURN res;
END;
' LANGUAGE 'plpgsql';
using psql the c
15 matches
Mail list logo