then we can stop discussion
with 4th point made by Alvaro as conclusion of this discussion.
Please committers give their final view on this.
--
Thanks and Regards,
Sachin Kotwal
and increase naming string
where naming conventions are correct but make shorten.
Suggestions and feedbacks are welcome.
Regards,
Sachin Kotwal
On Mon, Nov 6, 2017 at 8:03 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Sachin Kotwal <kotsac...@gmail.com> writes:
>
indicating the catalog , can we use 4 or 5 letters
?
I think we need to rethink about these short naming conventions which are
making confusion, If community is ok with that.
Please share yours thoughts on this.
Regards,
Sachin Kotwal
On Mon, Nov 6, 2017 at 6:21 PM, Peter Eisentraut
Hi All,
Correcting my words.
Is there any special reason to keep column names as usesysid
and usename instead of usersysid and username in below system View?
On Mon, Nov 6, 2017 at 4:03 PM, Sachin Kotwal <kotsac...@gmail.com> wrote:
> Hi All,
>
> Is there any reason to ke
row)
--
Thanks and Regards,
Sachin Kotwal
the same
> columns that were generated by the existing view query (that is, the
> same column names in the same order and with the same data types), but
> it may add additional columns to the end of the list. The calculations
> giving rise to the output columns may be completely different.
> <<<<<<
>
> Francisco Olarte.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Thanks and Regards,
Sachin Kotwal
On Thu, Apr 21, 2016 at 7:20 PM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 04/21/2016 02:23 AM, Sachin Kotwal wrote:
>
>> Hi Tom,
>>
>> Thanks for reply.
>>
>> On Tue, Apr 19, 2016 at 7:40 PM, Tom Lane <t...@sss.pgh.pa.us
>> <mail
Hi Tom,
Thanks for reply.
On Tue, Apr 19, 2016 at 7:40 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Sachin Kotwal <kotsac...@gmail.com> writes:
> > On Tue, Apr 19, 2016 at 7:02 PM, Adrian Klaver <
> adrian.kla...@aklaver.com>
> > wrote:
> >> Did y
On Tue, Apr 19, 2016 at 7:02 PM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 04/18/2016 11:46 PM, Sachin Kotwal wrote:
>
>> Hi,
>>
>> I am trying to install auto_explain on PostgreSQL-9.3.11
>> OS X EI Capitan - 10.11
>>
>
> Did you inst
and failed with exit code 1 (use -v to see
invocation)
make: *** [auto_explain.so] Error 1
--
Thanks and Regards,
Sachin Kotwal
(as
pg_similarity.conf) and include the following line in postgresql.conf:-
include 'pg_similarity.conf'
-
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pg-similarity-tp5774125p5774835.html
Sent from
How you checked result type?
Can you explain in details?
-
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/C-language-stored-function-and-float4-type-tp5773493p5774840.html
Sent from the PostgreSQL
1. You have to remove foreign key reference from table searchcache.
2. take backup of data from searchcache.
3. create partition of table product
4. add constraints on table searchcache.(if necessary delete and create
searchcache after taking backup.)
-
Thanks and Regards,
Sachin Kotwal
Please look at following topic:-
http://www.postgresql.org/docs/9.0/static/functions-admin.html
try using
#SELECT pg_terminate_backend(2738);
-
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com
create sample table with one or two rows then use following command to
populate data.
INSERT INTO TABLE_NAME VALUES(generate_series(1,10));
-
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com
wrong elsewhere in your code.
Also check free memory of your system, at the time of insertion.
http://www.microolap.com/products/connectivity/postgresdac/help/TipsAndTricks/ByteaVsOid.htm
-
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http
defined tables,
functions, views.
Please reply.
-
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Migration-from-Symfoware-to-PostgreSQL-Constructor-functions-tp5766203.html
Sent from the PostgreSQL
Its looks like your previous un-installation was not done properly.
Uninstall it properly first then restart your system.
check pre-requisite for postgresql if any.
then install Postgres 9.2.4.
--
View this message in context:
where I need to run simultaneously different tests using transactions
Are you running tests simultaneously on different databases?
i.e. access to different databases within one transaction.
If not --
after each transaction you can do pg_switch_xlog() then new transaction log
will be created and
While migrating my application from DB2 to PostgreSQL.
I want to migrate TIMESTAMP() function of DB2 into PostgreSQL.
Example in DB2:
#SELECT TIMESTAMP('2013-01-01','12:13:14') FROM SYSIBM.SYSDUMMY1
1
--
2013-01-01-12.13.14.00
1 record(s)
I have done some more try as follows:
#select timestamp(current_date);
ERROR: syntax error at or near current_date at character 18
STATEMENT: select timestamp(current_date);
ERROR: syntax error at or near current_date
LINE 1: select timestamp(current_date);
Using your link
http://www.postgresql.org/docs/9.2/static/functions-formatting.html
In DB2 when I use following command I am getting output combined date and
time i passed to function.
#SELECT TIMESTAMP('2013-01-01','12:13:14') FROM SYSIBM.SYSDUMMY1
1
I've done something weird:
CREATE OR REPLACE FUNCTION timestamp(_date date, _time time) RETURNS
timestamp AS $$
SELECT _date + _time;
$$ LANGUAGE sql;
SELECT timestamp('2013-01-01'::date, '12:00:00'::time);
Good one.
function with above definition is already present in pg_catalog. so no need
as i know each value is limited to 1GB. For larger content use module lo
http://www.postgresql.org/docs/9.2/static/lo.html
I just want to know that like DB2 we can convert other data types into
CLOB/BLOB using function CLOB()/BLOB().
Example:
SELECT CLOB('testdata') FROM SYSIBM.SYSDUMMY1
Same
PostgreSQL has no such capability. Unless you need that and
want to code it yourself, the best solution would be to
write a function that just ignores the third argument.
For time being I will write a function that just ignores the third argument.
but if we really want to create such
While migrating my application from DB2 to PostgreSQL.
I want to migrate following functions in PostgreSQL.
Functions in DB2: BLOB()/CLOB()
Criteria:
Size of character string targeted for cast is more than 1GB. Character
String as argument to this function.
How can I migrate this function
While migrating my application from DB2 to PostgreSQL.
I want to migrate following functions in PostgreSQL.
TO_CHAR() in DB2 which can take three arguments as follows:
SELECT TO_CHAR(CURRENT_DATE,'-MM-DD',112.50) FROM SYSIBM.SYSDUMMY1
I am not sure what is the purpose of third argument in
While migrating my application from DB2 to PostgreSQL.
I want to migrate ROLLUP() function in PostgreSQL.
Example:
SELECT WEEK(SALES_DATE) AS WEEK,
DAYOFWEEK(SALES_DATE) AS DAY_WEEK,
SUM(SALES) AS UNITS_SOLD
FROM SALES
GROUP BY ROLLUP ( WEEK(SALES_DATE),
Function in DB2: BLOB()Criteria:Size of character string targeted for cast is
more than 1GBHow can I migrate this function into PostgreSQL with above
mention criteria.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-tp5759607.html
Sent
29 matches
Mail list logo
