On Tue, Mar 22, 2011 at 4:09 PM, Dave Page wrote:
>
>
> On Tue, Mar 22, 2011 at 3:45 PM, Dave Page wrote:
>>
>>
>> On Tue, Mar 22, 2011 at 5:10 AM, Craig Sacco
>> wrote:
>>>
>>> The following bug has been logged online:
>>>
>>> Bug reference: 5938
>>> Logged by: Craig Sacco
>>> Ema
On Wed, Mar 23, 2011 at 9:07 PM, Alex Lai 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 master by
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 l
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
);
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 subs
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 nee
On Thu, Mar 24, 2011 at 10:36 AM, Pavel Stehule 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'
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 to
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: itagaki.takah..
I have another example of this issue with WIN1252. This line in a copy
file:
659446 828 1 /6�\bH@^W^Za$H�\b�@\\/No
valid or unique HTTP objects found in XML response.
Into this table:
Table "public.ep_tests"
Column | Type | Modifiers
-+--+-
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 f
On Fri, Mar 25, 2011 at 03:33, Kasia Tuszynska 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
postgres just supports
> 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
13 matches
Mail list logo
