Re: [GENERAL] documentation vs reality: template databases

2007-01-20 Thread Bruce Momjian
taiton mention that 'datistemplate' must be changed to 'false' to allow deletion. Backpatched to 8.2.X. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + Index: doc/src/sgml/

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-19 Thread Bruce Momjian
--- > Network with peers, keep pace with technology : > Technical community: http://www.sun.com/boardroom > Executive community: http://www.sun.com/innercircle > "The box said 'Windows Server 2003 or better', so I inst

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-19 Thread Bruce Momjian
cial accounting close) can be > > specified. > > Another thought, is it at all possible to do a partial vacuum? ie spend the > next 30 minutes vacuuming foo table, and update the fsm with what hew have > learned over the 30 mins, even if we have not done a full table scan ? &

Re: [GENERAL] ORDER BY col is NULL in UNION causes error?

2007-01-12 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian wrote: > > > Here the column result is an expression, and you reference that. > > Updated wording: > > > > test=> select * from test union select * from test order by x is null; > > ERROR: A UNION/INTERSECT/EX

Re: [GENERAL] ORDER BY col is NULL in UNION causes error?

2007-01-11 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Updated wording: > > > test=> select * from test union select * from test order by x is null; > > ERROR: A UNION/INTERSECT/EXCEPT ORDER BY cannot use expressions or > > functions, only resu

Re: [GENERAL] ORDER BY col is NULL in UNION causes error?

2007-01-11 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Well, it can be an expression _if_ the expression _matches_ an existing > > UNION column. > > You're mistaken. It has to be *an output column name*. Not anything else. Yea, I was thinking of this:

Re: [GENERAL] Trying to load MySQL data

2007-01-11 Thread Bruce Momjian
^INSERT | psql [yadda] Wow, mysqldump has a postgresql compatibility mode? Intersting. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)

Re: [GENERAL] ORDER BY col is NULL in UNION causes error?

2007-01-11 Thread Bruce Momjian
CEPT result must match existing result > columns and not be an expression"))); Well, it can be an expression _if_ the expression _matches_ an existing UNION column. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your l

Re: [GENERAL] ORDER BY col is NULL in UNION causes error?

2007-01-11 Thread Bruce Momjian
item has to be just a simple column name of the UNION output". Anyone > have a suggestion for better wording? I have updated the wording from "ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns"))); to: "ORDER BY on a UNION/INTERS

Re: [GENERAL] How does one perform a case-insenstive query on

2007-01-10 Thread Bruce Momjian
though - if what you're looking to do is look for any row where > thisfield contains 'some text' somewhere within it then that's an > entirely different thing and you'd want "... ilke '%some text%';" > > Cheers, >Steve > > ----

Re: [GENERAL] Postgres Differential backup

2007-01-08 Thread Bruce Momjian
Bill Moran wrote: > In response to "Vijayaram Boopalan - TLS , Chennai" <[EMAIL PROTECTED]>: > > > > I do not kb=3Dnow how to take differential= > > database backup in postgre 8.1.5. > > What on Earth is wrong with your MUA? For some reason I thought th

Re: [GENERAL] More activity in pg_stat_activity

2007-01-05 Thread Bruce Momjian
eem that this is due to some fine tuning > somewhere on th backside of 8.2 versus previous versions. Was there > previously a more limited precision to the query lengths that would be > picked up by the pg_stat_activity view? 8.2 gives a much more up-to-date list of active queries than pr

Re: [GENERAL] Clustering & Load Balancing & Replication

2006-12-23 Thread Bruce Momjian
x.html > Please keep in mind, its new and written by a novice out of desparation, not > one of the community super geeks, but it takes a very pragmatic approach to > replication and maybe just what the doctor ordered Good Luck. > -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBh

Re: [GENERAL] Autovacuum Improvements

2006-12-19 Thread Bruce Momjian
al way that can accommodate a > wide variety of usage patterns. I wonder if the simple solution is to just have a cron script modify postgresql.conf and pg_ctl reload. That seems very flexible, or have two postgresql.conf files and move them into place via cron. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Autovacuum Improvements

