[ADMIN] idle in transaction with mod_perl

corrupt my DB or worst still bring down my server? I appreciate any help. Thanks, Kostis ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] duplicates

Tsirkin Evgeny wrote: yes i understand that i can create a primary key/unique etc... however my question is if i have to understand if and why the i got duplicate rows inserted. so here is the picture: an application is deleting rows and inserting right after that new ones some of which are the sam

Re: [ADMIN] duplicates

No, you should lock the table. I mean that you can select or insert into that table even if a transaction is running. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] Alternate db location

I believe that su user -c command throws away the environment su - user -c command executes the user .profile Tom Lane wrote: "Bender, Cheryl" <[EMAIL PROTECTED]> writes: I need to add an alternate db location for my 7.3.4 server (running on FreeBSD 5.2 Release) I thought I did everything according

[ADMIN] convert char to varchar

ypes on v1 to character and then back to character varying the trailing spaces disappears and the above selection is ok. Is there any other way to clear trailing spaces when I restore the table? regards, kostis. ---(end of broadcast)--- TIP 6: explain analyze is your friend

[ADMIN] Re: how to get all system views and connections

guard wrote: > > thanks > > -- what was the reply? can you please send it to newsgroup? kostis. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] exclude a table from pg_dump

Hi all, is it possible to exclude a table from being pg_dumped?   In my case I need to backup everything except one table that is very large and I want to pg_dump it later   regards, kostis.