Re: [GENERAL] Stored procedures and schema renames

2014-04-22 Thread Florian Weimer
= '{search_path=symboldb, public}' WHERE pronamespace = (SELECT oid FROM pg_namespace WHERE nspname = 'symboldb'); -- Florian Weimer / Red Hat Product Security Team -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Stored procedures and schema renames

2014-04-10 Thread Florian Weimer
on function definition time, which does not address this issue either. If backend code changes are required, what would be a reasonable way to approach this? Would adding a CURRENT_SCHEMA pseudo-schema which can be used in stored procedures work? -- Florian Weimer / Red Hat Product Security

Re: [GENERAL] Postgres as In-Memory Database?

2014-04-07 Thread Florian Weimer
. For example, you wouldn't want to use it as your web application session store. -- Florian Weimer / Red Hat Product Security Team -- 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] 9.3.2 server creates hundreds of thousands of temporary files

2014-02-03 Thread Florian Weimer
On 01/22/2014 06:56 PM, Tom Lane wrote: Florian Weimer fwei...@redhat.com writes: I've got a query which causes PostgreSQL to create hundreds of thousands of temporary files, many of them empty. The process also needs a lot of memory. I suspect this is due to bookkeeping for those files

Re: [GENERAL] Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC

2014-01-29 Thread Florian Weimer
://jdbc.postgresql.org/documentation/92/connect.html#connection-parameters -- Florian Weimer / Red Hat Product Security Team -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] 9.3.2 server creates hundreds of thousands of temporary files

2014-01-22 Thread Florian Weimer
=1275149 loops=1) Output: ef.arch, ef.contents_id Total runtime: 87983.826 ms Is this a bug? -- Florian Weimer / Red Hat Product Security Team -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Testing an extension without installing it

2013-12-06 Thread Florian Weimer
Is it possible to test an C extension module (.so file) without installing a SHAREDIR/extension/extension_name.control file? My test suite already runs initdb and the database as a non-postgres user, but I don't see a way to override the extension control file location. -- Florian Weimer

Re: [GENERAL] What is the relationship between checkpoint and wal

2013-08-26 Thread Florian Weimer
during recovery. -- Florian Weimer / Red Hat Product Security Team -- 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] Problem creating index

2013-08-26 Thread Florian Weimer
On 08/26/2013 04:27 PM, Torello Querci wrote: Create index statement that I use is: CREATE INDEX dati_impianto_id_tipo_dato_id_data_misurazione_idx ON dati USING btree (impianto_id , tipo_dato_id , data_misurazione DESC); What are the data types of these columns? -- Florian Weimer

Re: [GENERAL] Bottlenecks with large number of relation segment files

2013-08-06 Thread Florian Weimer
On 08/06/2013 12:28 PM, KONDO Mitsumasa wrote: (2013/08/05 20:38), Florian Weimer wrote: On 08/05/2013 10:42 AM, John R Pierce wrote: On 8/5/2013 1:01 AM, KONDO Mitsumasa wrote: When we open file, ext3 or ext4 file system seems to sequential search inode for opening file in file directory

Re: [GENERAL] Bottlenecks with large number of relation segment files

2013-08-05 Thread Florian Weimer
. And the Linux dentry cache is rather aggressive, so most of the time, only the in-memory hash table will be consulted. (The dentry cache only gets flushed on severe memory pressure.) -- Florian Weimer / Red Hat Product Security Team -- Sent via pgsql-general mailing list (pgsql-general

Re: [HACKERS] [GENERAL] Floating point error

2013-03-06 Thread Florian Weimer
. -- Florian Weimer / Red Hat Product Security Team -- 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] Pipelining INSERTs using libpq

2012-12-23 Thread Florian Weimer
. (Sorry if this message arrives twice.) -- Florian Weimer / Red Hat Product Security Team -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Pipelining INSERTs using libpq

2012-12-21 Thread Florian Weimer
tables are filled. It does not seem possible to use the asynchronous APIs for this purpose, or am I missing something? -- Florian Weimer / Red Hat Product Security Team -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Is it possible to speed up addition of not null?

2012-02-02 Thread Florian Weimer
. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Puzzling full database lock

