Re: [GENERAL] use log_statement to log only SELECTs?

Brian Witt wrote: > Hi, > > I've been looking for a way to use log_statement to log only select > statements; is this possible? (I'm using PostgreSQL 8.1.18) > > I'd like to know if someone tried to read the data back from the > database, but don't care to see the inserts or updates since these

Re: [GENERAL] vacuumdb -z do a reindex?

Hi Scott, On Sat, Nov 28, 2009 at 3:12 PM, Irene Barg wrote: > Hi Scott, > > Scott Marlowe wrote: >> >> On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg wrote: >>> >>> I've had a simple update running for over 4 hours now (see results from >>> pg_top below). The sql is: >> >> Have you looked in

[GENERAL] duplicating a schema

I need to create a new schema with all the content in an existing one, just with a new name. The way I've found is: - make a backup - load it in a dev box - rename the schema - make a backup of the new schema - restore the new schema on the original DB. Is there a more efficient approach? -- Iv

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

On 28/11/2009 7:10 PM, Magnus Hagander wrote: On Sat, Nov 28, 2009 at 11:53, Leonardo Camargo wrote: Hi all, I'm wondering if someone here know how to go about fixing this problem that apparently affects everyone who manually install Postgresql8.4 on Ubuntu Karmic(9.10). Postgres installation

Re: [GENERAL] Time zone 'GMT+8'

there are 3 terms which refer to GMT GMT in the UK Zulu time for aviators UTC for Scientific measurements UTC is now replacing 'Zulu' and 'GMT' for 0 time references http://wwp.greenwichmeantime.com/info/zulu.htm Martin Gainty __ Verzicht und Vertrau

Re: [GENERAL] [BUGS] BUG #5218: Easy strategic feature requests

On 29/11/2009 6:34 AM, Russell Wallace wrote: (There wasn't a separate form for feature requests, so I'm assuming that like most projects, this one files them together with bugs, please let me know if that is not the case.) http://wiki.postgresql.org/wiki/Todo ... but it's generally preferred

Re: [GENERAL] [BUGS] BUG #5218: Easy strategic feature requests

On Sun, Nov 29, 2009 at 1:57 PM, Craig Ringer wrote: > Rather than implementing SHOW (blah) as wrappers for selects from views in > the backend, though, IMO it'd make a lot more sense to provide minimal stubs > that raised an exception telling the user the right way to do it. > > "SHOW TABLES is a

Re: [GENERAL] Time zone 'GMT+8'

silly writes: >> From >> http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES > Another issue to keep in mind is that in POSIX time zone names, > positive offsets are used for locations west of Greenwich. Yeah, we're caught between two incompatible convent

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

> So - just use rpath linkage for your added libraries, storing them in a > private directory. Please. Argh. It's worse than I hoped. Libraries the One-Click installer tramples all over include: libxml2 libssl libcrypto libreadline libtermcap libuuid ... all of which have the

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

Libraries the One-Click installer tramples all over include: libxml2 libssl libcrypto libreadline libtermcap libuuid Apart from libxml2 (which is now being fixed) all other libraries you mentioned , dint get installed (or copied) to the PGHOME/lib directory if the

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

On Sun, Nov 29, 2009 at 16:18, Sachin Srivastava wrote: > > Libraries the One-Click installer tramples all over include: > >libxml2 >libssl >libcrypto >libreadline >libtermcap >libuuid > > > Apart from libxml2 (which is now being fixed) all other libraries you > mentioned ,

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

On Sun, Nov 29, 2009 at 4:17 PM, Magnus Hagander wrote: > On Sun, Nov 29, 2009 at 16:18, Sachin Srivastava > wrote: >> Apart from libxml2 (which is now being fixed) all other libraries you >> mentioned , dint get installed (or copied) to the PGHOME/lib directory if >> the same name library alrea

Re: [GENERAL] 8.45.1 on mac - Plist problems

>PGDATA is /usr/local/postgres/data But you pass /usr/local/postgresql-8.4.1/bin as the data directory? In the future, two things to try: - Examine pg's logfile; would probably have alerted you to the problem. - Look in the console for error messages from launchd (and add Debug to the plist

[GENERAL] Help, server cannot start anymore

Hi, i recently migrated from mysql to postgres and i might have made a no-no in that process. bascily i want/need a selfcontained folder \database where i can zip that directory move it anywhere, unzip and carry on my busniess with no dependencies. Postgres presented me with a challenge in this reg

[GENERAL] Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

What is this? PANIC: corrupted item lengths: total 8192, available space 8068 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Help, server cannot start anymore

Solved. For now. -> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No such file or directory I copied this folder from another postgres installation i did some months back on another system and wham, up and running agan. weird. -- On Sun, Nov 29, 2009 at 11:27 AM, CyTG wro

Re: [GENERAL] Date with time zone

On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver wrote: > On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote: > > Hi Adrian, thanks for your answer. > > > > I see current criteria and all the SQL-standard compliance policy, but > > wouldn't it still make sense to be able to store a date

Re: [GENERAL] Date with time zone

On Sunday 29 November 2009 2:38:43 pm Eduardo Piombino wrote: > On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver wrote: > > On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote: > > > Hi Adrian, thanks for your answer. > > > > > > I see current criteria and all the SQL-standard compliance

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

Magnus Hagander wrote: > On Sun, Nov 29, 2009 at 16:18, Sachin Srivastava > wrote: >> Libraries the One-Click installer tramples all over include: >> >>libxml2 >>libssl >>libcrypto >>libreadline >>libtermcap >>libuuid >> >> >> Apart from libxml2 (which is now being fixed) a

Re: [GENERAL] Date with time zone

On Sun, Nov 29, 2009 at 8:23 PM, Adrian Klaver wrote: > On Sunday 29 November 2009 2:38:43 pm Eduardo Piombino wrote: > > On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver > wrote: > > > On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote: > > > > Hi Adrian, thanks for your answer. > > >

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

Greg Stark wrote: > But i don't see what the conflict is if they're installed in > PGHOME/lib as long as the installer doesn't fiddle with > /etc/ld.so.conf or set any environment variables. The binaries should > just be built with an rpath pointing to that directory or ship with a > startup scrip

Re: [GENERAL] Access a Field / Column of a resultset by Number

In response to Daniel Schuchardt : > hy group, > > i currently look for a solution to access a resultset in a db-stored > function by number. in plpgsql thats not possible. Can you wait until 8.5? http://okbob.blogspot.com/2009/10/dynamic-access-to-record-fields-in.html Regards, Andreas --

[GENERAL] Fwd: psql+krb5

-- Forwarded message -- From: rahimeh khodadadi Date: 2009/11/29 Subject: Re: psql+krb5 To: Denis Feklushkin These items have added after my sending. I repeat again my configurations: * 1) The configuration of krb5.conf is: [realms] EXAMPLE.COM ={

Re: [GENERAL] Postgres 8.4

2009/11/29 Yasser Shakoor : > Hi > I am using postgres 8.4 but couldnot able to use the OLAP functionality can > you please advice do i have apply any patch for this. > I am using postgres on windows and downloaded the latest version from > Enterprise DB site. > Regards, > Yasser What exactly is "