Re: [GENERAL] Wrap around id failure and after effects

? This shouldn't really be possible without disabling autovaccuum or configuring it strangely. http://www.postgresql.org/docs/current/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Failed to autoconvert '1' to text.

If you use the literals directly the context lets PostgreSQL figure it out. SELECT levenshtein('1','2'); -- Richard Huxton Archonet Ltd -- 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] Why doesn't COPY support the HEADER options for tab-separated output?

. I'd like there to be a header in my files. I have to use CSVs instead. Late to the discussion, but it does work to set format=csv and delimiter = E'\t' to get tab-separated. Be nice not to have to though. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mail

Re: [GENERAL] Postgres DB crashing

se a connection pooler. You'll also need to reduce work_mem to 1MB or so. -- Richard Huxton Archonet Ltd -- 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] PostgreSQL Synchronous Replication in production

protect against? Make a list of possible failures and what they mean to the business/project and then decide how much time/money to spend protecting against each one. -- Richard Huxton Archonet Ltd -- 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] PostgreSQL Synchronous Replication in production

cases where you want (a), but lots where you want (b) and monitor the replication lag. [1] For various values of "safely" of course [2] In the same mode - adding async slaves doesn't count [3] Assuming a reasonable write load of course. Read-only databases won't care. --

Re: [GENERAL] apt.postgresql.org broken dependency?

lidas: barman : Depende: python (< 2.7) pero 2.7.3-4 va a ser instalado Depende: python-argcomplete pero no va a instalarse Since when 2.7.3 isn't larger then 2.7. Is that not complaining that it *wants* a version of python < 2.7 and you have larger? -- Richard Huxto

Re: [GENERAL] Table containing only valid table names

vel/static/event-triggers.html -- Richard Huxton Archonet Ltd -- 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] Checking for changes in other tables

nges CALLING PROCEDURE ...; A different "feel", but no difference in behaviour. -- Richard Huxton Archonet Ltd -- 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] Do "after update" trigger block the current transaction?

tem underlying Londiste. That would handle tracking the changes in PostgreSQL leaving you to just handle the MySQL end. Timestamps will do the job as long as you are careful to allow enough slack to deal with clock updates. -- Richard Huxton Archonet Ltd -- Sent via pgsql-gener

Re: [GENERAL] PostgreSQL service terminated by query

be reproduced, adapted or communicated without the prior written consent of the copyright owner. Oh no, too late! -- Richard Huxton Archonet Ltd -- 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] Do "after update" trigger block the current transaction?

umn, which is not pretty but should be fairly simple. Why not use one of the established trigger-based replication solutions? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [GENERAL] Running update in chunks?

ck and also not updating any indexed fields (and you were, I think). A GIN index is very expensive to update compared to btree too. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [GENERAL] Running update in chunks?

thout the fillfactor and with/without the GIN index while you do the updates. It's possible your SSD is just behaving oddly under stress. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Running update in chunks?

en year old PCs with very little RAM and disk space. At least deliver additional conf files for small, medium, large, huge setups. -- Richard Huxton -- 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] Running update in chunks?

updating those rows whose id has changed - that seemed to be the suggestion in your first message. If not, simply adding "AND make_id <> md.make_id" should help. Also (and you may well have considered this) - for a normalised setup you'd just have the model-id in "import

Re: [GENERAL] Running update in chunks?

write. If it's much faster then something else is happening. -- Richard Huxton Archonet Ltd -- 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] Backup/Restore bytea data

in "escape" rather than "hex" format. -- Richard Huxton Archonet Ltd -- 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] Postgres PHP error

ump to dump the database regularly too. I'd expect to have to do a little work to move the data into an up-to-date version of PostgreSQL and it's always better to know what issues you'll have before doing it for real. -- Richard Huxton Archonet Ltd -- Sent via pgsql-gener

Re: [GENERAL] Noticed something odd with pgbench

On 16/11/12 19:35, Shaun Thomas wrote: Hey guys, So, we have a pretty beefy system that runs dual X5675's with 72GB of RAM. After our recent upgrade to 9.1, things have been... odd. I managed to track it down to one setting: shared_buffers = 8GB It does the same thing at 6GB. 4GB is safe

Re: [GENERAL] deadlock detected

7;2170501' How may I get more information about this deadlock like which queries created it. The error message shows which queries - your two UPDATEs. I'm guessing either t1 or c1 are views and so refer to the same row with id "2710501". -- Richard Huxton -- Sent

Re: [GENERAL] Recover from failed files