2012-02-02 Thread Florian Weimer
query procs are killed). Does the kernel log something? Does dmesg display anything illuminating? -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99

Re: [GENERAL] Is it possible to speed up addition of not null?

2012-02-02 Thread Florian Weimer
be NULL. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Incomplete startup packet help needed

2012-01-24 Thread Florian Weimer
11549 LOG: autovacuum launcher started 2012-01-23 10:42:55.268 UTC 11551 [unknown] [unknown] LOG: incomplete startup packet I think it's harmless, it's been there for years. It might be related to the init script that starts the database server. -- Florian Weimerfwei

Re: [GENERAL] On duplicate ignore

2012-01-20 Thread Florian Weimer
an alternative. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] On duplicate ignore

2012-01-20 Thread Florian Weimer
address the restart issue, transactional code is simpler and easier to check for correctness. Restarting transactions has other benefits, too. For instance, you can restart your PostgreSQL server process, and your applications will just keep running. -- Florian Weimerfwei...@bfk.de

Re: [GENERAL] On duplicate ignore

2012-01-19 Thread Florian Weimer
aborts will be high. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] On duplicate ignore

2012-01-19 Thread Florian Weimer
* Scott Marlowe: On Thu, Jan 19, 2012 at 7:54 AM, Florian Weimer fwei...@bfk.de wrote: * Gnanakumar: Just create a unique index on EMAIL column and handle error if it comes Thanks for your suggestion.  Of course, I do understand that this could be enforced/imposed at the database-level

Re: [GENERAL] Adding German Character Set to PostgresSQL

2012-01-03 Thread Florian Weimer
terminal do you use? This doesn't appear to be an issue with PostgreSQL as such, rather something related to terminal configuration and perhaps readline. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D

Re: [GENERAL] fsync on ext4 does not work

2011-12-20 Thread Florian Weimer
* Havasvölgyi Ottó: 2011/12/19 Florian Weimer fwei...@bfk.de * Havasvölgyi Ottó: Even though the TPS in pgbench about 700 with 1 client. I have tried other sync methods (fdatasync, open_sync), but all are similar. Should I disable write cache on HDD to make it work? Did you mount

Re: [GENERAL] fsync on ext4 does not work

2011-12-19 Thread Florian Weimer
is supposed to cope properly with hard disk caches, unless the drive is lying about completing writes (but in that case, disabling write caching is probably not going to help much with reliability, either). -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de

Re: [GENERAL] heavy swapping, not sure why

2011-08-30 Thread Florian Weimer
it. Given that I'm on a machine with 128G ram, I just put /sbin/swapoff -a in /etc/rc.local and viola, problem solved. Was this NUMA machine? Some older kernels can only migrate pages between nodes through swap. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http

[GENERAL] Generic terminal-based data browsing entry

2011-07-06 Thread Florian Weimer
leaves something to be desired. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] LOCK TABLE permission requirements

2011-06-30 Thread Florian Weimer
* Josh Kupershmidt: On Wed, Jun 29, 2011 at 7:48 AM, Florian Weimer fwei...@bfk.de wrote: I've been looking around in the 9.0 documentation, but couldn't find the permission requirements for LOCK TABLE (in particular, LOCK TABLE IN SHARE MODE).  From the source, you need at least one

[GENERAL] LOCK TABLE permission requirements

2011-06-29 Thread Florian Weimer
TABLE, or is this just an oversight? -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general

Re: Fwd: Re: [GENERAL] SSDD reliability

2011-05-05 Thread Florian Weimer
at the same point. With hard disks, this doesn't seem to happen; even bad batches fail pretty much randomly. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49

Re: [GENERAL] SSDs with Postgresql?

2011-04-28 Thread Florian Weimer
have a significant performance impact on some of our loads. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing

Re: [GENERAL] SSDs with Postgresql?

2011-04-28 Thread Florian Weimer
be reasonably accurate. The numbers look as if they are valid, they match my expectations for different databases with different loads. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133

Re: [GENERAL] SSDs with Postgresql?

2011-04-21 Thread Florian Weimer
up. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] SSDs with Postgresql?

