Re: [GENERAL] Internal function call from C-language function

2006-12-07 Thread Martijn van Oosterhout
, timest); You're passing a cstring as first argument, whereas I'm fairly sure you should be passing text. When calling from C the're no argument checking. I think what you're looking for is: yeardatum = text_in(year); Or something like that. Hope this helps, -- Martijn van Oosterhout kleptog

Re: [GENERAL] Internal function call from C-language function

2006-12-07 Thread Martijn van Oosterhout
the result of GetAttributeByName directly. Get at least a backtrace next time it crashes... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [GENERAL] [PERFORM] Locking in PostgreSQL?

2006-12-06 Thread Martijn van Oosterhout
, readers (SELECT statements) will not be blocked. So it's not a lock as such, more a I've updated this row, go find the new version if that's appropriate for your snapshot. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [GENERAL] HELP: Urgent, Vacuum problem

2006-12-06 Thread Martijn van Oosterhout
. I don't know why. :| You need to subscribe. If you don't actually want to receive list mail, you configure your email address nomail. Then you can send messages and they'll get through straight away. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From

Re: [GENERAL] PG Admin

2006-12-05 Thread Martijn van Oosterhout
is incorrect. If what you were asking was easy, it would have been done long ago... Sequences without holes is nowhere near as trivial as people think it is. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each

Re: [GENERAL] pgsql bug found?

2006-12-04 Thread Martijn van Oosterhout
a double entry every now and again. for instance I constantly get the following entries It's either a wierd daylight savings thing, or something to do with the fact that not all months have 31 days. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From

Re: [GENERAL] Unsuccessful SIGINT - More Info

2006-12-02 Thread Martijn van Oosterhout
try stronger signals? Have a ncie day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] DBI module for postgres 1.4.3

2006-12-01 Thread Martijn van Oosterhout
version of DBI should I be using. Whichever version is installed by your system should be fine. Clients are compatable across many versions. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [GENERAL] How to increace nightly backup speed

2006-11-30 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Ident authentication failed for user dsivam

2006-11-30 Thread Martijn van Oosterhout
localhost snip Maybe you're not running an ident daemon? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] coalesce with all nulls can only be assigned to

2006-11-29 Thread Martijn van Oosterhout
without any associated type. Or does Java not distinguish either? Does this help? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [GENERAL] IN clause

2006-11-28 Thread Martijn van Oosterhout
can't use the index for IS NULL tests, although patches exist for that. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] How to increace nightly backup speed

2006-11-28 Thread Martijn van Oosterhout
have a multicore system, it may be worth having pg_dump not compress but piping the output through gzip, then you can use both processors simultaneously. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each

Re: [GENERAL] Very minor configure issue?

2006-11-28 Thread Martijn van Oosterhout
-standard paths, at least include those paths in the system-wide library search path or add them to LD_LIBRARY_PATH. You could even symlink the libs into /usr/lib, that would also solve the problem. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From

Re: [GENERAL] FK pointing to a VIEW

2006-11-28 Thread Martijn van Oosterhout
known to be wrong before. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Datafiles binary portable?

2006-11-28 Thread Martijn van Oosterhout
be compatable across the same platform with different compilers and/or configure flags. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [GENERAL] backend crash following load command

2006-11-28 Thread Martijn van Oosterhout
that. The protection of ETXTBUSY only applies to code started via exec(). Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] backend crash following load command

2006-11-28 Thread Martijn van Oosterhout
this? dlopen() mmaps the .so into memory and the cp overwrites what was mmaped, changing what is in memory. Ideally, the cp should fail with ETXTBSY, but that doesn't happen, so what else can you do? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From

Re: [GENERAL] backend crash following load command

2006-11-28 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] fatal error on 8.1 server

2006-11-27 Thread Martijn van Oosterhout
you've updated your maintainence setup to avoid this in the future? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] which version? old user coming back....

2006-11-27 Thread Martijn van Oosterhout
://packages.debian.org/unstable/misc/postgresql-8.0 http://packages.debian.org/unstable/misc/postgresql-8.1 http://packages.debian.org/experimental/misc/postgresql-8.2 Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [GENERAL] indexes

2006-11-25 Thread Martijn van Oosterhout
of magnitude more often than they are updated, so index update cost isn't all that relevent. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description