nsaction information will have been lost. But before you do anything drastic, do steps #1 and #2. -- Richard Huxton -- 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] table logging

Other than that, it seems to work fine. -- Richard Huxton Archonet Ltd -- 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] Notiffy problem

l(n_user); EXECUTE cmd; or just EXECUTE 'NOTIFY demoApp, ' || quote_literal(n_user); -- Richard Huxton Archonet Ltd -- 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] maybe incorrect regexp_replace behavior in v8.3.4 ?

ot;strict" then any null parameters automatically result in a null result. And indeed, this: SELECT * FROM pg_proc WHERE proname LIKE 'regexp_r%'; shows pro_isstrict is set to true, as it is for most other function.s -- Richard Huxton Archonet Ltd -- Sent via pgsql-gene

Re: [GENERAL] Problem with reading data from standby server ?

ar behind the replica could never catch up). You can control how long before it switches: http://www.postgresql.org/docs/9.1/static/hot-standby.html#HOT-STANDBY-CONFLICT -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

Re: [GENERAL] default value returned from sql stmt

On 30/03/12 08:46, Pavel Stehule wrote: 2012/3/30 Richard Huxton: On 29/03/12 23:28, Pavel Stehule wrote: select anum from t1 where anum = 4 union all select 100 limit 1; I'm not sure the ordering here is guaranteed by the standard though, is it? You could end up with the 4 being disc

Re: [GENERAL] default value returned from sql stmt

On 29/03/12 23:28, Pavel Stehule wrote: select anum from t1 where anum = 4 union all select 100 limit 1; I'm not sure the ordering here is guaranteed by the standard though, is it? You could end up with the 4 being discarded. -- Richard Huxton Archonet Ltd -- Sent via pgsql-ge

Re: [GENERAL] Desperately need a magical PG monitoring tool

above. -- Richard Huxton Archonet Ltd -- 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] Indexing MS/Open Office and PDF documents

ntify headings etc. -- Richard Huxton Archonet Ltd -- 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] 100% cpu usage on some postmaster processes kill the complete database

s along shortly, try reposting to the performance list. There are people there who are used to machines of this size. -- Richard Huxton Archonet Ltd -- 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] 100% cpu usage on some postmaster processes kill the complete database

just installed a script, which prints me out the top and ps axf information for facing out the problem. I will post a snippet of the top here: Combine that with this: SELECT * FROM pg_stat_activity; That will let you line up pids from top with active queries. -- Richard Huxton Archonet

Re: [GENERAL] problem trying to create a temp table

On 24/02/12 13:37, Andrew Gould wrote: On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton wrote: Temp tables get their own schema, and each session (connection) gets its own temp schema. So - don't qualify them by schema. Is that to avoid naming conflicts between simultaneous users? Y

Re: [GENERAL] problem trying to create a temp table

OP TABLE table1; DROP TABLE => SELECT * FROM table1; id 1 2 3 (3 rows) Try "SELECT * FROM pg_namespace" to see the various temp schemas being created. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] problem trying to create a temp table

annot create temporary relation in non-temporary schema Temp tables get their own schema, and each session (connection) gets its own temp schema. So - don't qualify them by schema. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Problemas com client_encoding ?

r some such). http://archives.postgresql.org/pgsql-admin/2011-09/msg00088.php http://archives.postgresql.org/pgsql-admin/2011-09/msg00101.php Do you have version 9.0 installed too? -- Richard Huxton Archonet Ltd

Re: [GENERAL] Postgresql as main database

8.4 - you will get better performance, new features and it will be supported for longer. -- Richard Huxton Archonet Ltd

Re: [GENERAL] function return update count

- the cast to int is because count() returns bigint. -- Richard Huxton Archonet Ltd -- 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] sql statements using access frontend

gine we are both updating the same row at the same time. If my update gets committed before yours, then yours won't find a row to update. Otherwise my changes could be overwritten without you knowing. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] Huge number of INSERTs

;, but this directory is empty. You'll need to check the manuals for full details on how to configure your logging - I'd expect a zero-length file even if you weren't logging anything to it. Might be worth checking the directory is owned by user "postgres" (or whoever you

Re: [GENERAL] function doesn't see change in search_path

I now try to add a SET search_path to the bottom of all my plpgsql functions. It can get very confusing otherwise, as you've just demonstrated. -- Richard Huxton Archonet Ltd -- 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] function within a function/rollbacks/exception handling

transaction (insertA)? Unless you catch the exception, it will roll back the whole transaction, so "yes" to b + c. If it helps to visualise what happens, exceptions are actually implemented using savepoints in plpgsql. -- Richard Huxton Archonet Ltd -- 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] Analytic type functionality, matching patters in a column then increment an integer