2011-04-21 Thread Florian Weimer
in $DATA/pg_xlog so checking the size of that directory regularly would get you the information. But log files are recycled, so looking at the directory alone does not seem particularly helpful. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de

Re: [GENERAL] Changing SHMMAX

2011-02-02 Thread Florian Weimer
distribution-specific. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] why sometimes checkpoint is too slow????

2011-01-19 Thread Florian Weimer
* Edmundo Robles L.: why sometimes checkpoint is too slow Checkpoints are deliberately throttled to spread out the disk write load. Is that what you are observing? -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-06 Thread Florian Weimer
* Tom Lane: Florian Weimer fwei...@bfk.de writes: The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we

Re: [GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-06 Thread Florian Weimer
* Tom Lane: Florian Weimer fwei...@bfk.de writes: Put differently, I think it's rather odd that in 9.0, both encode(bytea_value, 'escape') and encode(bytea_value, 'hex') output hexadecimal values. I don't believe that; encode produces text not bytea, so its result is not affected

[GENERAL] encode(bytea_value, 'escape') in PostgreSQL 9.0

2010-12-03 Thread Florian Weimer
The old 'escape' encoding used by PostgreSQL 8.4 and prior was pretty helpful for getting human-readable strings in psql. It seems this functionality was removed in PostgreSQL 9.0. Was this an accident or a deliberate decision? Could we get it back, please? -- Florian Weimer

Re: [GENERAL] PostgreSQL hanging on new connections?

2010-11-30 Thread Florian Weimer
might hint to what's going on with the system. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql

[GENERAL] Streaming processing of result sets

2010-11-24 Thread Florian Weimer
deadlock if you block during result processing (waiting for another network connection, for instance). Is this true for PostgreSQL as well, or can clients block without causing too much trouble? -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße

Re: [GENERAL] alter table add column - specify where the column will go?

2010-11-24 Thread Florian Weimer
features rely on deterministic column order. Here's an example: SELECT 1 AS a, 2 AS b UNION SELECT 3 AS b, 4 AS a; a | b ---+--- 1 | 2 3 | 4 (2 rows) -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1

Re: [GENERAL] alter table add column - specify where the column will go?

2010-11-24 Thread Florian Weimer
* Grzegorz Jaśkiewicz: 2010/11/24 Florian Weimer fwei...@bfk.de: * Grzegorz Jaśkiewicz: just never use SELECT *, but always call columns by names. You'll avoid having to depend on the order of columns, which is never guaranteed, even if the table on disk is one order, the return columns

Re: [GENERAL] Simple schema diff script in Perl

2010-09-17 Thread Florian Weimer
don't know if there is a newer version. I can see that such a tool could be useful. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via

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

2010-01-21 Thread Florian Weimer
be a different story, but TOAST table are a fairly deep implementation detail and should perhaps be hidden here). -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721

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

2009-12-16 Thread Florian Weimer
* Craig Ringer: On 16/12/2009 3:54 PM, Florian Weimer wrote: * Michael Clark: The solution to the problem seemed to be to change the value for the wal_sync_method setting to fsync_writethrough from the default of fsync. I was curious if there were perhaps any other reasons that we should

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

2009-12-15 Thread Florian Weimer
. fsync_writethrough seems to be global in effect (not file specific), so it's going to hurt if there is other I/O activity on the box. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe

Re: [GENERAL] Working around spurious unique constraint errors due to SERIALIZABLE bug

2009-07-20 Thread Florian Weimer
, then compliant implementations would have to do predicate locking. Ouch. Does anybody do that? You don't need predicate locking here. You just have to lock on the gap in the index you touched. I think some implementations do this (InnoDB calls it next-key locking). -- Florian Weimer

Re: [GENERAL] Working around spurious unique constraint errors due to SERIALIZABLE bug

2009-07-20 Thread Florian Weimer
a few times if a unique_violation is detected, but I'd like to get rid of that because it's one thing less the programmer needs to worry about. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133

[GENERAL] Working around spurious unique constraint errors due to SERIALIZABLE bug

2009-07-16 Thread Florian Weimer
in a background task which doesn't run in parallel, but this approach isn't always possible. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent

Re: [GENERAL] Working around spurious unique constraint errors due to SERIALIZABLE bug