Re: [GENERAL] IN clause

2006-11-24 Thread Martijn van Oosterhout
null queries , am i right? You'll need to check the standard, but IN() treats NULL specially, I think it returns NULL if any of the elements is null, or something like that. It certainly doesn't work the way you think it does. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http

Re: [GENERAL] log database changes - a design problem?

2006-11-23 Thread Martijn van Oosterhout
be good for. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] IS it a good practice to use SERIAL as Primary Key?

2006-11-23 Thread Martijn van Oosterhout
, but the check digit does not need to be stored, as it can be regenerated on demand. The user interface just verifies the check digit, then throws it away. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according

Re: [GENERAL] COPY FROM : out of memory

2006-11-23 Thread Martijn van Oosterhout
Can you put together a self-contained example? The reference to line 1 suggests that you wouldn't need the whole 20M row file, just the first few rows ... Maybe it's a line termination problem? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From

Re: [GENERAL] Buffer overflow in psql

2006-11-22 Thread Martijn van Oosterhout
summarize my vacuuming strategy for anyone interested.) I think most people have OIDs disabled, which avoids the problem entirely. Perhaps that's why it hasn't been run into before. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006-11-22 Thread Martijn van Oosterhout
variants. For transmission between systems it's the easiest to get right... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] User-defined-type in C crashing PostgreSQL server: What am I doing wrong?

2006-11-18 Thread Martijn van Oosterhout
trying to copy it. Hope this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Data conversion tools?

2006-11-17 Thread Martijn van Oosterhout
tables to accomplish that. Sorry? # \h alter table snip ALTER TABLE [ ONLY ] name [ * ] RENAME [ COLUMN ] column TO new_column ALTER TABLE name RENAME TO new_name snip Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his

Re: [GENERAL] Accessing postgres in perl app using ssl authentication

2006-11-16 Thread Martijn van Oosterhout
authentication? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Linux hard drive/device nodes for a Postgres RAID array

2006-11-16 Thread Martijn van Oosterhout
2 to always be SDC, even if the drive on port 1 fails or is pulled? I thought you could do this with options on the command-line, or using udev. But I don't think it's actually necessary. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each

Re: [GENERAL] PgSQL not recognized

2006-11-15 Thread Martijn van Oosterhout
understands directly is SQL, other languages are restricted to use within functions. The documentation is large. There has been some effort to get it into a form more accessable, but it's hard when there's that much of it. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http

Re: [GENERAL] Using SAN Splits to instantly copy a DB

2006-11-15 Thread Martijn van Oosterhout
to ensure database consistancy after a crash. When you take a snapshot and start a new postmaster on the snapshot, it sees what looks like a crashed database and recovers it to the instant it snapshotted (aka crashed). Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http

Re: [GENERAL] Using SAN Splits to instantly copy a DB

2006-11-15 Thread Martijn van Oosterhout
/wal.html Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Using SAN Splits to instantly copy a DB

2006-11-15 Thread Martijn van Oosterhout
SAN splitting is so I'm not totally sure. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Using PL/pgSQL

2006-11-14 Thread Martijn van Oosterhout
upgrade. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] encoding advice requested

2006-11-14 Thread Martijn van Oosterhout
the tip about how to get the browser to tell you what encoding it used. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] libpq.so full name?

2006-11-14 Thread Martijn van Oosterhout
libpq.so with size = 133320 it gives an error (linking error i think), howver if i rename the above file to libpq.so.3 then it works fine. What is this behaviour? Please provide the exact commandline you're running and the exact error message. Have a nice day, -- Martijn van Oosterhout kleptog

Re: [GENERAL] Out of memory (Failed on request size 24)

2006-11-14 Thread Martijn van Oosterhout
there was a check on negative sized allocations... Did make check pass ok? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] PgSQL not recognized

2006-11-14 Thread Martijn van Oosterhout
question still stands, however. In the latest release, in beta, you can DROP IF EXISTS. However, most people just execute the drop and ignore the error, less risk of race conditions. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his

Re: [GENERAL] help needed, PG 8.0.0 ERROR: index is not a btree is solved in 8.0.9

2006-11-14 Thread Martijn van Oosterhout
. No-one has come across an bug that would cause that. Basically, for more info we need to see the hexdump of the first 8k of the index file to see why the system thinks it's not a btree. Can you do that? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog

Re: [GENERAL] The old Insert and retrieving your Serial problem in VB

2006-11-14 Thread Martijn van Oosterhout
deal with an auto-generated database object an *extremely* inelegant solution. Maybe you're looking for lastval()? http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each

Re: [GENERAL] PG_MODULE_MAGIC check in 8.2

2006-11-14 Thread Martijn van Oosterhout
this could be made into a configurable option so the user can choose the desired behavior? Why? It's a one line addition to the source of the module, much less work than trying to disable the check in the backend... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org

Re: [GENERAL] PG_MODULE_MAGIC check in 8.2

2006-11-14 Thread Martijn van Oosterhout
the library kernel32? If you use language internal, doesn't that find it since it's already loaded? Then you don't need any module magic at all... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his

Re: [GENERAL] Table and Field namestyle best practices?

2006-11-13 Thread Martijn van Oosterhout
-insensetive and you don't have to worry much about upper and lower case. You will read them back in lowercase though. But to answer your question, unquoted identifiers can contain letters, numbers and the underscore. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org

Re: [GENERAL] Why isn't it allowed to create an index in a schema other than public?

2006-11-12 Thread Martijn van Oosterhout
to be doing exactly what you want. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] encoding advice requested

2006-11-11 Thread Martijn van Oosterhout
that variable per user also. b) I can issue a SET CLIENT_ENCODING TO 'LATIN1'; statement every time I open a connection. A brief test indicates this will work. This is the solution, assuming ofcourse your application is in Latin1. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http

Re: [GENERAL] ECPG and multiple threads

2006-11-10 Thread Martijn van Oosterhout
places. Note, you might be able to make ECPG and libpq thread-safe, however even then you *cannot* use the same connection simultaneously from different threads. You will have to open a new connection for each parallel connection you want to handle. Or use locking. Have a nice day, -- Martijn van

Re: [GENERAL] Which DatumGet ?

2006-11-10 Thread Martijn van Oosterhout
On Fri, Nov 10, 2006 at 05:30:09PM +0100, Enrico wrote: In my table I have a field myfied defined by myfield numeric(20,5); Which kind of DatumGet macro I have to use? As an indirect type you want DatumGetPointer and cast it to numeric*. Have a nice day, -- Martijn van Oosterhout

Re: [GENERAL] wildcard alias

2006-11-10 Thread Martijn van Oosterhout
. ---(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 -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each

Re: [GENERAL] 8.1.2 postmaster died

2006-11-09 Thread Martijn van Oosterhout
killer too? Although maybe it's quotas? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Datum problem

2006-11-09 Thread Martijn van Oosterhout
you're returing something else. } What are you returning if the if statement doesn't get run? Hope this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description

Re: [GENERAL] Can non-superuser install c functions ?

2006-11-09 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] converting Informix outer to Postgres

2006-11-08 Thread Martijn van Oosterhout
don't know what the Informix outer join is, but is it like the SQL FULL OUTER JOIN? Have you tried using that? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate

Re: [GENERAL] Header meaning for pg_dump

2006-11-07 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] X.50x OID representation

2006-11-07 Thread Martijn van Oosterhout
://projects.commandprompt.com/public/pgsql/browser/trunk/pgsql/contrib/ltree/README.ltree Hope this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [GENERAL] timezone difference in timestamp?

2006-11-06 Thread Martijn van Oosterhout
calculations postgresql is correct. $ perl -e 'print scalar(gmtime(1162789200)),\n' Mon Nov 6 05:00:00 2006 Make sure you understand whether the dates your comparing are in the same timezone. Maybe you want 'timestamp with time zone'. Hope this helps, -- Martijn van Oosterhout kleptog@svana.org

Re: [GENERAL] explosion of tiny tables representing multiple

2006-11-05 Thread Martijn van Oosterhout
, the performence should be good. If you make a single array with 50,000 element, it's going to suck very badly. Note, recent versions of postgres have better support for arrays, including for indexing thereof. Especially the new GIN index type may be useful for you. Have a nice day, -- Martijn van

Re: [GENERAL] dividing integers not producing decimal fractions

2006-11-05 Thread Martijn van Oosterhout
, mostly it's better to explicitly make all your constants non-integer if that's what you mean. This statement: select (1.0/2.0)*4.0; Gives the same result, but doesn't need any casts. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according