r (order by id) FROM tfcount ) AS rows ORDER BY id; HTH P.S. - I always find the windowing function syntax confusing, but it's as the standards define I believe. -- Richard Huxton Archonet Ltd -- 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] Create Extension search path

though. See ALTER DATABASE or ALTER ROLE. -- Richard Huxton Archonet Ltd -- 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] stored procs

you the queries it uses. -- Richard Huxton Archonet Ltd -- 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] : Checksum ERROR when restoring Online Backup

f you need replication then Slony can handle this. -- Richard Huxton Archonet Ltd -- 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] forcing table ownership

UMN t text; ALTER TABLE I think the key bit you're missing is the "INHERIT" on the group. Also note that the CREATE USER/CREATE GROUP commands actually just run CREATE ROLE under the hood. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Remote connection shows localhost databases

t the server-name by itself. You'll want the internet name for the machine which in theory can be different from the Windows network name, but usually is the same. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Remote connection shows localhost databases

On 16/09/11 09:01, Guillaume Lelarge wrote: On Fri, 2011-09-16 at 08:14 +0100, Richard Huxton wrote: Odd that pgAdmin doesn't give an error though. Probably because the OP entered the Windows networking path in the Name field, and didn't change the Host field. In which case, pg

Re: [GENERAL] Remote connection shows localhost databases

? -- Richard Huxton Archonet Ltd -- 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] psql can't subtract

the initial position will be zero. Minus one will give you a negative substring length. -- Richard Huxton Archonet Ltd -- 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] database is bigger after dump/restore - why? (60 GB to 109 GB)

? That would be my immediate guess. Someone changed the fillfactor on the table - that won't affect the existing data but will affect a restore. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Inserting data from one database to another using stored functions

any SQL statement that doesn't return rows)". A SELECT statement returns rows. Zero rows are still rows. What happens if you just use dblink(...)? http://www.postgresql.org/docs/9.0/static/contrib-dblink-exec.html http://www.postgresql.org/docs/9.0/static/contrib-dblink.html -- R

Re: [GENERAL] Pl/perl and perl version-tip in doc

of plperl? -- Richard Huxton Archonet Ltd -- 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] Which variant to choose?

r .net, odbc and jdbc but whether they are seamless enough only you can decide. -- Richard Huxton Archonet Ltd -- 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] Upgrade from 8.3.3

. Have they said it doesn't or is it just not tested against it? -- Richard Huxton Archonet Ltd -- 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] Record Separator with psql -c when output to a variable not a file!

footer off (tuples only) and sets the output to unaligned tab-separated columns. -- Richard Huxton Archonet Ltd -- 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] Index on points

51.756..551.757 rows=1 loops=1) -> Seq Scan on fleet (cost=0.00..20883.00 rows=1000 width=0) (actual time=5.142..551.624 rows=121 loops=1) Filter: (box(locn, locn) <@ '(20,20),(10,10)'::box) Total runtime: 551.831 ms (4 rows) -- Richard Huxton Archonet Ltd

Re: [GENERAL] varchar lengths

rest of you deal with this situation? PostgreSQL actually measures length in characters anyway, so varchar(10) always holds 10 characters, whatever they are. You'll need to have the appropriate database encoding for those characters of course. -- Richard Huxton Archonet Ltd -

Re: [GENERAL] to_date conversion semantics?

r gmtime(mktime(0,0,0,32,13-1,73)),"\n"' Fri Feb 1 00:00:00 1974 http://perldoc.perl.org/POSIX.html#mktime http://linux.die.net/man/3/mktime -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] Regular expression in an if-statement will not work

123: | t :1234: | f : 123: | f :123 : | f (6 rows) Works in 8.2, 8.3, 8.4, 9.0 for me. Either you're not testing the values you think you are, or there is some issue with escaping of characters. -- Richard Huxton Archonet Ltd -- 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] On-disk size of db increased after restore

On 01/09/10 21:32, Devrim GÜNDÜZ wrote: On Wed, 2010-09-01 at 21:13 +0100, Richard Huxton wrote: Could you have changed the fillfactor on some big tables/indexes in the live database after populating them? Nope. Even a pg_dump -h prod|psql backup_node resulted with the same issue Is the

Re: [GENERAL] On-disk size of db increased after restore

live database after populating them? Is the locale the same on each machine/db? -- Richard Huxton Archonet Ltd -- 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] Foreign keys and permissions oddity

