o $$
Declare
t text;
begin
t:='COMMENT ON TABLE TEST_COPY IS '||''''||'TEST WITH '||current_date||'''';
execute t;
end;
$$ language plpgsql;
Thanks & Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postg
ant you can do that Or You can use proper where clause as given below:
CREATE INDEX indexname on tablename(columname) where condition;
example:
create index directed_graph_idx on directed_graph(node_from) where node_from in
('A','B');
Thanks & Regards,
Vibhor
On Feb 21, 2011, at 1:39 PM, Yan Cheng CHEOK wrote:
> INSERT INTO backup_table SELECT * FROM unit_11 WHERE status = 1;
You can try something like,
INSERT INTO backup_table select unit_id, 99, status, value from unit_11 where
status=1;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corp
gt; Thinking I was missing something I tried using -t servers, and I get :
> pg_dump: No matching tables were found
>
It should not. Try schemaname.tablename with switch -t.
Thanks & Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
y-many
> hour dump-restore.
>
> Using Postgres 8.4.X.
>
> I assume slony replication is an option.
Right! Replication would help. You can also try Bucardo.
> What about some sort of wal log shipping replication?
WAL Log shipping won't help.
Thanks & Regards,
ber as given
below:
select id,stamp, row_number() over(order by stamp) from test;
Or
Create table test1 as select row_number() over(order by stamp) as id, stamp
from test;
Thanks & Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
erify if those
tables are in template1 database.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Cell: +91-932-568-2279
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
}
> 2 | {4,5,6} | {sm4,sm5,sm6}
Try with intarray Module:
http://www.postgresql.org/docs/8.4/static/intarray.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Cell: +91-932-568-2279
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogsp
nks & Regards,
Vibhor Kumar
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
kup + PITR.
Did you verify base backup (Restoring without PITR) ?
Thanks & Regards,
Vibhor Kumar
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
backup_label
information.
Try following steps:
1. Untar all the gzipped WAL File in One Location
2. Use Following restore command:
cp /%f %p
> We were concerned that shutting down / starting up while recovery is ongoing
> might cause some problems, but the pg documentation indicat
; CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."out2cp" x WHERE
> "site"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text AND
> "cp"::pg_catalog.text OPERATOR(pg_catalog.=) $2::pg_catalog.text FOR SHARE OF
> x"
tp://www.pgadmin.org/docs/1.10/backup.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
my example.
You don't need any table to assign value of function to Variable, if function
returning single value. You can use EXECUTE 'SELECT '||$1||'(y)' into x;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...
ua
> suggested.
>
> A
+1
If UPDATE is for all rows, then
1. CTAS with change value in SELECT
2. Rename the tables. -- This will give zero Bloats.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork
lassid, objid, refclassid, refobjid,
> deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2
> pg_dump: *** aborted because of error
reindexdb -s
will resolve the issue.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Co
ar with.
> Is this part of EntepriseDB's Postgres+ package or something? You should
> probably contact them via their support channels.
GRANT all on function nvl to public would help.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibho
d argument types. You might need
> to add explicit type casts.
Error Message is only saying nvl(integer,integer) does not exists.
Please check offload database is having function nvl and then, grant all on
that function.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enter
below:
psql -c 'COPY tablename to STDOUT;' dbname|psql -c 'COPY tablename from STDIN;'
dbname
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-gener
r near "TABLE"
> SQL state: 42601
> Character: 6
You can't create a table using CSV. However try following:
1. Create structure of table (Parse the column using some script or manually)
2. Import data using COPY Command.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporati
ql:
http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On Mar 9, 2011, at 9:56 AM, abcdef wrote:
> I use postgresql in red hat linux .
> I want to know how I can find out all the procedure stored in the database .
> Any SQL command to do it ???
pg_catalog.pg_proc can be use to find all the functions.
Thanks & Regards,
Vibhor Kumar
password when prompted?
Include following in dos script.
set PGPASSWORD=
Or you can use pgpass.conf file option.
> 3. Is there a way of running the pg_dump with a user that doesn't have a
> password?
For that user, you have to mention trust with hostname in pg_hba.conf
Thanks
o timestamp without time zone
Use to_timestamp function. For more detail refer following documentation:
http://www.postgresql.org/docs/8.3/static/functions-formatting.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprise
up with Filesystem Backup before any
upgrade.
Can you explain, why are you upgrading to 9.1? Currently there is no Prduction
release of 9.1.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blog
R [ trigger_name | ALL | USER ]
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
ers u, pref_match m
where u.id=m.id and u.id like 'DE%' and sum(m.completed > 30 group by u.id,
u.first_name order by sum desc limit 3;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blo
m
where u.id=m.id and u.id like 'DE%' group by u.id, u.first_name having
sum(m.completed > 30 order by sum desc limit 3;
>
> On Tue, Mar 15, 2011 at 10:43 PM, Vibhor Kumar
> wrote:
>>
>> On Mar 16, 2011, at 3:03 AM, Alexander Farber wrote:
>>
>>
um(completed) > 30 group by...
>^
Use having clause for aggrgate function,
group by col1, col2 having sum(col) >
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
B
ed end of line.
Try following, it should work:
INSERT INTO mytypetable VALUES (
6,ARRAY[row('a', 'aa'), row('b',
'bb')]::mytype[] );
Thanks & Reg
and can also
use array of that
http://www.postgresql.org/docs/8.4/static/sql-createtype.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-g
pen. If the Binaries version is same and Data Directory is
same, then \l should show all databases.
Please reconfirm the data directory and Version of PG.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blo
irst statement.
B > A, if the there is any change happened Or Any session has evicted the
cached data.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general ma
'select empno from '||$1||' where id = 1'
LOOP
return next rec.empno;
END LOOP;
return next rec.empno;
END;
$$ language plpgsql;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterpr
text)
RETURNS SETOF text AS $$
BEGIN
RETURN QUERY EXECUTE 'SELECT content FROM ' || quote_ident(tablename);
END;
$$ LANGUAGE plpgsql;
To prevent from sql injection user can try with SQL Protect:
http://www.enterprisedb.com/docs/en/9.0/sqlprotect/Table%20of%20Contents.htm
Thanks &
mething like given below:
ERROR: SQLPROTECT: Illegal Query: relations
Which stops user guessing relation.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing lis
of syncing and restarting to bring up a new slave.
You can try repmgr developed by 2nd Quadrant. Link is given below:
http://projects.2ndQuadrant.com/repmgr
You can also try with pgpool failover feature:
http://pgpool.projects.postgresql.org/
Thanks & Regards,
Vibhor Kumar
Enterpris
lete based on the age
> of the file? What the the best way to manage the removal of old archive logs?
Its totally upto you which method you want to follow.
tar command gives an option of deleting of files, after archiving it
(--remove-files).
Thanks & Regards,
Vibhor Kumar
Blog:http://vib
If you are using one-click installer by EnterpriseDB then you can use
"unattended mode" of installer. Following is a link:
http://www.enterprisedb.com/docs/en/8.4/instguide/Postgres_Plus_Advanced_Server_Installation_Guide-15.htm#P889_74430
Thanks & Regards,
Vibhor Kumar
Enterpri
ious connection kept
You have created role and trying to login as role. Create user and then try.
USER=ROLE+Login Privilege.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent vi
readline was installed via ports)
> - Perl 5.12.3 (compled from source under /usr/local/ linked via enviromentab
> le variables in .profile / config options ./configure.gnu -des -Duseshrplib
> --prefix=/usr/local/perl5)
Any Error Message?
Thanks & Regards,
Vibhor Kumar
Enter
is?
Try Following link:
http://rpm.pbone.net/index.php3/stat/4/idpl/14282865/dir/opensuse/com/psqlODBC-08.03.0200-9.2.i586.rpm.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
S
ECT
T -- TEMPORARY
arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects)
* -- grant option for preceding privilege
/ -- role that granted this privilege
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enter
[ Please don't overpost the list. Adding PG General List]
On Apr 5, 2011, at 3:30 AM, Ray Stell wrote:
> On Tue, Apr 05, 2011 at 02:42:30AM +0530, Vibhor Kumar wrote:
>>
>> On Apr 5, 2011, at 2:31 AM, Ray Stell wrote:
>>
>>> What does the results in col
On Apr 5, 2011, at 6:07 PM, Ray Stell wrote:
> On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
>>
>> Following are details:
>> postgres=UC/postgres+
>> [user] [privs] /[ ROLE who granted privs.
>
> What's the logic for reporting the U pr
ace where
nspname='schemaname');" ;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
ing subquery with single comparison
operator (like "=" ) in condition clause.
Please share the query which is giving this error message
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspo
tm#P134_8474
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgre
> space. Thanks in advance.
No. You can't do that.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Apr 11, 2011, at 11:56 PM, Willy-Bas Loos wrote:
> My ON INSERT rule won't go off when I copy into it.
> Is there a way to COPY into a RULE?
COPY Command does not respect rule on table, so please use trigger.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterp
CT pg_stat_activity.procpid, (('now'::text)::timesta...
> ^
> It failed.
Reason is: From postgreSQL 9.2 onwards, pg_stat_activity.procpid is renamed as
pg_stat_activity.pid.
http://www.postgresql.org/docs/9.2/interactive/release-9-2.html
Thanks & Regards,
Vibhor Ku
>
You would like to try something like:
COPY (SELECT id, testname FROM my_foreigntbl) TO '/tmp/testlist_aid'
(DELIMITER ',');
I am curious to know, why do you want to execute COPY command through fdw, why
not run directly on server, which has table?
Thank
database.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Postgres Database Company
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jun 21, 2013, at 3:38 PM, Lonni J Friedman wrote:
> On Fri, Jun 21, 2013 at 11:17 AM, Vibhor Kumar
> wrote:
>>
>> On Jun 21, 2013, at 2:05 PM, Lonni J Friedman wrote:
>>
>>> On Fri, Jun 21, 2013 at 10:56 AM, Vibhor Kumar
>>> wrote:
>&
around this?
>
> Not sure how deep you are into your present situation. The only thing I can
> think of is to install Postgres using the PGDG repos and then migrating the
> data from the EDB install to the RPM install. You would probably have to
> change the port numbers, at least temporarily, while you do the migration.
> This way you could use the packaging system without resorting to work-arounds.
I don’t think Martin has to migrate database. He has installed PostgreSQL 9.6
using EDB one-click installer. I can see two options here:
1. Install PostgreSQL using RPM as mentioned by Adrian. Stop the PostgreSQL
using one click installer binaries and start using RPM binary. After that
Martin can install repmgr using RPM.
2. Compile repmgr with existing installation.
https://github.com/2ndQuadrant/repmgr <https://github.com/2ndQuadrant/repmgr>
Thanks & Regards,
Vibhor Kumar
Blogs:https://vibhorkumar.blog
> On May 11, 2017, at 10:40 AM, Adrian Klaver wrote:
>
> On 05/11/2017 07:32 AM, Vibhor Kumar wrote:
>>> On May 11, 2017, at 10:17 AM, Adrian Klaver >> <mailto:adrian.kla...@aklaver.com> <mailto:adrian.kla...@aklaver.com
>>> <mailto:adrian.kla...@a
"more" exists in C:\Windows\System32. So, please set the path in PATH
Environment Variable. and then try.
My Computer (Right Click) -> Properties -> then go to Advanced tab ->
Environment Variable -> set the path.
Thanks & Regards,
Vibhor Kumar
www.enterprisedb.com
times. Yes it requires double space. However it has given
me what I needed. Online VACUUM FULL (for primary key table), Online CLUSTER.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
-
able.
> There's a proposal about an alternative to pg_reorg on depesz' Blog:
> http://www.depesz.com/index.php/2010/10/17/reduce-bloat-of-table-without-longexclusive-locks/
For huge bloats, mentioned Method is slower.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The
cation of PG Database
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
: the database system is starting up
> Master DB is running and able to query table. But slave DB is not running and
> not able to query table.
Please confirm if you have made Slave DB using PITR/Hot Backup of Master. Also,
please let me know the steps which you have followed.
Thanks &a
On Apr 21, 2011, at 4:23 PM, Tiruvenkatasamy Baskaran wrote:
> Which version of postgresql supports replication on RHEL6?
> RHEL version : 2.6.32-71.el6.x86_64
Why are you re-posting your question, if it has been answered?
Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.bl
ql.org/wiki/Streaming_Replication
Thanks & Regards,
Vibhor
On Apr 22, 2011, at 11:08 AM, Tiruvenkatasamy Baskaran wrote:
> Hi Vibhor Kumar,
>
> Here is the configuration changes.
> Changes made on Master DB
> -
> 1. tar –xzvf
On Apr 28, 2011, at 2:56 PM, Thomas Larsen Wessel wrote:
> UPDATE foo SET bar = TO_VARCHAR( TO_FLOAT(bar) * 2); -- INCORRECT
If you are sure bar contains float value, then try following:
UPDATE foo SET bar = bar::float * 2;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporat
On Apr 28, 2011, at 3:22 PM, Dmitriy Igrishin wrote:
> NB: I am sure that OP is not sure :-) And since foo.bar is varchar,
> it is better to use numeric instead of float :-)
Now, this make to ask question, why numeric? How its better than float?
Thanks & Regards,
Vibhor Kumar
En
t. This I have missed.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@enterprisedb.com
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
On May 17, 2011, at 3:17 AM, Gauthier, Dave wrote:
> Is there a way to suppress the "INSERT x x" and "DELETE y" (etc...) messages
> in psql?
psql -q
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.ku...@e
sql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Please post the questions about xDB Replication on following link:
http://forums.enterprisedb.com/forums/show/3.page
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise
On Jun 7, 2011, at 4:09 PM, AI Rumman wrote:
> Is there any maximum size limit for a query string in Postgresql 9.0.1?
> If yes, what is it ?.
track_activity_query_size parameter.
http://www.postgresql.org/docs/9.0/static/runtime-config-statistics.html
Thanks & Regards,
Vi
larger then query
> size.
>
Thanks. my bad :(. I understood this question wrong.
> Regards
>
> Pavel Stehule
>
>
> 2011/6/7 Vibhor Kumar :
>>
>> On Jun 7, 2011, at 4:09 PM, AI Rumman wrote:
>>
>>> Is there any maximu
suggest me some guidelines to follow and some links too.
I think you would like to go through following thread:
http://archives.postgresql.org/pgsql-sql/2010-04/msg6.php
Presentation:
http://wiki.postgresql.org/images/9/91/Pguswest2008hnd.pdf
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corpora
t to a shell command and STDIN to read input
from shell command.
Something like given below:
psql -c "COPY mytable to STDOUT"|gzip >/home/tgl/mytable.dump.gz
cat filename|psql -c "COPY mytable from STDIN;"
OR psql -c "COPY mytable from STDIN;" < filename
On Jul 21, 2011, at 3:59 AM, Tatsuo Ishii wrote:
>> On Jul 20, 2011, at 18:11, Andrej wrote:
>>
>>> Can anyone recommend "PostgreSQL 9.0 High Performance" by G. Smith?
>>
>> Yes.
>
> +1.
+1.
Thanks & Regards,
Vibhor Kumar
Enterprise
ind / -name dblink.sql
>
> What am I missing?
>
> Regards, Clodoaldo
After installing the contrib module you have to execute following command in
Database:
CREATE EXTENSION dblink;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: h
not in (SELECT MIN(ctid) FROM
file_test WHERE md5sum='0010a3e4cc6cb8623c014f5bb95b5be1';
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-gener
t; Even if i do a pg_start_backup()? I thought it set db data/ files in a
> consistent state and puts in wal files the new transactions and apply them
> when call pg_stop_backup().
>
> I must do it other way then :(
>
> Thanks
If you are doing pg_start_backup(), taking snapshot and pg_
nt, if that fulfill your requirement as
given below:
create table test2(col citext check(length(col) < 3));
Or
you can create a domain which you can use in CREATE TABLE command as given
below:
CREATE domain citext_char as CITEXT CHECK(length(value) <= 3);
Thanks & Regards,
Vibho
ewall/antivirus software and restart
the PostgreSQL.
Following is a thread, which has good discussion on it:
http://www.mail-archive.com/pgsql-general@postgresql.org/msg132613.html
--
Thanks & Regards,
Vibhor Kumar.
-pgport=5444' '--with-ldap'
'--with-pam' '--with-libmemcached' 'CC=/usr/local/gcc41/bin/gcc'
'CPPFLAGS=-I/home/edb/AS83R2/build/AS83R2/edb-postgres/src/include'
LIBS = -lpgport -lmemcached -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5
-lz -ledit -
-pgport=5444' '--with-ldap'
'--with-pam' '--with-libmemcached' 'CC=/usr/local/gcc41/bin/gcc'
'CPPFLAGS=-I/home/edb/AS83R2/build/AS83R2/edb-postgres/src/include'
LIBS = -lpgport -lmemcached -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5
-lz -ledit -ltermcap -lcrypt -ldl -lm
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Co.
er% -U %username% -d %database% -p %port% --file File.sql >> xx
--
Thanks& Regards,
Vibhor Kumar.
Senior System Engineer.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Foll
he services.
--
Thanks& Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb
--
Sent via pgsql-
e992e" does not exist
Try with reset_query_list= 'ABORT; DISCARD ALL'
--
Thanks& Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Fo
; Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb
--
Sent via pgsql-general mailing list (pgs
On Aug 9, 2010, at 11:40 AM, tuanhoanganh wrote:
> What is the name of DW in --type=DW
> Sorry for my English.
>
DW: Data Warehouse
> Tuan Hoang Anh
>
> On Mon, Aug 9, 2010 at 6:21 PM, Amitabh Kant wrote:
> 2010/8/9 Sim Zacks
>
>
>
> I just found out about pgtune and am trying it out o
On Aug 12, 2010, at 2:43 PM, Peter Geoghegan wrote:
> Hello,
>
> I would like to set up pgAgent on windows. I'm using the EDB 8.4.4
> package. I know that it is bad practice to put the password directly
> in the conninfo string, so I've avoided that. I want to use pgpass
> authentication, per th
--help
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
inary hidden somewhere
> in the packages.
Yes, you are right. pg_filedump is not part of PG Source. Its a separate
module, which needs to be compile.
Thanks & Regards,
Vibhor Kumar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
>
> Hello,
>
> Can any one help me if oracle like any user_source table is there in postgre
> 8.4 (in pg_catalog or information_schema).
> Actually we migrated code from Oracle to Postgre. Now i want to search in how
> many places( i.e. in functions ) we have used a particular syntax( e.g.
e parameter version of xslt_process()
> is available.
>
> Perhaps is need to run some script to have it available ?
xslt_process function is part of xml2 contrib module. Execute following for xml2
CREATE EXTENSION xml2;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
T
rror message, you are getting.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
u can set log_statement parameter.
http://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-LOG-STATEMENT
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (
ce
WHERE c.relkind='r' and c.oid=$1
$$ language sql;
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Blog: http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
priseDB_OraCompat_EN_8.3-49.htm
Regards,
Vibhor Kumar
www.enterprisedb.com
Mauro Bertoli wrote:
Hi all,
is possible in PostgreSQL to create query between multidatabase like Sql Server
2005?
An example:
SELECT
db1.a.id FROM db1.a
UNION
db2.b.id FROM db2.b
Where "db1" is a databas
Hi Eugenio,
Use the following command to know about the locale.
pg_controldata
For more information, please follow the link given below:
http://www.postgresql.org/docs/8.3/static/app-pgcontroldata.html
Thanks & Regards,
Vibhor Kumar
www.enteprisedb.com
Stefan Kaltenbrunner wrote:
Eug
:
http://www.postgresql.org/docs/8.1/static/app-pgcontroldata.html
Thanks & Regards,
Vibhor Kumar
www.enterprisedb.com
Vibhor Kumar wrote:
Hi Eugenio,
Use the following command to know about the locale.
pg_controldata
For more information, please follow the link given below:
96 matches
Mail list logo
