Re: [GENERAL] Extensions and privileges in public schema

On Sun, Dec 4, 2016 at 4:24 PM, Paul Ramsey wrote: > When you create the student user, remove their create privs in public. > Then create a scratch schema and grant them privs there. > Finally, alter the student user so that the scratch schema appears FIRST > in their

[GENERAL] Extensions and privileges in public schema

organization might address both concerns. Best, --Lee -- Lee Hachadoorian Assistant Professor of Instruction, Geography and Urban Studies Assistant Director, Professional Science Master's in GIS Temple University

Re: [GENERAL] Replication Recommendation

On Mon, Sep 12, 2016 at 5:12 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 09/12/2016 12:46 PM, Lee Hachadoorian wrote: >> >> There are a wide variety of Postgres replication solutions, and I >> would like advice on which one would be appropriate to my use

[GENERAL] Replication Recommendation

; solution of updating "master" and doing a full database drop and restore on the "slaves". But I would like to know which of the other (real) replication solutions might work for this use case. Regards, --Lee -- Lee Hachadoorian Assistant Professor of Instruction, Geography and Ur

Re: [GENERAL] Postgres case insensitive searches

want to write every table like this, but if (a) query speed trumps all other requirements and (b) functional index, CITEXT, etc. have all been rejected as not fast enough --Lee -- Lee Hachadoorian Assistant Professor in Geography, Dartmouth College http

[GENERAL] SQL keywords are suddenly case sensitive

. version() = PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit Regards, --Lee -- Lee Hachadoorian Assistant Professor in Geography, Dartmouth College http://freecity.commons.gc.cuny.edu -- Sent via pgsql-general mailing list

Re: [GENERAL] SQL keywords are suddenly case sensitive

On 04/16/2013 07:31 PM, Adrian Klaver wrote: On 04/16/2013 02:46 PM, Lee Hachadoorian wrote: List, SQL seems to be behaving in a case-sensitive manner: universe=# select 1; ?column? -- 1 (1 row) universe=# SELECT 1; ERROR: syntax error at or near SELECT 1 LINE 1: SELECT

Re: [GENERAL] SQL keywords are suddenly case sensitive

On 04/16/2013 07:34 PM, Adrian Klaver wrote: On 04/16/2013 02:46 PM, Lee Hachadoorian wrote: List, SQL seems to be behaving in a case-sensitive manner: universe=# select 1; ?column? -- 1 (1 row) universe=# SELECT 1; ERROR: syntax error at or near SELECT 1 LINE 1: SELECT

Re: [GENERAL] SQL keywords are suddenly case sensitive

formatting thing. In psql, the caret is under the S. Looking at the other issues you raised, but just wanted to provide a quick answer to that. Best, --Lee -- Lee Hachadoorian Assistant Professor in Geography, Dartmouth College http://freecity.commons.gc.cuny.edu -- Sent via pgsql-general

Re: [GENERAL] SQL keywords are suddenly case sensitive

On 04/16/2013 08:23 PM, Tom Lane wrote: Lee Hachadoorian lee.hachadooria...@gmail.com writes: SQL seems to be behaving in a case-sensitive manner: universe=# select 1; ?column? -- 1 (1 row) universe=# SELECT 1; ERROR: syntax error at or near SELECT 1 LINE 1: SELECT 1

Re: [GENERAL] Current Schema for Functions called within other Functions

Merlin, Perfect. Thank you. Best, --Lee On Mon, Apr 1, 2013 at 10:04 AM, Merlin Moncure mmonc...@gmail.com wrote: On Sun, Mar 31, 2013 at 5:32 PM, Lee Hachadoorian lee.hachadooria...@gmail.com wrote: I'm working on some PL/pgSQL functions to generate dynamic SQL. The functions live

[GENERAL] Current Schema for Functions called within other Functions

, changing search_path to the other schema returns the correct current_schema but the value from the table in the *other* schema (e.g. var2,var1). What am I missing? Thanks, --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://freecity.commons.gc.cuny.edu/

[GENERAL] Check table storage parameters

. Thanks, --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://freecity.commons.gc.cuny.edu/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Check table storage parameters

On Fri, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian lee.hachadooria...@gmail.com wrote: How can I read the current storage parameters for an existing table? Specifically interested in autovacuum_enabled. On Fri, Nov 16, 2012 at 12:08 PM, Mike Blackwell mike.blackw...@rrd.com wrote: Try

Re: [GENERAL] pg_wrapper error

are not installed. You cannnot enable them by making them each a link to pg_wrapper. You might want to bring this back to the PostGIS list, because I think this is a problem of an incorrect PostGIS installation. --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http

Re: [GENERAL] dblink.sql and Linux

a not-very-obvious "Show [x] technical items" link at the bottom of the window. I would recommend using apt (command line) or Synaptic (graphical) instead of Software Center. sudo apt-get install postgresql postgresql-contrib should get you started. --Lee

[GENERAL] Multiple COPY statements

in the same transaction? Any other advice will be appreciated. Regards, --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center for Urban Research http://freecity.commons.gc.cuny.edu/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Multiple COPY statements