Re: [GENERAL] Simple stored procedure examples?

2006-11-05 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Simple stored procedure examples?

2006-11-05 Thread Martijn van Oosterhout
automatically quote anything, ever. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] UNICODE and UTF-8

2006-11-04 Thread Martijn van Oosterhout
is concerned, UTF8 is UNICODE. IIRC some versions said one name, some the other, but they mean the same thing. So maybe you have a different version than your provider? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each

Re: [GENERAL] start up and shut down script

2006-11-03 Thread Martijn van Oosterhout
to be for a redhat based system, not sure because I don't have them. if [ `uname` = Linux ]; then INITD=/etc/rc.d/init.d . $INITD/functions # Get config. . /etc/sysconfig/network fi Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according

Re: [GENERAL] Counting records in a PL/pgsql cursor

2006-11-03 Thread Martijn van Oosterhout
that without looping through them all? You can move to the end, look at the row number, then move to the beginning. It will still need to materialise the entire resultset though. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [GENERAL] Isolation / Visibility inside a trigger

2006-11-03 Thread Martijn van Oosterhout
fields in NEW) and tasks after (updating other tables). Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Isolation / Visibility inside a trigger

2006-11-03 Thread Martijn van Oosterhout
field into a seperate table updated by the after trigger. Hope this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Invoking java in a trigger

2006-11-03 Thread Martijn van Oosterhout
van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] fetching unique pins in a high-transaction environment...

2006-11-03 Thread Martijn van Oosterhout
the amount of contention dramatically, so you can use the simple method. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] explosion of tiny tables representing multiple fields--Is this necessary?

2006-11-03 Thread Martijn van Oosterhout
, etc. Have you considered using arrays? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Weird double single quote issue

2006-11-02 Thread Martijn van Oosterhout
functions to help create dynamic sql safely. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] compiling c-function on various version

2006-11-02 Thread Martijn van Oosterhout
On Thu, Nov 02, 2006 at 10:53:52PM +0900, Hitoshi Harada wrote: but couldn't, PG_VERSION is string type. any other macro or definitions?? In recent versions there's a PG_VERSION_NUM. For older versions you can track changes in the catalog version number. Have a nice day, -- Martijn van

Re: [GENERAL] pg_proc Question

2006-11-02 Thread Martijn van Oosterhout
... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] lots of values for IN() clause

2006-11-02 Thread Martijn van Oosterhout
. PostgreSQL now actually checks whether the number you provided makes sense. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Encoding, Unicode, locales, etc.

2006-11-01 Thread Martijn van Oosterhout
and the xlog taking dozens of megabytes. At the end of the day I don't think 10MB for the Unicode data it going to be that big a deal, *if* the patch solves all the problems in this area in a reasonably clean way... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog

Re: [GENERAL] access and security

2006-10-30 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

2006-10-27 Thread Martijn van Oosterhout
extra configuration. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] what is the default username password for PostgreSQL, which was installed with FC5.

2006-10-27 Thread Martijn van Oosterhout
user y. Check the documentation. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] recovery from xid wraparound

2006-10-24 Thread Martijn van Oosterhout
while the old data was invisible. Only you can say if that's going to be an issue. Hope this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital

Re: [GENERAL] recovery from xid wraparound

2006-10-24 Thread Martijn van Oosterhout
. But to get a handle on that you need to analyse your tuple turnover and usage ratio. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description

Re: [GENERAL] recovery from xid wraparound

2006-10-24 Thread Martijn van Oosterhout
based on the table continuing to be updated while vacuum is running) It depends on how many tuples it needs to process and how much memory you gave it (the maintainence_work_mem settings). The more memory you give it, the less passes it needs to do... Have a nice day, -- Martijn van Oosterhout

Re: [GENERAL] How to get joins to work

2006-10-24 Thread Martijn van Oosterhout
(joinfield) or select * FROM rack r JOIN sample s ON (r.a = s.b); If you really don't want any constraints, use a comma, or a cross join Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability

Re: [GENERAL] How to find out about zlib compression

2006-10-22 Thread Martijn van Oosterhout
| grep libz You should be checking the libraries used by pg_dump, not postgres. It's pg_dump that does the compression, the actual server does not use an external compression library (directly anyway). Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From

