[GENERAL] Database design question: ugliness or referential integrity?

r, perhaps). Basically, store the deleted email accounts in another table... but then we lose the referential integrity check in "emails_log". The question is: what would you do? (I don't really like the idea of creating yet another "dead_emails_log" table pointing to &quo

[GENERAL] Perfomance difference between 7.2 and 7.3

ference (7.2 vs. 7.3) account for all of it? Or should I start looking at other factors? As I said, both machines are almost equivalent hardware-wise, and as for the number of shared buffers, the faster machine actually has less of them (the 7.3 machine has "shared_buffers = 768", while the 7.2 one has "shared_buffers = 1024"). Paulo Jan. DDnet. ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] existing but not-existing database.

ojamon database?? > You should have deleted the database with "destroydb". Now you can edit "by hand" the pg_database table, which is the system table where the available databases are stored. Use standard SQL commands like "SELECT * FROM pg_database" and etc. to delete the entry for your database. Paulo Jan. DDnet.

Re: [GENERAL] "Tuple is too big"

beyond the maximum size, while still taking technically just one byte? (Some of the inserted texts were Front Page-generated HTML, and had all kinds of tabs, return carriages and such). Paulo Jan. DDnet.

[GENERAL] "Tuple too big" when the tuple is not that big...

-Everytime I try to do a "\d (table)", Postgres dumps core with the "backend closed the channel unexpectedly". Any ideas? (Aside of upgrading to 7.x; we can't do that for now). Do you need any other information?

[GENERAL] Creating numeric type by hand?

ossible causes for this error, I'd be grateful too). Paulo Jan. DDnet.

[GENERAL] Cannot find attribute of relation...

e pointers? Thanks in advance, Paulo Jan. DDnet.

[GENERAL] System tables

lds the information about blah blah..."). Sorry for the rant-like nature of this post, but in any case... can anybody help? And while we're on this, what do people here do in cases like what I have described above? Paulo Jan. DDnet.

[GENERAL] pg_operator corrupted... Any ideas?

and it said: "An error occured! connectDB() -- connect() failed: Operation timed out Is the postmaster running (with -i) at'pgsql.tht.net' and accepting connections on TCP/IP port '5432'?"). Paulo Jan. DDnet.

[GENERAL] Recovering data from binary files?

ments to counter him... Paulo Jan. DDnet.

[GENERAL] Miracle

he database was succesfully recovered. Thanks a lot. Paulo Jan. DDnet.