[GENERAL] Logging successful SELECTS?

Hi, I can get postgres to log unsuccessful queries, including the user who wrote them, but I'm missing how to get postgres to log the successful queries too (I don't need a store of the answer, just the query itself). How do I do this? Thanks, Matthew -- Matthew Vernon Quantitative

Re: [GENERAL] COPY FROM in psql

t...@sss.pgh.pa.us (Tom Lane) writes: > Matthew Vernon writes: >> naiively, you might try: >> \set pwd '\'' `pwd` '\'' >> COPY table FROM :pwd || '/relative/path/to/data' ; > > Umm ... why don't you just use a relative pat

Re: [GENERAL] COPY FROM in psql

Matthew Vernon writes: > naiively, you might try: > \set pwd '\'' `pwd` '\'' > COPY table FROM :pwd || '/relative/path/to/data' ; so I could do: \set path '\'' `pwd` '/path/to/data1' '\'' COPY table1 FROM

Re: [GENERAL] COPY FROM in psql

Matthew Vernon writes: > naiively, you might try: > \set pwd '\'' `pwd` '\'' > COPY table FROM :pwd || '/relative/path/to/data' ; I should also note that I want to run a series of these commands, hence setting pwd once and then wanting to us

[GENERAL] COPY FROM in psql

;\'' COPY table FROM :pwd || '/relative/path/to/data' ; but that doesn't work because the concatenation operator can't be used there. How should I be doing this? Thanks, Matthew -- Matthew Vernon Quantitative Veterinary Epidemiologist Epidemiology Research Unit,

[GENERAL] Replication with infrequent large updates

ation (via log shipping), or will I have to use slony? Thanks, Matthew -- Matthew Vernon Quantitative Veterinary Epidemiologist Epidemiology Research Unit, SAC Inverness -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

[GENERAL] Postgres connection error

Greetings, I keep getting the following error when attempting to establish a connection (from Perl): install_driver(Pg) failed: DBD::Pg object version undef does not match bootstrap parameter 2.2.2 at /usr/lib/perl/5.8/DynaLoader.pm line 245. Here's the body of code used to connect: sub db_

[GENERAL] Installation Instruction For Window

Where I can find the instruction on-line? I only see the UNIX/LINUX instruction. I installed PG on window before, but can't remember how it is done right now. BTW, is the 8.2 beta good for a development environment? Thanks, v

Re: [GENERAL] insert serial numbers

BEFORE INSERT OR UPDATE ON two FOR EACH ROW EXECUTE PROCEDURE return_one_id() Voila! -albert On 3.1.2006, at 14:36, Albert Vernon Smith wrote: I have two tables, listed as below. I'm inserting values for "text" into table "two" (which must already exist as "te

Re: [GENERAL] insert serial numbers

xt = two.mytext); On 3.1.2006, at 16:07, codeWarrior wrote: Don't use reserved words for column names. "Albert Vernon Smith" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I have two tables, listed as below. I'm inserting values for "text"

[GENERAL] insert serial numbers

I have two tables, listed as below. I'm inserting values for "text" into table "two" (which must already exist as "text" values in table "one"). When I do that, I'd like to also insert the associated "one_id" value from table "one" into the field "two.one_id". How is best to go about tha

Re: [GENERAL] optimizer not optimizing

Yes, I did an analyze, and see this behavior. -albert On 30.6.2005, at 20:39, Joshua D. Drake wrote: Albert Vernon Smith wrote: I am in process of migrating from Pg 7.4.5 to 8.0.3. I have the same data loaded in to the two. However, when I do a query on my 8.0.3 installation, I am

[GENERAL] optimizer not optimizing

I am in process of migrating from Pg 7.4.5 to 8.0.3. I have the same data loaded in to the two. However, when I do a query on my 8.0.3 installation, I am not getting a very well optimized query. (All the memory settings are equivalent.) On 8.0.3, I get the following query plan: dbsnp_b1

Re: [GENERAL] query plan in pg7.4 vs 8.0.3

I just re-checked, and all the same index definitions are on both tables. Cheers, -albert On 17.6.2005, at 14:20, Tom Lane wrote: Albert Vernon Smith <[EMAIL PROTECTED]> writes: I am in process of migrating a database from Pg 7.4.3 to Pg 8.0.3. I dumped and reloaded the data, and

[GENERAL] query plan in pg7.4 vs 8.0.3

I am in process of migrating a database from Pg 7.4.3 to Pg 8.0.3. I dumped and reloaded the data, and things look good, until I try to work with it. When I try to make a query to a view based on a large join (select * from 'view' limit 10), the 7.4.3 query works very well, and the indexe

[GENERAL] Command prompt window (8.0)

, which is the same outcome with a different user. How to bring up the command prompt correctly? Thanks, Vernon __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com

[GENERAL] Any easy ways to change configuration

Any easy ways to change the configuration or I need to uninstall and install the server? BTW, I would like to have the server works for Chinese in Window XP with Chinese language installed. Thanks, Vernon __ Do you Yahoo!? Yahoo! Small Busi

[GENERAL] Another help needed on Window client

I have tried to find out any document on the subject (that is the Window client) without success. I am wondering whether a file contains the readable authentication information or not. Thanks, Vernon __ Do you Yahoo!? Yahoo! Small Busi

[GENERAL] Command Prompt on Window version

. How to bring up the command prompt correctly? Also, is a way to bring it up with a different user from the user in configuration? Thanks, Vernon __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.co

[GENERAL] get_typdefault: failed to ...

Hi, Here is the case: mm=# delete from signon where user_id='210'; ERROR: get_typdefault: failed to lookup type 0 What is wrong here? A bug or something else. Thanks for your information. Vernon Get advanced SPAM fi

Re: [GENERAL] SAP DB: The unsung Open Source DB

IL PROTECTED] Cc: [EMAIL PROTECTED],Jean-Christian Imbeault <[EMAIL PROTECTED]> >On Thursday 24 July 2003 04:42, Mike Mascari wrote: >> Vernon Smith wrote: >> > The unknown is only in North American, but not in Europe. >> > That is what I learnt more than a year ago.

Re: [GENERAL] SAP DB: The unsung Open Source DB

The following statements is based on your own experience or not? >That's fine, but my understanding of SAP DB's failure to attract a large >community was that: > - it had a lot of competition (MySQL/PG/Firebird...) It is true that there are quite some open source free DBs out there. They, how

[GENERAL] The best way to change column data type in 7.2

I need to change a column of one table from int2 to int4. What is the best way to do it and retain the data in the 7.2 version? Thanks, Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com

[GENERAL] caching/ virtual file systems

A newbie question as I prepare to dive into this:   Under $PGDATA, can I expect to see subdirectories emerge within databases, say for INDICES, TABLES, etc?   The reason: On Solaris,   I have some RAM in /tmp I want to employ as a virtual file system to increase the performance of PG. I've mo

Re: [GENERAL] Re: Re: Need for newbie friendly docs (was Newbie struggling...)

Joel- In all fairness, there aren't any good HTML-based Unix tutorials. I've looked for them. In particular, Sun is worthless here, curious since their Java tutorial is (IMO) really well done. I'm hoping PostgreSQL is MORE stable than Oracle in our Solaris environment. The massive CPU/disk footp

[GENERAL] newbie ?'s

have integrity? What is the best strategy to study for backing up of databases that may be in use 7x24?   5) This seemingly full-fledged password overhead is worrisome. Is this tedious to manage in practice? Can the same (quasi-generic) user be reading the database from many simultaneous processes?   Clayton Vernon Houston, Texas