ld justify either, but of course they're frequently the same (as in your case). -- Richard Huxton Archonet Ltd -- 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] PQescapeStringConn

On 30/07/10 16:57, Scott Frankel wrote: On Jul 30, 2010, at 1:13 AM, Richard Huxton wrote: On 30/07/10 07:52, Scott Frankel wrote: I have a number of very long strings that each contain many instances of semi-colons, single quotes, forward and back slashes, etc. I'm looking for an effi

Re: [GENERAL] PostgreSQL keepalives help

nitor onto the connection and see if any packets are being sent back and fore while there is no real traffic. Oh, and please don't cross-post to multiple lists (particular -cluster-hackers - can't see the relevance of that). -- Richard Huxton Archonet Ltd -- Sent via pgsql-

Re: [GENERAL] PQescapeStringConn

but they need to be quoted correctly. Every application language will have its own library, but they all have a similar prepare+exec option (and I think most use the "C" libpq interface underneath). -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-gener

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

d and third graphs look like a sinusoidal variation overlaid on a steadily increasing baseline? -- Richard Huxton Archonet Ltd -- 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] Full Text Search dictionary issues

search for 'wommman & batt && pzsdja' vs '... pzsdj1'? I'm assuming pzsdja/1 aren't valid tokens of course... -- Richard Huxton Archonet Ltd -- 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] error "CDT FATAL: invalid frontend message type 69"

doing and what the "pg_stat_activity" view says PostgreSQL is doing. Any ideas of what it means, how to track the cause and cure? Is there any way to reproduce this error? Not without knowing more about how it happened, which we could only investigate before you restarted the mast

Re: [GENERAL] 'default nextval()' loses schema-qualification in dump ?

_get_expr. Check on the odbc mailing-list - there may be an updated version available for you to test. -- Richard Huxton Archonet Ltd -- 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] PSQL segmentation fault after setting host

x00531000) libkrb5.so.3 => /opt/PostgreSQL/psqlODBC/lib/libkrb5.so.3 (0x00a2c000) libgssapi_krb5.so.2 => /opt/PostgreSQL/psqlODBC/lib/libgssapi_krb5.so.2 libk5crypto.so.3 => /opt/PostgreSQL/psqlODBC/lib/libk5crypto.so.3 -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailin

Re: [GENERAL] Identical command-line command will not work with \i metacommand and filename

http://www.xs4all.nl/~mechiel/projects/bomstrip/ -- Richard Huxton Archonet Ltd -- 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] Tuple storage overhead

le testcase I'm importing data from text files which are 5.7 Gb in total, and this causes the db size to grow to 34Gb. Anything from double to ten times the size isn't unexpected, depending on row-sizes and how many indexes you are talking about. -- Richard Huxton Archonet Ltd -- Sent

Re: [GENERAL] Text search

On 16/03/10 13:49, Richard Huxton wrote: You could run an xslt transform over the xml fragments and extract what you want and then use tsearch to index that, I suppose. Similarly, you might be able to do the same via xslt and xquery. Actually, if it's only attribute names you're int

Re: [GENERAL] UPDATE with JOIN not using index

one is 5,000,000 - about 6 times as much. That's why it's not using the index, because it thinks it will be more expensive. If it's not really more expensive that suggests your configuration values aren't very close to reality. The first query should run faster if it has

Re: [GENERAL] UPDATE with JOIN not using index

index. What does it do, then? The output of EXPLAIN would be a start if EXPLAIN ANALYSE is too expensive. Oh - and how many rows will this actually update? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Text search

Finally, and to my mind most sensibly, if you want to search attributes, then store attributes. Parse out your XML and have an "attributes" table (id, name, value, last_changed, changed_by). That's not brilliant because every value will just be text, but at least each attribute is i

Re: [GENERAL] reuse data in existing data directory

l that 8.3 again). 3. If your PG files are in the standard directory then you should see an error saying initdb refused to run. 4. That's it - it should all just work. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Text search

s/8.4/static/datatype-xml.html http://www.postgresql.org/docs/8.4/static/functions-xml.html http://www.postgresql.org/docs/8.4/static/xml2.html -- Richard Huxton Archonet Ltd -- 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] FW: 8.4.2 One Click Installer

"fileid" if you have 10 mins spare. This is 8.4.3, Linux 64-bit http://www.enterprisedb.com/getfile.jsp?fileid=878 This is 8.4.1 Windows http://www.enterprisedb.com/getfile.jsp?fileid=855 I'd guess it's somewhere between the two. -- Richard Huxton Archonet Ltd -- Sent vi

