[ADMIN] Doubt about Multi Dimensional Array Fetching

2012-12-10 Thread Niyas P K
Hai, I have problem in PostgreSql Multidimensional Arrays, which I need to use in my project.I need to fetch a particular value or one dimensional array from a two dimensional array or from a multidimensional array without specifying the dimensions or index. Please help me out to

[ADMIN] Doubt

2006-03-18 Thread Babu
Hi   i have create one table and view., but i have not able to insert,update and delete view., how to solve this. Pls send me on example.   Table : Create Table Test (eno int,ename varchar(10));  View : Create or Replace view TestView as Select * from Test;  Regards  Babu.

[ADMIN] doubt

2005-07-08 Thread Mogin Mohandas
Hi When I try to run 'make install' it gives me an "error 2". Any idea about error 2. I guess it has something to do with initdb. Here is portions of the error: make[2]: *** [installdirs] Error 2 make[2]: Leaving directory `/home/mmohanda/postgres/postgresql-7.4.8/doc' make[1]: **

Re: [ADMIN] doubt

2005-07-06 Thread Joshua D. Drake
Dong B. Calmada wrote: According to Joshua D. Drake: I don't show that as a package in my apt-cache? postgresql-autodoc is under the 'multiverse' category. Have you added the keyword to the sources.list's archive entry? Aha! I had universe not multiverse. Thanks for the tip. J -- Your P

Re: [ADMIN] doubt

2005-07-06 Thread Dong B. Calmada
According to Joshua D. Drake: > > I don't show that as a package in my apt-cache? postgresql-autodoc is under the 'multiverse' category. Have you added the keyword to the sources.list's archive entry? ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [ADMIN] doubt

2005-07-06 Thread Jonathan Daugherty
# I don't show that as a package in my apt-cache? It's in mine on debian testing. Redhat's package cache isn't nearly as extensive; I've found numerous widely-available packages missing from it, even ones you can get on redhat CDs. -- Jonathan Daugherty Lead Programmer Command Prompt, Inc

Re: [ADMIN] doubt

2005-07-06 Thread Joshua D. Drake
Dong B. Calmada wrote: According to Joshua D. Drake: Date: Wed, 06 Jul 2005 20:52:22 -0700 It depends on what you mean by Extend. If you mean adding contrib modules, custom functions etc... then just make sure that you have all of postgresql installed... libecpg-dev - development files for

Re: [ADMIN] doubt

2005-07-06 Thread Dong B. Calmada
According to Joshua D. Drake: > Date: Wed, 06 Jul 2005 20:52:22 -0700 > > It depends on what you mean by Extend. If you mean adding contrib > modules, custom functions etc... then just make sure that you have all > of postgresql installed... > > libecpg-dev - development files for ECPG (Embedded

Re: [ADMIN] doubt

2005-07-06 Thread Joshua D. Drake
Mogin Mohandas wrote: Hi again I just wanted to know for extending the database, is it better to install postgres from a pre-installed package or source. I have installed ubuntu and was trying to install from source. Please give me some opinions. It depends on what you mean by Ext

[ADMIN] doubt

2005-07-06 Thread Mogin Mohandas
Hi again I just wanted to know for extending the database, is it better to install postgres from a pre-installed package or source. I have installed ubuntu and was trying to install from source. Please give me some opinions. Thank you Mogin ---(end of broadcas

[ADMIN] doubt

2004-06-13 Thread sathish
dear groups, i have a doubt in sql, i have a table staff_skills in which i have set a table level constraint to create a primary key of two fields . so 'name' and 'skill' combinedly forms a primary key. now the issue is in another table i have only 'name' field and i want to create a fore

[ADMIN] Doubt about Database Migration Wizard

2003-06-06 Thread Marco Aurélio Cerqueira Teixeira
Gents, Whent I try to use Database Migration Wizard through pgAdminII and I select the MS Jet Ole DB in order to import a MS Access Database to PostgreSQL, there is a field named Provider String that I don't know what it means. Can you tell me what is this? Thank you. Rgds, Marco Aurélio

[ADMIN] Doubt in Plpgsql

2002-05-26 Thread shreedhar
Hi all,     I am sorry for putting this question in this list. Hope some body may know 'plpgsql' in postgres.     As I am practicing plpgsql I wrote the following code which is not retrieving data.   declare temprec record; funcs text; funcid integer;   begin funcs := 'success';    for temp

[ADMIN] Doubt...

2001-07-13 Thread LA
Hi.. I have a few doubts, please help me.. 1. how I change from a database to other? 2.- The command "copy" just root-postgres can do it o another users? 3.- If "copy" can do another users what priviligies must have them? Thanks __ ---(end of broadcast)---