2009-07-16 Thread Florian Weimer
occur for another reason (which would be a bug), and I want to avoid an endless loop in such cases. But if it's possible to isolate this type of error recovery to a single statement, this risk is greatly reduced. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http

Re: [GENERAL] How to store text files in the postgresql?

2009-06-07 Thread Florian Weimer
* DimitryASuplatov: I`ve also worked out how to do this simply from bash ./bin/psql mypdb EOF insert into pdb values ('`cat /file/name`'); EOF This doesn't work if the file contains embedded ' characters (and backslashes and NULs are also problematic). You will also get errors if the file

[GENERAL] Apparent race in information_schema.tables

2009-05-11 Thread Florian Weimer
CREATE TEMPORARY TABLE/DROP TABLE activity in an other backend process. -- Florian Weimerfwei...@bfk.de BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql

Re: [GENERAL] Memory on 32bit machine

2008-01-07 Thread Florian Weimer
Or would you rather vote for 64bit because there are no problems anymore and postgresql runs fine on 64bit debian. We haven't run into any trouble with iptables on Debian etch, running on amd64 hardware. But we use only fairly standard iptables functionality. -- Florian Weimer

Re: [GENERAL] [Slony1-general] Any big slony and WAL shipping users?

2007-12-28 Thread Florian Weimer
it might increase risk). If you use multiple systems with a comparator, things are different, of course. -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201

Re: [HACKERS] [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Florian Weimer
* Magnus Hagander: Oh, that's interesting. That's actually a sideeffect of us increasing the stack size for the postgres.exe executable in order to work on other things. By default, it burns 1MB/thread, but ours will do 4MB. Never really thought of the problem that it'll run out of address

Re: [HACKERS] [GENERAL] Undetected corruption of table files

2007-08-29 Thread Florian Weimer
be pretty straightforward). Something like an Adler32 checksum (not a full CRC) on each page might be helpful. However, what I'd really like to see is something that catches missed writes, but this is very difficult to implement AFAICT. -- Florian Weimer[EMAIL PROTECTED] BFK edv

Re: [GENERAL] Memory settings, vm.overcommit, how to get it really safe?

2007-05-18 Thread Florian Weimer
. Other Java implementations make different choices. -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 ---(end of broadcast

[GENERAL] Foreign keys, table inheritance, and TRUNCATE

2007-01-30 Thread Florian Weimer
. Perhaps it's a good idea to extend TRUNCATE on a parent table to all children? -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99

Re: [GENERAL] Rollback using WAL files?

2007-01-26 Thread Florian Weimer
database as much as possible, meaning I would like to undo all transactions that were performed on it. In theory, this should be possible (especially if you haven't switched off full page writes). But I don't know a ready-made solution for this kind of task. -- Florian Weimer

Re: [GENERAL] Very long or where clause

2007-01-16 Thread Florian Weimer
* Scara Maccai: Which would be the best method to access data? Should I use a procedure on the server side? I tend to use a join to a temporary table for similar purposes. It seems like the cleanest approach. -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH

Re: [GENERAL] (Perl) script to set up an instance for regression tests

2006-12-13 Thread Florian Weimer
* Tom Lane: Florian Weimer [EMAIL PROTECTED] writes: For regression tests, I'd like to automatically set up a fresh PostgreSQL instance. Has anybody automated the task (initdb, setting a password, choosing a port at random, starting the server, and after running the tests, stopping

[GENERAL] (Perl) script to set up an instance for regression tests

2006-12-12 Thread Florian Weimer
a straightforward Perl script, but perhaps someone else has already written it. 8-) And: $ fakeroot /usr/lib/postgresql/8.1/bin/postgres -D . postgres root execution of the PostgreSQL server is not permitted. [...] This is a major problem when autobuilding Debian packages. 8-( -- Florian Weimer

[GENERAL] DISTINCT is not quite distinct

2006-11-06 Thread Florian Weimer
). Is this a known problem? If I drop the DISTINCT, the output is not correctly ordered, either. Perhaps this is an index corruption issue? The hardware itself seems fine. -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100

Re: [GENERAL] DISTINCT is not quite distinct

2006-11-06 Thread Florian Weimer
be interested to compare the two versions of the index. The index files are about 155 MB and 98 MB, compressed. How shall we transfer them? (Their contents is not super-secret, but I don't want to distribute them widely, either.) -- Florian Weimer[EMAIL PROTECTED] BFK edv

Re: [GENERAL] DISTINCT is not quite distinct

2006-11-06 Thread Florian Weimer
= 1007617 for both rows, the others are zero. The table hasn't got OIDs. -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99

Re: [GENERAL] Deadlock when one process opens two separate connections?

2006-09-26 Thread Florian Weimer
* Kaloyan Iliev: Probbly beacause both transactions started from one process? Yes, the deadlock detector isn't psychic. It can't know about lock ordering constraints which are external to PostgreSQL. -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH http

[GENERAL] Inherited tables vs UNION ALL views

2006-09-14 Thread Florian Weimer
, is there still a difference between the two approaches? -- Florian Weimer[EMAIL PROTECTED] BFK edv-consulting GmbH http://www.bfk.de/ Durlacher Allee 47tel: +49-721-96201-1 D-76131 Karlsruhe fax: +49-721-96201-99 ---(end

Re: [GENERAL] ECPG and COPY

2006-09-12 Thread Florian Weimer
confused. STDOUT is already implemented. I wasn't aware of the fact that ECPG's implementation of STDOUT is verbatim stdout (and not something similar to what DBD::Pg does). This means both STDOUT and STDIN are not very useful (and STDIN even less). -- Florian Weimer[EMAIL PROTECTED

Re: [GENERAL] ECPG and COPY

2006-08-02 Thread Florian Weimer
* Michael Meskes: COPY TO STDOUT has been implemented, but I'm unsure whether COPY FROM STDIN really makes sense. Does anyone know a real life example where this would be needed and the work couldn't be done easier using psql? COPY FROM STDIN saves lots of network round-trips. -- Florian

Re: [GENERAL] ECPG and COPY

2006-08-02 Thread Florian Weimer
* Michael Meskes: Could you please explain what this has to do with my original question? I assumed that ECPG did something special with TO STDOUT, like other interfaces do. This is not the case (that is, STDOUT is really standard output, so the functionality is not very useful. -- Florian

Re: [GENERAL] INSERT 0 1 problems

2006-07-17 Thread Florian Weimer
* Stefan Schwarzer: INSERT 0 1 INSERT 48593 1 The former is printed if the table hasn't got an OID column (new default), the latter is used when OIDs are available (old default, nowadays it's CREATE TABLE ... WITH OIDS). -- Florian Weimer[EMAIL PROTECTED] BFK

Re: [GENERAL] Timestamp vs timestamptz

2006-07-14 Thread Florian Weimer
* Agent M.: timestamp with time zone does not record the timezone you inserted it with- it simply stores the GMT version and converts to whatever timezone you like on demand. Are you sure? This behavior is not documented, and I can't reproduce it with PostgresQL 8.1.4. -- Florian Weimer

Re: [GENERAL] Timestamp vs timestamptz

2006-07-14 Thread Florian Weimer
* Tom Lane: Florian Weimer [EMAIL PROTECTED] writes: * Agent M.: timestamp with time zone does not record the timezone you inserted it with- it simply stores the GMT version and converts to whatever timezone you like on demand. Are you sure? This behavior is not documented, and I can't

Re: [GENERAL] Need help with quote escaping in exim for postgresql

2006-07-09 Thread Florian Weimer
* Martijn van Oosterhout: * If application always sends untrusted strings as out-of-line parameters, instead of embedding them into SQL commands, it is not vulnerable. This paragraph should explictly mention PQexecParams (which everybody should use anyway). It seems that Exim's

Re: [GENERAL] Disk corruption detection

2006-06-12 Thread Florian Weimer
* Lincoln Yeoh: At 07:42 PM 6/11/2006 +0200, Florian Weimer wrote: We recently had a partially failed disk in a RAID-1 configuration which did not perform a write operation as requested. Consequently, What RAID1 config/hardware/software was this? I would expect that any RAID-1 controller

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

2006-06-12 Thread Florian Weimer
* Roy Souther: In what way could a database like PostgreSQL not be faithful to relational theory? Does he give any explanation as to what that means? My guess: In SQL (and in PostgreSQL as a result), relations aren't sets, aren't first-class, and the underlying logic is not Boolean.

Re: [GENERAL] Disk corruption detection

2006-06-12 Thread Florian Weimer
* Jim C. Nasby: Anyway, how would be the chances for PostgreSQL to detect such a corruption on a heap or index data file? It's typically hard to detect this at the application level, so I don't expect wonders. I'm just curious if using PostgreSQL would have helped to catch this sooner. I

[GENERAL] Disk corruption detection

2006-06-11 Thread Florian Weimer
We recently had a partially failed disk in a RAID-1 configuration which did not perform a write operation as requested. Consequently, the mirrored disks had different contents, and the file which contained the block switched randomly between two copies, depending on which disk had been read. (In

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-18 Thread Florian Weimer
* Kenneth Downs: If you seek to provide a closed source app that is built upon Andromeda, you are required to provide the source code to Andromeda itself. However, your app is not a derivative work in the strict sense because your code is not mixed in with mine in any sense. You never

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-18 Thread Florian Weimer
* Joshua D. Drake: Sounds great! But why GPL? Are you looking to sell licenses? GPL is to spread it as far and wide as possible as fast as possible. LGPL? My concern would be, I can't use this toolkit for a closed source application if it is GPL. Closed source? It's a PHP framework. 8-)

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-18 Thread Florian Weimer
* Kenneth Downs: Many proprietary software vendors think that if you program to an interface which has a sole implementation, your code becomes a derived work of that implementation. If you sell different licenses for run-time and development environments, such an attitude towards copyright law

Re: [GENERAL] Announce: GPL Framework centered on Postgres

2006-05-18 Thread Florian Weimer
* Matteo Beccati: Hi, Florian Weimer wrote: Closed source? It's a PHP framework. 8-) Anyway, for a web application, the GPL is usually *less* restrictive than various BSD license variants because you do not need to mention the software in the end user documentation. The viral aspect

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

2006-05-10 Thread Florian Weimer
* Hannes Dorbath: + Hardware Raids might be a bit easier to manage, if you never spend a few hours to learn Software Raid Tools. I disagree. RAID management is complicated, and once there is a disk failure, all kinds of oddities can occur which can make it quite a challenge to get back a

Re: [GENERAL] Debian Packages For PostgreSQL

2006-02-09 Thread Florian Weimer
* Redefined Horizons: It looks like the packages.debian.org site is down. Is there another place where I can download a .deb for the latest stable version of PostgreSQL. (I don't have a direct link to the internet on my Linux box, so I can't use APT.)

Re: [GENERAL] Postgresql FIFO Tables, How-To ?

2003-07-18 Thread Florian Weimer
Kirill Ponazdyr [EMAIL PROTECTED] writes: It is for a advanced syslog server product we are currently developing. The very basic idea is to feed all syslog messages into a DB and allow easy monitoring and even correlation, we use Postgres as our DB Backend, in big environments the machine

Re: [GENERAL] IPv4 addresses, unsigned integers, space

2003-07-17 Thread Florian Weimer
Jim Crate [EMAIL PROTECTED] writes: on 7/15/03, Florian Weimer [EMAIL PROTECTED] wrote: If I switched from signed integers to unsigned integers (and from INET to real IPv4 addresses, consisting of the relevant 32 bits only) I think I could save about 25% of my table size. Why do you need

[GENERAL] IPv4 addresses, unsigned integers, space

2003-07-15 Thread Florian Weimer
If I switched from signed integers to unsigned integers (and from INET to real IPv4 addresses, consisting of the relevant 32 bits only) I think I could save about 25% of my table size. Does PostgreSQL already implement these data types? I don't think so. If I succeed in implementing them, would

Re: [GENERAL] IPv4 addresses, unsigned integers, space

2003-07-15 Thread Florian Weimer
Bruno Wolff III [EMAIL PROTECTED] writes: Does PostgreSQL already implement these data types? I don't think so. If I succeed in implementing them, would you accept a patch? You can have unsigned integers using a domain with a check constraint. They take twice as much storage as necessary.