Re: [GENERAL] Restore/dump from "/usr/local/pgsql/data" directory

2010-09-23 Thread Bruce Momjian
o the new system. You really haven't given us much information on what problem you are having. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-gen

Re: [GENERAL] A note on pg_upgrade and missing "pg_upgrade_support.so"

2010-09-28 Thread Bruce Momjian
PostgreSQL cluster". The big problem was that the title said "Install pg_upgrade", but the detail had you installing two things, one of which was pg_upgrade. It was using pg_upgrade in both a generic sense, and in the /contrib/pg_upgrade sense, which is bound to confuse, as you sai

Re: [GENERAL] pg_upgrade

2010-09-28 Thread Bruce Momjian
x27;mit'; > oid | relname > + > 3000767630 | company > 3000767633 | company_history > (22 rows) > Interesting. Odd it would report the max 32-bit signed int. I wonder if it somehow is getting set to -1. I looked briefly at the pg_upgrade code and it a

Re: [GENERAL] pg_upgrade

2010-09-28 Thread Bruce Momjian
t; I think C90 and C99 specify different behaviors with atol > > Is there some standard way postgresql parses integer strings? Maybe that > method should be used instead of duplicating the functionality so at least > the two behave consistently. > > --brian > > On Sep

Re: [GENERAL] pg_upgrade

2010-09-28 Thread Bruce Momjian
Bruce Momjian wrote: > Brian Hirt wrote: > > It looks like it's related to atol > > Yep, I found the use of atol in the pg_upgrade code too. Working on a > patch now. I have applied the attached patch to HEAD and 9.0.X. Odd I had never received a bug report about this

Re: [GENERAL] pg_upgrade

2010-09-28 Thread Bruce Momjian
Brian Hirt wrote: > Bruce, > > The applied patch has the same behavior on i686 Ubuntu 10.04. It > looks like atol() is just a macro for strtol() in stdio.h. I think > you want strtoul() instead of strtol() Yes, thanks. I have now applied that fix in HEAD and 9.0.X. > when

Re: [GENERAL] SPACE FOR POSTGRESQL DATABASE

2008-07-14 Thread Bruce Momjian
> space in the db as it does in a flat file. that's just an > approximation. The actual size of each type etc is defined in the > other links in this thread. Folks, we have an FAQ about this: http://www.postgresql.org/docs/faqs.FAQ.html#item4.5 -- Bruce Momjia

Re: [GENERAL] statement timeout and pg_dump

2008-07-14 Thread Bruce Momjian
e pg_dump should disable > >> statement_timeout when it runs. > > > > You mean like this? > > > > http://archives.postgresql.org/pgsql-committers/2008-05/msg00026.php > > Very cool. I assume it's not in 8.3.3 then? No, because this is a functionality change, rather than

Re: [GENERAL] FAQ correction for Windows 2000/XP

2008-07-14 Thread Bruce Momjian
t; > > On Windows XP, however, there is no Control Panel applet for ODBC > management. The answer should read: > > "Go to Programs -> Administrative Tools -> Data Sources and Add the > PostgreSQL Unicode driver". Uh, I am not sure where you saw this FAQ but

Re: [GENERAL] FAQ correction for Windows 2000/XP

2008-07-15 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian escribi?: > > Dan Dascalescu wrote: > > > I'd like to submit a correction for question "2.1) How do I setup a > > > datasource?" in the FAQ. The existing text reads: > > > > > > "For Windows, us

Re: [GENERAL] Psql crashes with Segmentation fault on copy from

