Re: [BUGS] BUG #5938: PostgreSQL Installer outputs log file with superuser password in clear text

2011-03-24 Thread Dave Page
On Tue, Mar 22, 2011 at 4:09 PM, Dave Page dp...@pgadmin.org wrote: On Tue, Mar 22, 2011 at 3:45 PM, Dave Page dp...@pgadmin.org wrote: On Tue, Mar 22, 2011 at 5:10 AM, Craig Sacco craig.sa...@gmail.com wrote: The following bug has been logged online: Bug reference:      5938 Logged

Re: [BUGS] postgres 9 streaming replication

2011-03-24 Thread Fujii Masao
On Wed, Mar 23, 2011 at 9:07 PM, Alex Lai a...@sesda2.com wrote: I have no idea why I keep getting the message:\  could not connect to the primary server: FATAL:  no pg_hba.conf entry for replication connection from host slave_server_ip, user my_super_user_name Can you connect from slave to

[BUGS] Service Wont Start

2011-03-24 Thread Viner, Adrian
We have been using postgres8.4 with the postgis add on for a month. On Monday we had to reboot the server that holds all the databases we use. The server was down for ten minutes and when it was back up and running the databases wouldn't open. We tried to connect back on, but got a server doesn't

Re: [BUGS] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-03-24 Thread depstein
Update: It has been suggested to wrap perform around a select like this: do $$begin perform( with A as (select 1 as foo) select foo from A ); end$$; This won't work if select returns more than one statement: do $$begin perform( with A as (select generate_series(1,3) as foo) select foo from A );

Re: [BUGS] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-03-24 Thread Pavel Stehule
Hello why you can do it? please, try to RETURN QUERY ... Regards Pavel Stehule $$begin perform( with A as (select generate_series(1,3) as foo) select foo from A ); end$$; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription:

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-24 Thread Nathan M. Davalos
I just tried it from the psql console and it seems to work, which isn't really an option for us to use since we need to be able to let end users load data via our custom designed database application. None of them would understand or know how to use the console. Currently there's no pressing

Re: [BUGS] Can't use WITH in a PERFORM query in PL/pgSQL?

2011-03-24 Thread Merlin Moncure
On Thu, Mar 24, 2011 at 10:36 AM, Pavel Stehule pavel.steh...@gmail.com wrote: Hello why you can do it? please, try to RETURN QUERY ... Regards Pavel Stehule $$begin perform( with A as (select generate_series(1,3) as foo) select foo from A ); end$$; This is 'DO' statement.

Re: [BUGS] Service Wont Start

2011-03-24 Thread Heikki Linnakangas
On 24.03.2011 11:12, Viner, Adrian wrote: We have been using postgres8.4 with the postgis add on for a month. On Monday we had to reboot the server that holds all the databases we use. The server was down for ten minutes and when it was back up and running the databases wouldn't open. We tried

Re: [BUGS] ERROR: character 0xe3809c of encoding UTF8 has no equivalent in EUC_JP

2011-03-24 Thread Kasia Tuszynska
Hi, We have a customer in Japan who would be interested in this fix, in the future. Would you like me to enter it as an official Postgres bug? Sincerely, Kasia -Original Message- From: Tatsuo Ishii [mailto:is...@postgresql.org] Sent: Tuesday, March 22, 2011 10:17 PM To:

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-24 Thread Josh Berkus
I have another example of this issue with WIN1252. This line in a copy file: 659446 828 1 /6�\bH@^W^Za$H�\b�@\\/pp/ppNo valid or unique HTTP objects found in XML response./p/p Into this table: Table public.ep_tests Column | Type | Modifiers

Re: [BUGS] BUG #5943: jdbc client doesn't omit pg_toast_temp tables from schema views

2011-03-24 Thread Kris Jurka
On Wed, 23 Mar 2011, Daniel Ceregatti wrote: The following bug has been logged online: Bug reference: 5943 Logged by: Daniel Ceregatti Email address: dan...@ceregatti.org Description:jdbc client doesn't omit pg_toast_temp tables from schema views Details: In the

Re: [BUGS] ERROR: character 0xe3809c of encoding UTF8 has no equivalent in EUC_JP

2011-03-24 Thread Itagaki Takahiro
On Fri, Mar 25, 2011 at 03:33, Kasia Tuszynska ktuszyn...@esri.com wrote: We have a customer in Japan who would be interested in this fix, in the future. Would you like me to enter it as an official Postgres bug? Not a bug at all -- there are at least 3 versions of EUCJP encodings, and

Re: [BUGS] ERROR: character 0xe3809c of encoding UTF8 has no equivalent in EUC_JP

2011-03-24 Thread Tatsuo Ishii
We have a customer in Japan who would be interested in this fix, in the future. Would you like me to enter it as an official Postgres bug? Sincerely, As I stated before, I don't regard this as a bug. BTW I wonder why you don't use CREATE CONVERSION which can be used for customer's problem