pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFunction
22+ messages / 12 participants
[nested] [flat]
* Function
@ 2000-04-10 08:13 Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
0 siblings, 1 reply; 22+ messages in thread
From: Angel Manuel Diaz Aunion @ 2000-04-10 08:13 UTC (permalink / raw)
To: pgsql-sql
Hello,
I have a problem with the output value of a function, that is to say,
the value I get when the function is carried out:
I want a function, chich output value is an array, and when I create the
function, it is defined as follows:
> create function path_inte(path,path) returns _point
> as '/net/ipfy/angel/postgres/geometry/libMWgeom.so' language 'c';
>
> When the function is used, the resultat is always: "{}", so I do not
> Know if:
-the function is not well defined, or
-the output value can not be an array
Thank you very much.
Angel Manuel Diaz Aunion
Institut fuer Photogrametrie und Fernerkundung.
Universitaet Karlsruhe.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2000-04-10 14:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
0 siblings, 0 replies; 22+ messages in thread
From: Tom Lane @ 2000-04-10 14:03 UTC (permalink / raw)
To: Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>; +Cc: pgsql-sql
Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de> writes:
> I want a function, chich output value is an array, and when I create the
> function, it is defined as follows:
>> create function path_inte(path,path) returns _point
>> as '/net/ipfy/angel/postgres/geometry/libMWgeom.so' language 'c';
>>
>> When the function is used, the resultat is always: "{}", so I do not
>> Know if:
> -the function is not well defined, or
> -the output value can not be an array
I don't know of any reason why a C function couldn't return an array,
so the problem is probably in your code...
regards, tom lane
^ permalink raw reply [nested|flat] 22+ messages in thread
* Function
@ 2000-04-11 15:08 Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
0 siblings, 0 replies; 22+ messages in thread
From: Angel Manuel Diaz Aunion @ 2000-04-11 15:08 UTC (permalink / raw)
To: pgsql-sql
Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de> writes:
> I want a function, chich output value is an array, and when I create the
> function, it is defined as follows:
>> create function path_inte(path,path) returns _point
>> as '/net/ipfy/angel/postgres/geometry/libMWgeom.so' language 'c';
>>
>> When the function is used, the resultat is always: "{}", so I do not
>> Know if:
> -the function is not well defined, or
> -the output value can not be an array
I don't know of any reason why a C function couldn't return an array,
so the problem is probably in your code...
regards, tom lane
I have received your response about how a function, which output value
is an array, can be created (e-mail 10.04.99), but I get always the same
resultat. Would you be so kind as to write an example of a function,
which output value is an array ?
Thank you very much.
Angel Manuel Diaz Aunion
Institut fuer Photogrametrie und Fernerkundung.
Universitaet Karlsruhe.
^ permalink raw reply [nested|flat] 22+ messages in thread
* function
@ 2000-04-17 15:35 Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
0 siblings, 0 replies; 22+ messages in thread
From: Angel Manuel Diaz Aunion @ 2000-04-17 15:35 UTC (permalink / raw)
To: pgsql-sql
Angel Manuel Diaz Aunion writes:
I want a function, chich output value is an array, and when I create
the
function, it is defined as follows:
create function path_inte(path,path) returns _point
as '/net/ipfy/angel/postgres/geometry/libMWgeom.so' language 'c';
When the function is used, the resultat is always: "{}", so I do not
Know if:
-the function is not well defined, or
-the output value can not be an array
I have received your response about how a function, which output value
is an array, can be created (e-mail 10.04.99), but I get always the same
resultat. Would you be so kind as to write an example of a function,
which output value is an array ?
Thank you very much.
Angel Manuel Diaz Aunion
Institut fuer Photogrametrie und Fernerkundung.
Universitaet Karlsruhe.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Function
@ 2000-04-19 17:20 Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
0 siblings, 0 replies; 22+ messages in thread
From: Angel Manuel Diaz Aunion @ 2000-04-19 17:20 UTC (permalink / raw)
To: pgsql-sql; lockhart@alumni.caltech.edu; maillist@candle.pha.pa.us
I'm trying to write a function which is defined as follows:
create function lseg_res(path,path) returns _lseg
as '/net/ipfy/angel/postgres/geometry/libMWgeom.so' language 'c';
The output value is supposed to be an array, but what I get is "{}".
I don't know whether
-the function is not well defined, or
-the output value can not be an array
The code:
#include "../include/geometry.h"
LSEG *lseg_res(PATH *p1,PATH *p2)
{
int4 i,j;
bool c;
LSEG *result[p1->npts] ;
for (j = 0; j < p1->npts; j++)
{
result[j] = palloc (sizeof(LSEG));
}
c = path_inter(p1,p2);
if (c == TRUE )
{
for (i = 0 ; i< p1->npts ; i ++)
{
result[i] = lseg_construct( &p1->p[i], &p1->p[i + 1]);
return result[i];
}
return NULL;
}
Thank you very much.
Angel Manuel Diaz Aunion.
Institut fuer Photogrametrie und Fernerkundung.
Universitaet Karlsruhe.
^ permalink raw reply [nested|flat] 22+ messages in thread
* function
@ 2000-07-01 15:56 Andrey <bp@profit.net.ua>
0 siblings, 0 replies; 22+ messages in thread
From: Andrey @ 2000-07-01 15:56 UTC (permalink / raw)
To: pgsql-sql
Hi.
Does anyone know how I can declaration internal variable in function( SQL language ), and can I use "if" - operation, such as
if( $1 <> $2 )
Best regards
Andrey
^ permalink raw reply [nested|flat] 22+ messages in thread
* function
@ 2000-08-30 15:54 Normunds <normunds@mt.lv>
0 siblings, 2 replies; 22+ messages in thread
From: Normunds @ 2000-08-30 15:54 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-sql
Hi all,
how can I write function which takes text from one field, replaces
some characters and puts it in other field? I have array with old and
new values.
For example:
old array = {'r', 'Z', 'o'}
new array = {'s', 'm', 't'}
old field value = 'Zorro'
new field value which must calculate this function = 'mtsst'
This function will be used in update trigger.
Any ideas?
Normunds
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: function
@ 2000-08-30 22:14 Jan Wieck <janwieck@Yahoo.com>
parent: Normunds <normunds@mt.lv>
1 sibling, 0 replies; 22+ messages in thread
From: Jan Wieck @ 2000-08-30 22:14 UTC (permalink / raw)
To: Normunds <normunds@mt.lv>; +Cc: pgsql-general@postgresql.org; pgsql-sql
Normunds wrote:
> Hi all,
>
> how can I write function which takes text from one field, replaces
> some characters and puts it in other field? I have array with old and
> new values.
>
> For example:
> old array = {'r', 'Z', 'o'}
> new array = {'s', 'm', 't'}
> old field value = 'Zorro'
> new field value which must calculate this function = 'mtsst'
>
> This function will be used in update trigger.
> Any ideas?
Tcl has a "map" functionality as subcommand of "string". I
think it appeared in version 8.1. To use the example below,
your Tcl installation must be 8.1 or newer when rebuilding
PostgreSQL configured with "--with-tcl" and enable PL/Tcl
with "createlang".
CREATE FUNCTION string_map(text, text) RETURNS text AS '
return [string map $2 $1]
' LANGUAGE 'pltcl';
CREATE
SELECT string_map('Zorro', 'r s Z m o t');
string_map
------------
mtsst
(1 row)
As you see, the old and new arrays are both coded into the
second argument. It is a key, value pair list, with usual Tcl
quoting for lists. Can you convert your arrays to that?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: function
@ 2000-08-31 01:50 Ian Turner <vectro@pipeline.com>
parent: Normunds <normunds@mt.lv>
1 sibling, 0 replies; 22+ messages in thread
From: Ian Turner @ 2000-08-31 01:50 UTC (permalink / raw)
To: Normunds <normunds@mt.lv>; +Cc: pgsql-general@postgresql.org; pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> how can I write function which takes text from one field, replaces
> some characters and puts it in other field? I have array with old and
> new values.
Probably best to do this as an embedded perl sql function. Then it is
about 3 lines.
Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE5rbnTfn9ub9ZE1xoRAh7uAKCAxqAM9Wo09g6qntF6qJTtp5u+KACgsO9d
VvH5BBpn4gIpdrHFAw8x6Jo=
=zH55
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 22+ messages in thread
* Function
@ 2004-02-12 11:40 Sumita Biswas (sbiswas) <sbiswas@cisco.com>
0 siblings, 1 reply; 22+ messages in thread
From: Sumita Biswas (sbiswas) @ 2004-02-12 11:40 UTC (permalink / raw)
To: pgsql-sql
Hi All,
This function of mine gives a Parse Error:
CREATE or replace FUNCTION Proc_ConferenceSummary(date,date,int,int,int)
RETURNS SETOF tbl_error_master AS
'
declare
li_CallManagerId int;
begin
select * FROM tbl_error_master;
end;
'
LANGUAGE SQL;
psql:Proc_ConferenceSummary.sql:9: ERROR: parser: parse error at or
near "int" at character 31
I don't see any Syntax Error. Can you please let me know what can be the
issue?
Regards,
Sumita
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-15 19:36 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Sumita Biswas (sbiswas) <sbiswas@cisco.com>
0 siblings, 1 reply; 22+ messages in thread
From: Stephan Szabo @ 2004-02-15 19:36 UTC (permalink / raw)
To: Sumita Biswas (sbiswas) <sbiswas@cisco.com>; +Cc: pgsql-sql
On Thu, 12 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Hi All,
>
> This function of mine gives a Parse Error:
>
> CREATE or replace FUNCTION Proc_ConferenceSummary(date,date,int,int,int)
> RETURNS SETOF tbl_error_master AS
> '
> declare
> li_CallManagerId int;
> begin
> select * FROM tbl_error_master;
> end;
> '
> LANGUAGE SQL;
I think you want plpgsql as the language.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-16 08:12 Sumita Biswas (sbiswas) <sbiswas@cisco.com>
parent: Stephan Szabo <sszabo@megazone.bigpanda.com>
0 siblings, 2 replies; 22+ messages in thread
From: Sumita Biswas (sbiswas) @ 2004-02-16 08:12 UTC (permalink / raw)
To: 'Stephan Szabo' <sszabo@megazone.bigpanda.com>; +Cc: pgsql-sql
Thanks for the answer.
I have one more issue. How do I test a function that I wrote?
I was able to create a function called Proc_ConferenceSummary().
In SQL Server I used to run it through query analyzer by writing the
following command:
exec Proc_ConferenceSummary '12/1/2003','1/23/2004',1,1,0,5001
But I don't know how to do it in Postgresql.
Any help is appreciated.
Thanks,
Sumita
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone.bigpanda.com]
Sent: Monday, February 16, 2004 1:07 AM
To: Sumita Biswas (sbiswas)
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Function
On Thu, 12 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Hi All,
>
> This function of mine gives a Parse Error:
>
> CREATE or replace FUNCTION
> Proc_ConferenceSummary(date,date,int,int,int)
> RETURNS SETOF tbl_error_master AS
> '
> declare
> li_CallManagerId int;
> begin
> select * FROM tbl_error_master;
> end;
> '
> LANGUAGE SQL;
I think you want plpgsql as the language.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-16 17:39 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Sumita Biswas (sbiswas) <sbiswas@cisco.com>
1 sibling, 0 replies; 22+ messages in thread
From: Stephan Szabo @ 2004-02-16 17:39 UTC (permalink / raw)
To: Sumita Biswas (sbiswas) <sbiswas@cisco.com>; +Cc: pgsql-sql
On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Thanks for the answer.
> I have one more issue. How do I test a function that I wrote?
> I was able to create a function called Proc_ConferenceSummary().
> In SQL Server I used to run it through query analyzer by writing the
> following command:
> exec Proc_ConferenceSummary '12/1/2003','1/23/2004',1,1,0,5001
For functions that return setof or complex types, you can do it as
select * from Proc_ConferenceSummary(...) as alias;
For simple functions you can just use:
select functionname(...);
^ permalink raw reply [nested|flat] 22+ messages in thread
* FW: Function
@ 2004-02-17 14:41 Sumita Biswas (sbiswas) <sbiswas@cisco.com>
0 siblings, 1 reply; 22+ messages in thread
From: Sumita Biswas (sbiswas) @ 2004-02-17 14:41 UTC (permalink / raw)
To: pgsql-sql
Is there nothing like SET NOCOUNT ON; in plpgsql
Is there any option like SET ANSI_NULLS ON in plpgsql.
Do we append # before the temp table names in plpgsql, like we do for
MSSQL ? In case no how do we create a temp table in a function in plsql?
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone.bigpanda.com]
Sent: Monday, February 16, 2004 11:10 PM
To: Sumita Biswas (sbiswas)
Cc: pgsql-sql@postgresql.org
Subject: RE: [SQL] Function
On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Thanks for the answer.
> I have one more issue. How do I test a function that I wrote? I was
> able to create a function called Proc_ConferenceSummary(). In SQL
> Server I used to run it through query analyzer by writing the
> following command: exec Proc_ConferenceSummary
> '12/1/2003','1/23/2004',1,1,0,5001
For functions that return setof or complex types, you can do it as
select * from Proc_ConferenceSummary(...) as alias;
For simple functions you can just use:
select functionname(...);
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: FW: Function
@ 2004-02-17 19:26 Richard Huxton <dev@archonet.com>
parent: Sumita Biswas (sbiswas) <sbiswas@cisco.com>
0 siblings, 0 replies; 22+ messages in thread
From: Richard Huxton @ 2004-02-17 19:26 UTC (permalink / raw)
To: sbiswas@cisco.com; pgsql-sql
On Tuesday 17 February 2004 14:41, Sumita Biswas (sbiswas) wrote:
> Is there nothing like SET NOCOUNT ON; in plpgsql
What is this supposed to do for you?
> Is there any option like SET ANSI_NULLS ON in plpgsql.
What is this supposed to do for you too?
> Do we append # before the temp table names in plpgsql, like we do for
> MSSQL ? In case no how do we create a temp table in a function in plsql?
The thing to remember with plpgsql is that it's compiled (unlike say plTcl).
This means that it translates table-names etc. into oids. So what you have to
be careful of is referring to a temporary table that is created, destroyed an
re-created (because it's oid will change).
The solution is to use the EXECUTE command to build a dynamic query. Check the
archives for plenty of other people doing this.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-17 22:46 scott.marlowe <scott.marlowe@ihs.com>
parent: Sumita Biswas (sbiswas) <sbiswas@cisco.com>
1 sibling, 3 replies; 22+ messages in thread
From: scott.marlowe @ 2004-02-17 22:46 UTC (permalink / raw)
To: Sumita Biswas (sbiswas) <sbiswas@cisco.com>; +Cc: 'Stephan Szabo' <sszabo@megazone.bigpanda.com>; pgsql-sql
On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Thanks for the answer.
> I have one more issue. How do I test a function that I wrote?
> I was able to create a function called Proc_ConferenceSummary().
> In SQL Server I used to run it through query analyzer by writing the
> following command:
> exec Proc_ConferenceSummary '12/1/2003','1/23/2004',1,1,0,5001
>
> But I don't know how to do it in Postgresql.
select functioname(arg1,arg2,arg3);
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-19 15:10 Sumita Biswas <sbiswas@cisco.com>
parent: scott.marlowe <scott.marlowe@ihs.com>
2 siblings, 0 replies; 22+ messages in thread
From: Sumita Biswas @ 2004-02-19 15:10 UTC (permalink / raw)
To: 'scott.marlowe' <scott.marlowe@ihs.com>; +Cc: 'Stephan Szabo' <sszabo@megazone.bigpanda.com>; pgsql-sql
Is this the right place to get PostgreSQL 7.3.4 from:
ftp://ftp10.us.postgresql.org/pub/postgresql/source/v7.3.4/postgresql-7.
3.4.tar.gz
Regards,
Sumita
-----Original Message-----
From: scott.marlowe [mailto:scott.marlowe@ihs.com]
Sent: Wednesday, February 18, 2004 4:17 AM
To: Sumita Biswas (sbiswas)
Cc: 'Stephan Szabo'; pgsql-sql@postgresql.org
Subject: Re: [SQL] Function
On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Thanks for the answer.
> I have one more issue. How do I test a function that I wrote? I was
> able to create a function called Proc_ConferenceSummary(). In SQL
> Server I used to run it through query analyzer by writing the
> following command: exec Proc_ConferenceSummary
> '12/1/2003','1/23/2004',1,1,0,5001
>
> But I don't know how to do it in Postgresql.
select functioname(arg1,arg2,arg3);
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-20 06:39 Sumita Biswas <sbiswas@cisco.com>
parent: scott.marlowe <scott.marlowe@ihs.com>
2 siblings, 2 replies; 22+ messages in thread
From: Sumita Biswas @ 2004-02-20 06:39 UTC (permalink / raw)
To: 'scott.marlowe' <scott.marlowe@ihs.com>; +Cc: 'Stephan Szabo' <sszabo@megazone.bigpanda.com>; pgsql-sql
We installed postgres, but it did not install the default DB "postgres".
This is on 7.3.4 postgres.
Any thing that we might have missed out?
TIA,
Sumita
-----Original Message-----
From: scott.marlowe [mailto:scott.marlowe@ihs.com]
Sent: Wednesday, February 18, 2004 4:17 AM
To: Sumita Biswas (sbiswas)
Cc: 'Stephan Szabo'; pgsql-sql@postgresql.org
Subject: Re: [SQL] Function
On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Thanks for the answer.
> I have one more issue. How do I test a function that I wrote? I was
> able to create a function called Proc_ConferenceSummary(). In SQL
> Server I used to run it through query analyzer by writing the
> following command: exec Proc_ConferenceSummary
> '12/1/2003','1/23/2004',1,1,0,5001
>
> But I don't know how to do it in Postgresql.
select functioname(arg1,arg2,arg3);
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-20 08:43 Sumita Biswas <sbiswas@cisco.com>
parent: scott.marlowe <scott.marlowe@ihs.com>
2 siblings, 1 reply; 22+ messages in thread
From: Sumita Biswas @ 2004-02-20 08:43 UTC (permalink / raw)
To: 'scott.marlowe' <scott.marlowe@ihs.com>; +Cc: 'Stephan Szabo' <sszabo@megazone.bigpanda.com>; pgsql-sql
I have a postgres function that returns a boolean, I want to use this
return in another function.
How do I do it?
Will the following code help me fetch it in a variable:
select lv_flag = drop_table_if_exists(''alarmconfig'',false);
drop_table_if_exists is the function which I want to call.
Any help is appreciated.
Thanks,
Sumita
-----Original Message-----
From: scott.marlowe [mailto:scott.marlowe@ihs.com]
Sent: Wednesday, February 18, 2004 4:17 AM
To: Sumita Biswas (sbiswas)
Cc: 'Stephan Szabo'; pgsql-sql@postgresql.org
Subject: Re: [SQL] Function
On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Thanks for the answer.
> I have one more issue. How do I test a function that I wrote? I was
> able to create a function called Proc_ConferenceSummary(). In SQL
> Server I used to run it through query analyzer by writing the
> following command: exec Proc_ConferenceSummary
> '12/1/2003','1/23/2004',1,1,0,5001
>
> But I don't know how to do it in Postgresql.
select functioname(arg1,arg2,arg3);
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-21 08:12 V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
parent: Sumita Biswas <sbiswas@cisco.com>
0 siblings, 0 replies; 22+ messages in thread
From: V i s h a l Kashyap @ [Sai Hertz And Control Systems] @ 2004-02-21 08:12 UTC (permalink / raw)
To: Sumita Biswas <sbiswas@cisco.com>; +Cc: pgsql-sql
Dear Sumita Biswas ,
>I have a postgres function that returns a boolean, I want to use this
>return in another function.
>How do I do it?
>
>Will the following code help me fetch it in a variable:
>select lv_flag = drop_table_if_exists(''alarmconfig'',false);
>drop_table_if_exists is the function which I want to call.
>
>
If this valriable is
lv_flag and you are using plpgsql
just declase
lv_flag as boolean
and point as this
lv_flag := drop_table_if_exists(''alarmconfig'',false);
I hope this helps
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap@jabber.org
ICQ : 264360076
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
I am usually called as Vishal Kashyap
and my Girlfriend calls me Vishal CASH UP.
Because everyone loves me as Vishal Kashyap
and my Girlfriend loves me as CASH.
___
//\\\
( 0_0 )
----------------o0o-----o0o---------------------
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-21 08:12 V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
parent: Sumita Biswas <sbiswas@cisco.com>
1 sibling, 0 replies; 22+ messages in thread
From: V i s h a l Kashyap @ [Sai Hertz And Control Systems] @ 2004-02-21 08:12 UTC (permalink / raw)
To: Sumita Biswas <sbiswas@cisco.com>; +Cc: pgsql-sql
Dear Sumita Biswas ,
>We installed postgres, but it did not install the default DB "postgres".
>
>
Default Db is template1 .
I belive you are talking about user postgres
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap@jabber.org
ICQ : 264360076
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
I am usually called as Vishal Kashyap
and my Girlfriend calls me Vishal CASH UP.
Because everyone loves me as Vishal Kashyap
and my Girlfriend loves me as CASH.
___
//\\\
( 0_0 )
----------------o0o-----o0o---------------------
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Function
@ 2004-02-21 16:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Sumita Biswas <sbiswas@cisco.com>
1 sibling, 0 replies; 22+ messages in thread
From: Tom Lane @ 2004-02-21 16:10 UTC (permalink / raw)
To: Sumita Biswas <sbiswas@cisco.com>; +Cc: pgsql-sql
"Sumita Biswas" <sbiswas@cisco.com> writes:
> We installed postgres, but it did not install the default DB "postgres".
The only DB that exists in a fresh installation is "template1". If
you want to create a DB named "postgres", use the createdb script.
BTW, it's bad manners to ask a new question by following up an existing
unrelated thread. Start a new thread with an appropriate subject line.
Otherwise you're wasting the time of the other people on the mailing
list, who are exactly the people who might answer your question.
regards, tom lane
^ permalink raw reply [nested|flat] 22+ messages in thread
end of thread, other threads:[~2004-02-21 16:10 UTC | newest]
Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-10 08:13 Function Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
2000-04-10 14:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-04-11 15:08 Function Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
2000-04-17 15:35 function Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
2000-04-19 17:20 Function Angel Manuel Diaz Aunion <angel@ipf.uni-karlsruhe.de>
2000-07-01 15:56 function Andrey <bp@profit.net.ua>
2000-08-30 15:54 function Normunds <normunds@mt.lv>
2000-08-30 22:14 ` Re: function Jan Wieck <janwieck@Yahoo.com>
2000-08-31 01:50 ` Re: function Ian Turner <vectro@pipeline.com>
2004-02-12 11:40 Function Sumita Biswas (sbiswas) <sbiswas@cisco.com>
2004-02-15 19:36 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2004-02-16 08:12 ` Sumita Biswas (sbiswas) <sbiswas@cisco.com>
2004-02-16 17:39 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2004-02-17 22:46 ` scott.marlowe <scott.marlowe@ihs.com>
2004-02-19 15:10 ` Sumita Biswas <sbiswas@cisco.com>
2004-02-20 06:39 ` Sumita Biswas <sbiswas@cisco.com>
2004-02-21 08:12 ` V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
2004-02-21 16:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-20 08:43 ` Sumita Biswas <sbiswas@cisco.com>
2004-02-21 08:12 ` V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
2004-02-17 14:41 FW: Function Sumita Biswas (sbiswas) <sbiswas@cisco.com>
2004-02-17 19:26 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox