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 may
Hi Scott,
On Sat, Nov 28, 2009 at 3:12 PM, Irene Barg ib...@noao.edu wrote:
Hi Scott,
Scott Marlowe wrote:
On Fri, Nov 27, 2009 at 2:17 PM, Irene Barg ib...@noao.edu wrote:
I've had a simple update running for over 4 hours now (see results from
pg_top below). The sql is:
Have you
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?
--
On 28/11/2009 7:10 PM, Magnus Hagander wrote:
On Sat, Nov 28, 2009 at 11:53, Leonardo Camargo
camargoleona...@gmail.com 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
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
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
On Sun, Nov 29, 2009 at 1:57 PM, Craig Ringer
cr...@postnewspapers.com.au 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
silly silly8...@gmail.com 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
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
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
On Sun, Nov 29, 2009 at 16:18, Sachin Srivastava
sachin.srivast...@enterprisedb.com 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
On Sun, Nov 29, 2009 at 4:17 PM, Magnus Hagander mag...@hagander.net wrote:
On Sun, Nov 29, 2009 at 16:18, Sachin Srivastava
sachin.srivast...@enterprisedb.com wrote:
Apart from libxml2 (which is now being fixed) all other libraries you
mentioned , dint get installed (or copied) to the
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
keyDebug/keytrue/
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
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
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
On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver akla...@comcast.net 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
On Sunday 29 November 2009 2:38:43 pm Eduardo Piombino wrote:
On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver akla...@comcast.net 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
Magnus Hagander wrote:
On Sun, Nov 29, 2009 at 16:18, Sachin Srivastava
sachin.srivast...@enterprisedb.com wrote:
Libraries the One-Click installer tramples all over include:
libxml2
libssl
libcrypto
libreadline
libtermcap
libuuid
Apart from libxml2 (which is now
On Sun, Nov 29, 2009 at 8:23 PM, Adrian Klaver akla...@comcast.net wrote:
On Sunday 29 November 2009 2:38:43 pm Eduardo Piombino wrote:
On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver akla...@comcast.net
wrote:
On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote:
Hi Adrian,
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 script
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
--
-- Forwarded message --
From: rahimeh khodadadi rahimeh.khodad...@gmail.com
Date: 2009/11/29
Subject: Re: psql+krb5
To: Denis Feklushkin denis.feklush...@gmail.com
These items have added after my sending.
I repeat again my configurations:
*
1) The configuration of krb5.conf
2009/11/29 Yasser Shakoor yassershak...@gmail.com:
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
24 matches
Mail list logo