I would need to do case insensitive match against a field that contains
text in different languages - Greek, Hungarian, Arabic etc.
The db encoding is UTF8.
So far I found no way to achieve that. I tried converting both strings
to the same case and using ~* , but neither worked.
Does anybody
This is reproducible, and I think it is a bug, because I have the
problem not only with data backed up from Postgres 8.0 and restored to
Postgres 8.1, but with data generated in Postgres 8.1. It is
reproducible, at least on Windows XP. Here is a table that I backed up
from Postgres 8.0. It can
On Mon, Mar 27, 2006 at 11:31:17AM +0200, SunWuKung wrote:
I would need to do case insensitive match against a field that contains
text in different languages - Greek, Hungarian, Arabic etc.
The db encoding is UTF8.
So far I found no way to achieve that. I tried converting both strings
to
I get this error when trying to back up a database in Postgres 8.1 that
I was able to back up from Postgres 8.0 and restore into Postgres 8.1:
C:\Archivos de programa\PostgreSQL\8.1\bin\pg_dump.exe -i -h localhost
-p 5432 -U z2233935 -F c -b -v -f C:\Documents and
In article [EMAIL PROTECTED], kleptog@svana.org says...
On Mon, Mar 27, 2006 at 11:31:17AM +0200, SunWuKung wrote:
I would need to do case insensitive match against a field that contains
text in different languages - Greek, Hungarian, Arabic etc.
The db encoding is UTF8.
So far I
I had a bright idea that has not worked quite as well as I thought.
We have a web sites for selling cars that we are trying to expand to vans,
bikes etc. We get a datafeed containing prices and technical data updated
nightly (for cars it's about 2.3GB, others are smaller). This comes into SQL
On Mon, Mar 27, 2006 at 11:44:00AM +0100, Ashley Moran wrote:
I had a bright idea that has not worked quite as well as I thought.
We have a web sites for selling cars that we are trying to expand to vans,
bikes etc. We get a datafeed containing prices and technical data updated
nightly
Hi, I'm new on postgres and I've just installed postgres 7.4.7 on a
debian sarge. I'm interested on using inheritance. I've tried a simple code:
CREATE TABLE t_main (
id serial primary key
);
CREATE TABLE t_derived1 (
field1 varchar(128)default NULL
)
We are upgrading our systems to handle new languages and therefore we
need to change the encoding of our postgres database from LATIN1 to UTF-8.
I have pg_dumped the database and imported it into the new UTF-8 base.
It seems like this worked just fine.
Can anyone confirm that this is the
On Mon, Mar 27, 2006 at 12:45:05PM +0200, SunWuKung wrote:
This sounds like a very interesting concept.
It wouldn't be 'case insensitive' just insensitive.
The way I imagine it now is a special case of the ~ function.
I create matchgroups in a table and check each character if it is in the
On Mon, Mar 27, 2006 at 01:32:33PM +0200, Tormod Omholt-Jensen wrote:
We are upgrading our systems to handle new languages and therefore we
need to change the encoding of our postgres database from LATIN1 to UTF-8.
I have pg_dumped the database and imported it into the new UTF-8 base.
It
On Fri, Mar 24, 2006 at 11:25:35AM -0700, [EMAIL PROTECTED] wrote:
test-# $$ select not exists
test$# (select * from test_dates t1
test$# where 1 ( select count(*) from test_dates t2
test$# where (t1.from_date, t1.to_date) overlaps
test$#
On Fri, Mar 24, 2006 at 11:54:29PM -0800, Leon Pu wrote:
--- Tom Lane [EMAIL PROTECTED] wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
No there is not. I actually suggest, considering your ancient
version of
RedHat that you install from source.
Better yet, install a more
On Sat, Mar 25, 2006 at 08:11:22PM +0100, Tomaz Borstnar wrote:
Hello!
First tried some searching around, but did not find anything useful
so I gave up and decided to ask here... I am wondering how do pair of
1.5GHz Itanium2(4MB cache) stack up against pair of AMD or Intel
Hi,
On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote:
I'd hope that RH would support at least the
most recent version of 7.4, since presumably that's part of what they
pay Tom for... Just understand that 7.4 is approaching end-of-life.
(Presumably so is RHEL2...)
RH won't support a
On Sat, Mar 25, 2006 at 01:07:02PM -0800, Just Someone wrote:
After exchanging a few emails regarding pgbench in the list, I was
thinking it'll be cool to have a place to post pgbench resulats from
all over the place. Just so people can get an idea of what others are
getting.
If more people
On Sun, Mar 26, 2006 at 11:27:33AM -0500, Matthew T. O'Connor wrote:
The table has 6800 rows over 18000 pages, and is getting a
minimum of many tens of thousands of updates per day with
queries like this:
If you're updating that much, how often are you running
'analyze'? Are you running
On Sun, Mar 26, 2006 at 08:30:44PM +0200, David Hoksza wrote:
Hi, I would like to know, when ambulkdelete is run. I thought that
when tuple is deleted so bulkdelete is run, but when I set breakpoint
to btbulkdelete, it doesn't stop there. Does it mean, that
ambulkdelete is run just when I use
Alex bahdushka [EMAIL PROTECTED] wrote
LOG: REDO @ D/19176610; LSN D/19176644: prev D/191765E8; xid 81148979:
Heap - clean: rel 1663/16386/16559898; blk 0
LOG: REDO @ D/19176644; LSN D/191766A4: prev D/19176610; xid 81148979:
Heap - move: rel 1663/16386/16559898; tid 1/1; new 0/10
PANIC:
On Mon, Mar 27, 2006 at 11:44:00AM +0100, Ashley Moran wrote:
I had a bright idea that has not worked quite as well as I thought.
We have a web sites for selling cars that we are trying to expand to vans,
bikes etc. We get a datafeed containing prices and technical data updated
nightly
On Mon, Mar 27, 2006 at 03:16:29PM +0300, Devrim GUNDUZ wrote:
Hi,
On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote:
I'd hope that RH would support at least the
most recent version of 7.4, since presumably that's part of what they
pay Tom for... Just understand that 7.4 is
Hello,
Does anybody know good comparison/review article of XML support in
major RDMBSes? I know that PostgreSQL's XML capabilities are quite
weak, but how far is it from other products?
Sincerely,
Ivan Zolotukhin
---(end of broadcast)---
TIP 6:
On Mon, Mar 27, 2006 at 05:22:40PM +0400, Ivan Zolotukhin wrote:
Hello,
Does anybody know good comparison/review article of XML support in
major RDMBSes? I know that PostgreSQL's XML capabilities are quite
weak, but how far is it from other products?
For other databases it's probably
Jim C. Nasby wrote:
On Fri, Mar 24, 2006 at 11:25:35AM -0700, [EMAIL PROTECTED] wrote:
pet-peeve
If you only want to know if something exists, do NOT use count!
test$# (select * from test_dates t1
test$# where EXISTS ( select * from test_dates t2
test$# where
On Mon, Mar 27, 2006 at 03:46:17PM +0200, Alban Hertroys wrote:
Jim C. Nasby wrote:
On Fri, Mar 24, 2006 at 11:25:35AM -0700, [EMAIL PROTECTED]
wrote:
pet-peeve
If you only want to know if something exists, do NOT use count!
test$# (select * from test_dates t1
test$# where
Hi,
I might have missed it in the docs, but is there a way for the non super
user owner of a db to reset a objects ACL to default?
I have been able to do it for users using the super user account by
setting the objects acl entry to null.
Thanks,
Tony
---(end of
I'm having some troubles restoring a database on Windows and I found this
difference between PostgreSQL running on Linux and Windows.
When I create a table like this:
CREATE TABLE fee_payment1(id_fee_payment1 serial NOT NULL) WITH
OIDS;
On Linux platform it will be:
CREATE TABLE
JP Glutting [EMAIL PROTECTED] writes:
This is reproducible, and I think it is a bug, because I have the
problem not only with data backed up from Postgres 8.0 and restored to
Postgres 8.1, but with data generated in Postgres 8.1. It is
reproducible, at least on Windows XP. Here is a table
On Sun, 2006-03-26 at 16:00, Robert Treat wrote:
mysql's various user permissions / connection tables are often seen as being
more featurefull than postgresql pg_hba system, due to its closer likeness to
using sql, potentially simpler syntax, and ability to use remote admin tools.
That
Qingqing Zhou [EMAIL PROTECTED] writes:
Actually I tried to simulate your situation, but everytime I got a neat
recovery --
You probably filled the test table and then vacuumed within a single
checkpoint cycle, so that the replay sequence included loading data into
page 1 in the first place.
On Fri, 2006-03-24 at 17:08, Guy Fraser wrote:
On Fri, 2006-24-03 at 14:53 -0600, Scott Marlowe wrote:
...snip...
Only my most recent personal experience, when I was explaining to the
guy from MySQL how frustrating it was that installing MySQL broke my
build of PHP and meant I had to use
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each table.
How can I do that ?
Thanks in advance !
--
Bruno BAGUETTE
---(end of broadcast)---
TIP 5:
Bruno Baguette wrote:
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each
table.
How can I do that ?
Thanks in advance !
on contrib package or contrib subdir from the source is dbsize
Bruno Baguette [EMAIL PROTECTED] schrieb:
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the size
(in bytes, Mbytes or anything else) of that database, for each table.
How can I do that ?
I'm not sure if this functions available in 8.0:
If not, see in contrib.
The space occupied by your database and tables can be found this way:# select oid from pg_database where datname='mybase';oid ---17239(1 row)$ du -hs data/base/17239
13.5 MFor getting a table size to get an approx size you can do the following:SELECT relpages * 8192 AS size_in_bytesFROM
Scott Marlowe wrote:
On Sun, 2006-03-26 at 16:00, Robert Treat wrote:
mysql's various user permissions / connection tables are often seen as being
more featurefull than postgresql pg_hba system, due to its closer likeness to
using sql, potentially simpler syntax, and ability to use remote
--- Jim C. Nasby [EMAIL PROTECTED] wrote:
On Mon, Mar 27, 2006 at 03:16:29PM +0300, Devrim GUNDUZ wrote:
Hi,
On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote:
I'd hope that RH would support at least the
most recent version of 7.4, since presumably that's part of what
they
Bruno Baguette wrote:
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each table.
How can I do that ?
Thanks in advance !
This will probably work for you (in bytes - or you could divide by 8
Bruno Baguette wrote:
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each
table.
You've already got several replies. Know that the PG documentation is
excellent. If you visit www.postgresql.org, you will
Hi guys,
I trying for days to get this simple plpgsql procedure
to run but I keep getting this error:
psql:pgsql_procedure.txt:15: ERROR: syntax error at
or near at character 17
QUERY: copy cancel TO $1 with delimiter as ',' null
as '.'
CONTEXT: SQL statement in PL/PgSQL function doedit
near
Dino Vliet wrote:
Hi guys,
I trying for days to get this simple plpgsql procedure
to run but I keep getting this error:
psql:pgsql_procedure.txt:15: ERROR: syntax error at
or near at character 17
QUERY: copy cancel TO $1 with delimiter as ',' null
as '.'
CONTEXT: SQL statement in PL/PgSQL
Chris Travers [EMAIL PROTECTED] writes:
Out of curiosity, how hard would it be to change the default maximum
length on the name type in PostgreSQL?
Change NAMEDATALEN in postgres_ext.h, recompile, re-initdb.
I'm not sure why we still define it in postgres_ext.h, because it hasn't
been part of
Nope:-(
I added it just now and still the same error message!!
--- Bricklen Anderson [EMAIL PROTECTED] wrote:
Dino Vliet wrote:
Hi guys,
I trying for days to get this simple plpgsql
procedure
to run but I keep getting this error:
psql:pgsql_procedure.txt:15: ERROR: syntax
Dino Vliet wrote:
Nope:-(
I added it just now and still the same error message!!
Have you tried it with your copy command executed dynamically?
eg. execute 'copy cancel to location ...';
---(end of broadcast)---
TIP 1: if posting/reading
Dino Vliet [EMAIL PROTECTED] writes:
I trying for days to get this simple plpgsql procedure
to run but I keep getting this error:
You can't ordinarily use a variable to supply a table (or field) name
in a plpgsql query; that doesn't work because plpgsql wants to cache a
plan for the query. A
I am developing a small web application. Currently, our web server is
sitting outside our firewall (running its own firewall), and the application
being developed would let users do things like place orders.
My question is...what and where is the database for this?
Do I have a small database
On Mar 27, 2006, at 2:10 PM, Dino Vliet wrote:
Can somebody tell me why my location variable is NOT
working as expected? I would like to use it in a loop
to create multiple text files which names would be
different because of the way I concatenate it with the
looping variable.
You can't
I am developing a small web application. Currently, our web server is
sitting outside our firewall (running its own firewall), and the
application
being developed would let users do things like place orders.
My question is...what and where is the database for this?
What do you mean when you
Ok thanks for now. I understood the problem and what I
should do to fix it. Will try that later.
Thanks for all the tips and the REALLY FAST answers!!
--- John DeSoi [EMAIL PROTECTED] wrote:
On Mar 27, 2006, at 2:10 PM, Dino Vliet wrote:
Can somebody tell me why my location variable is
On Mar 27, 2006, at 4:46 AM, JP Glutting wrote:
Can anyone reproduce this on Linux or another platform? Is this a
known bug?
I took your dump and loaded it into a Pg 8.1.3 database on FreeBSD 6
with UTF-8 encoding. Then I did pg_dump on that database and it had
no complaints.
The
I have two questions:
1. In Postgresql, what is the name of the exact DATAFILE under the DATA
DIRECTORY ?
2. We want to prepare a backup machine (for disaster management) by
passing only the ARCHIVEDIR directory from another online machine - both
the machines have Postgresql installed. We have
Tom Lane wrote:
Qingqing Zhou [EMAIL PROTECTED] writes:
Jo De Haes [EMAIL PROTECTED] wrote
CETERROR: XX001: invalid page header in block 22182 of relation
dunn_main
I suppose there is no system error happens during the period (like lost
power). Can you attach the gdb at b bufmgr.c:257
Are donations made to http://www.postgresql.org/about/donate tax deductible?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Richard Broersma Jr wrote:
Are donations made to http://www.postgresql.org/about/donate tax deductible?
No.
We are currently working with SPI (Software in the public interest) to
resolve this.
Sincerely,
Joshua D. Drake
---(end of
Ted Byers wrote:
I am developing a small web application. Currently, our web server is
sitting outside our firewall (running its own firewall), and the
application
being developed would let users do things like place orders.
My question is...what and where is the database for this?
What do
I am getting a deadlock which I can't explain...although maybe
somebody else can...here's teh situation:
I have a plpgsql function which increments a sequence when called.
when the sequence hits a certain threshold, the sequence is reset and
a materilized structure (small table) is updated. The
Merlin Moncure [EMAIL PROTECTED] writes:
I am getting a deadlock which I can't explain...although maybe
somebody else can...here's teh situation:
TRUNCATE requires exclusive lock, and won't release it until end of
transaction. Since you've already read something from the target
table before
Hello Folx!
We are running into a problem that I wanted to run by the group before I report
it as a bug.
We have a medium sized database that when dumped creates +4G files within the
tar archive. When we restore it seems that pg_restore has a 4G limit for
reading files, once it reads 4G of a
On 3/27/06, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
I am getting a deadlock which I can't explain...although maybe
somebody else can...here's the situation:
TRUNCATE requires exclusive lock, and won't release it until end of
transaction. Since you've
The webserver runs linux and I also have iptables on that server filtering
out all but HTTP and SSH traffic.
I have not yet implemented the database, and I am VERY reluctant to put the
full db outside our main firewall because of the need to protect sensitive
info. So my question, is how do the
beer [EMAIL PROTECTED] writes:
We have a medium sized database that when dumped creates +4G files
within the tar archive. When we restore it seems that pg_restore has
a 4G limit for reading files, once it reads 4G of a file, it moves on
to the next file. Has anyone else experienced this
I have not yet implemented the database, and I am VERY reluctant to put the
full db outside our main firewall because of the need to protect sensitive
this is natural. One solution is to put 2nd nic on the web server
(carefully firewalled) for connections to the database. Theres lots
of
I would normally put the database inside my LAN and only accesible
from boxes in the DMZ through certain ports (remoting). I usually not
let the web application access the database directly. I use business
objects through remoting and only have those business objects
available to the web
On 3/27/06, Merlin Moncure [EMAIL PROTECTED] wrote:
I have not yet implemented the database, and I am VERY reluctant to put the
full db outside our main firewall because of the need to protect sensitive
this is natural. One solution is to put 2nd nic on the web server
(carefully
Ardian Xharra (Boxxo) wrote:
I'm having some troubles restoring a database on Windows and I found
this difference between PostgreSQL running on Linux and Windows.
When I create a table like this:
CREATE TABLE fee_payment1(id_fee_payment1 serial NOT NULL) WITH OIDS;
On Linux platform it will be:
Sumita Chatterjee wrote:
I have two questions:
1. In Postgresql, what is the name of the exact DATAFILE under the DATA
DIRECTORY ?
It depends. The subfolders under data are the OID of the database - they
are not stored per name.
2. We want to prepare a backup machine (for disaster
How, really, do people pronounce PostgreSQL?
I've read the politically correct answer, Post-Gres-Q-L but it's
such a mouthful, such a day's work to pronounce, that there must be a
real street pronunciation, or a number of them, that are not being
confessed to.
They say that SQL should be
Hi,
I'm looking at a very simple database that contains a table
of recipes and a table of ingredients with nutritional content.
I'd defined the schema as such
CREATE TABLE ingredients
(
uid integer,
... -- nutritional info
)
CREATE TABLE recipes
(
uid integer,
ingredients
On Tue, 28 Mar 2006, Michael Talbot-Wilson wrote:
How, really, do people pronounce PostgreSQL?
I've read the politically correct answer, Post-Gres-Q-L but it's
such a mouthful, such a day's work to pronounce, that there must be a
real street pronunciation, or a number of them, that are not
Michael Talbot-Wilson [EMAIL PROTECTED] writes:
How, really, do people pronounce PostgreSQL?
I've read the politically correct answer, Post-Gres-Q-L but it's
such a mouthful, such a day's work to pronounce, that there must be a
real street pronunciation, or a number of them, that are not
Michael Talbot-Wilson [EMAIL PROTECTED] writes:
How, really, do people pronounce PostgreSQL?
Postgres
-Doug
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
Solution
CREATE TABLE ingredients
(
uid integer,
... -- nutritional info
)
CREATE TABLE recipes
(
uid integer,
uid_bridge integer -- uids in bridge table
)
CREATE TABLE bridge
(
uid integer,
uid_ingredients integer -- uids in table ingredients
)
rows in recipes table
Wait, nm,
no need for uid_bridge in recipes
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Tue, 28 Mar 2006 10:10:15 +0930 (CST), Michael Talbot-Wilson [EMAIL
PROTECTED] wrote:
How, really, do people pronounce PostgreSQL?
we just use postgres.
They say that SQL should be pronounced Sequel and I've even met
people who do that.
I hate that. It's an acronym not a word - you
On Mar 27, 2006, at 4:40 PM, Michael Talbot-Wilson wrote:
Do you have a snappy pronunciation and what is it? I'd be interested
in what the babble is at your PostgreSQL site.
Externally, to customers, post-gres-kwul.
Internally, the database.
Cheers,
Steve
On Tue, 28 Mar 2006, Klint Gore wrote:
They say that SQL should be pronounced Sequel and I've even met
people who do that.
...
Who's they? The only datbase vendor I've heard call their own product
sequel is MS.
E.g. Sybex SQL Instant Reference (1993), page 2.
On Mar 27, 2006, at 4:23 PM, Mark Feller wrote:
Maybe a synch is done between
webserver database and main database every five minutes, where the
main
database pulls any new orders, and pushes any updated part lists,
pricing
etc. to the webserver db?
I have implemented a design like
On Mon, Mar 27, 2006 at 05:08:58PM -0800, Ricebot wrote:
Wait, nm,
no need for uid_bridge in recipes
Sure there is. If one recipe can contain several ingredients and an
ingredient can be in more than one recipe, you need that join table :)
Cheers,
D (who isn't going to try to design a
The solution that I have seen typical is to have both webserver and database machine behind a firewall both NATed, with only HTTP and HTTPS ports open on the webserver. SSH is not open, as trusted clients connect via the VPN in the firewall. The database machine, unlike the webserver, will not
hi again
i made one mod to dbmirror.
1) I implemented a mechanism to exclude attributes (columns) from
dbmirror'ed tables.
I added one table
CREATE TABLE dbmirror_exclude_attributes (
tblname character varying(100) NOT NULL,
attnames text[] NOT NULL
);
ALTER TABLE ONLY
Hi list,
We have developed a system that is running as an ASP application, currently we
are using Postgresql 7.4. For every customer we have a separate schema, and
this works OK. Now in version 8, tablespaces were introduced. This summer we
are planning to migrate to version 8.1. Question is
Jebus scrisse in data 03/27/06 19:03:
I could be wrong but primary keys and other constraints are not inherited.
Thank you very much Jebus; in effect I've found in the mailing list
archives a 2003 thread INHERITS and Foreign keys that claim the same
problem. Someone (Stephan Szabo)
On Tue, Mar 28, 2006 at 09:41:46AM +0200, Dick Kniep wrote:
Hi list,
We have developed a system that is running as an ASP application, currently
we
are using Postgresql 7.4. For every customer we have a separate schema, and
this works OK. Now in version 8, tablespaces were introduced.
On Mon, 2006-03-27 at 14:55 +0530, Sumita Chatterjee wrote:
I have two questions:
1. In Postgresql, what is the name of the exact DATAFILE under the DATA
DIRECTORY ?
2. We want to prepare a backup machine (for disaster management) by
passing only the ARCHIVEDIR directory from another
On Sun, 2006-03-26 at 20:30 +0200, David Hoksza wrote:
Hi, I would like to know, when ambulkdelete is run. I thought that
when tuple is deleted so bulkdelete is run, but when I set breakpoint
to btbulkdelete, it doesn't stop there.
Does it mean, that
ambulkdelete is run just when I use
OK, that's cleared, thanks,
Now another question related to this. In 7.4.8 I have a schema with the
following authorization:
CREATE SCHEMA adeuxproductie
AUTHORIZATION postgres;
GRANT ALL ON SCHEMA adeuxproductie TO postgres;
GRANT ALL ON SCHEMA adeuxproductie TO GROUP adeuxproductie;
COMMENT
86 matches
Mail list logo
