Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Dec 5, 2007 at 8:25 AM, in message <[EMAIL PROTECTED]>, Paul

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Dec 5, 2007 at 8:25 AM, in message <[EMAIL PROTECTED]>, Paul

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Dec 5, 2007 at 2:47 AM, in message <[EMAIL PROTECTED]>, Paul

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Tue, Dec 4, 2007 at 12:21 PM, in message <[EMAIL PROTECTED]>,

Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Tue, Dec 4, 2007 at 12:03 PM, in message <[EMAIL PROTECTED]>,

Re: Fwd: Re: [GENERAL] Archiving problem on Windows

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Tue, Dec 4, 2007 at 11:44 AM, in message <[EMAIL PROTECTED]>,

Fwd: Re: [GENERAL] Archiving problem on Windows

lt; failed: error code 1 >>copy pg_xlog\myfile C:\Archive\DBArchive\myfile<< failed: error code 1 WARNING: transaction log file could not be archived: too many errors Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Reg

[GENERAL] Archiving problem on Windows

ied one or two weeks ago and since then i have not change the command. Thanks for any advice! Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-94

Re: [GENERAL] Trigger problem

;') || ' TO ' || coalesce(NEW.gruppe, ''); there still seem to be null values. Of course, it can be that the user deletes a value and then there is a NULL value, say for NEW.gruppe for example, but shouldn't the coalesce in this case avoid that the whole field-string is empty?

[GENERAL] Trigger problem

_NAME; INSERT INTO history(aennam, action, table_name) VALUES(current_user, act, tab); RETURN NULL; END; Now the problem is that a tuple gets added to the table history, but the field "action" (whatever the user did) is 99% empty, whereas the others are filled and I don't see wh

Re: [GENERAL] Usúario Conectados

Hi, you could use "select usename from pg_stat_activity;" PS. this is an english-speaking list, so for the future please write your mails in english. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 F

[GENERAL] Questions concerning check constraints

constraint might be simpler. 2) Is it possible to issue custom error messages in case a constraint is violated? Thanks! Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg

Re: [GENERAL]

Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Wed, Oct 31, 2007 at 4:07 AM, in message <[EMAIL PROTECTED]>, ca

Re: [GENERAL] DROP VIEW lasts forever

Nevermind, by mistake I tried dropping it as a different user. But, just a question, wouldn't it make more sense to issue an error message or something instead of letting the query run indefinitely? Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Fors

[GENERAL] DROP VIEW lasts forever

x27;m using psql 8.2 Thanks in advance Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 ---(end of broa

Re: [GENERAL] Upper and Lower-cased Database names?

This error probably does not have anything to do with the case of your database name. Instead you probably logged into a database which is not MyTest, because it is not possible to log into a database x and make a query on database y. Christian Rengstl M.A. Klinik und Poliklinik für Innere

[GENERAL] Privileges on information_schema

admin. I tried explicitly setting the SELECT privileges on the above mentioned view but without success. I really appreciate any help. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11

Re: [GENERAL] Error while database creation

I guess that "No space left on device" explains a lot, i.e. there is no space left on your hard drive/partition. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Rege

Re: [GENERAL] TSearch - Bulgarian

You might have to create a Bulgarian dictionary first before you will be able to successfully use tsearch. Maybe some information here will help you: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung

[GENERAL] Partial index

used. So, does anyone have a suggestion on how to increase the performance of the queries. Thanks Chris Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regen

[GENERAL] Warning during pg_dump

kup did not work? Mainly because my db is around 100GB and the tar file was just 4.5GB. I mean, i don't mind such a good compression but with the warning messages i got, i am a little bit confused as to whether it really worked. Thanks! Chris Christian Rengstl M.A. Klinik und Poliklinik fü

[GENERAL] Problem writing function

Hi list, the following function is created properly: CREATE OR REPLACE FUNCTION insert_into_table_overview(text, chr integer) RETURNS void AS ' DECLARE in_tableALIAS FOR $1; p RECORD; BEGIN RAISE NOTICE ''in_table = %'', in_table; FOR p IN EXECUTE '

Re: [GENERAL] Query performance

ft for > the corresponding tables. > > If you're using psql try \d yur-table-name. > > Best regards > > Hakan Kocaman > Software-Development > > digame.de GmbH > Richard-Byrd-Str. 4-8 > 50829 Köln > > Tel.: +49 (0) 221 59 68 88 31 > Fax: +

Re: [GENERAL] Query performance

CTED] >> Sent: Thursday, August 03, 2006 11:00 AM >> To: Christian Rengstl >> Cc: Hakan Kocaman; pgsql-general@postgresql.org >> Subject: Re: [GENERAL] Query performance >> >> >> Christian Rengstl wrote: >> > Hi, >> > >> > th

