Yes, I should know it. thank you.
There are a few sentences about pg_dump syntax compatibility from
postgresql documentation:
Because pg_dump is used to transfer data to newer versions of
PostgreSQL, the output of pg_dump can be expected to load into
PostgreSQL server versions newer than pg_
On Mon, Jun 18, 2012 at 4:09 PM, Michal Kozusznik <
kozusznik.mic...@ifortuna.cz> wrote:
> While performing db dump (from postgresql 8.4), pgAdmin stores CREATE
> LANGUAGE in following way:
>
> CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
>
> This syntax is not compatible with postgresql 8.4
> O
While performing db dump (from postgresql 8.4), pgAdmin stores CREATE
LANGUAGE in following way:
CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
This syntax is not compatible with postgresql 8.4
OR REPLACE has been added in v9.0
Reference
http://www.postgresql.org/docs/8.4/static/sql-createlang
On Mon, 2012-06-18 at 05:23 -0500, Michael Shapiro wrote:
> I think it is PgAdmin 1.14.3. I just uninstalled that version and
> reinstalled 1.14.2 and the RI-Constraints do not show up.
>
We have a fix in 1.14.3 to make sure we don't display these system
triggers on recent PostgreSQL releases. I
I think it is PgAdmin 1.14.3. I just uninstalled that version and
reinstalled 1.14.2 and the RI-Constraints do not show up.
On Mon, Jun 18, 2012 at 5:00 AM, Michael Shapiro wrote:
> We are running
>
> PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
> 4.1.2 20080704 (Red Ha
We are running
PostgreSQL 8.4.9 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit
On Mon, Jun 18, 2012 at 4:23 AM, Guillaume Lelarge
wrote:
> On Mon, 2012-06-18 at 10:06 +0100, Dave Page wrote:
> > On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik
On Mon, 2012-06-18 at 10:06 +0100, Dave Page wrote:
> On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik
> wrote:
> >> What database server version? I just tested here with 9.0 and 1.14.3,
> >> and I don't see the triggers, either with or without Show System
> >> Objects enabled.
> >>
> >
> > I re
On Mon, Jun 18, 2012 at 10:01 AM, Michal Kozusznik
wrote:
>> What database server version? I just tested here with 9.0 and 1.14.3,
>> and I don't see the triggers, either with or without Show System
>> Objects enabled.
>>
>
> I reported it happens with postgresql 8.4
> Now I checked v9.0.2 and ind
What database server version? I just tested here with 9.0 and 1.14.3,
and I don't see the triggers, either with or without Show System
Objects enabled.
I reported it happens with postgresql 8.4
Now I checked v9.0.2 and indeed RI constraints are hidden.
So looks that this issue is related only t
On Mon, Jun 18, 2012 at 9:31 AM, Michael Shapiro wrote:
> I have exactly this same problem. As best as I can tell, the only thing that
> changed was I upgraded to 1.14.3.
> I made no changes to any options. Before 1.14.3 I did not see any RI
> Constraint triggers appear in object browser.
> I am r
I have exactly this same problem. As best as I can tell, the only thing
that changed was I upgraded to 1.14.3.
I made no changes to any options. Before 1.14.3 I did not see any RI
Constraint triggers appear in object browser.
I am running Windows 7
On Mon, Jun 18, 2012 at 3:25 AM, Guillaume Lelarg
On Fri, 2012-06-15 at 14:40 -0500, Michael Shapiro wrote:
> I am now running 1.14.3 (under Windows) and I am seeing the
> RI_ConstraintTriggers now that I hadn't seen before. How do I prevent
> PgAdmin from showing these?
I need a way to reproduce your issue. Apparently, you're not the only
one ha
On Fri, 2012-06-15 at 10:44 -0300, Nelson A. de Oliveira wrote:
> Hi!
>
> On Thu, Jun 14, 2012 at 6:01 PM, Guillaume Lelarge
> wrote:
> > On Thu, 2012-06-14 at 15:29 -0300, Nelson A. de Oliveira wrote:
> >> Sometimes I see my pgadmin3 crashing with a segmentation fault and
> >> today I got a back
On Fri, 2012-06-08 at 13:14 +0200, Michal Kozusznik wrote:
> Thanx for the answer
> To make test, I de-installed v1.14.0 and v1.16.0-beta. Restarted system
> and installed v1.14.3
> Unfortunately without success. RI Constraint triggers appear in object
> browser, SQL pane and even in table create
14 matches
Mail list logo