2008-07-15 Thread Bruce Momjian
size_t not int, but I have a feeling there are a lot of other similar > gotchas when running this code on a 64-bit machine. We use int > arithmetic an awful lot for stuff that probably should be size_t > or ssize_t ... I assume this is not a TODO item. -- Bruce Momjian <[EMAIL

Re: [GENERAL] TODO list and "hyphen"

2008-07-17 Thread Bruce Momjian
ill executed. Kill was never officially supported as a way to terminate a backend, but it will be in 8.4 and there is an SQL function to do it too. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your

Re: [GENERAL] TODO list and "hyphen"

2008-07-17 Thread Bruce Momjian
is complicated... it's obviously > used for a lot of other things... could you use another character? I think a search for ' -' will show you the items you want. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB

Re: [GENERAL] TODO list and "hyphen"

2008-07-18 Thread Bruce Momjian
Russ Brown wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Bruce Momjian wrote: > > Scara Maccai wrote: > >> Hi, > >> > >> I was looking at the TODO: > >> > >> http://www.postgresql.org/docs/faqs.TODO.html > >>

Re: [GENERAL] AT TIME ZONE and DST in UTC<->CET conversion

2008-08-22 Thread Bruce Momjian
ing and the other is using the timezone meaning. > > We don't have much control over the zone definition, so I'm thinking > maybe the abbrev should be removed from the tznames lists. But that > seems a bit sucky too. Does anyone have any idea if the zic folk would > be respo

Re: [GENERAL] log_statement not working on pl/pgsql functions

2008-09-05 Thread Bruce Momjian
gging every single query. By > the way, I'm using Postgresql 8.3.1 on window xp. > > Am I doing something wrong? The problem is that the checks for the statement type are done at the time the query arrives from the client, not while executing in a function. -- Bruce Momjian <[EMAI

Re: [GENERAL] Can I truncate statements in the log?

2008-09-06 Thread Bruce Momjian
and > ignore inserts. No, sorry. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@pos

Re: [GENERAL] Subqueries in Check() -- Still Intentionally Omitted?

2008-09-06 Thread Bruce Momjian
d optimize this into > something fast enough to be usable; but it's a research problem. > (The cases that I can see how to optimize are pretty much equivalent to > plain foreign key constraints, anyway.) Is this a TODO? I assume it is not. -- Bruce Momjian <[EMAIL PROTECTED

Re: [GENERAL] pg_dumpall problem when roles have default schemas

2008-09-17 Thread Bruce Momjian
| f| f | | | {search_path=asdf} (2 rows) The ALTER SET command is performed; it only generates a NOTICE. Is that the problem? (FYI, you emailed the Postgres general _owner_; that is not the right address for posting questions.

Re: [GENERAL] pg_start_backup() takes too long

2008-09-22 Thread Bruce Momjian
server logs or kernel logs show anything unusual? -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-gener

Re: Obfuscated stored procedures (was Re: [GENERAL] Oracle and Postgresql)

2008-09-23 Thread Bruce Momjian
any serious discussion with encryption starts here) > *) other things you can do with function source besides encryption > > for example, take a look at one idea I had (not at all vetted, but a start): > http://archives.postgresql.org/pgsql-performance/2007-12/msg00337.php > > me

Re: Obfuscated stored procedures (was Re: [GENERAL] Oracle and Postgresql)

2008-09-24 Thread Bruce Momjian
> C is not magic obfuscation gear. Anybody with a debugger can expose > what it's doing. There have been math papers showing that it's I bet 'strings' shows all the SQL queries in a C object file too. -- Bruce Momjian <[EMAIL PROTECTED]>http

Re: [GENERAL] Returning NEW in an on-delete trigger

2008-09-24 Thread Bruce Momjian
c patch that may clear up some of the confusion. Thanks, patch applied. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsq

Re: [GENERAL] Oracle and Postgresql

2008-09-25 Thread Bruce Momjian
it's output whether or not it > should allow a particular action. We were just talking today about adding column and row-level security to Postgres 8.4: http://archives.postgresql.org/pgsql-hackers/2008-09/msg01654.php -- Bruce Momjian <[EMAIL PROTECTED]>http:/

Re: [GENERAL] pg_start_backup() takes too long

2008-09-29 Thread Bruce Momjian
ate or leave the behavior unchanged. Personally I think immediate makes more sense because issuing pg_start_backup() seems like it should behave like a manual CHECKPOINT command. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB h

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-04 Thread Bruce Momjian
s there a way to avoid this problem without having to reset all passwords > or storing them in plain text? I don't know of a way to make MD5 and db_user_namespace work cleanly so we are considering removing db_user_namespace in 8.4. -- Bruce Momjian <[EMAIL PROTECTED]>

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-07 Thread Bruce Momjian
Alvaro Herrera wrote: > Tom Lane escribi?: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > I don't know of a way to make MD5 and db_user_namespace work cleanly so > > > we are considering removing db_user_namespace in 8.4. > > > > We are? It

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-14 Thread Bruce Momjian
t the backup module > should be ready to handle these situations in the future. No, I have no suggested workaround. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive,

Re: [GENERAL] Drupal and PostgreSQL - performance issues?

2008-10-15 Thread Bruce Momjian
>> detect other processes attached to a shmem block. > > > Didn't we solve this problem on Windows? > > Not terribly well --- see active thread on -hackers. We could allocate a small shared memory area to solve this and use mmap() for the other shared memory usage. --

Re: [GENERAL] PL/pgSQL stored procedure returning multiple result sets (SELECTs)?

2008-10-15 Thread Bruce Momjian
ain > precise info on the error type). > > > > That feature alone can help you enormously. Lest you think I'm > > biased, I dba a mysql box professionally...every time I pop into the > > mysql shell I feel like I'm stepping backwards in time about 5 years. >

Re: [GENERAL] Re: multi recordset and data type check was: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?

2008-10-15 Thread Bruce Momjian
> > > > Out of curiosity, what language are you using? > > For MySQL I've been mostly using PHP, occasionally Java, Python and C. Interesting. I think we need to decide if we want a TODO for this. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.

Re: [GENERAL] Annoying Reply-To

2008-10-23 Thread Bruce Momjian
y" going to the list and some have "reply" going to the author, I would have to think about the right reply option every time I send email. Fortunately, every email list I subscribe to and manage behaves like the Postgres lists. -- Bruce Momjian <[EMAIL PROTECTED]>

[GENERAL] UUID-OSSP Contrib Module Compilation Issue

2008-10-28 Thread Bruce McAlister
I have installed. Am I mising something here, or could the #ifdefs have something to do with it not picking up the newer ossp uuid defnitions? Any suggestions would be greatly appreciated. Thanks Bruce -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] UUID-OSSP Contrib Module Compilation Issue

2008-10-28 Thread Bruce McAlister
bin76784 Oct 28 15:33 /usr/lib/libuuid.so.16.0.22 Do I need to use a specific version of the ossp-uuid libraries for this module? Thanks Bruce -- 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] UUID-OSSP Contrib Module Compilation Issue

2008-10-28 Thread Bruce McAlister
> > Huh. Nothing obvious in your info about why it wouldn't work. I think > you'll need to dig through the config.log output to see why these link > tests are failing. (They'll be a few hundred lines above the end of the > log, because the last part of the log is always a dump of configure's >

Re: [GENERAL] UUID-OSSP Contrib Module Compilation Issue

2008-10-28 Thread Bruce McAlister
> > The 1.6.2 stable version which you use is right. > Thanks, we managed to get it working now. Thanks for the pointers. -- 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] UUID-OSSP Contrib Module Compilation Issue

2008-10-29 Thread Bruce McAlister
> > Bizarre ... I've never heard of a Unix system that didn't consider that > a default place to look. Unless this is a 64-bit machine and uuid > should have installed itself in /usr/lib64? > It is a rather peculiar issue, I also assumed that it would check the standard locations, but I thought

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

2008-10-31 Thread Bruce Momjian
t have the full page write copies of those pages to restore, and the compressed operating system might not be able to guarantee that the other parts of the file will be restored if only part of the 512 gets on disk. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us Enterprise

Re: [GENERAL] Decreasing WAL size effects

2008-11-01 Thread Bruce Momjian
e we want streaming archive logs, but there are still going to be people who are archiving for point-in-time recovery, and I assume a good number of them are going to compress their WAL files to save space, because they have to store a lot of them. Wouldn't zeroing out the trailing byte

Re: [GENERAL] GEQO randomness?