2006-12-19 Thread Bruce Momjian
Alvaro Herrera wrote: > Chris Browne wrote: > > matthew@zeut.net ("Matthew O'Connor") writes: > > > > > Bruce Momjian wrote: > > >> Yes, I think there are these TODO items. I was waiting to see what > > >> additional replies there ar

Re: [GENERAL] Autovacuum Improvements (was: Second attempt,

2006-12-19 Thread Bruce Momjian
> discourage) autovacuum from doing maintenance work during normal > business hours either for the entire system or for specific tables. > > None of those three items are on the todo list, however I think there is > general consensus that they (at least 1 & 3) are good ideas. > > >

Re: [GENERAL] Subcribing to this list, what's the secret?

2006-12-16 Thread Bruce Momjian
orked too. Interestingly, I can't find your previous email that I saw in our archives, or in google archives. What email address where you trying? -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your back

Re: [GENERAL] a question on SQL

2006-12-13 Thread Bruce Momjian
dded the limit option. This was interesting in the MySQL manuals: For compatibility with PostgreSQL, MySQL also supports the LIMIT row_count OFFSET offset syntax. Did we add the OFFSET _keyword_. I remember we had the comma-ed numbers backwards, and we had OFFSET, but I thought that

Re: [GENERAL] forcing compression of text field

2006-12-13 Thread Bruce Momjian
that the > field values you need to store are on the order of a few KB. See ALTER TABLE ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ

Re: [GENERAL] ALTER TABLE RENAME and primary key

2006-12-13 Thread Bruce Momjian
t think so - my understanding is that > database objects are represented internally as OIDs, so renaming the > object changes only the name and not the OID. We worked very hard to prevent renaming from affecting the behavior of any objects. -- Bruce Momjian [EMAIL PROTECTED] Enterp

Re: [GENERAL] Marking indexes out of date (WAS: loading data,

2006-12-13 Thread Bruce Momjian
abling will essentially need to rebuild the index. > > > That's what I had in mind. You could just as easily blow away the index > file(s). It's just that I don't want it to toss the index *definition*. Well, you can just pg_dump the index definition to a file. What mo

Re: [GENERAL] Online index builds

2006-12-12 Thread Bruce Momjian
would certainly solve the > > awkwardness of maintenance on a primary key. I didn't see much > > objection, maybe it's worth consideration for 8.3? > > Added to TODO: > > * Allow REINDEX CONCURRENTLY Oops, removed. Seems there is a deadlock issue. -- Bru

Re: [GENERAL] Online index builds

2006-12-12 Thread Bruce Momjian
ations, like Slony, > use the primary key by default. > > After reading through the archives, it looks like Gregory Stark > suggested a REINDEX CONCURRENTLY, which would certainly solve the > awkwardness of maintenance on a primary key. I didn't see much > objection

Re: [GENERAL] Asynchronous replication of a PostgreSQL DB to

2006-12-12 Thread Bruce Momjian
tion. > > My hopes aren't all too high that there's an easy way to accomplish what > I wish to do, so any advice would be very much welcome - even a "can't > be done that way" by somebody who has tried to travel that path before > :) > > Kind regards &

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-12 Thread Bruce Momjian
postgresql.conf None of these are optional for restoring a database. They are all interconected. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broa

Re: [GENERAL] concatenation operator || with "null" array

2006-12-11 Thread Bruce Momjian
ai > > > ---(end of broadcast)--- > TIP 9: In versions below 8.0, the planner will ignore your desire to >choose an index scan if your joining column's datatypes do not >match -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhtt

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-05 Thread Bruce Momjian
PG instance, then you > > > should be okay. > > > > > > - John D. Burger > > >MITRE > > > > > The raw db files are not from this installation, but same ver of windows > > binary pg. Does this mean the db is not going to be usea

Re: [GENERAL] Restore database from files (not dump files)?

2006-12-01 Thread Bruce Momjian
ntier /data directory tree? If so, just restore the directory start it up a binary. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)

Re: [GENERAL] Windows default editor for psql \e

2006-11-28 Thread Bruce Momjian
g this, but does anyone know the windows (xp) equivalent to: > /etc/rc.conf for *nix? i.e. the place that windows uses to store system wide > variables from future > use? Is still the autoexec.bat? :o) OK, I am freaked out that I know the answer to this, but it My Computer/Properties/Adv

