> What encoding/locale is your database using?
The following are the contents from the SQL pane for the database:
-- Database: "alphaOneBiz"
-- DROP DATABASE "alphaOneBiz";
CREATE DATABASE "alphaOneBiz"
WITH OWNER = kkelly
ENCODING = 'UTF8'
LC_COLLATE = 'English, United States'
Unfortunately it is a remote machine and can only connect to that
server. So I can't test that.
On Fri, Aug 21, 2009 at 1:39 AM, Dave Page wrote:
> On Thu, Aug 20, 2009 at 12:08 AM, Andrew
> Maclean wrote:
>> Sorry I was on a different machine.
>> Here is the log file.
>> Essentially the whole pro
Le jeudi 20 août 2009 à 16:16:07, DUPREZ Cédric a écrit :
> [...]
> This problem seems to come from the fact that PgAdmin executes code in a
> single transaction statement...
>
I'm sure it doesn't. Try to do the following steps:
BEGIN;
CREATE temp TABLE toto (id int);
INSERT INTO toto VALUES (1);
On Thu, Aug 20, 2009 at 12:41 AM, JwexlerAt
MailDotCom wrote:
> The error often happens after I have created a number of columns and then
> creating the two timestamp with timezone columns at which the error seams to
> appear most. Naming convention is lower case first word, then capital first
>
On Thu, Aug 20, 2009 at 12:08 AM, Andrew
Maclean wrote:
> Sorry I was on a different machine.
> Here is the log file.
> Essentially the whole program crashes when you connect to a database.
That sure ain't normal. There's nothing in the log - does it happen
with just one server, or can you reprodu
Hi,
I am using PgAdmin 1.10.0 with Postgresql 8.3.7 on Windows XP Pro (SP3).
The problem I am facing deals with savepoint and rollback management in PgAdmin.
I initiate a transaction, then I run different queries, create a savepoint :
begin;
CREATE temp TABLE toto (id int);
INSERT IN