2008-11-04 Thread Bruce Momjian
rm that this is the case? Yes, "random" means random. > Is this really a good idea? Is non-deterministic behavior really > acceptable? I would think it would be much more sensible to have it > operate deterministically (such as with some predetermined random > sequence of numbers used re

Re: [GENERAL] Equivalent for AUTOINCREMENT?

2008-11-06 Thread Bruce Momjian
lem. > > If the INSERT fails, the SERIAL is in any case increased... > > So this was the reason, why I have tried to use max(serno) and add +1 > the get the next value for "serno". > > Is there a solution for it? You should read our three FAQ entries about

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-11-10 Thread Bruce Momjian
Bruce Momjian wrote: > Alvaro Herrera wrote: > > Tom Lane escribi?: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > I don't know of a way to make MD5 and db_user_namespace work cleanly so > > > > we are considering removing db_user_na

Re: List Ettiquette (perhaps Off Topic by now) was: Re: [GENERAL] Database access over the Internet...

2008-11-20 Thread Bruce Momjian
etting email help from us. Michelle is asking to be involved in this community and there are requirements for that involvement. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard d

Re: [GENERAL] compiling libpq.dll with Borland C++, is it possible?

2008-11-20 Thread Bruce Momjian
#x27;ret' in function > readdir > Error E2451 ..\..\port\dirent.c 109: Undefined symbol 'handle' in > function closedir > Error E2451 ..\..\port\dirent.c 110: Undefined symbol 'handle' in > function closedir > Error E2451 ..\..\port\dirent.c 111: Undefined sym

Re: [GENERAL] Question about the WITH RECURSIVE patch

2008-11-20 Thread Bruce Momjian
hing in the developer docs regarding them. Does that mean > they > won't make it or that simply the documentation isnt't yet there? The patch is still being reviewed for inclusion in 8.4. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB

Re: [GENERAL] Question about the WITH RECURSIVE patch

2008-11-20 Thread Bruce Momjian
Thomas Kellerer wrote: > Bruce Momjian wrote on 20.11.2008 22:56: > >> From http://umitanuki.net/pgsql/wfv08/design.html I got the impression > >> that > >> windowing functions will make into (at least partially) into 8.4 because > >> on that > &

Re: [GENERAL] Postgres mail list traffic over time

2008-11-20 Thread Bruce Momjian
d. I am going to post another blog tomorrow with more thoughts. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-gene

Re: [GENERAL] Postgres mail list traffic over time

2008-11-20 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> So, to a first approximation, the PG list traffic has been constant > >> since 2000. Not the result I expected. > > > I also was confused by its flatness. I am finding

Re: [GENERAL] Postgres mail list traffic over time

2008-11-21 Thread Bruce Momjian
brian wrote: > Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> > >> I am finding the email traffic > >> almost impossible to continue tracking, so something different is > >> happening, but it seems it is not volume-related. &g

Re: [GENERAL] Postgres mail list traffic over time

2008-11-21 Thread Bruce Momjian
Steve Crawford wrote: > Bruce Momjian wrote: > > brian wrote: > > > >> Tom Lane wrote: > >> > >> Perhaps it's just subjective: we're all getting older. > >> > Which, as "Dr. A" (aka Isaac Asimov) pointed ou

Re: [GENERAL] Postgres mail list traffic over time

2008-11-22 Thread Bruce Momjian
Ron Mayer wrote: > Joshua D. Drake wrote: > > On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote: > >> Bruce Momjian wrote: > >>> Tom Lane wrote: > >>>> ... harder to keep > >>>> up with the list traffic; so something is happening that a

Re: [GENERAL] Postgres mail list traffic over time

2008-11-22 Thread Bruce Momjian
Magnus Hagander wrote: > Bruce Momjian wrote: > > Ron Mayer wrote: > >> Joshua D. Drake wrote: > >>> On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote: > >>>> Bruce Momjian wrote: > >>>>> Tom Lane wrote: > >>>>>>

Re: [GENERAL] Postgres mail list traffic over time

2008-12-02 Thread Bruce Momjian
othing for backbranches. > > So, if you can be a bit more specific in what you want :) Attached is > for example "commits per month" and "lines per month". Yea, this is the graph I was looking for; unfortunately it does not shed any insight on why things seems busier;

Re: [GENERAL] Monty on MySQL 5.1: "Oops, we did it again"

2008-12-03 Thread Bruce Momjian
rs ago when the default table type did not have > transactions and subqueries were not existent. The features I was > looking for were already in PostgreSQL for several versions. > > I am surprised to see such an honest post regarding MySQL. Monty is quite suppor

Re: [GENERAL] posible BUG on psql... or maybe worst

2008-12-06 Thread Bruce Momjian
described. Yes, \dt was designed that way, and *.name is the proper way to show tables in all schemas. -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be you

Re: [GENERAL] Absolute value of intervals

2009-11-10 Thread Bruce Momjian
t about why there is no interval_abs(): it is unclear what value to return: http://archives.postgresql.org/pgsql-general/2009-10/msg01031.php http://archives.postgresql.org/pgsql-general/2009-11/msg00041.php -- Bruce Momjian http://momjian.us

Re: [GENERAL] Where do you store key for encryption

2009-11-28 Thread Bruce Momjian
a password, which is the most basic way to go if > you don't have a keystore to use. I covered this a little bit in my recent security presentation: http://momjian.us/main/presentations.html#securing -- Bruce Momjian http://momjian.us EnterpriseDB

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