Re: [GENERAL] Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

you can have a more permissive system for them. -- Richard Huxton Archonet Ltd -- 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] Failed to run initdb: 128

ot; and "e:\" too (doesn't need write access). -- Richard Huxton Archonet Ltd -- 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] Foreign key behavior different in a function and outside

s there I'm sure you'd have seen it. -- Richard Huxton Archonet Ltd -- 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] FSM and VM file

that autovacuum_naptime is too large for your workload, or (auto)vacuum_cost_delay is too high. http://www.postgresql.org/docs/8.4/static/routine-vacuuming.html#AUTOVACUUM http://developer.postgresql.org/pgdocs/postgres/runtime-config-autovacuum.html#RUNTIME-CONFIG-AUTOVACUUM -- Richard Huxton Archone

Re: [GENERAL] Foreign key behavior different in a function and outside

behave the same? I'm guessing that you either: 1. Have a trigger you don't know about. 2. Have another function of the same name, but in a different schema that is being called by mistake. Add a "RAISE NOTICE" to the function to find out. -- Richard Huxton Archonet Lt

Re: [GENERAL] Restore Data Encountered the ERROR: literal carriage return found in data Error

inal or shell escape sequence of some sort. It will convert the following keypress into a control-code that will get displayed as "^M" (ctrl+M = ascii 13 = CR). You could just do: sed 's/\r/\\r/' ... though -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailin

Re: [GENERAL] need some advanced books on Postgres

#x27;s also the developer side of the website and wiki. http://www.postgresql.org/developer/ http://developer.postgresql.org/index.php/Main_Page http://wiki.postgresql.org/wiki/Development_information -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] Failed to run initdb: 128

ss you are relying on the incorrect behaviour of a bug, it is worth keeping up-to-date. http://www.postgresql.org/docs/8.2/static/release-8-2-15.html Do you think uninstalling this locale would fix this issue? No. Can you post the end of the installer log-file you get? Or preferably the whole f

Re: [GENERAL] Failed to run initdb: 128

es, 1, > {1F701DBD-1660-4108-B10A-FB435EA63BF0} Version: 8.2.0 Attributes: 0 > PatchId: Native BaselineId: - This isn't version 8.2.0 you're installing, is it? Because 8.2.15 is the current release for that version. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general

Re: [GENERAL] Scratching my head why results are different between machines.

ystemdrive%\Windows\SysWoW64 folder. * The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder." -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] The REAL cost of joins

bly aren't many) - not a terribly useful scenario. If you wanted to measure actual join costs, you'd need to repeat the tests (say) 100-1000 times in a loop, optionally with prepared plans. Varying WHERE clauses might be useful too, if that's how your real application will wo

Re: [GENERAL] disable triggers isolated to transaction only?

d here for the archives). The session_replication_role was added in 8.3: http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html That wouldn't have occurred to me. Definitely worth adding to the archives. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list

Re: [GENERAL] FSM and VM file

need to cluster tables / restart the replication to get the best case. Vacuuming needs to be a continual process. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] FSM and VM file

#x27;) ); This will show you the size of "mytable" (formatted nicely). -- Richard Huxton Archonet Ltd -- 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] createdb but revoke dropdb

x27;t have adminuser as an automatic login through .pgpass The adminuser has no login privileges so by removing dropdb this should remove the possibility for any hacker chaos other than creating more databases? Or deleting/modifying all your data, presumably. If you don't trust the lin

Re: [GENERAL] Cast char to number

based on the available information. If you get it wrong, there's always ALTER TABLE :) Coming in 9.1: ALTER CUSTOMER ... SET REQUIREMENTS ... -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Curious plperl behavior

On 24/02/10 21:34, Tom Lane wrote: Richard Huxton writes: On 24/02/10 20:55, Tom Lane wrote: but if plperl is doing something that contributes to this, maybe it requires documentation. It is documented. http://www.postgresql.org/docs/8.4/static/plperl-funcs.html Hmm. Jeff found some

Re: [GENERAL] Curious plperl behavior

ad that: 1. "Dangerous in Perl" - well, what isn't? 2. "Dangerous in Perl" - blimey, if they think it's dangerous, it must make lion-wrestling safe. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Cast char to number

On 24/02/10 20:27, Joshua D. Drake wrote: On Wed, 2010-02-24 at 20:22 +, Richard Huxton wrote: On 24/02/10 20:06, Raymond O'Donnell wrote: However, to address your immediate problem, you could try something like this: (i) Create a new column of type numeric or integer as approp

  1   2   3   4   5   6   7   8   9   10   >