Re: [GENERAL] Query performance

gt; Tel.: +49 (0) 221 59 68 88 31 > Fax: +49 (0) 221 59 68 88 98 > Email: [EMAIL PROTECTED] > > > >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> Christian Rengstl >> Sent: Thursday, August 03, 2006 1

[GENERAL] Query performance

40220 width=13) (act ual time=0.020..30.131 rows=40220 loops=1) Total runtime: 357017.259 ms Unfortunately the query takes pretty long for the big table, so maybe one of you has a suggestion on how to make it faster. -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie -

Re: [GENERAL] Strange error message

The thing is that the very same file was copied to the specified directory. Martijn van Oosterhout wrote on 08/02/06 9:43 am: > On Wed, Aug 02, 2006 at 09:34:25AM +0200, Christian Rengstl wrote: >> it seems as if in /pg_xlog/archive_status the respective file >> 0001002

Re: [GENERAL] Strange error message

Kretschmer" <[EMAIL PROTECTED]> wrote on 08/02/06 9:40 am: > am 02.08.2006, um 9:27:22 +0200 mailte Christian Rengstl folgendes: >> Postgre copied the file 0001002000D2 to the specified directory >> and now it says it can't be copied...I really, really don&

Re: [GENERAL] Strange error message

it seems as if in /pg_xlog/archive_status the respective file 0001002000D2.ready was not changed to 0001002000D2.done. Can this be done manually? About the persmission denied error i still have absolutely no clue! "Christian Rengstl" <[EMAIL PROTECTED]>

[GENERAL] Strange error message

w it says it can't be copied...I really, really don't get it! -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230

Antw: Re: Antw: Re: [GENERAL] Query questions

I meant that i have an index on pid and one on crit. >>> "A. Kretschmer" <[EMAIL PROTECTED]> 31.07.06 17.16 Uhr >>> am 31.07.2006, um 15:55:39 +0100 mailte Richard Huxton folgendes: > Christian Rengstl wrote: > >My version is 8.1.4. Here is

Antw: Re: [GENERAL] Query questions

Kretschmer" <[EMAIL PROTECTED]> 31.07.06 15.49 Uhr >>> am 31.07.2006, um 15:32:19 +0200 mailte Christian Rengstl folgendes: > Hi list, > > i have a problem with creating a query and i hope somebody can give me > some hints. I have the following table > pid(varchar)

[GENERAL] Query questions

Hi list, i have a problem with creating a query and i hope somebody can give me some hints. I have the following table pid(varchar), crit(varchar), val1(varchar), val2(varchar), iDate(timestamp) where there are up to 63 million lines with 1500 distinct pids and around 42000 distinct crits: pid c

[GENERAL] Shared buffers

Hi list, just wanted to ask what is a "good/reasonable" value for the shared_bufferes variable. Right now i set it to 64000 on a windows 2003 server with 1GB ram and 3.2 GHz which runs as file server (for only a small number of users) and db server. Thanks -- Christian Rengstl M

[GENERAL] question about default value and timestamp

? I mean of course i can change it and insert the current_timestamp explicitly in every tuple, i just would like to know why it doesn't work the way i wanted it to work... Thanks! Chris -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Fors

[GENERAL] Archiving wal files

d? Thanks! -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 ---(end of broadcast)--- TIP 2: Don&

[GENERAL] Antw: problem with windows installer

Hi, forget the last email. After rebooting it's working again. Don't know why or how, but it's working... >>> Christian Rengstl 21.07.06 12.55 Uhr >>> Hi list, i just wanted to delete my sandbox version of postgre and install the "real" post

[GENERAL] problem with windows installer

nstaller on the same machine (win 2003 server). Even stranger, on my local workstation i can start the very same installer. Does anybody have an idea why this is happening? -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Rege

Re: [GENERAL] Performance problem with query

) VALUES (new.entry_no, new.pid, new.val_1, new.val_2, new.chr, new.aendat, new.aennam); Like this i have around 20 rules so far, but there might be more later on. The children tables are so far exactly as the master table. Q <[EMAIL PROTECTED]> wrote on 07/19/06 1:52 pm: > On 19/07/2006

Re: [GENERAL] Performance problem with query

AIL PROTECTED]> wrote on 07/19/06 11:54 am: > On 19/07/2006, at 6:32 PM, Christian Rengstl wrote: > >> The analyze is from the exact query and i dropped the indexes >> before the insert as well without imrpvement. The target table is >> as well completely empty and the i

