Re: Develop item from TODO list

Hello!

We are 2 Students from the Technical University of Vienna. At our internship
we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS
to be qualified by schema/table name".
Is anyone working on it?

Our research at the SET CONTRAINTS function showed the following Error:
*ERROR: cross-database references are not implemented:
"schema.table.constraint"*
*SQL state: 0A000*

Is this the problem we could implement?
Approximately where is the point to implement?

As we have few experience with open-source programs, can someone recommend a
good C-editor for Ubuntu?
What do others use?

Thanks in advance,

Chris & Viktor

On 3 August 2010 13:57, Viktor Valy <vili0121(at)gmail(dot)com> wrote:
> Hello!
> We are 2 Students from the Technical University of Vienna. At our internship
> we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS
> to be qualified by schema/table name".
> Is anyone working on it?
> Our research at the SET CONTRAINTS function showed the following Error:
> ERROR: cross-database references are not implemented:
> "schema.table.constraint"
> SQL state: 0A000
> Is this the problem we could implement?
> Approximately where is the point to implement?
> As we have few experience with open-source programs, can someone recommend a
> good C-editor for Ubuntu?
> What do others use?
> Thanks in advance,
> Chris & Viktor

I can't answer the main question, but you can try Anjuta as a C
editor: http://www.anjuta.org/

--
Thom Brown
Registered Linux user: #516935

Viktor Valy <vili0121(at)gmail(dot)com> writes:
> We are 2 Students from the Technical University of Vienna. At our internship
> we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS
> to be qualified by schema/table name".
> Is anyone working on it?

Uh, it was done years ago, AFAICS, unless the Todo entry means something
non-obvious.

regression=# create schema foo;
CREATE SCHEMA
regression=# create table foo.bar (f1 int unique deferrable);
NOTICE: CREATE TABLE / UNIQUE will create implicit index "bar_f1_key" for table "bar"
CREATE TABLE
regression=# set constraints foo.bar_f1_key deferred;
SET CONSTRAINTS
regression=# set constraints foo.bar_f1_key immediate;
SET CONSTRAINTS
regression=#

Bruce, do you remember what that entry was really about?

regards, tom lane

On Tue, Aug 3, 2010 at 9:01 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> I can't answer the main question, but you can try Anjuta as a C
> editor: http://www.anjuta.org/

Or vi.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

On Tue, 2010-08-03 at 11:10 -0400, Robert Haas wrote:
> On Tue, Aug 3, 2010 at 9:01 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> > I can't answer the main question, but you can try Anjuta as a C
> > editor: http://www.anjuta.org/
>
> Or vi.

cough.

The hint here would be:

>As we have few experience with open-source programs, can someone
>recommend a good C-editor for Ubuntu?

I doubt they are unix/linux people at all. Putting them into Vi land is
a bit torturous.

There are quite a few editors out there but here are some that are going
to be a bit more user friendly (in terms of learning curve):

Bluefish
Anjuta
Kate

If you want a full environment with projects, SCM integration etc... I
would suggest Eclipse.

That said, if you can get a handle on VI/VIM or (joe :P) you will
probably be pleased with the efficiency.

Sincerely,

Joshua D. Drake

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

Thanks for the advice!

Yes, we are new to linux too :)
We have chosen Eclipse, because we have already experience with it.
However, after downloading the code from CVS, we can't build it, because of
some include commands in *tutorial / complex.c *says "*No such file or
directory*". Does anybody know what the clue is?
What should we get, if the code starts?

All the best,

Chris & Viktor

2010/8/3 Joshua D. Drake <jd(at)commandprompt(dot)com>

> On Tue, 2010-08-03 at 11:10 -0400, Robert Haas wrote:
> > On Tue, Aug 3, 2010 at 9:01 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> > > I can't answer the main question, but you can try Anjuta as a C
> > > editor: http://www.anjuta.org/
> >
> > Or vi.
>
> cough.
>
> The hint here would be:
>
> >As we have few experience with open-source programs, can someone
> >recommend a good C-editor for Ubuntu?
>
> I doubt they are unix/linux people at all. Putting them into Vi land is
> a bit torturous.
>
> There are quite a few editors out there but here are some that are going
> to be a bit more user friendly (in terms of learning curve):
>
> Bluefish
> Anjuta
> Kate
>
> If you want a full environment with projects, SCM integration etc... I
> would suggest Eclipse.
>
> That said, if you can get a handle on VI/VIM or (joe :P) you will
> probably be pleased with the efficiency.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
> Consulting, Training, Support, Custom Development, Engineering
> http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
>
>