Re: [GENERAL] Windows default editor for psql \e

2006-11-28 Thread Bruce Momjian
Richard Broersma Jr wrote: > Does anyone know how to change the default editor from NOTEPAD to something > link gVim? It would be > nice to use an editor with a little more smarts. Sure, see the psql manual page, but setting EDITOR is the easiest way. This works on Win32 too. --

Re: [GENERAL] ISO week dates

2006-11-22 Thread Bruce Momjian
Added to TODO: * Add ISO day of week format 'ID' to to_char() where Monday = 1 * Add an ISO year field to extract() called 'isoyear' -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard driv

Re: [GENERAL] Possible problem with PQescapeStringConn and

2006-11-22 Thread Bruce Momjian
o haphazardly. You wouldn't want to change it at > runtime if the bulk of your queries involved escape sequences. > > Regards, > Jeff Davis > > > ---(end of broadcast)--- > TIP 9: In versions below 8.0, the pl

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006-11-22 Thread Bruce Momjian
16 are ways of representing that characters set in 8-bit and 16-bit segments, respectively. PostgreSQL only suports UTF8, and Win32 only supports UTF16 in the operating system. And 0x00 is not a valid value in any of those, that I know of, but perhaps it is in UTF16. -- Bruce Momjian [EMAIL PRO

Re: [GENERAL] select result / functions from another database

2006-11-17 Thread Bruce Momjian
er, they don't know other answers as well. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] CUBE, ROLLUP, GROUPING SETS?

2006-11-14 Thread Bruce Momjian
hose aggregates at once. We'll presumably > discover this if and when someone begins work on it... Our TODO has: * Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Ch

Re: [GENERAL] c (lowercase) privilege

2006-10-22 Thread Bruce Momjian
Alvaro Herrera wrote: > Javier Carlos wrote: > >Hi, > > > >Does anybody know what's the meaning of the c (lowercase) privilege in > > PostgreSQL 8.2 Beta? > > "connect" And it is listed in the 8.2 documentation. -- Bruce Mo

Re: [GENERAL] difference b/w text and varchar datatypes

2006-10-16 Thread Bruce Momjian
Harpreet Dhaliwal wrote: > Hi, > Just wanted to know how would it make a difference if i use text datatype > instead of varchar. See FAQ item. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be yo

Re: [GENERAL] some log statements ignored

2006-10-12 Thread Bruce Momjian
s anyone > seen this behaviour? > > > test=# show log_statement; > log_statement > --- > mod > (1 row) I have no idea why that would happen. If you do 'all' do you see all of them? -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp:/

Re: [GENERAL] URGENT - startup process (PID 29541) was

2006-10-07 Thread Bruce Momjian
d always treated > as if it was set to on. Is it wrong? Well, early versions of 8.1.X did honor full_page_writes, but 8.1.4 disabled it. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +

Re: [GENERAL] PG Rocks! (was:Backslashes in 8.2 still escape,

2006-09-30 Thread Bruce Momjian
along, I am SUPER impressed. Yea, we figured standard_conforming_strings was going to be needed badly in certain environments. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -

Re: [GENERAL] how much free space in tables and index ?

2006-09-24 Thread Bruce Momjian
> For tables see the contrib/pgstattuple module. And that will work for indexes in 8.2. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-14 Thread Bruce Momjian
I *owned* it. No > > bank :) > > Are we talking about this one? > http://www.musclecarclub.com/musclecars/plymouth-cuda/plymouth-cuda.shtml > > > Note that this was a very long time ago :) > > I hope it wasn't on 1966 ... I am not going to ask how you got to 135MP

Re: [GENERAL] invalid byte sequence ?

2006-09-02 Thread Bruce Momjian
you checked our extensive FAQ? > >http://www.postgresql.org/docs/faq -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)-

Re: [GENERAL] [pgsql-advocacy] Thought provoking piece on

2006-08-31 Thread Bruce Momjian
. and would they listen to a > roadmap if they had one, rather than scratching their own itches? I think the longer someone is with the project the more they start working on what is good for the project, rather than what interests them. I think we have seen many cases of that. -- Bruce Momjian

Re: [GENERAL] [pgsql-advocacy] Thought provoking piece on NetBSD

2006-08-31 Thread Bruce Momjian
I saw good and bad and thought it would be good > for everyone to review as we are as a project dealing with some of our > own growth problems. Yes. There are lessons to be learned. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a

Re: [GENERAL] Thought provoking piece on NetBSD

2006-08-31 Thread Bruce Momjian
nk the best configuration somewhere is in the middle, which is what we have. I don't see how it is related to the OS problem domain. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + --

Re: [GENERAL] Atomicity?

2006-08-28 Thread Bruce Momjian
g which > > took me ages to track down. Is anyone able+willing to explain a little > > here or should I ask in -hackers ? > > This has some workarounds and explanations that may help: > > http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html URL add

Re: [GENERAL] Atomicity?

2006-08-28 Thread Bruce Momjian
nd is being executed, rather than at the end of the statement or transaction. and moved to "referential integrity" section. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] SQL:2003 Window Functions for postgresql 8.3?

