Hi All,
I want to create a user in Postgres Database. And I want to restrict that user
with some privileges. And also I want that user should be specific to
particular database.
He should not be able to do the following
1) Connect to any other database.
2) Connect to System da
check under $PGHOME/data/pg_log directory.
Usually $PGHOME=/usr/local/pgsql if u have not changed this path during
installation
With Reagrds
Ashish...
- Original Message -
From: phillip
To: pgsql-general@postgresql.org
Sent: Thursday, June 07, 2007 2:21 PM
Subject: [GENE
Hello All,
I think I am little bit lost in congiguration of SHMMAX parameter.
As per documantation on :
http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/admin_user/kernel-resources.html
Name Description Reasonable Values
SHMMAX Maximum size of shared memory segment (by
Hello All,
I have a long list of sql server queries that needs to me remoulded in to
postgres format
can anyone please suggest me any tool that will convert sqlserver query into
postgresql query except
SwisSQL - SQLOne Console 3.0
Thanks in advance
With regards
Ashish Karalkar
ance
With regards
Ashish Karalkar
Hello all,
I want to set Auto vaccunme in such a way that it will start in the Mid night
(12:00 A.M.)
Is there any way to do this except Cron Job for Linux
Thanks In advance
With Regards
ashish ...
Thnkas Richard for your replay.
Actually ,I was looking for some setting in postgresql.conf file
Is there any one?
With Regards
Ashish
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc:
Sent:
Hello All,
I am trying to create a user and i dont understand why it is showing me any
massage even after giving parameter -e to the command.
command :
C:\Program Files\PostgreSQL\8.2\bin>createuser ashish -S -d -R -l -P -E -e -U
postgres
Enter password for new role:
Enter it again:
Passwor
Hello All,
I want to create a user through script and dont want user to assign password
interactively, I want it to be assigned through some file or anything else
some this like
createuser -P * OR createuser -P
Is there any way?
Thanks in Advance
With Regards
Ashish...
Hello All,
I am trying to create databse with script.
I run this script from root prompt with command
$ su - postgres -c 'path to script.sql'
In the script I follow following steps
1) create user xyz
2) create database xyz -O xyz
3) create schema xyz
4) {PG_PATH}/psql -d xyz -U xyz -f
/usr/l
Thanks for your replay Scott,
I am using just sql script
and there is no option like pwd with createuser command
With Regards
Ashish...
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Sent
schmer" <[EMAIL PROTECTED]>
To:
Sent: Monday, July 02, 2007 2:28 PM
Subject: Re: [GENERAL] Tables not created in proper schema
am Mon, dem 02.07.2007, um 11:13:54 +0530 mailte Ashish Karalkar
folgendes:
Hello All,
I am trying to create databse with script.
I run this script from root
- Original Message - >
2007/7/2, Ashish Karalkar <[EMAIL PROTECTED]>:
Hello All,
I want to create a user through script and dont want user to assign
password
interactively, I want it to be assigned through some file or anything
else
some this like
createuser -P
Hello Stefan,
Recently I Have faced this problem and solved by .pgpass file approch
Take alook on
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
With Regards
Ashish...
- Original Message -
From: "Stefan Zweig" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, July 03, 2007
Hello All,
I am trying tu run a script to create database from a batch programme and dont
want to supply password everytime.
So i tried to setup pgpass.conf file.
File is kept in user profile/application data
i.e
C:\Documents and Settings\postgres\Application Data\postgresql\pgpass.conf
file co
- Original Message -
From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 10, 2007 3:51 PM
Subject: Re: [GENERAL] pgpass.conf
On 10/07/2007 08:47, Ashish Karalkar wrote:
Still the
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 10, 2007 4:25 PM
Subject: Re: [GENERAL] pgpass.conf
Ashish Karalkar wrote:
Hello All,
I am trying tu run a script to create
Hello all,
I want to take backup from one server and save it to another machine hard drive.
The backup will be taken through a shell script attached to a cron job.
something like:
pg_dump -d postgres -U postgres -f
is there any way?
With regards
ashish...
Hello All,
I am having PostgreSQL server 8.2.0 running on Redhat Linux .
I want to install PgAdmin GUI on the Linux Server.
can anybody please guide me to the appropriate documantation and the
prerequisite required for the same .
Thanks In Adavnce
With Reagrds
Ashish...
Hello All,
I am having following PostgreSQL & Linux version
PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
20041212 (Red Hat 3.4.3-9.EL4)
I am trying to create the backupfile using gunzip utility
pg_dump qsweb | gzip > /usr/local/backup/backup.gzBut when I run this comm
take a look at dblink in contrib module
With Regards
Ashish...
- Original Message -
From: "Phoenix Kiula" <[EMAIL PROTECTED]>
To: "Postgres General"
Sent: Thursday, August 16, 2007 6:18 PM
Subject: [GENERAL] Accessing tables in other databases, through functions
Probably an optimist
Hello all,
I have a database abc with owner c .
I want to grant only read access on this DB abc to user d.
More specificaly to a schema abcs in the databse abc.
Is ther any way to do so?
I have more than 1000 table so dont want to list all the table name in the
grant command.
Thanks in advan
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Thanks in advance...
With Regrads
Ashish...
Hello All,
I have a data script which runs fine from PgAdmin SQL Editor,but when I run
this from command prompt I get following error:
test=# \i /usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql
psql:/usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql:1: ERROR: invalid byt
e sequence fo
- Original Message -
From: "Ashish Karalkar" <[EMAIL PROTECTED]>
To: "Albe Laurenz" <[EMAIL PROTECTED]>
Sent: Monday, September 03, 2007 4:09 PM
Subject: Re: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff
- Original M
- Original Message -
From: "Albe Laurenz" <[EMAIL PROTECTED]>
To: "Ashish Karalkar *EXTERN*" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, September 03, 2007 4:54 PM
Subject: RE: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff
Ashish K
Hello All,
I am having a table with 5 columns.
I want to add another column by altering the table at 2nd position
constraint is that I can not drop and recreate the table as column ordering
is of importance.
Is there anyway to do so.
Thanks in advance.
With regards
Ashish...
---
Hello All,
I am having a table with 5 columns.
I want to add another column by altering the table at 2nd position constraint
is that I can not drop and recreate the table as column ordering is of
importance.
Is there anyway to do so.
Thanks in advance.
With regards
Ashish...
As per as I think this is not bug,
in first case
when u update the first row
In first case:
M1= 1+1 =2 conflict with the second row.
in second case:
M1=3+1=4 no conflict with second row
I hope this will help.
With reagrds
Ashish
- Original Message -
From: Anoo Sivadasan P
Dear list member,
I am trying to install pgpooladmin tool and the documantation talks about
following parameter
pcp_attach_node command pass /usr/local/bin/pcp_attach_node
pcp_detach_node command pass /usr/local/bin/pcp_detach_node
pcp_node_count command pass /usr/local/bin/
It is
confirmed that the function of php_mstring and php_pgsql is effective.
a.. "Multibyte Support" is "enabled".
b.. "PostgreSQL Support" is "enabled". "
But I dont see any phpinfo.php file in the install directory.
What may be the reason?
With Re
- Original Message -
From: Ashish Karalkar
To: Devrim GÜNDÜZ
Sent: Tuesday, September 25, 2007 4:30 PM
Subject: Re: [GENERAL] PgpoolAdmin installation
I got the answer for the same and is sloved it is just a file which gives
information about the php installations.
I have verified
Hello All,
I have installed pgpoolAdmin on linux box. first pgpool configuration setting
pages work properly after that when I try to login nothing happens.
Following is the error in the apache server log
PHP Warning: fetch(templates_c/%%6A^6A5^6A537DD8%%login.tpl.php): failed to
open stream:
INSERT INTO qsweb.core_board(board_name, entry_user_id, entry_date)
VALUES ('a',1,now()),('b',1,now());
- Original Message -
From: test tester
To: pgsql-general@postgresql.org
Sent: Thursday, October 04, 2007 4:49 PM
Subject: [GENERAL] multiple row insertion
In MySQL, I
Hello All,
I am getting following error when trying to create new database.
createdb: database creation failed: ERROR: could not create directory
"base/1923827": No space left on device
can anybody please tell me what is going wrong.
Thanks in advance.
With regards
Ashish
Hello List Member,
I am trying to setup recovery from WAL, recovery is done properly but there are
some alerting messages in the log file
log file :
*
2007-11-27 14:08:04 IST LOG: database system was
Hello List Members,
I have PostgreSQL 8.2.4 on Suse Linux
Whne I am doing recovery from WAL archives I see in the logger that
"01.history file not found" infact server has not created such file insted
it created 01.backup file which contains the history which documents also
suggest is
Thanks Simon for your replay,
Yes I have followed the same instruction givn on the link, still it is
happining , should i ignore this message too?
With Regards
Ashish
Simon Riggs <[EMAIL PROTECTED]> wrote: On Wed, 2007-11-28 at 06:05 +0000,
Ashish Karalkar wrote:
> I have PostgreSQL
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 05.12.2007, um 10:24:04
+0000 mailte Ashish Karalkar folgendes:
> Hello List member,
>
> Iha a table containing two columns x and y . for single value of x there are
> multiple values in y e.g
>
> X
Hello List member,
Iha a table containing two columns x and y . for single value of x there are
multiple values in y e.g
XY
1ABC
2PQR
3 XYZ
4 LMN
1 LMN
2 XYZ
I want a query that will give me following output
1ABC:LMN
2
Hello there,
I am having data in table something like below:
user_idtype_id
11
12
21
33
43
51
1 10
76
What i want is the co
Hi,
I am having PostgreSQL 8.2.4 on Suse 10.3
Server is not using the index insted it chooses to take seq scan path. table is
having @ 120 million rows
here is the output from planner:
Nested Loop IN Join (cost=0.00..5030217.97 rows=2 width=106)
-> Seq Scan on sms_new (cost=0.00..5027902.0
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 12:44:09
+0000 mailte Ashish Karalkar folgendes:
> > Do you have an index on "mobile"? Can you show us the table definition
> > and the output from EXPLAIN ANALYSE?
>
Alvaro Herrera <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
> Thanks for your answer actually that was the part of full query here is the
> actuall plan
I think you are confusing this for "here is a completely different plan
for a completely different query that
Alvaro Herrera <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
> Thanks for your answer actually that was the part of full query here is the
> actuall plan
I think you are confusing this for "here is a completely different plan
for a completely different query that
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 12:25:20
+0000 mailte Ashish Karalkar folgendes:
> > here is the output from planner:
> > Nested Loop IN Join (cost=0.00..5030217.97 rows=2 width=106)
> > -> Seq Scan on sm
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 11:44:58
+0000 mailte Ashish Karalkar folgendes:
> Hi,
> I am having PostgreSQL 8.2.4 on Suse 10.3
>
> Server is not using the index insted it chooses to take seq scan path. table
> is
> h
Thanks Richard for your replay,
here is the output..
Richard Huxton <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
>
> Richard Huxton wrote: Ashish Karalkar wrote:
>> query which was taking seconds on the join of these two table
>> suddenly started taking 20/25 m
Richard Huxton <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
> query which was taking seconds on the join of these two table
> suddenly started taking 20/25 min
Show the EXPLAIN ANALYSE of your problem query and someone will be able
to tell you why.
Here is the output from exp
Dear list member:
I have small problem,
below is the output from ls -larth command for listing WAL segments.
As far as my understanding every new WAL segment created is numerically greater
than the previous one,but below out show the WAL 13 is created after wal
14,15,16,17,18,19 checked by creat
Dear list members,I am having table with 4M rows.I am trying to update all these rows with statementupdate mytable set mycolumn=0;At the same time there are insert happening on the table.but all these insert are in waiting mode. does update is locking the table for insert?does insert and update con
--- On Wed, 9/1/08, Ashish Karalkar <[EMAIL PROTECTED]> wrote:From: Ashish Karalkar <[EMAIL PROTECTED]>Subject: [GENERAL] Insert waiting for update?To: "pggeneral" Cc: [EMAIL PROTECTED]Date: Wednesday, 9 January, 2008, 4:29 PMDear list members,I am having table with 4M rows
Thanks for the replayI think you missed on second detail mail :For more details:I have two tables master,child.with child having fk to master.Now
that master table contains 4M rows . while I update them (Master table)
the inserts are going into waiting mode on child table.Update
acquired row exclu
Hello list members,I hav a table with 140M rows. While I am trying to select the count from the tableI am getting following errorERROR: shared buffer hash table corruptedCan anybody please suggest me wht had gone wrong and how to fix it?PostgreSQL 8.2.4OS:Suse 10.3With RegardsAshish...
Sa
isting row?
>>
>
> You can simply send the UPDATE, if nothing was updated, it's safe to
> send the INSERT
>
> Regards
> Thomas
>
>
>
something on the line of
http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html
*Example 38-2. Exceptions with UPDATE/INSERT*
--
With Regards
Ashish Karalkar
wow! http://cochesclasicosparabodas.com/cnn.com_world.html
mjfamywelicjnyqepohu
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello List membersI have just upgraded the PostgreSQL server from 8.2.4 to 8.3 on Suse 10.3 64 bit.While inspecting the log i see this errorERROR: shared buffer hash table corruptedCan anybody please help me in getting into details of it?With regardsAshish...
Unlimited freedom, unlimited s
e is an example:
http://pgsql.privatepaste.com/74d558e05f
Any help would be much /appreciated./
--
With Regards
Ashish Karalkar
On 12/10/2009 01:00 PM, dipti shah wrote:
> Hi,
>
> We have started using PostGreSQL for more than 3 months and it looks
> awesome. Currently, we have been suing superuser by default as login
> account. Now, the users are getting increased and we want to go away
> with using superuser by default.
Ashish Karalkar wrote:
Abdul Rahman wrote:
Hi all,
Can any body tell me about tool for PostgreSQL load testing
preferably freeware.
Regards,
Abdul Rehman.
I am not sure its a freeware or not but looks promising
http://bristlecone.continuent.org/HomePage
--Ashish
And ofcourse the
Abdul Rahman wrote:
Hi all,
Can any body tell me about tool for PostgreSQL load testing preferably
freeware.
Regards,
Abdul Rehman.
I am not sure its a freeware or not but looks promising
http://bristlecone.continuent.org/HomePage
--Ashish
--
Sent via pgsql-general mailing list (pgsql-g
Kusuma Pabba wrote:
when creating tables,
in my sql i have used create table
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(50) NOT NULL,
`first_name` varchar(50) default NULL,
`middle_name` varchar(50) default NULL,
`last_name` varchar(50) default NUL
Shahbaz A. Tyagi wrote:
Hi,
We are using Postgres 8.3. We have backed up our db and while trying
to restore, its not able to. We are using PgAdminIII for the same.
What all other ways we have to restore the db. We have both the old
data directory as well as backed up data.
Sh
Shahbaz A. Tyagi wrote:
Hi,
We are using Postgres 8.3. We have backed up our db and while trying
to restore, its not able to. We are using PgAdminIII for the same.
What all other ways we have to restore the db. We have both the old
data directory as well as backed up data.
Sh
. Tyagi
Sphere Networks
-Original Message-
From: Ashish Karalkar [mailto:ashis...@synechron.com]
Sent: Wednesday, February 25, 2009 4:38 PM
To: Shahbaz A. Tyagi
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore DB
Shahbaz A. Tyagi wrote:
Hi,
We are using Postgres 8.3
ö,
Torsten.
If I understood you correctly you might get help from following:
http://pgfouine.projects.postgresql.org/
With Regards
Ashish Karalkar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
najmuddin hassan wrote:
Hi,
I just installed a program called moteview by crossbow technologies.
It uses postgreSQL 8.0.0-rc1 for its database. There is something
wrong as when I launched the program it automaticly gives me an error
that the database is not available. The postgreSQL database
Siddharth Shah wrote:
Hello All,
How Postgres Maintains data in Shared Buffer
Does It maintains queried data in memory or table data and Next time
how postgres fetch data from memory
rather than disk
Which algorithm is used for storing data how data is indexed in shared
buffers
Thanks
Sidd
Hello list,
I was wondering is there any postgresql template for cacti to monitor
PostgreSQL server.
can anybody plz point me to the same?
Thanks in advance
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
Ashish Karalkar wrote:
Hello list,
I was wondering is there any postgresql template for cacti to monitor
PostgreSQL server.
can anybody plz point me to the same?
Thanks in advance
--Ashish
That worked from google,
sorry for making noise...
http://forums.cacti.net/about23300.html
transaction.
With Regards
Ashish Karalkar
EnterpriseDB
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Nagalingam, Karthikeyan wrote:
Hi,
Is there any way to keep each database in separate partition ie)
separate folder for each database.
I would like to do the dabase level backup in storage side, for that
If I am able to separate the database in folderwise, I can allocate
separate partition
Joshua D. Drake wrote:
On Tue, 2009-03-17 at 18:23 +0100, Jennifer Trey wrote:
Which one should one install? Is there any difference?
They are both free right? And both has fulltext support, right?
It depends on your requirements. I always suggest using a version that
natively supp
Simon Riggs wrote:
On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote:
Postgres Plus does support Linux and it includes all the PostgreSQL
features as well as have many other additional useful features.One of
which is its dyna tune module.
You can check through the webpage
http
pd.objoid
AND pc.relname=ic.table_name
AND ic.ordinal_position=pd.objsubid
AND pc.relnamespace=pn.oid
AND pn.nspname in ('public')
ORDER BY pn.nspname,pc.relname,ic.ordinal_position;
With Regards
--Ashish Karalkar
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
ql/xxid.so: failed to map segment from
shared object: Permission denied
Function xxid.so is there in the /usr/lib/pgsql
directory stil its unable to load.
Can any one please help me which shared object it is
refering to...
With Regards
Ashis
Thanks Chris ,
I ahve checked the permissions on the xxid.so file and
it ids having all permission i.e. 0777
I think its not getting the permission from the object
which xxid.so is refering, any idea which object it is
refering
With Regards
Ashish Karalkar
--- Chris <[EMAIL PROTECTED]>
shared
object -permission denied)function was refering ?
with regards
Ashish Karalkar
--- Chris <[EMAIL PROTECTED]> wrote:
> Ashish Karalkar wrote:
> > Thanks Chris ,
> > I ahve checked the permissions on the xxid.so file
> and
> > it ids having all permission i.e. 07
I want to create new set,
I am running create set command as follows
create set (id=2, origin=1, comment='All tables');
but it gives error
syntax error near unexpected token `('
can anybody tell me where i am doing wrong
With regards
Ashish
_
into
which i will merge it later on.
If yes, how to do it coz with the slonik script it
gives me error cluster already exists.
Please help.
Thanks
--- Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar
> wrote:
>
> >
1 );
> _EOF_
:1: ERROR: syntax error at or near MERGE
thanks & regards
ashish karalkar
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited
--
Hello all,
I have build 8.2 version from source code on redhat
linux 4.0
but i am not able to figure out why directory pg_log
is missing...
and as it is missing then where are the log file.'
can anybody help..
Thanks & Regards
Ashish
Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
With Regads
Ashish Karalkar
Want to start your own business?
Learn how on Yahoo! Small Business.
http
Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
With Regads
Ashish Karalkar
Have a burning question?
Go to www.Answers.yahoo.com and get answers from
oing wrong
With Regards
Ashish Karalkar
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
---(end of broadcast)---
Hello All,
I am running PostgresSQL 8.2 on Redhat Linux 4.
When I look for the processes that are using postgres
using ps aux|more
I got lots of Idle processes with servers own IP
address. Can anybody please tell me why this is
happening.
Also there are multiple processes for my single
client(same
uot;commit": SPI_ERROR_TRANSACTION
Thanks in advance!!!
With Regards
Ashish Karalkar
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(e
? where Foreign key = TableAPK
and this should list me
TableB
TableC
is there any way to get this?
Thanks in advance
With Regards
Ashish Karalkar
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail
have strict nameing convention for
foreign key and primary key in order to arive at table
name..
Reece pgutil is excellent to get the all required
information on foreign key tables and primary key
tables.
With Regards
Ashish Karalkar
--- Reece Hart <[EMAIL PROTECTED]> wrote:
>
Hello List,
I am having list of tables , what I want to do is to
filter this list of table for a particular value of
its column, the column which i will be searching is
common accross all tables in list
any clues??
With regards
Ashish Karalkar
Hello all,
I am getting a syntax error near open cursor,
can anybody please point me what is missing. i am
using Postgresql 8.2
CREATE OR REPLACE FUNCTION
sp_gen_foreign_keys_tables(OUT par_result integer, OUT
par_childtables text, IN par_colname character varying
, IN par_colvalue integer) AS
$BO
--- Shoaib Mir <[EMAIL PROTECTED]> wrote:
> Can you show us the output for:
>
> ps auxwww | grep ^postgres
>
> that should explain a little more...
>
> -
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>
> On 1/10/07, Ashish Karalkar
> &l
, we
are using jboss as web application server. Point of
worry is that my server has many idle process on its
own IP .
With regards
Ashish Karalkar
--- Shane Ambler <[EMAIL PROTECTED]> wrote:
> Ashish Karalkar wrote:
> > Hi Shoaib
> >
> > Following is the output for p
#x27; VOLATILE;
it is giving me error in select statment,
Thanks in advance
With Regards
Ashish Karalkar
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.searc
lect into (variable)" but it gives me error
"Execute of select into is not implemented yet"
I am using postgreSQL 8.2.
Thanks in advance
With Regards
Ashish Karalkar
___
Hello list,
I want to automate database creation, user creation,table creation via script.
this script will be run by an external programme to postgresql server.
is there any way?
what i want to do is as follows:
#!/bin/sh
su - postgres
TIMEDUMP=`date +%Y%m%d"_"%H%M`
PG_PATH=/usr/local/pgsql
Hello List,
I want to append column of two different tables in a single column of a view .
data type of tow column of two diffrent tables will be same.
WHAT I WANT TO DO IS:
Table 1
ID DESC
1 A
2 B
3 C
Hello All,
I want to prompt user to input some value and do some action on that value in
runtime of a sql script.
Is there any psql command to do this ??
I can use \echo do display massage
but to take input what is the command?
Thanks in advance
With Regards
Ashish Karalkar
Hello All,
I have downloaded the PLpgSQl Debugger tarball edb-debugger-20061107-src.tar.gz
after issuing gmake
it gives me list of errors.
But not getting how to install it.
Can anybody tell me what are the steps to install it.
Thanks in advance
With Regards
Ashish..
Try
pg_ctl -D /path to pg data home
e.g.
pg_ctl -D /usr/local/pgsql/data
Hope this will help
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "postgresql-general"
Sent: Thursday, March 22, 2007 8:31 AM
Subject: [GENERAL] Configuring phpPgAdmin and pg_ctl reload
1 - 100 of 121 matches
Mail list logo