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, so

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 Subj

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 mailto:david.g.johns...@gmail.com> >> wrote: On Wed, Feb 3, 2016 at 3:48 PM, drum

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

> > >> On 4 February 2016 at 12:03, David G. Johnston >> mailto:david.g.johns...@gmail.com>> wrote: >> >> On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com >> > >wrote: >> >> Hi all, >> >> Below is an example

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 schema

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 schema

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 grpl_collection.copy_in_collect

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 > RETURN cpid in (sel

[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 cr

[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

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, 03600). >> Hmm. On

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 semget" says EINVAL means

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. On my Linux box, "man

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 means EINVAL nse

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 be

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

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 be

[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 c

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

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

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, FarjadF

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." a

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 e

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 expl

[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 con

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 ? >> Neither. It's a li

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, you'll need to rebuild the

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 have the file somewhere,

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 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 fe

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 fjåg

[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] 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 bet

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 must be case insensitive can

[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 varcha

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 beca

[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

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] 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 get