On Thu, May 10, 2012 at 2:42 PM, Andy Colson a...@squeakycode.net wrote: On 5/10/2012 1:10 PM, Lee Hachadoorian wrote: 2) Is there a performance hit to doing a COPY to more than one table in the same transaction? No, I don't think so.  I assume you are the only user hitting

Re: [GENERAL] huge price database question..

On Tue, Mar 20, 2012 at 11:28 PM, Jim Green student.northwest...@gmail.comwrote: On 20 March 2012 22:57, John R Pierce pie...@hogranch.com wrote: avg() in the database is going to be a lot faster than copying the data into memory for an application to process. I see.. As an example, I

Re: [GENERAL] huge price database question..

On Wed, Mar 21, 2012 at 12:57 PM, Andy Colson a...@squeakycode.net wrote: On 3/21/2012 11:45 AM, Lee Hachadoorian wrote: On 20 March 2012 22:57, John R Pierce pie...@hogranch.com mailto:pie...@hogranch.com wrote: avg() in the database is going to be a lot faster than copying

Re: [GENERAL] DDL Triggers

what you want when the problem is ogr2ogr. So, I would back up and ask, what are you trying to do, and what information is being lost using -append? Also, you mentioned asking this on the GDAL list, did you try the PostGIS list? --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences

Re: [GENERAL] JOIN column maximum

be views. --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center for Urban Research http://freecity.commons.gc.cuny.edu/

[GENERAL] JOIN column maximum

, so the question is mostly curiosity, but I haven't been able to find this documented anywhere. Moreover, the 32767 limit doesn't map to any immediately intuitive transformation of 90, like squaring (which is much too low) or factorial (which is much to high). Any insight? Regards, --Lee -- Lee

Re: [GENERAL] JOIN column maximum

different approaches, but for now planning on using array columns, with each sequence (in the Census sense, not the Postgres sense) of 200+ variables in its own array rather than its own table. --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center

[GENERAL] Significant Digits in Floating Point Datatype

/2011-08/msg00144.php) If this is the case, what does a precision of at least [x] digits actually mean? And can I reliably retrieve the original integer by casting to int (or bigint) if the number of digits in the original integer is less than 15? Regards, --Lee -- Lee Hachadoorian PhD, Earth

Re: [GENERAL] Significant Digits in Floating Point Datatype

how many or few digits are involved). So integers are fine, bigints not so much. regards, tom lane Thank you, that clarification is extremely useful. --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center for Urban

Re: [GENERAL] Large Rows

from the database as it is, with 117 linked tables? 2) Is there any way to store the data all in one row? If numeric types are un-TOASTable, 23k columns will necessarily break the 8k limit even if they were all smallint, correct? Regards, --Lee -- Lee Hachadoorian PhD, Earth Environmental

Re: [GENERAL] Large Rows

On Wed, Oct 26, 2011 at 10:15 AM, Simon Riggs si...@2ndquadrant.com wrote: On Wed, Oct 26, 2011 at 2:57 PM, Lee Hachadoorian lee.hachadoor...@gmail.com wrote: Interesting. Although your example of one, 10-dimension array works, five hundred 2-dimension arrays does not work. I can do

[GENERAL] Large Rows

are un-TOASTable, 23k columns will necessarily break the 8k limit even if they were all smallint, correct? Regards, --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center for Urban Research http://freecity.commons.gc.cuny.edu -- Sent via pgsql

Re: [GENERAL] The first dedicated PostgreSQL forum

that they are external. They don't look, act or feel like forums. Shrug. Further they aren't part of postgresql.org so nobody knows the level of real support they are going to get. JD -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center

Re: [GENERAL] Connection timeouts from pgAdmin

John, Just wanted to reply that this seems to have been the right track. Rather than change the firewall settings, our network administrator was able set postgres to send a keepalive to the client. Thanks, --Lee On Thu, Mar 4, 2010 at 5:26 PM, Lee Hachadoorian lee.hachadoor...@gmail.com wrote

[GENERAL] Connection timeouts from pgAdmin

minutes of inactivity. Thanks, --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Connection timeouts from pgAdmin

? 15-20 mins sounds a lot like the typical NAT idle connection timeout... I will have to ask the network administrator and respond. Thanks, --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center -- Sent via pgsql-general mailing list

[GENERAL] Array columns vs normalized table

quarters. Thanks, --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Array columns vs normalized table

data out of sight. Thanks for your replies. Please feel free to comment if you think of anything else. Best, --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Client Encoding and Latin characters

to COPY FROM data incompatible with LATIN1, the command will just choke, and I can pick an appropriate encoding and try again, right? Thanks, --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Client Encoding and Latin characters

, IIUC, the general approach is: *Leave the default client_encoding = server_encoding (in this case UTF8) *Rely on the client to change client_encoding on a session basis only Thanks, --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center

[GENERAL] PostgreSQL won't start

has read/write access (it does). What else can I try to start the server? Thanks, Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] PostgreSQL won't start

Services Manager, it generates the following error: Error 1069: The service did not start due to a logon failure. Thanks, Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center On Wed, Mar 12, 2008 at 2:05 PM, Scott Marlowe [EMAIL PROTECTED] wrote