R: Re: [GENERAL] postgres user password: Log on failure

Hi guys, Thanks for taking time to reply. - Despite what the error message says, the user postgres doesn't have administrator privileges (and I don't see why these would change by retyping the password). - In Control Panel -> Administrative Tools -> Computer Manager -> Users -> postgres I see

[GENERAL] postgres user password: Log on failure

Hello, I'm on Windows XP with postgresql 8.4 installed by postgresql-8.4.4-1-windows. exe with essentially default settings (only the path to the data dir was changed from default). I realized that sometimes (not always!) the server cannot start when I reboot my machine (I get error messages on

[GENERAL] R: Catch exception from plpy

*** ERROR: relation "tmp_foo" already exists SQL state: 42P07 Context: SQL statement "create table tmp_foo (v1 int);" -- >Messaggio originale >Da: dario@libero.it >Data: 24/04/2010 14.48 >A: >Ogg: Catch exception from plpy > >Hello, > >Coul

[GENERAL] Catch exception from plpy

Hello, Could someone show me how to catch exceptions generated by plpy.execute()? >From the documentation and other posts I understand that you need to call plpy. error() but I still cannot figure out how to use it. For example, say I need a function that creates table foo if it doesn't exists,

Re: [GENERAL] Function with DEFAULT arguments

>Messaggio originale >Da: t...@sss.pgh.pa.us >Data: 12/03/2010 17.51 >A: "dario@libero.it" >Cc: >Ogg: Re: [GENERAL] Function with DEFAULT arguments > >"dario@libero.it" writes: >> I'm trying to use the DEFAULT option

R: Re: [GENERAL] Function with DEFAULT arguments

Ok, thanks for the quick reply and the link! Dario >Messaggio originale >Da: dep...@depesz.com >Data: 12/03/2010 17.38 >A: "dario@libero.it" >Cc: >Ogg: Re: [GENERAL] Function with DEFAULT arguments > >On Fri, Mar 12, 2010 at 05:28:57PM +0100, d

[GENERAL] Function with DEFAULT arguments

Hello, I'm trying to use the DEFAULT option to pass parameters to the arguments of a function. When I call that function, how can I change the default value of some arguments and leave as default the value of other arguments? In other words, is there a way to 'call' the arguments by their name

R: Re: [GENERAL] quote string exactly as it is

Thanks a lot for replies! Dollar quote is what I needed, but I could find it in! Dario >Messaggio originale >Da: mmonc...@gmail.com >Data: 02/12/2009 14.15 >A: "dario@libero.it" >Cc: >Ogg: Re: [GENERAL] quote string exactly as it is > >On

[GENERAL] quote string exactly as it is

Hello, How can I quote a string *exactly* as it is? I tried using quote_literal() but it doesn't return what I need in some cases. E.g. If my string is: ss\\\ss And I do: select quote_literal('ss\\\ss'); I get: E'ss\\ss' <-- My string now has E'' added and one backslash has been removed!

[GENERAL] Count occurrences of pattern in string

Hello, I'm looking for a function to count the occurrences of a pattern in a string. E.g. something like: fun_count_pattern('fooXblaX', 'X') which would return 2 (I.e. pattern 'X' found 2 times in string 'fooXblaX'). I could write my own function for this (probably using plpython?) but I was