2006-08-25 Thread Bruce Momjian
ss "Implement SQL:2003 window functions" should be enough :-) Not > sure if you should append the [Karen Hill] bit to it though ;-) Added to TODO. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Chri

Re: [GENERAL] SQL:2003 Window Functions for postgresql 8.3?

2006-08-25 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian wrote: > > Karen Hill wrote: > > > > > > Alvaro Herrera wrote: > > > > Karen Hill wrote: > > > > > > > > > It would be really great if PostgreSQL supported SQL:2003 Window > > >

Re: [GENERAL] SQL:2003 Window Functions for postgresql 8.3?

2006-08-25 Thread Bruce Momjian
e SQL:2003 > Window Functions listed. Is it because they are not desired, or is it > because there are more pressing things to accomplish? I noticed that > Tom has mentioned that it appears unworkable in this thread. This is the first time I have seen them mentioned. Do we want the

Re: [GENERAL] invalid byte sequence ?

2006-08-23 Thread Bruce Momjian
a bulletproof solution isn't clear. For the moment all you can > do is be real careful about making your locale settings match up. > > regards, tom lane > > ---(end of broadcast)-

Re: [GENERAL] invalid byte sequence ?

2006-08-23 Thread Bruce Momjian
2220a > > What's up ? > db_test was created UTF8 encoded What does your client_encoding show? It should be UTF8 too. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---

Re: [GENERAL] Majordomo drops multi-line Subject:

2006-08-23 Thread Bruce Momjian
just saw it happened to > a mail from Bruce as well. Can you have multi-line subject lines? I didn't think that was possible. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---

Re: [GENERAL] pgxml & xpath_table

2006-08-21 Thread Bruce Momjian
n with different > behaviour in this situation is possible or helpful. > > Give me a few days... FYI, I have not seen a patch for this yet. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +

Re: new FAQ entry (was:Re: [GENERAL] UTF8 problem)

2006-08-21 Thread Bruce Momjian
> in the same set of data, which will cause you headaches when you try to > convert the whole lot to some consistent encoding in the future. > > See section 21.2 of the documentation for more complete information. > > > Tim > > -- > ------

Re: [GENERAL] Cast null string '' to integer 0

2006-08-19 Thread Bruce Momjian
Does anyone know of a fix? You would have to hack the backend code to change this. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)-

Re: [GENERAL] limitations of constraints, possible bugs

2006-08-16 Thread Bruce Momjian
ently we don't support arrays of domain types (this should get fixed > sometime). If we did, then yeah, that's how it'd work. Added to TODO: * Add support for arrays of domains -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com

Re: [GENERAL] Connection string

2006-08-13 Thread Bruce Momjian
gt; to fix misleading parts of the documentation or whether he'd commit > the necessary changes based on what we've already discussed in this > thread. Yes, please submit a documentation patch and I will apply it. Thanks. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhtt

Re: [GENERAL] WIN32 Build?

