[GENERAL] 8.3.-build fails due parse error in VERSION script

#make skip make[3]: Entering directory `/opt_noraid/src/postgresql-8.3.0/src/interfaces/libpq' echo '{ global:' exports.list gawk '/^[^#]/ {printf %s;\n,$1}' exports.txt exports.list echo ' local: *; };' exports.list gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline

[GENERAL] extend group by to include empty relations ?

this? thnx a lot, peter -- mag. peter pilsl - goldfisch.at IT-Consulting Tel: +43-650-3574035 Tel: +43-1-8900602 Fax: +43-1-8900602-15 skype: peter.pilsl [EMAIL PROTECTED] www.goldfisch.at ---(end of broadcast)--- TIP 3: Have you checked our

[GENERAL] proper export table to csv? multilineproblem.

not know about the CSV-option yet (not does the postgres 8). Is there any ready tool to create flexible csv-files or any trick I did not find out yet? thnx, peter -- mag. peter pilsl - goldfisch.at IT-Consulting Tel: +43-650-3574035 Tel: +43-1-8900602 Fax: +43-1-8900602-15 skype: peter.pilsl

[GENERAL] order by text-type : whitespaces ignored??

I just get my mind crossed here: I do a simple select with order on a text-type. In my opinion entries with leading spaces should be either first (or maybe last) in the list. But in my select the whitespace just seems to be ignored: Note that the second row has a leading space and should

Re: [GENERAL] order by text-type : whitespaces ignored??

Richard Huxton wrote: peter pilsl wrote: I just get my mind crossed here: I do a simple select with order on a text-type. In my opinion entries with leading spaces should be either first (or maybe last) in the list. But in my select the whitespace just seems to be ignored: That'll be down

[GENERAL] help with rules please

which makes postgres break with a nested.loop -error (happily postgres detects the recursion :) thnx for any help peter -- mag. peter pilsl goldfisch.at IT- dataconsulting tel: +43 650 3574035 tel: +43 1 8900602 fax: +43 1 8900602 15 [EMAIL PROTECTED] ---(end

[GENERAL] count( only if true)

the count-aggreate counts every expression that does not evaluate to null. I would like to have a count that counts all values that are true. Do I really need to make a count( case when expression then 't' else null) to implement this? thnx, peter -- mag. peter pilsl goldfisch.at

Re: [GENERAL] count( only if true)

; thnx a lot, peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fae +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] renumber id's in correct order (compact id's)

table using nextval on the sequencec. Unfortunately UPDATE does not know about an order-statement. Any Idea, thnx, peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fae +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] renumber id's in correct order (compact id's)

+0200, peter pilsl wrote: I've entries with id's like: x | id ---+ b | 1 a | 4 e | 5 c | 12 d | 19 (5 rows) now I'd like to have the id in continuing number to get: x | id ---+ b | 1 a | 2 e | 3 c | 4 d | 5 (5 rows) Simpliest way to do would be to create a sequence and update

Re: [GENERAL] renumber id's in correct order (compact id's)

Martijn van Oosterhout wrote: thnx a lot. But it does not work as expected cause the update-statement ist not commiting for the whole table during the execution. So the resulting order can be different from the original order, which is what I try to avoid. Well, that's because you're

[GENERAL] optimal hardware for postgres?

at all, cause CPU is only 20% of the whole system. Any comments appretiated, thnx, peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fae +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [GENERAL] Overload

. On one system CPU-speed might be the bottleneck, on others the RAM and so on. And the cost for a query on your system is not always the same. Depending on swap, cache and so on. Maybe you should consider having a second SQL-server to lower load. best, peter -- mag. peter pilsl goldfisch.at

[GENERAL] many similar indexbased selects are extremely slow

( 'select OID from artikelindex where id_artikel=?'); foreach (@id) { my $ret=$sth-execute($_); my $x=$sth-fetchrow_arrayref; } - thnx a lot for any idea, peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED

[GENERAL] 7.1.3: dataloss: FATAL 2: XLogFlush: request is not satisfied

while the server crashed. thnx, peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