2009-11-29 Thread Bruce Momjian
to see the inserts or updates since these may > have sensitive data like credit card data which I don't want logged in > the logs. I really don't even care if the SELECT was successful or not, > or what the results of the SELECT were. No, log_statement doesn't allow d

Re: [GENERAL] Catastrophic changes to PostgreSQL 8.4

2009-12-03 Thread Bruce Momjian
Kern Sibbald wrote: > Hello, > > Thanks for all the answers; I am a bit overwhelmed by the number, so I am > going to try to answer everyone in one email. We aim to please, and overwhelm. :-) -- Bruce Momjian http://momjian.us EnterpriseDB

[GENERAL] Installing PL/pgSQL by default

2009-12-03 Thread Bruce Momjian
roplang: language removal failed: ERROR: cannot drop language plpgsql because it is required by the database system I assume we still want to allow the language to be uninstalled, for security purposes. Right? Any suggestions? -- Bruce Momjian http://

Re: [GENERAL] Installing PL/pgSQL by default

2009-12-03 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > One problem is that because system oids are used, it isn't possible to > > drop the language: > > I assume we still want to allow the language to be uninstalled, for > > security purposes. > > Yes. That behavior i

Re: [GENERAL] Installing PL/pgSQL by default

2009-12-03 Thread Bruce Momjian
Andrew Dunstan wrote: > > > Tom Lane wrote: > > Bruce Momjian writes: > > > >> One problem is that because system oids are used, it isn't possible to > >> drop the language: > >> I assume we still want to allow the language to be uninstall

Re: [GENERAL] Installing PL/pgSQL by default

2009-12-08 Thread Bruce Momjian
LANGUAGE plpgsql; ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres; What is odd is that I used the same process that initdb uses to create other objects. Does anyone know why this is happening? -- Bruce Momjian http://momjian.us EnterpriseDB

Re: [HACKERS] [GENERAL] Installing PL/pgSQL by default

2009-12-10 Thread Bruce Momjian
do this > in initdb, filling in template0: > CREATE EXTENSION plpgsql ...; > > Then at createdb time, what would become automatic is: > INSTALL EXTENSION plpgsql; > > And that's it. pg_dump would now about extensions and only issues this > latter statement in its dump. >

Re: [GENERAL] Installing PL/pgSQL by default

2009-12-11 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > I installed PL/pgSQL by default via initdb with the attached patch. The > > only problem is that pg_dump still dumps out the language creation: > > CREATE PROCEDURAL LANGUAGE plpgsql; > > ALTER PROCEDURAL LANGUAG

Re: [GENERAL] How to remove non-UTF values from a table?

2009-12-17 Thread Bruce Momjian
ere has been no work done that would > make it any more reliable for 8.5. I do not share Tom's conclusions. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup.

Re: [GENERAL] How to remove non-UTF values from a table?

2009-12-17 Thread Bruce Momjian
fined array data type o a user-defined enum data type So, pg_migrator is a work in progress. It current requires migration testing and should be used by experienced Postgres users. Someday pg_migrator will be easier to use and more reliable. -- Bruce Momjian http://momjian.

Re: [GENERAL] How to remove non-UTF values from a table?

2009-12-17 Thread Bruce Momjian
Bruce Momjian wrote: > pg_migrator (not pg_upgrade) has been used by many people to migrate > from 8.3 to 8.4. I just helped someone yesterday with a migration. > pg_migrator threw an error because they had reindexed pg_largeobject, > and pg_migrator was not prepared to handle that

Re: [GENERAL] Installing PL/pgSQL by default

2009-12-17 Thread Bruce Momjian
Bruce Momjian wrote: > Tom Lane wrote: > > Bruce Momjian writes: > > > I installed PL/pgSQL by default via initdb with the attached patch. The > > > only problem is that pg_dump still dumps out the language creation: > > > CREATE PROCEDURAL LANGUAGE plpgsq

Re: [GENERAL] How to remove non-UTF values from a table?

2009-12-18 Thread Bruce Momjian
Phoenix Kiula wrote: > On Fri, Dec 18, 2009 at 3:54 AM, Bruce Momjian wrote: > > Bruce Momjian wrote: > >> pg_migrator (not pg_upgrade) has been used by many people to migrate > >> from 8.3 to 8.4. ?I just helped someone yesterday with a migration. > >> pg_migr

Re: [GENERAL] When is the release date for Postgres 8.5?