2006-08-09 Thread Bruce Momjian
t; forma > > > > l parameter list > > > > ..\..\backend\utils\mb\wchar.c(101) : error C2143: syntax error : missing > > ';' be > > > > fore '{' > > > > ..\..\backend\utils\mb\wchar.c(116) : error C2054: expected '('

Re: [GENERAL] WIN32 Build?

2006-08-09 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Interesting. It seem the key line is here: > > > cl : Command line warning D4029 : optimization is not available in the > > standard edition compiler > > > So the "standard" version

Re: [GENERAL] WIN32 Build?

2006-08-09 Thread Bruce Momjian
C) Microsoft Corporation. All rights reserved. > > Which came with > Microsoft Visual C++ .NET Version 7.1.3088 > > Don't know if that helps or not! Not really. I need to see all the defines predefined by the compiler. Anyone know how to do that on MSVC? -- Bruce

Re: [GENERAL] WIN32 Build?

2006-08-09 Thread Bruce Momjian
gt; standard edition compiler So the "standard" version doesn't support inline functions. To fix that, I think we need some compiler define test to tell us if it is a "standard" edition compiler. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb

Re: [GENERAL] ECPG and COPY

2006-08-02 Thread Bruce Momjian
standard output, so the functionality is not very useful. I am confused. STDOUT is already implemented. It was STDIN that we were asking if it was valuable. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, C

Re: [GENERAL] ECPG and COPY

2006-08-02 Thread Bruce Momjian
Michael Meskes wrote: > On Mon, Mar 06, 2006 at 10:15:06AM -0500, Bruce Momjian wrote: > > Added for ecpg TODO: > > > >o Add COPY TO STDIN / STDOUT handling > > COPY TO STDOUT has been implemented, but I'm unsure whether COPY FROM > STDIN really makes

Re: [GENERAL] pg_xlog not cleaned up

2006-07-31 Thread Bruce Momjian
Christian Kastner wrote: > Bruce Momjian wrote: > > What PostgreSQL version are you using? I know the *.backup file removal > > was added in 8.1: > > > > * Remove old "*.backup" files when we do pg_stop_backup() (Bruce) > >This preve

Re: [GENERAL] pg_xlog not cleaned up

2006-07-31 Thread Bruce Momjian
-(end of broadcast)------- > TIP 5: don't forget to increase your free space map settings -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Log actual params for prepared queries: TO-DO item?

2006-07-18 Thread Bruce Momjian
> WHERE id = $2] > > Thoughts on making this a to-do item? It is already a TODO item: * Allow protocol-level BIND parameter values to be logged -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative

2006-07-11 Thread Bruce Momjian
ow if this is fixed in later versions? > > Paul Tilles > > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.postgresql.org -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB

Re: [GENERAL] Aim of --enable-thread-safety ?

2006-07-10 Thread Bruce Momjian
thread-safety Make the client libraries thread-safe. This allows concurrent threads in libpq and ECPG programs to safely control their private connection handles. This option requires adequate threading support in your operating system.

Re: [GENERAL] A real currency type

2006-06-16 Thread Bruce Momjian
> > -- > Martijn van Oosterhout http://svana.org/kleptog/ > > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > > tool for doing 5% of the work and then sitting around waiting for someone > > else to do the other 95% so you can sue them. -- End

Re: [GENERAL] Omitting tablespace creation from pg_dumpall...

2006-06-16 Thread Bruce Momjian
different > tablespace is compareable to not supporting database renaming. Think > of pg_dumpall as equivalent to copying the data directory - only that > it works while the database is online, and supports differing > architectures on source and destination machine. > > gre

Re: [GENERAL] postgres and ldap

2006-06-16 Thread Bruce Momjian
hes. > Will gather up the docs and apply unless Bruce beats me to it. Thanks. > > regards, tom lane > > ---(end of broadcast)------- > TIP 6: explain analyze is your friend > -- Bruce Momjian http://cand

Re: [GENERAL] A few questions about carriage returns (\r)

2006-06-15 Thread Bruce Momjian
Convert string to ASCII from another encoding (only supports conversion from LATIN1, LATIN2, LATIN9, and WIN1250 encodings) -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + --

Re: [GENERAL] GPL Licensed Files in 8.1.4

