Re: [GENERAL] Pgsql troubleshooting & Iscsi

2016-02-17 Thread Alberto Cabello Sánchez
x/kernel/1332888 I'm not an XFS guru, but it seems that XFS does a bunch of checks just on/after mount, so perhaps PgSQL cannot access /var/lib/pgsql/data immediately. You could igive it a try forcing some delay in systemd conf file, or tweaking the PgSQL startup script. -- Alberto Cabell

Re: [GENERAL] Secret Santa List

2015-12-23 Thread Alberto Cabello Sánchez
n make a table with a field (1, 2, 3, 4) and take advantage of the integer arithmetic (one problem with your original question is I don't know how to ask for the next employee in plain SQL when the ID is a given name). -- Alberto Cabello Sánchez Universidad de Extremadura

Re: [GENERAL] Secret Santa List

2015-12-23 Thread Alberto Cabello Sánchez
giver,current_time))") then setting each employee as next's employee giver. -- Alberto Cabello Sánchez Universidad de Extremadura -- 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] unexpected (to me) sorting order

2015-04-08 Thread Alberto Cabello Sánchez
- 2 | Lalin 1 | La Palma 3 | Lasarte It is pretty obvious that ' ' is not between 'l' and 's', but this makes more sense than 1 | La Palma 2 | Lalin 3 | Lasarte -- Alberto Cabello Sánchez -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Application written in pure pgsql, good idea?

2015-03-01 Thread Alberto Cabello Sánchez
e http get/post values would be passed into > postgrel as an array). I did something this way with an obscure HTTP library for Oracle PL/SQL. I think "nightmare" is an appropriate word to describe the outcome. -- Alberto Cabello Sánchez -- Sent via pgsql-general mailing list (pgsq

Re: [GENERAL] postgresql for small business

2014-11-19 Thread Alberto Cabello Sánchez
an appliance which includes high-end (and high priced) hardware. For a more affordable solution, you should look for a virtualized iso image, too. -- Alberto Cabello Sánchez -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.post

Re: [GENERAL] Why can't I select un-grouped columns when grouping by a (non-primary) unique key?

2014-09-24 Thread Alberto Cabello Sánchez
? At first sight, primary key means no grouping at all, as there are no duplicated A.primary_key values: SELECT A.document FROM A GROUP BY A.primary_key is the same as SELECT A.document FROM A -- Alberto Cabello Sánchez -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [GENERAL] Why isn't Java support part of Postgresql core?

2014-09-15 Thread Alberto Cabello Sánchez
ql seems closer to the already-known SQL than PL/JAVA. Besides that, PL/JAVA -which I honestly think is a great concept in itself- doesn't free you from learning "yet another language" if you are working with PHP, Python, Node.js, etc... In these cases, PL/pgsql is a safer bet. -- Al

Re: [GENERAL] Trouble finding libpq on Centos 6.5

2014-05-08 Thread Alberto Cabello Sánchez
quot; searches in ld.so.conf.d paths, but "ld" doesn't... which doesn't make sense to me. -- Alberto Cabello Sánchez -- 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] Trouble finding libpq on Centos 6.5

2014-05-08 Thread Alberto Cabello Sánchez
Maybe you need to install postgresql93-devel package? -- Alberto Cabello Sánchez -- 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] importing a messy text file

2014-04-30 Thread Alberto Cabello Sánchez
stand (I think). What about using "cut" to strip the extra fields? -- Alberto Cabello Sánchez -- 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] importing a messy text file

2014-04-30 Thread Alberto Cabello Sánchez
$// , don't you? -- Alberto Cabello Sánchez -- 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] Trouble installing Slony 2.0

2014-04-15 Thread Alberto Cabello Sánchez
n-setup.html http://www.howtoforge.com/configuring-slony-i-cascading-replication-on-postgresql-8.3 But Slony-I documentation is still the best resource. -- Alberto Cabello Sánchez -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscr

Re: [GENERAL] Trouble installing Slony 2.0

2014-04-14 Thread Alberto Cabello Sánchez
-- Alberto Cabello Sánchez -- 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] Order By and Comparisson

2014-04-10 Thread Alberto Cabello Sánchez
sorting can get pretty complicated, as stated in this note from Oracle 10g Release 2 docs[1]: "In the ASCII standard, all uppercase letters appear before any lowercase letters. In the EBCDIC standard, the opposite is true: all lowercase letters appear before any uppercase letters". [1]

[GENERAL] Capture the SQL statement text with libpq [was: Re: Help]

2014-04-09 Thread Alberto Cabello Sánchez
1] http://sourceforge.net/projects/sqlrelay/ -- Alberto Cabello Sánchez -- 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 constraint question

2014-04-08 Thread Alberto Cabello Sánchez
lberto Cabello Sánchez -- 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] public schema owner for newly created database

2014-04-08 Thread Alberto Cabello Sánchez
esql Public Schema Is Not Owned By The DB Owner By Default? http://www.postgresql.org/message-id/4527.1225340...@sss.pgh.pa.us -- Alberto Cabello Sánchez -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general