2010-01-22 Thread Bruce Momjian
A. Kretschmer wrote: > In response to DM : > > Hello All, > > > > When is the release date for Postgres 8.5? > > Never. > > The next version will be 9.0, released when it is ready for production. Yea, we are months away from a new major release. -- Bruce M

Re: [GENERAL] varchar(n) and text

2010-02-03 Thread Bruce Momjian
ort answer is that there is no different for any of them in any areas, except documented behavior, e.g. char(10) is always output as 10 characters. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Chris

Re: [GENERAL] \dt+ sizes don't include TOAST data

2010-02-05 Thread Bruce Momjian
plus toast items. It would be a > bit slower, but the normal case of using the same server version would > be fast. Added to TODO: Consider showing TOAST and index sizes in \dt+ * http://archives.postgresql.org/pgsql-general/2010-01/msg00912.php -- Bruce Momjian http://momjia

Re: [GENERAL] possible bug with inheritance?

2010-02-16 Thread Bruce Momjian
the 'not null' - > constraint are in the child-table, in other case they are not. > > Version 8.4.2. > > Bug, feature? What have i overlooked? > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> H

Re: [GENERAL] Postgres physical directory structure meaning

2010-02-16 Thread Bruce Momjian
nt > > the > > doc link. > > http://www.postgresql.org/docs/8.4/interactive/storage.html > > Read there and the sub-chapters. Yea, "base" was chosen because that makes the directory hierarchy "/data/base", e.g. "database". -- Bruce Momj

Re: [GENERAL] Possible causes for database corruption and solutions

2010-02-19 Thread Bruce Momjian
drant Baltimore, MD > PostgreSQL Training, Services and Support > g...@2ndquadrant.com www.2ndQuadrant.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pg

Re: [GENERAL] Un successful Restoration of DATA using WAL files

2010-02-22 Thread Bruce Momjian
es of writes of byte sequences to > offsets within files in the cluster. A new cluster (or a new > database created in the original cluster by CREATE DATABASE) > will have a different layout in its files, so the WAL archives > don't mak

Re: [GENERAL] Info about concurrent sequential scans

2010-02-22 Thread Bruce Momjian
ng, > query characteristic, etc.)? > Is there any feedback showing the feature kicking in (e.g. an explain > analyze output, log, etc.)? The feature is called 'synchronize_seqscans' and was implemented in Postgres 8.3. -- Bruce Momjian http://momjian.u

Re: [GENERAL] COPY command character set

2010-02-22 Thread Bruce Momjian
urrent client encoding, > > even > > if the data does not pass through the client but is read from or > > written to a file. > > > > Seems clear enough to me. > > > > regards, tom lane > > Maybe the link might help? >

Re: [GENERAL] comment on constraint

2010-02-22 Thread Bruce Momjian
gresql.org/pgsql-general/2003-07/msg01448.php > > I think, this is a bug, isn't it? Yep, added to TODO: Allow \dd to show constraint comments -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://ww

Re: [GENERAL] COPY command character set

2010-02-22 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > I have updated the documentation to be more direct about COPY encoding > > behavior. Patch attached and applied. > > Uh, why exactly do you find that better? "Processes data" seems a lot > vaguer to me than the pr

Re: [GENERAL] COPY command character set

2010-02-23 Thread Bruce Momjian
Peter Headland wrote: > In respect of Bruce's proposed changes, I prefer the original wording > (for the same reasons as Tom), but with the addition of the mention of > the server - "... read from or written to a file directly by the > server". OK, done with the a

Re: [GENERAL] After each row trigger NOT seeing data changes?

2010-02-25 Thread Bruce Momjian
eople have been bit by this, then maybe ... comments anyone? I have applied the attached documentation patch to subtly mention this issue. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/co

Re: [GENERAL] trouble with to_char('L')

2010-02-25 Thread Bruce Momjian
> *** > *** 437,442 > --- 511,524 > CurrentLocaleConv.n_sign_posn = extlconv->n_sign_posn; > > /* Try to restore internal settings */ > + #ifdef WIN32 > + #undef strdup > + if (lc_ctype_change) > +

Re: [GENERAL] trouble with to_char('L')

