Thread: 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@gmail.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@gmail.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@linux.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@linux.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
On Tue, 2010-08-03 at 11:10 -0400, Robert Haas wrote: > On Tue, Aug 3, 2010 at 9:01 AM, Thom Brown <thom@linux.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@commandprompt.com>
On Tue, 2010-08-03 at 11:10 -0400, Robert Haas wrote:cough.
> On Tue, Aug 3, 2010 at 9:01 AM, Thom Brown <thom@linux.com> wrote:
> > I can't answer the main question, but you can try Anjuta as a C
> > editor: http://www.anjuta.org/
>
> Or vi.
The hint here would be:I doubt they are unix/linux people at all. Putting them into Vi land is
>As we have few experience with open-source programs, can someone
>recommend a good C-editor for Ubuntu?
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@gmail.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@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
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@momjian.us>
Yep, that was it. I have remove that TODO item. Thanks.Tom Lane wrote:
> Viktor Valy <vili0121@gmail.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?
--
Bruce Momjian <bruce@momjian.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@gmail.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@gmail.com> wrote: > What does the TODO list item mean by "and actions"? Things like ON DELETE CASCADE versus ON DELETE RESTRICT? -Kevin
Viktor Valy <vili0121@gmail.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'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
On Wed, Aug 4, 2010 at 5:34 PM, Dimitri Fontaine <dfontaine@hi-media.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