[GENERAL] [SQL] Q: documentation bug ?

Hello all, the online documentation for REINDEX http://www.postgresql.org/docs/9.5/static/sql-reindex.html talks about VERBOSE Synopsis REINDEX [ ( { VERBOSE } [, ...] ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name [...] VERBOSE

[GENERAL] workarounds for ci_text

Hi, As far as I can tell, you can't restrict the length of a ci_text field like char(5) or varchar(5)? Let's say you got a stock table and you want an alphanumeric stock code that is the primary key but it must be case insensitive can I do something like this: create table stock(stock code

Re: [GENERAL] [SQL] Q: documentation bug ?

On Thu, Feb 04, 2016 at 12:00:45PM +0100, Vik Fearing wrote: >> REINDEX [ ( { VERBOSE } [, ...] ) ] { INDEX | TABLE | SCHEMA | DATABASE >> | SYSTEM } name ... >> Does this constitute a bug in the documentation or in the Debian version of >> PG ? > > Neither. It's a little bit obscure

Re: [GENERAL] workarounds for ci_text

On Thu, 4 Feb 2016 13:48:37 +0200 Heine Ferreira wrote: > > As far as I can tell, you can't restrict the length of a ci_text field like > char(5) or varchar(5)? > Let's say you got a stock table and you want an alphanumeric stock > code that is the primary key but it

Re: [GENERAL] Asp.net 5 and EF6

It looks like builds versioning number but not sure if anyone has tried asp.net 5 or not? -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: 04 February 2016 18:02 To: pgsql-general@postgresql.org

Re: [GENERAL] Asp.net 5 and EF6

On 2/4/2016 2:34 PM, FarjadFarid(ChkNet) wrote: It looks like builds versioning number but not sure if anyone has tried asp.net 5 or not? I personally don't use ASP.NET anything. The people I know who do develop software for .NET generally try and stay with the lowest common denominator,

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

On 02/04/2016 01:35 PM, drum.lu...@gmail.com wrote: On 4 February 2016 at 12:03, David G. Johnston >> wrote: On

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

> > >> On 4 February 2016 at 12:03, David G. Johnston >> > wrote: >> >> On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com >> > >wrote: >>

Re: [GENERAL] Hot standby and xlog on a ramdisk

On 02/04/2016 09:25 AM, Tore Halvorsen wrote: > > On 02/04/2016 09:15 AM, Tore Halvorsen wrote: > > Can a hot standby run correctly with the xlog-files on a ramdisk? > > > > Yes, but, if you lose any, you'll need to rebuild the standby. > > > Even if the master and archive contain

Re: [GENERAL] Hot standby and xlog on a ramdisk

On Thu, Feb 4, 2016 at 3:30 PM, Scott R Mead wrote: > > Can a hot standby run correctly with the xlog-files on a ramdisk? >> > >> >> Yes, but, if you lose any, you'll need to rebuild the standby. >> >> > Even if the master and archive contain all the wal files? > > If you

Re: [GENERAL] reverse proxy to postgresql with haproxy

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 02/04/2016 03:56 AM, Aviel Buskila wrote: > Hey everyone, > I am trying to configure reverse proxy to postgresql using haproxy, for this example I have the following architecture: > - node1 > - node2 > - haproxysrv > > Streaming replication

[GENERAL] Hot standby and xlog on a ramdisk

Hi, Can a hot standby run correctly with the xlog-files on a ramdisk? -- Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul] Tore Halvorsen || +052 0553034554

Re: [GENERAL] Hot standby and xlog on a ramdisk

> > On 02/04/2016 09:15 AM, Tore Halvorsen wrote: > > Can a hot standby run correctly with the xlog-files on a ramdisk? > > > > Yes, but, if you lose any, you'll need to rebuild the standby. > > Even if the master and archive contain all the wal files? -- Eld på åren og sol på eng gjer mannen

Re: [GENERAL] query from two tables & concat the result

On Wed, Feb 3, 2016 at 8:19 PM, Raymond O'Donnell wrote: > On 03/02/2016 14:05, arnaud gaboury wrote: thetradinghall=> SELECT u.username ||'@'||d.domain as email_address FROM email.mailusers u INNER JOIN email.domainlist d ON (u.domain_id=d.id);

