Hi,
I tried to add a comment to an existing column and pgadmin crashed. I'm
using the WIN32 snapshot of today.
After installation I get the old logo (elephant). I hope this is OK.
--
Best regards,
Marc.
---(end of broadcast)---
TIP 2: you can ge
> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 11:47
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: FW: [pgadmin-support] pgAdmin3: adding comments
> to existing tables
>
>
> Dave Page wrote:
>
> >Hi Andreas,
> >
> >This is a little
Hi Andreas,
This is a little worrying - I just tried it here and when trying to set
a comment on a table, what it actually executed was:
ALTER TABLE fig.test ADD COLUMN fooCol fig.foo_domain;
ALTER TABLE fig.test ADD COLUMN myFatCol int4[];
ALTER TABLE fig.test DROP COLUMN "fooCol";
ALTER TABLE f
Terence Kearns wrote:
because the interface attempts to "re-submit all" of the properties of
the existing table for alteration,
That should not happen at all. There's a lot of effort taken to identify
only changes, and submit only these changes.
if you want to change any one property of a tabl
Thanks Dave,
I understand that numeric is a safer option than float8 for Currency
fields, but in the type map editor I can't set the precision and scale.
If I use numeric without setting precision and scale, Access 97 sees
the field as "text" which is definitely not what I want. If I could
s
Version: 0.8.0 (Jul 14 2003), Win32 version
Steps:
1) create table with one varchar column
CREATE TABLE public.test
(
a varchar(50) NOT NULL
) WITHOUT OIDS;
2) fill it with some empty strings
INSERT INTO test(a) VALUES('')
3) run pgAdmin III, select table and choose view data from popup menu
When attempting to create a view with the comment box populated,
pgAdmin3 generated the following SQL
CREATE OR REPLACE VIEW global.v_db_classes AS
select type_id AS db_class_id, title AS db_class
from global.types
where cat = 'dbClasses';
COMMENT ON TABLE global.v_db_classes IS 'This pseudo enti
Dave Page wrote:
Hi Andreas,
This is a little worrying - I just tried it here and when trying to set
a comment on a table, what it actually executed was:
ALTER TABLE fig.test ADD COLUMN fooCol fig.foo_domain;
ALTER TABLE fig.test ADD COLUMN myFatCol int4[];
ALTER TABLE fig.test DROP COLUMN "fooCo
> -Original Message-
> From: Matej Rizman [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 00:34
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] BUG: pgAdmin III View table with
> empty strings
>
>
> Version: 0.8.0 (Jul 14 2003), Win32 version
>
> Steps:
> 1) create table with one
Thanks, fixed in CVS.
Regards, Dave.
> -Original Message-
> From: Terence Kearns [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 09:52
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] minor bug in pgAdmin3 when creating views
>
>
> When attempting to create a view with the comment b
Hello,
I'm trying to migrate an Access 2000 database to Postgres. Even with the
most simple database (1 table, 1 field), I get the following error:
380: Invalid property value
Rolling back... Done.
Here is the log file.
2003-07-16 08:04:43 - Executing Plugin: Database Migration Wizard v1.4.12
> -Original Message-
> From: Fjeld, Shauna [mailto:[EMAIL PROTECTED]
> Sent: 16 July 2003 15:13
> To: '[EMAIL PROTECTED]'
> Subject: [pgadmin-support] Database Migration Error
>
>
> Hello,
> I'm trying to migrate an Access 2000 database to Postgres.
> Even with the
> most simple datab
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Matej Rizman" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 3:27 PM
Subject: Re: [pgadmin-support] BUG: pgAdmin III View table with empty strings
>> -Original Message-
>> From: Matej Rizma
Donald Fraser wrote:
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Matej Rizman" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 3:27 PM
Subject: Re: [pgadmin-support] BUG: pgAdmin III View table with empty strings
-Original Message-
F
Dave Page wrote:
Looks OK now, though the definition pane needs a refresh to see the
changes.
What do you mean with "needs a refresh"? Every time the sql page is
selected, the sql query is freshly assembled. Do you have a GUI refresh
problem?
Regards,
Andreas
---(e
Marc Cuypers wrote:
Hi,
I tried to add a comment to an existing column and pgadmin crashed.
I'm using the WIN32 snapshot of today.
I can't reproduce this, neither in debugging mode nor with the release
20030716. What exactly are the steps you're doing?
After installation I g
- Original Message -
From: "Andreas Pflug" <[EMAIL PROTECTED]>
To: "Dave Page" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 5:30 PM
Subject: Re: FW: [pgadmin-support] pgAdmin3: adding comments to existing tables
>> Dave Page wrote:
>> >
>> >
>> >Looks OK now
Donald Fraser wrote:
- Original Message -
From: "Andreas Pflug" <[EMAIL PROTECTED]>
To: "Dave Page" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 5:30 PM
Subject: Re: FW: [pgadmin-support] pgAdmin3: adding comments to existing tables
Dave Page wrote:
Unsubscribe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
It's rumoured that Andreas Pflug once said:
> Dave Page wrote:
>
>>
>>
>>Looks OK now, though the definition pane needs a refresh to see the
>>changes.
>>
>>
> What do you mean with "needs a refresh"? Every time the sql page is
> selected, the sql query is freshly assembled. Do you have a GUI refre
Dave Page wrote:
It's rumoured that Andreas Pflug once said:
Dave Page wrote:
Looks OK now, though the definition pane needs a refresh to see the
changes.
What do you mean with "needs a refresh"? Every time the sql page is
selected, the sql query is freshly assembled. Do you have a
I am use PostgreSQL 7.2.1 in Redhat Linux 7.2
Java 1.4.x
When I do JDBC
String sql = "SELECT datetime_column FROM mytable";
Timestamp ts = resultSet.getTimestamp(2);
If the timestamp return format like
2003-07-15 13:20:00.20+00
then is OK. But if timestamp return like
2003-07-15 13:20:00.
Hi all,
I'm looking for interesting screenshots of pgAdmin III for inclusion on
the website. Recent ones are preferred, but it would be nice to get some
in a variety of languages on a variety of platforms/window managers,
doing a variety of things.
If you want to submit one or more, please email
Andreas Pflug wrote:
Terence Kearns wrote:
because the interface attempts to "re-submit all" of the properties of
the existing table for alteration,
That should not happen at all. There's a lot of effort taken to identify
only changes, and submit only these changes.
Oh ok. my mistake. I assu
Andreas Pflug wrote:
and fooCol is not the same as "fooCol"
What is the deal with this anyway? Everytime I specify an object name
with mixed case it decides to throw double quotes around it.
Also, I created a schema called global (no mixed case) and now
pgAdminIII refers to all objects in this
25 matches
Mail list logo
