command failed with exit code 1 (use -v to see
invocation)
make: *** [auto_explain.so] Error 1
--
Thanks and Regards,
Sachin Kotwal
On Tue, Apr 19, 2016 at 7:02 PM, Adrian Klaver
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 install the 9.3.11 server from sourc
Hi Tom,
Thanks for reply.
On Tue, Apr 19, 2016 at 7:40 PM, Tom Lane wrote:
> Sachin Kotwal writes:
> > On Tue, Apr 19, 2016 at 7:02 PM, Adrian Klaver <
> adrian.kla...@aklaver.com>
> > wrote:
> >> Did you install the 9.3.11 server from source also?
>
>
On Thu, Apr 21, 2016 at 7:20 PM, Adrian Klaver
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 > <mailto:t...@sss.pgh.pa.us>> wrote:
>>
>&
xisting 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
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 f
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 in
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 T
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), DAYOFWEEK(SALES_
>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 funct
>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
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 n
>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
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:
http://postgresql.1045698.n5.nabble.com/Postgres-9-2-4-for-Wi
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
660"
so please check anything 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)
--
Vie
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
row)
--
Thanks and Regards,
Sachin Kotwal
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 wrote:
> Hi All,
>
> Is there any reason to keep column names as usesysid a
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
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 wrote:
> Sachin Kotwal writes:
> > I can understand that it is important to maintain namin
s, 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
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
) to PGDATA (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-tp5774125p5
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
29 matches
Mail list logo