Re: [GENERAL] why not kill -9 postmaster

2006-10-20 Thread Martijn van Oosterhout
discussed here. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] PostgreSQL, LGPL and GPL.

2006-10-20 Thread Martijn van Oosterhout
, but talking over a socket doesn't create any kind of dependancy at all. I don't think anyone has ever tried to claim that talking to a GPL server requires your code to be GPL also. The existing counterexamples alone... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org

Re: [GENERAL] VACUUM and open transactions

2006-10-19 Thread Martijn van Oosterhout
transaction can see effects of later started transactions, so VACUUM can't delete the later stuff either... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [GENERAL] VACUUM and open transactions

2006-10-19 Thread Martijn van Oosterhout
for the difference the READ COMMITTED and SERIALIZABLE transaction. The former (the default) will see the results of any committed transactions, even if they started later. http://www.postgresql.org/docs/8.1/interactive/transaction-iso.html#XACT-READ-COMMITTED Have a nice day, -- Martijn van Oosterhout

Re: [GENERAL] COPY FROM STDIN instead of INSERT

2006-10-18 Thread Martijn van Oosterhout
or joins to fill the table, only raw data. Binary may be slightly faster because the datum parsing can be partially skipped, but that's hardly much benefit over a text copy. Hope this helps, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [GENERAL] How to _really_use a non-default tablespace

2006-10-17 Thread Martijn van Oosterhout
is not split by database, all databases share the same xlog. Have a ncie day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] How to _really_use a non-default tablespace

2006-10-17 Thread Martijn van Oosterhout
as it first seemed to me. But I might be missing something. xlogs are recycled. You can control the growth somewhat by playing with the xlog settings in the config. It should stabilise at about 16MB times the wal segments. Have a nice dat, -- Martijn van Oosterhout kleptog@svana.org http

Re: [GENERAL] ERROR: current transaction is aborted, commands ignored until end of transaction block

2006-10-16 Thread Martijn van Oosterhout
not displaying. If you have a look at the server log file, what do you see? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] Dates rejected

2006-10-16 Thread Martijn van Oosterhout
(datfis = trunc(datfis::timestamp without time zone))); What are you trying to do here? If you only want a date, why not just use a date type? Have you tried evaluating the expression yourself? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each

Re: [GENERAL] old Pg interface

2006-10-16 Thread Martijn van Oosterhout
with continuing to use the old Pg interface with newer versions of PostgreSQL? I have a lot of code that still uses the old Pg interface. It works fine against newer versions. There's no requirement to change. If it ain't broke, don't fix it. Have a nice day, -- Martijn van Oosterhout kleptog

Re: [GENERAL] datatype preceded by underscore creates array

2006-10-16 Thread Martijn van Oosterhout
standard name. PostgreSQL displays SQL compliant output where possible. _int simply doesn't exist, and oddities like (3) after the char does have array support at all... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [GENERAL] datatype preceded by underscore creates array

2006-10-16 Thread Martijn van Oosterhout
another way of saying: create table a7 (b _bpchar) except that doesn't allow you to specify a length... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc

Re: [GENERAL] UTF-8

2006-10-13 Thread Martijn van Oosterhout
On Thu, Oct 12, 2006 at 11:09:53PM +0200, Tomi NA wrote: 2006/10/12, Martijn van Oosterhout kleptog@svana.org: On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote: There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4, (there are one of locale: lv_LV.utf8

Re: [GENERAL] Performance Problem

2006-10-13 Thread Martijn van Oosterhout
’t understand it from http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html, can anyone explain me with a simple example. Can't help you there... Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability

Re: [GENERAL] UTF-8

2006-10-13 Thread Martijn van Oosterhout
*should* work. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

Re: [GENERAL] UTF-8

2006-10-13 Thread Martijn van Oosterhout
On Fri, Oct 13, 2006 at 12:04:02PM -0400, Tom Lane wrote: Tomi NA [EMAIL PROTECTED] writes: 2006/10/13, Martijn van Oosterhout kleptog@svana.org: Similarly, upper/lower are also supported, although postgresql doesn't take advantage of the system support in that case. I think

Re: [GENERAL] more anti-postgresql FUD

2006-10-13 Thread Martijn van Oosterhout
see your point, but is that a safe assumption? Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature

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