Re: [GENERAL] semi-variable length type

> > James Harper writes: > > I want to make a float(n) type that emulates the mssql float type. The > > storage requirements are documented as 4 bytes for 1 <= n <=24, and 8 > > bytes for 25 <= n <= 53. > > Haven't we got that already? > > regression=# create table t1 (f1 float(5), f2 float(30)

Re: [GENERAL] semi-variable length type

James Harper writes: > I want to make a float(n) type that emulates the mssql float type. The > storage requirements are documented as 4 bytes for 1 <= n <=24, and 8 > bytes for 25 <= n <= 53. Haven't we got that already? regression=# create table t1 (f1 float(5), f2 float(30)); CREATE TABLE reg

[GENERAL] semi-variable length type

I want to make a float(n) type that emulates the mssql float type. The storage requirements are documented as 4 bytes for 1 <= n <=24, and 8 bytes for 25 <= n <= 53. If I understand correctly, my options for emulating this in postgres are: 1. declare as variable length. Storage is then 8 bytes (

[GENERAL] table "db1.public.a" and all behind "db1.public.a" tables did not do analyzing

when I used vacuumdb -d db1 -z -v > /BACKUP/script/db1.$LOG_DATE.log 2>&1 it occued this error [automatic vacuum of table "db1.public.a": could not (re)acquire exclusive lock for truncat] and table "db1.public.a" and all behind "db1.public.a" tables did not do analyzing. I want to know: 1.wh

Re: [GENERAL] Will Postgres work with Oracle Forms 6i?

On Thu, 2014-02-20 at 14:03 -0800, Joshua D. Drake wrote: > On 02/20/2014 12:53 PM, John R Pierce wrote: > > > > On 2/20/2014 12:45 PM, Santo Campione wrote: > >> We are assessing how to migrate our current (and very old) Oracle > >> Database 10.1.2.4 to Postgres. Our question/concern is the dat

[GENERAL] FIPS mode - SSL connection fails

We recently upgraded to version 8.4.18 within our product but this upgrade has caused SSL connections to fail when OpenSSL is in FIPS mode. We receive the following error: 2014-02-20 01:44:23 PST [9339]: [1-1] db=[unknown],user=[unknown] LOG: could not accept SSL connection: decryption failed or

Re: [GENERAL] Will Postgres work with Oracle Forms 6i?

On 02/20/2014 12:53 PM, John R Pierce wrote: On 2/20/2014 12:45 PM, Santo Campione wrote: We are assessing how to migrate our current (and very old) Oracle Database 10.1.2.4 to Postgres. Our question/concern is the data to be migrated is used extensively by custom applications written with Or

Re: [GENERAL] Timezone information

On Fri, Feb 21, 2014 at 12:43 AM, Andrew Sullivan wrote: > Do you control the client code? If so, why not set the TimeZone > locally when you connect? That's the right way to handle this, > really. > Agree. So find the OS timezone at programming level and set accordingly. This can be done eithe

Re: [GENERAL] Will Postgres work with Oracle Forms 6i?

On 2/20/2014 12:45 PM, Santo Campione wrote: We are assessing how to migrate our current (and very old) Oracle Database 10.1.2.4 to Postgres. Our question/concern is the data to be migrated is used extensively by custom applications written with Oracle Forms 6i. Will Postgres work with Forms

[GENERAL] Will Postgres work with Oracle Forms 6i?

We are assessing how to migrate our current (and very old) Oracle Database 10.1.2.4 to Postgres. Our question/concern is the data to be migrated is used extensively by custom applications written with Oracle Forms 6i. Will Postgres work with Forms 6i? If not, what options would you recommend?

Re: [GENERAL] UTF-8 collation on Windows?

On 02/20/2014 12:27 PM, Dev Kumkar wrote: On Fri, Feb 21, 2014 at 1:26 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: Well I dug out a Windows machine and tried to get what you wanted, to no avail. As far as I know there is no UTF8 collation, it is an encoding. What you

Re: [GENERAL] UTF-8 collation on Windows?

On 02/20/2014 11:40 AM, Dev Kumkar wrote: Hmm. Don't want to digress here and loose the topic context. Here would really appreciate if there are any suggestions for UTF-8 collation on Windows? Just had idea, not sure how feasible it is in your situation though. Run Postgres in a Linux VM on

Re: [GENERAL] UTF-8 collation on Windows?

On Fri, Feb 21, 2014 at 1:26 AM, Adrian Klaver wrote: > Well I dug out a Windows machine and tried to get what you wanted, to no > avail. As far as I know there is no UTF8 collation, it is an encoding. What > you want if I am following, is the en_US locale (or equivalent for another > language) on

Re: [GENERAL] UTF-8 collation on Windows?

On 02/20/2014 11:40 AM, Dev Kumkar wrote: Hmm. Don't want to digress here and loose the topic context. Here would really appreciate if there are any suggestions for UTF-8 collation on Windows? Well I dug out a Windows machine and tried to get what you wanted, to no avail. As far as I know t

Re: [GENERAL] UTF-8 collation on Windows?

On Fri, Feb 21, 2014 at 12:14 AM, Gavin Flower < gavinflo...@archidevsys.co.nz> wrote: > On 21/02/14 02:04, Dev Kumkar wrote: > > On Thu, Feb 20, 2014 at 3:04 AM, Gavin Flower < > gavinflo...@archidevsys.co.nz> wrote: > >> Upgrade servers to Linux? :-P >> > > Actually that's not the solution b

Re: [GENERAL] Timezone information

On Fri, Feb 21, 2014 at 12:14:42AM +0530, Dev Kumkar wrote: > These are the two clients which I have currently who communicate with > database. > Do you control the client code? If so, why not set the TimeZone locally when you connect? That's the right way to handle this, really. A -- Andrew

Re: [GENERAL] UTF-8 collation on Windows?

On 21/02/14 02:04, Dev Kumkar wrote: On Thu, Feb 20, 2014 at 3:04 AM, Gavin Flower mailto:gavinflo...@archidevsys.co.nz>> wrote: Upgrade servers to Linux? :-P Actually that's not the solution but running away from it. There is a heavy footprint of customers and huge market on windows to

Re: [GENERAL] Timezone information

On Thu, Feb 20, 2014 at 9:30 PM, Adrian Klaver wrote: > > So what is your requirement? > Do you have a specific application/use for the databases you are > installing? There are two interfaces for the database. One is from the ODBC driver and other is from the JDBC driver. These are the two clie

Re: [postgis-users] [GENERAL] postgis in postgresql apt and upgrades

So cool ^^ Going to simplify a lot install and upgrades ! Cheers, Rémi-C 2014-02-20 17:47 GMT+01:00 Willy-Bas Loos : > On Thu, Feb 20, 2014 at 4:45 PM, Willy-Bas Loos wrote: > >> Since the package names are equal to those in debian and ubuntu >> (postgresql-x.x-postgis), how will new versions

Re: [postgis-users][GENERAL] postgis in postgresql apt and upgrades

On Thu, Feb 20, 2014 at 4:45 PM, Willy-Bas Loos wrote: > Since the package names are equal to those in debian and ubuntu > (postgresql-x.x-postgis), how will new versions of postgis and upgrades be > handled? > please excuse me, i was being silly. the package names are actually: postgresql-x.x-p

Re: [postgis-users] [GENERAL] postgis in postgresql apt and upgrades

On Thu, Feb 20, 2014 at 4:57 PM, Rémi Cura wrote: > could you please explain what you mean by "Congrats on the availability of > postgis in de postgresql apt reporsitory"? > It would be very great, > but I can't find postgis package in > http://apt.postgresql.org/pub/repos/apt/dists/ > Is this w

[GENERAL] FIPS mode - SSL connection fails and RAND_cleanup

We recently upgraded to version 8.4.18 within our product but this upgrade has caused SSL connections to fail when OpenSSL is in FIPS mode. We receive the following error: 2014-02-20 01:44:23 PST [9339]: [1-1] db=[unknown],user=[unknown] LOG: could not accept SSL connection: decryption failed o

Re: [GENERAL] Timezone information

On 02/20/2014 04:59 AM, Dev Kumkar wrote: On Thu, Feb 20, 2014 at 4:31 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: It depends on how you are declaring the timestamp field. If you do not use with time zone then the input value is open to interpretation and is not 'anc

[postgis-users][GENERAL] postgis in postgresql apt and upgrades

Hi, Congrats on the availability of postgis in de postgresql apt reporsitory, this is great work! I have one question about versions and upgrade sof postgis. Since the package names are equal to those in debian and ubuntu (postgresql-x.x-postgis), how will new versions of postgis and upgrades be

Re: [GENERAL] Timezone information

On 02/20/2014 04:29 AM, Dev Kumkar wrote: On Thu, Feb 20, 2014 at 3:53 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: Each driver will have its own behavior. For an explanation of the JDBC behavior see here: http://www.postgresql.org/__message-id/4B2F2CED.10400@__opencl

Re: [postgis-users] [GENERAL] postgis in postgresql apt and upgrades

Hey, could you please explain what you mean by "Congrats on the availability of postgis in de postgresql apt reporsitory"? It would be very great, but I can't find postgis package in http://apt.postgresql.org/pub/repos/apt/dists/ Thanks, Rémi-C 2014-02-20 16:45 GMT+01:00 Willy-Bas Loos : > Hi,

Re: [GENERAL] configuration error

saravanan Chow, 20.02.2014 06:41: > There is nothing in the pg_log. > Log files contains : "2014-02-20 10:58:55 IST LOG: received fast shutdown > request > 2014-02-20 10:58:55 IST LOG: aborting any > active transactions > 2014

Re: [GENERAL] Query

is this not a help line? On 20 February 2014 09:31, Vik Fearing wrote: > On 02/20/2014 10:29 AM, Daniel Cardno wrote: > > How do I go about deleting the user? > > I don't know, I don't use Windows. > -- > Vik >

Re: [GENERAL] Query

How do I go about deleting the user? On 20 February 2014 01:09, Vik Fearing wrote: > On 02/19/2014 08:01 PM, Daniel Cardno wrote: > > Hi, > > > > I have recently changed from HEM2 to PT4, during the changeover i > > uninstalled Postgres and HM2, i then went on to install PT4 and > > postgres 8.

Re: [GENERAL] configuration error

There is nothing in the pg_log. Log files contains :  "2014-02-20 10:58:55 IST LOG:  received fast shutdown request   2014-02-20 10:58:55 IST LOG:  aborting any active transactions   2014-02-20 10:58:55 IST LOG:  autovacuum launch

Re: [GENERAL] UTF-8 collation on Windows?

On Thu, Feb 20, 2014 at 3:04 AM, Gavin Flower wrote: > Upgrade servers to Linux? :-P > Actually that's not the solution but running away from it. There is a heavy footprint of customers and huge market on windows too and so not that easy to migrate and convince in market. Regards...

Re: [GENERAL] Timezone information

On Thu, Feb 20, 2014 at 4:31 AM, Adrian Klaver wrote: > It depends on how you are declaring the timestamp field. If you do not use > with time zone then the input value is open to interpretation and is not > 'anchored' to a point in time. > > Example > > My time zone is currently PST. > test=> cr

Re: [GENERAL] Timezone information

inline: On Thu, Feb 20, 2014 at 3:57 AM, Tom Lane wrote: > > The functionality of determining an IANA timezone name equivalent to the > platform's behavior is currently embedded in initdb and isn't separately > accessible. So you've got several options: > Hmm, actually was looking for exact that

Re: [GENERAL] Timezone information

On Thu, Feb 20, 2014 at 3:55 AM, Terence Ferraro wrote: > Or, if you don't mind a little patching: http://pastebin.com/5AyaX2RF > > That restores the pre-9.1 functionality of determining the timezone on > postmaster start. As has been pointed out, their new stuff is more useful > if you're shippin

Re: [GENERAL] Timezone information

On Thu, Feb 20, 2014 at 3:53 AM, Adrian Klaver wrote: > Each driver will have its own behavior. For an explanation of the JDBC > behavior see here: > > http://www.postgresql.org/message-id/4b2f2ced.10...@opencloud.com > > > Per Andrews posts, the least surprise behavior is to explicitly set the >

Re: [GENERAL] UTF-8 collation on Windows?

On Thu, Feb 20, 2014 at 4:34 PM, Daniel Verite wrote: > Despite windows-1252 being a monobyte encoding sharing most > of LATIN1 codes and character set, it does not mean that > English_United States.1252 is limited to this character set. > You may use UTF-8 databases with that locale. > > Consider

Re: [GENERAL] automatically refresh all materialized views?

On Fri, Feb 14, 2014 at 7:26 PM, Reece Hart wrote: > I should be able to chase pg_depends entries to create this ordering, right? Not always, there may be circular dependencies between them. Regards, Marti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Possible to improve optimisation / index usage based on domain properties of a function

Thanks Alban, Sameer. My use of partitions should have been more of a side note really. I was particularly interested in wether the query planner could optimise a date_folded equality expression into a range query - for the case where it could benefit from an existing index on the non-folded valu

Re: [GENERAL] UTF-8 collation on Windows?

Dev Kumkar wrote: > Succeeds but as replied earlier it creates database with LC_COLLATE = > 'English_United States.1252' which corresponds to Latin1. Despite windows-1252 being a monobyte encoding sharing most of LATIN1 codes and character set, it does not mean that English_United States.

Re: [GENERAL] Query

On 02/20/2014 11:24 AM, Daniel Cardno wrote: > is this not a help line? > > > On 20 February 2014 09:31, Vik Fearing > wrote: > > On 02/20/2014 10:29 AM, Daniel Cardno wrote: > > How do I go about deleting the user? > > I don't know, I don't use Windows.

Re: [GENERAL] Query

On 02/20/2014 10:29 AM, Daniel Cardno wrote: > How do I go about deleting the user? I don't know, I don't use Windows. -- Vik -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general