I found on http://www.madeasy.de/7/ext2.htm (in german)
ext2 can't have bigger files than 16GB if blocksize is 1k.
Ext3 is ext2 with journaling.
Rafael Martinez Guerrero wrote:
Hello
We are having problems with pg_dump.
We are trying to dump a 30GB+ database using pg_dump with the --file
option.
SELECT COALESCE(s_house,'') || COALESCE(s_post_dir,'') || COALESCE(s_street,'') ||
COALESCE(s_suffix,'') FROM parcels WHERE s_pin = '1201703303520';
Gregory S. Williamson schrieb:
This is postgres 7.4 on a linux box ...
I have driven myself to distraction trying to what ought to be easy.
I have a
CREATE TABLE cats_items (
cat_id int4 NOT NULL,
item_id int4 NOT NULL,
FOREIGN KEY (cat_id) REFERENCES cats (cat_id),
FOREIGN KEY (item_id) REFERENCES items (item_id),
PRIMARY KEY (cat_id, item_id)
);
CREATE TABLE items_master_cats (
cat_id int4 PRIMARY KEY
item_id int4
mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email <>'';
However I get loads of blank email addresses coming up
anyone any ideas
---(end of broadcast)
Maybe other whitspace or non-printable-character.
Try:
SELECT first_name, '[' || work_email || ']', ASCII(work_email) FROM tb_contacts WHERE
tb_contacts.work_email <>'';
mike wrote:
On Wed, 2005-02-02 at 11:31 +0100, Troels Arvin wrote:
On Wed, 02 Feb 2005 09:59:30 +, mike
I don`t know, if there is a special feature in postgresql for this.
The standard SQL-way is to create a lookup-table and define a foreign-key to it.
create table states( state_id int primary key not null
, state_text varchar(30) not null
, constraint uk_states_
I had postet a similar question some time ago.
Someone answerded me, in the next PostgreSQL
it would be possible to use nested transactions.
Is is now implemented in version 8.0-beta
You can set a savepoint before the insert that possible fails.
http://developer.postgresql.org/docs/postgres/sql-sa
t;COMMIT": SPI_ERROR_TRANSACTION
Is there an other way to execute tis function ?
If the latter, is it poosible in other languages like PL/Python or PL/Perl ?
regards
Michael Kleiser
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