[GENERAL] UNION with more restrictive DISTINCT

, which is important. thnx. peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

[GENERAL] select single entry and its neighbours using direct-acess to index?

time-demanding. thnx, peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs

Re: [GENERAL] select single entry and its neighbours using direct-acess

solution is to read all the data without the WHERE-clause and then fetch the needed ones, which is quite time-demanding. thnx, peter -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast

[GENERAL] problems with lower() and unicode-databases

not apperar in the list, so I didnt try new 7.4.5. I think its merely a problem with setting than with postgreSQL. (at least I hope so ...) -- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED] ---(end of broadcast

[GENERAL] 'order by' does wrong with unicode-chars (german umlauts)

would be a solution but we plan to offer support for many non-latin languages later and the meaning of unicode is to get rid of all this converting-stuff after all. thnx, peter -- IT-Consulting mag. peter pilsl tel:+43-699-1-3574035 fax:+43-699-4-3574035 [EMAIL PROTECTED] http://www.goldfisch.at

[GENERAL] drop column

is there a trick to drop a column in a table ? or do I need to recreate the table and drop the old one ? thnx, peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available ---(end

[GENERAL] select, where and null-values (or: select null'1' is fuzzy)

-- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

[GENERAL] find position of an special entry in a select-result

by, search, entries per page ...). When he adds a new entry to that database the application should automatically show exact the page where the new entry is displayed. thnx, peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED

[GENERAL] bind postmaster to address

Is there are way to use postmaster with the -i option (accept tcp-ip-connections) and bind only to certain addresses interfaces ? thnx, peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available

Re: [GENERAL] bind postmaster to address

On Sun, Apr 22, 2001 at 03:37:12PM -0400, Tom Lane wrote: Peter Pilsl [EMAIL PROTECTED] writes: Is there are way to use postmaster with the -i option (accept tcp-ip-connections) and bind only to certain addresses interfaces ? In 7.1 there's a postmaster switch to bind only to one specific

[GENERAL] Re: problems with pg_dumplo (was Re: backup with blobs)

want play around any more on my testmachine. Later in the weekend I will jump into the production-server and dump all the stuff and try to restore the data in a new installed 7.1-environment. I'll post my success/failure here then. thnx, peter -- mag. peter pilsl phone: +43 676 3574035 fax

[GENERAL] Re: problems with pg_dumplo (was Re: backup with blobs)

there is a problem on my system. I will install 7.1 on a different machine and try if I can import all my data before migrating to 7.1 on a production-server. When I want to migrate _all_ data from one 7.1 to another 7.1 : does a brute filecopy do it ? Thanx a lot for your help, peter -- mag. peter pilsl

[GENERAL] backup with blobs

in the corresponding tables. thnx, peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [GENERAL] MS-ACCESS - PGSQL

in access I guess ... hope this helps, peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available

Re: [GENERAL] TEXT and BLOBS

) will do it for me I'm also looking forward for it. When will it come and where can I find information about it ? peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available

[GENERAL] format of blobs ? backup blobs ?

write a script to restore the blobs ? second question: how do you guys deal with blobs when upgrading/backuping/restoring ? thanx, peter -- mag. peter pilsl phone: +43 676 3574035 fax : +43 676 3546512 email: [EMAIL PROTECTED] sms : [EMAIL PROTECTED] pgp-key available

[GENERAL] restore blobs (xinv-files)

we just update from a 6.5 to a 7.0 version and we made a dumpall and we saved all files too. Restoring the data stored with dumpall didnt bring back the blobs again. How can I restore the blobs out of the pure filedump again ? thanks, peter -- mag. peter pilsl phone: +43 676 3574035 fax

[GENERAL] blobs dont rollback ?

; ... show_blob; # work fine !! ... $lobj_fd = $dbh-func($blob-oid, 'lo_unlink'); bloberror('lo_unlink failed') if not(defined($lobj_fd)); ... $dbh-rollback; ... show_blob; # get an error !! ... thanx for any help, peter -- mag. peter pilsl pgp-key available