2010-02-25 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Where are we on this issue? > > According to my files, I complained about the extreme ugliness of the > patch (redefining strdup for pete's sake) and the fact that it did not > actually do things anything like the LC_TIME code

Re: [GENERAL] trouble with to_char('L')

2010-02-25 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Right, but you are saying it is still an open issue, which says we > > should look at it. > > Sure. Maybe put it on TODO? OK, TODO is: Fix locale-aware handling (e.g. monetary) for specific server/client

Re: [GENERAL] trouble with to_char('L')

2010-02-25 Thread Bruce Momjian
Hiroshi Inoue wrote: > Bruce Momjian wrote: > > Where are we on this issue? > > Oops I forgot it completely. > I have a little improved version and would post it tonight. Ah, very good. Thanks. -- Bruce Momjian http://momjian.us EnterpriseDB

Re: [GENERAL] trouble with to_char('L')

2010-02-27 Thread Bruce Momjian
Hiroshi Inoue wrote: > Bruce Momjian wrote: > > Hiroshi Inoue wrote: > >> Bruce Momjian wrote: > >>> Where are we on this issue? > >> Oops I forgot it completely. > >> I have a little improved version and would post it tonight. > > > >

Re: [GENERAL] non intuitive behaviour of DROP TABLE IF EXISTS

2010-03-06 Thread Bruce Momjian
l if the schema does not exist Hmm. Well, it says TABLE IF EXISTS, not TABLE AND SCHEMA IF EXISTS. ;-) Not sure if it makes sense to change it. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.c

Re: [GENERAL] XML performance tuning

2010-03-06 Thread Bruce Momjian
Chris Roffler wrote: > Are there any guidelines for XML performance tuning ? Uh, no, I have never seen any. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010

Re: [GENERAL] log_statement and syslog severity

2010-03-06 Thread Bruce Momjian
red, for easy and performant redirection of just my > logged statements? Our logging system is very flexible, but not work-free on the user end. I don't see us changing things in that area. -- Bruce Momjian http://momjian.us EnterpriseDB http://

Re: [GENERAL] log_statement and syslog severity

2010-03-09 Thread Bruce Momjian
Greg Sabino Mullane wrote: > Bruce replied: > ... > >> This means that, even using syslog as a destination, it's not possible for > >> me to filter statements without some sort of log-text parsing, which I'd > >> prefer to avoid on effort, performance and

Re: [GENERAL] log_statement and syslog severity

2010-03-10 Thread Bruce Momjian
Stuart Bishop wrote: -- Start of PGP signed section. > > > On Wed, Mar 10, 2010 at 8:51 AM, Bruce Momjian wrote: > > Greg Sabino Mullane wrote: > >> Bruce replied: > >> ... > >> >> This means that, even using syslog as a destination, it&

Re: [GENERAL] How to remove superuser

2010-03-12 Thread Bruce Momjian
Also, you can do: NET USER postgres /delete as an administrator. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-general mailin

Re: [GENERAL] hardware for a server

2010-03-15 Thread Bruce Momjian
t seems we have a clear consensus on this and we should document this. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-general mailing list (p

Re: [GENERAL] Move to core xml from contrib/xml2

2010-03-15 Thread Bruce Momjian
; core xml support in the manuals or anywhere in the net. We have fixed the serious bugs in /contrib/xml2 with the minor releases that came out today, 2010-03-15. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.en

Re: [GENERAL] hardware for a server

2010-03-16 Thread Bruce Momjian
Greg Smith wrote: > Bruce Momjian wrote: > > Greg Smith wrote: > > > >> Given what you've said about your budget here, I suspect that you're > >> heading toward either 3ware or LSI and all SATA drives. I wouldn't > >> expect that bi

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

2010-03-31 Thread Bruce Momjian
nd if so, what is it? If it was rejected due to some > filter, it would be desirable (and polite) if the recepient was told what > happened. The bottom line is that this email list is best at answering short, detailed questions. Larger questions that require a lot of analysis by reader

Re: [GENERAL] prevent connection using pgpass.conf

2010-04-12 Thread Bruce Momjian
> - is there any options that can be set in postgres libpq C library to > > prevent the connection functions to search for password in files ? > > No, but you could possibly set the PGPASSFILE environment variable to > a place where you *know* there won't be a pgpass file, if

Re: [GENERAL] Wikipedia entry - AmigaOS port - error?

2010-04-12 Thread Bruce Momjian
t it). So that > pretty much kills any thought that it might've once worked and we just > forgot. I have removed the Amiga support mention for Postgres from Wikipedia: http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Operating_syst

<    2   3   4   5   6   7   8   9   10   11   >