Re: [GENERAL] Performance problem with query

Well, i'll try that, but honestly i don't think it's the rule as the rule is really simple: it's just one simple integer comparison... Q <[EMAIL PROTECTED]> wrote on 07/19/06 11:54 am: > On 19/07/2006, at 6:32 PM, Christian Rengstl wrote: > >> The analyze

Re: [GENERAL] Performance problem with query

inheritance table structure with one master table and around 20 child tables. Q <[EMAIL PROTECTED]> wrote on 07/19/06 4:37 am: > > On 19/07/2006, at 4:24 AM, Christian Rengstl wrote: > >> now finally after a long time i have the query plan for the whole >> filled table. I h

Re: [GENERAL] Performance problem with query

nutes, but i don't know why the insert is taking so long. "Merlin Moncure" <[EMAIL PROTECTED]> wrote on 07/18/06 9:39 pm: > On 7/18/06, Christian Rengstl > <[EMAIL PROTECTED]> wrote: >> now finally after a long time i have the query plan for the whole fill

Antw: [GENERAL] Performance problem with query

(cost=0.00..194313.00 rows=8044000 width= 10) (actual time=0.009..0.009 rows=1 loops=1) -> Seq Scan on temp_table (cost=0.00..194313.00 rows=8044000 width=39) (nev er executed) Total runtime: 22.270 ms (31 Zeilen) >>> "Christian Rengstl" <[EMAIL PROTECTED]> 13.07.06

Antw: Re: [GENERAL] Performance problem with query

(cost=0.00..194313.00 rows=8044000 width= 10) (actual time=0.009..0.009 rows=1 loops=1) -> Seq Scan on temp_table (cost=0.00..194313.00 rows=8044000 width=39) (nev er executed) Total runtime: 22.270 ms (31 Zeilen) >>> "Merlin Moncure" <[EMAIL PROTECTED]> 13.07.06 15.20

Antw: Re: [GENERAL] Problem with archive_command

i made a pg_dump. Maybe it would help to delete the files in the pg_xlog/archive_status directory...anyway the server just has a sandbox status so far. >>> "Merlin Moncure" <[EMAIL PROTECTED]> 14.07.06 17.18 Uhr >>> On 7/14/06, Christian Rengstl <[EMAIL PROTE

Antw: [GENERAL] Problem with archive_command

tries to copy non-existing wal-files back and forth, which, as you might imagine, does not work very well. Is there a way to reset pgsql regarding the wal files and to tell it to start all over again to make wal files? I tried to restart the server, but without success. Please help Chris >>&

Antw: Re: [GENERAL] Performance problem with query

Hi, somehow my reply yesterday got lost, but nevertheless here comes the explain analyze again. It's the explain of the operation that causes this huge performance discrepancy. Unfortunately i had to perform the explain analyze with an empty temp_table, because after the whole operation is done, i

[GENERAL] Problem with archive_command

Hi list, with the following archive_command (on Windows) archive_command = 'copy %p c:\\Archiv\\DBArchiv\\%f' I constantly have entries like the following in my log file: 2006-07-14 14:26:59 LOG: archive command "copy pg_xlog\000100020037 c:\Archiv\DBArchiv\000100020037" f

[GENERAL] Performance problem with query

d from temp_table to public.values took again only something like 10 minutes. Can it be that the cast takes up so much more time than when reading and transferring 2 million lines? Thanks for any advice! -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forsch

[GENERAL] Wtrlt: Getting progress of operation

Forget the last email. Today's simply not my day... -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 --- Begin Message --- Hi list, i ex

[GENERAL] Getting progress of operation

? Thanks! -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 ---(end of broadcast)--- TIP 1: if

Re: [GENERAL] Problem with COPY

uot;A. Kretschmer" <[EMAIL PROTECTED]> wrote on 07/10/06 11:28 am: > am 10.07.2006, um 10:21:59 +0200 mailte Christian Rengstl folgendes: >> Hi everyone, >> >> I have a table with a surrogate key which is an integer sequence. Is >> there a way to load a file usin

[GENERAL] Problem with COPY

Hi everyone, I have a table with a surrogate key which is an integer sequence. Is there a way to load a file using COPY and tell postgresql not to insert into the primary key column? Thanks! Chris -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung

[GENERAL] Inheritance and unique constraints

he child tables? Thanks! -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 ---(end of broadcast)--

[GENERAL] Question concerning arrays

those specific values, but rather something like select * from persons where person_id=... Thanks Chris -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944