[GENERAL] Recursive CTE in function problem

Postgres 9.4.1, with these tables: grpl_collection.collections id | integer | name | text| parent | bigint | (An adjacency list representing a collections hierarchy) grpl_collection.collections_copy_map id | integer | collection | bigint | copy | bigint | (map a

[GENERAL] Asp.net 5 and EF6

Hi I am trying to use certain features of Asp.net 5 using postgresql using EF6. I have downloaded the latest unstable version of npgsql and tried to connect to my db. But no luck. I have posted a request to stackoverflow.com but haven't had any response at all. It is easy to

Re: [GENERAL] Asp.net 5 and EF6

On 02/04/2016 08:46 AM, FarjadFarid(ChkNet) wrote: Hi I am trying to use certain features of Asp.net 5 using postgresql using EF6. I have downloaded the latest unstable version of npgsql and tried to connect to my db. But no luck. I am not a nppsql user, so some generic question. Can you

Re: [GENERAL] Hot standby and xlog on a ramdisk

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 02/04/2016 09:15 AM, Tore Halvorsen wrote: > Hi, > > Can a hot standby run correctly with the xlog-files on a ramdisk? > Yes, but, if you lose any, you'll need to rebuild the standby. > -- Eld på åren og sol på eng gjer mannen fegen og

Re: [GENERAL] Hot standby and xlog on a ramdisk

On 2/4/16 9:46 AM, Tore Halvorsen wrote: > On Thu, Feb 4, 2016 at 3:30 PM, Scott R Mead > wrote: > >> > Can a hot standby run correctly with the xlog-files on a >> ramdisk? >> > >> >> Yes, but, if you lose any,

Re: [GENERAL] Asp.net 5 and EF6

I have looked the Npgsql website and downloaded the EF7 files. Of course the full .net core. The problem *seems* to be that there are two separate libraries that need to be added. One is EF related and the other is the Npgsql wrapper. Unfortunately the Nuget installer is not working correctly

Re: [GENERAL] Asp.net 5 and EF6

I am not using EF7. It is actually EF6 under full .net 5 -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: 04 February 2016 17:29 To: FarjadFarid(ChkNet); pgsql-general@postgresql.org Subject: Re: [GENERAL] Asp.net 5 and EF6 On 02/04/2016 09:18 AM,

Re: [GENERAL] [SQL] Q: documentation bug ?

On 04-02-2016 08:53, Karsten Hilbert wrote: > Hello all, > > the online documentation for REINDEX > > http://www.postgresql.org/docs/9.5/static/sql-reindex.html > > talks about VERBOSE > > Synopsis > > REINDEX [ ( { VERBOSE } [, ...] ) ] { INDEX | TABLE | SCHEMA | DATABASE

Re: [GENERAL] Asp.net 5 and EF6

On 2/4/2016 9:52 AM, FarjadFarid(ChkNet) wrote: I am not using EF7. It is actually EF6 under full .net 5 then why is the error... NU1007 Dependency specified was EntityFramework7.Npgsql >=1.0.0 but ended with EntityFramework7.Npgsql 1.0.0 ?? -- john r pierce, recycling bits in santa cruz

[GENERAL] Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

$ initdb -D data-default The files belonging to this database system will be owned by user "pgsql". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search

Re: [GENERAL] Asp.net 5 and EF6

On 02/04/2016 09:18 AM, FarjadFarid(ChkNet) wrote: I have looked the Npgsql website and downloaded the EF7 files. Of course the full .net core. Alright now I am not following, in your original post you said: "Hi I am trying to use certain features of Asp.net 5 using postgresql using EF6."

Re: [GENERAL] [SQL] Q: documentation bug ?

Karsten Hilbert writes: > On Thu, Feb 04, 2016 at 12:00:45PM +0100, Vik Fearing wrote: >>> REINDEX [ ( { VERBOSE } [, ...] ) ] { INDEX | TABLE | SCHEMA | DATABASE | >>> SYSTEM } name >>> Does this constitute a bug in the documentation or in the Debian version of >>> PG

Re: [GENERAL] Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

I wrote: > Karl Denninger writes: >> $ initdb -D data-default >> ... >> creating template1 database in data-default/base/1 ... FATAL: could not >> create semaphores: Invalid argument >> DETAIL: Failed system call was semget(2, 17, 03600). > Hmm. On my Linux box, "man

Re: [GENERAL] Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

On 2/4/2016 12:47, Tom Lane wrote: > I wrote: >> Karl Denninger writes: >>> $ initdb -D data-default >>> ... >>> creating template1 database in data-default/base/1 ... FATAL: could not >>> create semaphores: Invalid argument >>> DETAIL: Failed system call was semget(2, 17,

Re: [GENERAL] Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

On 02/04/2016 10:02 AM, Karl Denninger wrote: $ initdb -D data-default The files belonging to this database system will be owned by user "pgsql". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly

Re: [GENERAL] Asp.net 5 and EF6

On 02/04/2016 09:52 AM, FarjadFarid(ChkNet) wrote: I am not using EF7. It is actually EF6 under full .net 5 Your previous post seemed to be referring to these instructions: http://www.npgsql.org/doc/ef7.html which would indicate you are using EF7, and as John pointed out, so does the error

Re: [GENERAL] Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

Karl Denninger writes: > $ initdb -D data-default > ... > creating template1 database in data-default/base/1 ... FATAL: could not > create semaphores: Invalid argument > DETAIL: Failed system call was semget(2, 17, 03600). Hmm. On my Linux box, "man semget" says EINVAL

Re: [GENERAL] Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

On 02/04/2016 10:02 AM, Karl Denninger wrote: $ initdb -D data-default The files belonging to this database system will be owned by user "pgsql". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly

Re: [GENERAL] Upgrade from 9.4 -> 9.5, FreeBSD 10.2-STABLE, fails on initdb

On 2/4/2016 12:28, Tom Lane wrote: > Karl Denninger writes: >> $ initdb -D data-default >> ... >> creating template1 database in data-default/base/1 ... FATAL: could not >> create semaphores: Invalid argument >> DETAIL: Failed system call was semget(2, 17, 03600). > Hmm.

Re: [GENERAL] Recursive CTE in function problem

On Thu, Feb 4, 2016 at 12:37 PM, Doug Kyle wrote: > But when I use it as a function it always returns false: > > CREATE OR REPLACE FUNCTION grpl_collection.copy_in_collection_name(cpid > bigint, colname text) > RETURNS boolean > LANGUAGE plpgsql > AS $function$ > BEGIN >

Re: [GENERAL] Recursive CTE in function problem

ugh, simple syntax screw up. Thanks David. On 02/04/2016 02:45 PM, David G. Johnston wrote: On Thu, Feb 4, 2016 at 12:37 PM, Doug Kyle >wrote: But when I use it as a function it always returns false: CREATE OR REPLACE FUNCTION

[GENERAL] Cannot Create Objects

Hi, I am having a few problems with access permissions. When I create a new role with NOCREATEUSER and then create a database for that role I can connect to the DB but when trying to create a db object I will get the ERROR: permission denied for schema public. Strangely though, if the role is

Re: [GENERAL] Cannot Create Objects

On 02/04/2016 11:42 AM, Alex Magnum wrote: Hi, I am having a few problems with access permissions. When I create a new role with NOCREATEUSER and then create a database for that role I can connect to the DB but when trying to create a db object I will get the ERROR: permission denied for

Re: [GENERAL] Cannot Create Objects

On 02/04/2016 11:42 AM, Alex Magnum wrote: Hi, I am having a few problems with access permissions. When I create a new role with NOCREATEUSER and then create a database for that role I can connect to the DB but when trying to create a db object I will get the ERROR: permission denied for

[GENERAL] reverse proxy to postgresql with haproxy

Hey everyone, I am trying to configure reverse proxy to postgresql using haproxy, for this example I have the following architecture: - node1 - node2 - haproxysrv Streaming replication between node1 and node2 and auto failover with repmgr. When I issue a connection to haproxysrv to connect, I