2006-06-07 Thread Bruce Momjian
> which is the licence I prefer, but my code in the backend is obviously > released under the original postgres licence. Since the module is loaded > dynamically and not linked into the backend I don't see a problem here. > If the licence becomes a problem I can easily cha

Re: [GENERAL] pgcrypto sha256/384/512 don't work on Redhat. Please help!

2006-06-07 Thread Bruce Momjian
HEAD only appears in 8.2, but 8.1.X means it will appear in 8.1.5. --- Joe Kramer wrote: > If it was commited to HEAD, it will appear in 8.1.5, right? > > On 5/30/06, Bruce Momjian wrote: > > > > Patc

Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Bruce Momjian
Joshua D. Drake wrote: > Bruce Momjian wrote: > > Stuart Bishop wrote: > > -- Start of PGP signed section. > >> Arnaud Lesauvage wrote: > >>> Hi list ! > >>> > >>> I have a small enterprise network (~15 workstations, 1 server), a

Re: [GENERAL] Best high availability solution ?

2006-06-03 Thread Bruce Momjian
lantic Monthly about the Valujet crash: http://www.theatlantic.com/issues/98mar/valujet1.htm Unfortunately that requires a subscription so I pulled a relivant paragraph: http://candle.pha.pa.us/main/valujet The issue is that reducing risk can increase it, as seen with Valujet, Th

Re: [GENERAL] Problem in Pg 8.1.4 with CREATEDB

2006-05-31 Thread Bruce Momjian
em is caused by CREATEDB, which seems > to hang. > Does anyone know this problem ? Is this Win32? Is it perhaps prompting for a password from the terminal, but you used to pipe in the password. That changed in 8.1.4 on Win32. -- Bruce Momjian http://candle.pha.pa.us

Re: [GENERAL] pgcrypto sha256/384/512 don't work on Redhat. Please help!

2006-05-30 Thread Bruce Momjian
gt; Now that I think about it, if your OpenSSL does not contain SHA2, then > there should be no conflict. But ofcourse, if someone upgrades OpenSSL, > server starts crashing. So I think its best to always apply this patch. > > I think I'll send the patch to 8.2 later, not sur

Re: [GENERAL] no prompt in psql!!!

2006-05-29 Thread Bruce Momjian
sole code page (437) differs from Windows code page (1252) > 8-bit characters may not work correctly. See psql reference > page "Notes for Windows users" for details. > > test=# \set > VERSION = 'PostgreSQL 8.2devel on i686-pc-mingw32, compiled by GCC gcc

Re: [GENERAL] a row disapearing

2006-05-27 Thread Bruce Momjian
ove in postgres 8.1. It is supposed to work that way. In the first query, we have to return a row to show you the count, while in the second query, there is no 'id' value to show you, so we return nothing (nothing to GROUP BY). -- Bruce Momjian http://candle.pha.pa.us

Re: [GENERAL] allow LIMIT in UPDATE and DELETE

2006-05-23 Thread Bruce Momjian
e long > > running transaction syndrome. > > I believe it's already fixed in HEAD/8.2. If it is, TODO doesn't reflect that: * Make CLUSTER preserve recently-dead tuples per MVCC requirements -- Bruce Momjian http://candle.pha.pa.us Enter

Re: [GENERAL] PostgreSQL internals. Help needed

2006-05-21 Thread Bruce Momjian
P 3: Have you checked our extensive FAQ? > >http://www.postgresql.org/docs/faq > -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end o

Re: [GENERAL] autovacuum "connections" are hidden

2006-05-18 Thread Bruce Momjian
Alvaro Herrera wrote: > Larry Rosenman wrote: > > Bruce Momjian wrote: > > > Tom Lane wrote: > > >> Casey Duncan <[EMAIL PROTECTED]> writes: > > >>> however, when I did "select * from pg_stat_activity" on the pg > > &

Re: [GENERAL] autovacuum "connections" are hidden

2006-05-18 Thread Bruce Momjian
autovacuum is running? Would the connection still appear while pg_autovacuum is sleeping? -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] statement_timeout and pg_dump

