Re: little patch for "Detect serial columns from pg_depend" and bugfix

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Quan Zongliang <quanzongliang(at)gmail(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: little patch for "Detect serial columns from pg_depend" and bugfix
Date: 2012-09-05 13:49:42
Message-ID: CA+OCxoz0RBmcv_HDvi=SENTYKz28o1ORiCkKDCpbQznNbcSJsg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On Wed, Sep 5, 2012 at 3:39 AM, Quan Zongliang <quanzongliang(at)gmail(dot)com> wrote:
>
> new patch attched.
> I tested it under Cygwin, seems OK.

I got an error on my first test I'm afraid :-(

2012-09-05 14:39:41 QUERY : Set query (localhost:5432): SELECT classid
FROM pg_depend
WHERE refobjid=207478::oid AND refobjsubid = 1 AND objid IN
('pem.agent_id_seq'::regclass,'"pem.agent_id_seq"'::regclass) AND
deptype='a'
2012-09-05 14:39:41 ERROR : ERROR: relation "pem.agent_id_seq" does not exist
LINE 3: ...id = 1 AND objid IN ('pem.agent_id_seq'::regclass,'"pem.agen...

How does the attached version of the patch look? I've tweaked the
formatting and removed the excess quotes that seemed to be causing the
issue.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Attachment Content-Type Size
pgColumn-v2.diff application/octet-stream 1.3 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message 权宗亮 2012-09-05 14:04:38 Re: patch for "Sequence: calculate next value to be expected"
Previous Message Dave Page 2012-09-05 13:35:32 Re: patch for "Sequence: calculate next value to be expected"