Tom Lane wrote:
> Viktor Valy <vili0121(at)gmail(dot)com> writes:
> > We are 2 Students from the Technical University of Vienna. At our internship
> > we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS
> > to be qualified by schema/table name".
> > Is anyone working on it?
>
> Uh, it was done years ago, AFAICS, unless the Todo entry means something
> non-obvious.
>
> regression=# create schema foo;
> CREATE SCHEMA
> regression=# create table foo.bar (f1 int unique deferrable);
> NOTICE: CREATE TABLE / UNIQUE will create implicit index "bar_f1_key" for table "bar"
> CREATE TABLE
> regression=# set constraints foo.bar_f1_key deferred;
> SET CONSTRAINTS
> regression=# set constraints foo.bar_f1_key immediate;
> SET CONSTRAINTS
> regression=#
>
> Bruce, do you remember what that entry was really about?

Yep, that was it. I have remove that TODO item. Thanks.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

Viktor Valy <vili0121(at)gmail(dot)com> writes:
> Thanks for the advice!Yes, we are new to linux too :)We have chosen
> Eclipse, because we have already experience with it.However, after
> downloading the code from CVS, we can&#39;t build it, because of some
> include commands in tutorial / complex.c says "No such file or
> directory".  Does anybody know what the clue is?

Did you try this wiki page yet?

http://wiki.postgresql.org/wiki/Working_with_Eclipse

> On Tue, 2010-08-03 at 11:10 -0400, Robert Haas wrote:
>> Or vi.
>
> cough.

Well, I guess letting newcomers know about tools of choice amongst
regular contributors is a good idea, but the best editor you can find
around is the one you master.

In all fairness until now I counted a lot of Emacs users, some (g)vim
ones, and I didn't keep track of users of Visual Studio, Eclipse, etc
but you can't pretend they're not there. My bet is that the winner in
term of user count would be Emacs.

Regards,
--
dim

Hello!

We have chosen another item from the list:
"Allow ALTER TABLE to change constraint deferrability and actions"

Is this already done? If yes, can you recommend any task which is
appropriate for beginners in open-source software?

Thanks in advance,

Chris & Viktor

2010/8/4 Bruce Momjian <bruce(at)momjian(dot)us>

> Tom Lane wrote:
> > Viktor Valy <vili0121(at)gmail(dot)com> writes:
> > > We are 2 Students from the Technical University of Vienna. At our
> internship
> > > we would like to develop the item of the TODO list: "Allow SET
> CONSTRAINTS
> > > to be qualified by schema/table name".
> > > Is anyone working on it?
> >
> > Uh, it was done years ago, AFAICS, unless the Todo entry means something
> > non-obvious.
> >
> > regression=# create schema foo;
> > CREATE SCHEMA
> > regression=# create table foo.bar (f1 int unique deferrable);
> > NOTICE: CREATE TABLE / UNIQUE will create implicit index "bar_f1_key"
> for table "bar"
> > CREATE TABLE
> > regression=# set constraints foo.bar_f1_key deferred;
> > SET CONSTRAINTS
> > regression=# set constraints foo.bar_f1_key immediate;
> > SET CONSTRAINTS
> > regression=#
> >
> > Bruce, do you remember what that entry was really about?
>
> Yep, that was it. I have remove that TODO item. Thanks.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>

On Wed, Aug 11, 2010 at 7:47 AM, Viktor Valy <vili0121(at)gmail(dot)com> wrote:
> We have chosen another item from the list:
> "Allow ALTER TABLE to change constraint deferrability and actions"

I believe that is not done. What does the TODO list item mean by "and actions"?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> What does the TODO list item mean by "and actions"?

Things like ON DELETE CASCADE versus ON DELETE RESTRICT?

-Kevin

On Wed, Aug 4, 2010 at 5:34 PM, Dimitri Fontaine <dfontaine(at)hi-media(dot)com> wrote:
>> On Tue, 2010-08-03 at 11:10 -0400, Robert Haas wrote:
>>> Or vi.
>>
>> cough.
>
> Well, I guess letting newcomers know about tools of choice amongst
> regular contributors is a good idea, but the best editor you can find
> around is the one you master.

I should probably mention that my comment about vi was mostly
tongue-in-cheek, although it is my preferred editor just because I've
been using it so long (i.e. it's the one I've mastered). I learned
emacs at one point, but it was just too slow on the Sun3 I was using
at the time, and the need to hit the control key constantly was hard
on my hands.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company