2006-05-18 Thread Bruce Momjian
o increase timeout time for the dump procedure? Yes, you can do: PGOPTIONS="-c statement_timeout=0" pg_dump test However, I think you are better using ALTER USER to set statement_timeout for specific users and allow system operations to run with the default timeout of zero/

Re: [GENERAL] Why won't it index scan?

2006-05-18 Thread Bruce Momjian
tunately > > a pretty large fraction at that. > > > > So sadly I think "at the mercy of randomness" is pretty accurate. You'll > > have > > to raise the statistics target as the table grows and I expect you'll > > eventually run into some downsi

Re: [GENERAL] ALTER SEQUENCE

2006-05-17 Thread Bruce Momjian
Don Y wrote: > Bruce Momjian wrote: > > Don Y wrote: > >> Bruce Momjian wrote: > >>> Don Y wrote: > >>>> Hi, > >>>> > >>>> It doesn't appear that there is a way to rename a sequence > >>>> (ideally wi

Re: [GENERAL] ALTER SEQUENCE

2006-05-17 Thread Bruce Momjian
Don Y wrote: > Bruce Momjian wrote: > > Don Y wrote: > >> Hi, > >> > >> It doesn't appear that there is a way to rename a sequence > >> (ideally with a "cascade" action). > > > > > > Uh, the ALTER SEQUENCE manual page

Re: [GENERAL] ALTER SEQUENCE

2006-05-17 Thread Bruce Momjian
sequence use ALTER TABLE RENAME. Does that help? -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 5: do

Re: [GENERAL] bytea hex input/output

2006-05-16 Thread Bruce Momjian
with it for > the moment. Should we rethink this for SQL standard strings? -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Is it me, or the list?

2006-05-16 Thread Bruce Momjian
s this me, or is this the list? It is the list, and we like it that way. Use group reply to include the list. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---

Re: [GENERAL] [PORTS] Compiling on 8.1.3 on Openserver 5.05

2006-05-15 Thread Bruce Momjian
bell > > > Confidentiality Notice: http://ucs.co.za/conf.html ^^^ Now there is a great idea! Instead of a huge block of legal text at the bottom of the email, just link to the content. Seems that would keep the lawyers and the email readers happy. --

Re: [GENERAL] GUI Interface

2006-05-12 Thread Bruce Momjian
I actually use a laptop running XP. I got it for the Win32 port, and because I use putty/ssh, Mozilla, and Gaim 99% of the time, it doesn't matter what OS I use. I could install a unix on it, but there seems to be no need because all my unix work is done on my server via ssh. -- Bruce Mo

Re: [GENERAL] [PERFORM] Arguments Pro/Contra Software Raid

2006-05-11 Thread Bruce Momjian
Jim C. Nasby wrote: > On Thu, May 11, 2006 at 07:20:27PM -0400, Bruce Momjian wrote: > > Joshua D. Drake wrote: > > > > > > >> You want an in-depth comparison of how a server disk drive is > > > >> internally > > > >> bette

Re: [GENERAL] [PERFORM] Arguments Pro/Contra Software Raid

2006-05-11 Thread Bruce Momjian
over them. > > Frankly I think if you are running drivess (in a production environment) > for more then 3 years your crazy anyway :) Agreed --- the cost/benefit of keeping a drive >3 years just doesn't make sense. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB

Re: [GENERAL] [PERFORM] Arguments Pro/Contra Software Raid

2006-05-11 Thread Bruce Momjian
I would rather not have to replace it. :-) Let me mention the only drive that has ever failed without warning was a SCSI Deskstar (deathstar) drive, which was a hybrid because it was a SCSI drive, but made for consumer use. -- Bruce Momjian http://candle.pha.pa.us

Re: [PERFORM] [GENERAL] Arguments Pro/Contra Software Raid

2006-05-10 Thread Bruce Momjian
! www.ffii.org www.nosoftwarepatents.org > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, C

Re: [PERFORM] [GENERAL] Arguments Pro/Contra Software Raid

2006-05-09 Thread Bruce Momjian
really needs the one on the drives anyway. You do if the controller thinks the data is already on the drives and removes it from its cache. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +

<    4   5   6   7   8   9   10   11   12   13   >