)::int AS cod_mun FROM
geo_politico.g_br_municipios
WHERE substring(cd_geocmu,1,2)::int = num
by itself (with a suitable value of "num"), do you get more than one row?
Also, what is the definition of the function
parametros.calcula_parametros()?
Ray.
--
Raymond O'Donnell :: Galw
lon in named parameters, so maybe that's causing
problems. You could try casting like this:
select words_buy_vip(cast(? as text), cast(? as int), .);
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgres
s during read only transactions.
As far as I know (and I could be wrong), WAL segments reflect activity
in the entire cluster, not just one table - so perhaps there is write
activity happening in other tables, or in other databases.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol
h
parameter, but you're trying to pass a varchar or text value.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
this, but did you
run ANALYZE on the table after creating it? - Depending on how you
created the table, the statistics needed by the planner may or may not
have been up to date.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgs
DROP INDEX "Raum_RaumID_idx";
CREATE INDEX "Raum_RaumID_idx"
ON "Raum"
USING btree
("RaumID");
But psql tells me "Raum" is not existent:
egon@xfEinzel ~ $ psql Hausrat
psql (9.3.15)
Type "help" for help.
Hausrat=# SELECT * FROM Raum;
"select count(*)
from ...", or something else?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rray($ipsrc));
if(!$query) { print error...}
Are you sure it's failing? Try this:
if ($query === false) {
}
PHP has funny ideas about what's true and false.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@pos
On 09/12/16 15:30, Tom Lane wrote:
As of 9.6 you could use the shorthand
array_value = Eg[i][:]
regards, tom lane
I hadn't spotted that - very handy - will go and read up on it. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
-
On 09/12/16 10:42, Raymond O'Donnell wrote:
On 09/12/16 06:35, VENKTESH GUTTEDAR wrote:
Hello,
Please help me in accessing multi-dimentional array in postgresql
PL/PGSQL.
for i in array_lower(product_list, 1) .. array_upper(product_list, 1)
LOOP
product_list[i][0];
is there any other way to access, i am getting null for
product_list[i][0];
By default, PostgreSQL uses 1-based arrays (i.e. no [0] slot), so maybe
that's your problem.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgs
://wiki.postgresql.org/wiki/Apt
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I seem to remember that it was actually deprecated at some point - this
is going back quite a few years. This was later reversed, though I don't
know why.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On 10/11/16 10:34, Juliano wrote:
Hi,
I'm trying to import some data from a MS SQL Server 2014 sequential
database to Postgresql using dbi-link.
Have you tried the foreign data wrapper for MS SQL Server? It's here:
https://wiki.postgresql.org/wiki/Foreign_data_wrappers#Specific_SQL_Database
On 08/11/16 18:24, Joshua D. Drake wrote:
Hello,
Drupal + Ubercart should service your needs.
+1 to what the others said about Drupal + Ubercart: easy to set up, but
very customisable too if you need to. There are a number of
freely-available themes which are aimed at online shops and work v
On 17/10/16 16:40, said assemlal wrote:
Hello,
I am looking for a way to test generically input arguments to raise an
exception if one is either null or empty.
I was thinking to create a function who takes an array to check them but
not sure if it's really good.
It's not clear what you want t
On 03/10/16 14:39, dudedoe01 wrote:
What is the most feasible way to emulate the below MySQL function into
postgreSQL. Since the isnull() function is no longer supported in 9.6
version. I have tried every trick in the hat to get the desired results.
Still 'RPG INV' doesn't show only the other two
On 13/09/16 19:03, Steve Crawford wrote:
I'm trying to install 9.6 RC1 on Ubuntu 16.04 Xenial on my laptop and it
seems broken.
Installation of 9.6 RC1 on Centos was straightforward by comparison -
just add the 9.6 yum package and install. Unfortunately Ubuntu seems
second-class by comparison.
On 04/09/16 19:33, Lukas Lehner wrote:
Hi
when I use a search engine for the term "Postgres Certification"
this page shows up
https://www.postgresql.org/about/news/333/
please remove that, very much outdated. The referenced link doesn't
exist anymore (404 No such domain)
In all fairness, th
On 20/07/16 16:57, John DeSoi wrote:
On Jul 18, 2016, at 11:47 PM, John R Pierce
wrote:
Drupal even tried to offer a database API so plugin developers
wouldn't touch SQL directly, but too many ignored it.
I have been using Drupal with PostgreSQL for more than 10 years
without too many probl
On 25/05/16 20:57, Jeff Janes wrote:
On Wed, May 25, 2016 at 10:31 AM, Sameer Kumar wrote:
On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, wrote:
I've recently wanted to run a different archive_command during
database shutdown than during normal operations. In particular, if
the normal archive
o upstream bugs in
wxWidgets, over which the pgAdmin team has no control (hence pgAdmin 4).
Having said all that, I've rarely had any trouble with pgAdmin 3 on
Windows 7 and XP, Ubuntu and Debian; just a very occasional crash (maybe
one every six months).
Ray.
--
Raymond O'Donnell
postgresql.org/docs/9./static/release-9-6.html
^^^
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
readable when you use long table / fiel names.
I reckon this is just a matter of style... I use underscores to make
long names readable...
create table my_table_with_a_really_long_name;
and it works fine.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via p
s in the row_to_json function and
> include only the fields that are non-null?
You could use a CTE to filter out the nulls (not tested - I haven't used
JSON in PG (yet!)):
with no_nulls as (
select ... from my_table
where whatever is not null
)
select row_to_json() from no_nulls;
://www.postgresql.org/download/solaris/
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t null,
password text not null,
domain_name text not null,
created timestamp with time zone not null default now(),
constraint users_pk primary key (username, domain_name),
constraint users_domains_fk foreign key (domain_name)
references domains(domain_name)
);
And then your query would look somethi
On 03/02/2016 13:57, arnaud gaboury wrote:
> On Wed, Feb 3, 2016 at 2:19 PM, Raymond O'Donnell wrote:
>> On 03/02/2016 13:11, arnaud gaboury wrote:
>>
>>> Hum hum...
>>> --
>>> SELECT u.use
with "d.id" (partly my
mistake, I missed that the column is called "id" and not "domain_id" in
the domains table).
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ly unique in their respective tables,
having additional serial and domain_id columns seems like overkill. Why
not ditch them and use the domain name and username as the primary keys?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 25/01/2016 10:16, Brian Cardarella wrote:
> Is it possible, and if so how, to dump and then load a database to/from
> a file from within a psql connection?
You can use the COPY command to do a table at a time, but you'll get
just the data - you won't get permissions etc.
R
t; pde.deleted = ''''N'''' and
> p.deleted = ''''N'''' and
> pt.deleted = ''''N'''' and
> de.local_date between ''''$2'''' and ''''$3'''' and
I missed whatever passed upthread, but at a guess I'd say all the
quoting is causing problems here. Why not use the quote_ident() and
quote_literal() functions? By the same token, I don't think you need to
put quotation marks around the parameters.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ro_lookup_id) MATCH SIMPLE
> ON UPDATE CASCADE ON DELETE RESTRICT.
>
> In 9.3 is there an alter constraint option or do I have to drop the
> constraint and add the new one?
I just had a quick look at the docs for 9.3:
http://www.postgresql.org/docs/9.3/static/sql-altertable
ist - thanks!]
You'd better show us your table structures - we're only guessing
otherwise. However, I think typing efficiency isn't important, but
rather what your application needs to do with the data - you only type
the query once. :-)
--
Raymond O'Donnell :: Galway :: Ireland
type out your column
names - I'm only guessing without seeing the DDL, but it sounds as if a
column called macro_lookup_id exists in more than one table.
You'll need to do something like this:
select
sample.macro_lookup_id as col_name_1,
macroscopic.macro_lookup_id as col_name_2
1]
http://www.postgresql.org/docs/9.4/static/datatype-numeric.html#DATATYPE-SERIAL
[2] http://www.pgadmin.org/support/list.php
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
#x27;t visible, you can make it visible under
the "View" menu.
As a bonus, you can select a block of SQL and only the selected code
will get executed.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
mals (
id serial,
taxonid integer, -- use the lookup table
parentid integer, -- use the lookup table
constraint mammals_taxon_fk foreign key (taxonid) references
taxon(taxonid)
);
If parentid also references taxon.taxonid, add a similar constraint for
it too,
Ray.
--
Raymond O
On 05/10/2015 20:08, Adrian Klaver wrote:
> On 10/05/2015 12:00 PM, Raymond O'Donnell wrote:
>> On 05/10/2015 19:53, Adrian Klaver wrote:
>>> On 10/05/2015 11:39 AM, Raymond O'Donnell wrote:
>>>> Hello all,
>>>>
>>>> I have
ften a geometrical solution to an algebraic problem.
Thanks!
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/10/2015 19:53, Adrian Klaver wrote:
> On 10/05/2015 11:39 AM, Raymond O'Donnell wrote:
>> Hello all,
>>
>> I have an SQL problem which ought to be simple, but I can't get my head
>> around it.
>>
>> I have pairs of integers - let's call
ection. There's
probably something simple that I'm just not seeing
If anyone's interested, these numbers represent channels and pistons on
the combination system of a largish pipe organ... it's for a hobby project.
Many thanks in advance!
Ray.
--
Raymond O'
On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:
> No worries.
>
> I found a way.
>
Would you share it, for the archives?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
ember having them!!!)
>> Oh, so you name your tables 'fish' and 'crow' instead of 'school' and
>> 'murder' ? Such wasted opportunities :p
>>
> ???
A school of fish and a murder of crows... wonderfully evocative
collective nouns.
Ray
coming from
192.168.02.64, whereas you specified 127.0.0.1 in pg_hba.conf.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e are tons of documentation and examples
out there - Google is your friend. Qt's own documentation is very good.
For plain C, read PostgreSQL's own docs:
http://www.postgresql.org/docs/9.4/static/libpq.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via
"postgres" (or whatever
user you used to connect):
alter role postgres with password 'whatever';
Don't forget to edit pg_hba.conf once again and set "trust" back to
"md5' (and re-start the service).
Finally, note that the "postgres" user is the
>
> it's not displaying timezone..any help..?
Hi there,
This question was answered a few days ago, but perhaps you didn't see
it. The reason you don't get timezone information is that subtracting
two timestamps results in an interval value. See table 9-27 on this page:
h
g? And if not in the official documentation is it in the wiki?
session_user, current_timestamp and current_user are all functions, not
magic constants:
http://www.postgresql.org/docs/9.4/static/functions-datetime.html
http://www.postgresql.org/docs/9.4/static/functions-info.html
I hop
name='US/Eastern'),'-MM-DD
> HH24'||':'||'MI'||':'||'SS')::timestamptz;
>
> it's not displaying timezone..any help..?
>
Because TIMESTAMPTZ - TIMESTAMPTZ = INTERVAL, not TIMESTAMPTZ.
Also, why on earth are you do
> RETURN;
> END;
> $$ language 'plpgsql';
>
> mydb=> select myfunc('foo','bar');
You need to do:
select * from myfunc('foo','bar');
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 18/06/2015 13:13, Maila Fatticcioni wrote:
> On 06/18/2015 11:48 AM, Raymond O'Donnell wrote:
>> On 18/06/2015 10:34, Maila Fatticcioni wrote:
>>> Hello. I have a postgres cluster made by two nodes with OS Ubuntu
>>> 14.04. About two weeks ago I did a minor updat
ion_size = 10MB
The comments in postgresql.conf indicate that log_destintion and
logging_collector, at least, need to be set as above to generate log files.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
able where number * 3 between start_value3 and end_value3;
If they're all the same table, just use OR:
... where (number * 3 between start_value1 and end_value1) or (number *
3 between) etc.
Or am I missing something?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.
lays with Windows, I've no idea I'd guess that changing
the drive letter might well cause Bad Things to happen.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
matically if they are not in use by other
> services or programs”
Hi there,
Sounds like you're on Windows - you can get more information from
PostgreSQL's own logs, which by default on Windows are in a directory
called pg_log under the data directory.
Ray.
--
Raymond O'Donn
On 23/04/2015 19:08, Raymond O'Donnell wrote:
> On 23/04/2015 18:09, Cory Tucker wrote:
>> I have the need to move a specific set of data from one schema to
>> another. These schemas are on the same database instance and have all
>> of the same relations defined. The
integrity?
I'd create the tables in the new schema without the FK constraints, copy
the data, then add the constraints afterwards.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
fline all the time.
> Is there another possibility to migrate a database with 200 GB ?
Those version numbers aren't correct... current PG major versions run
from 9.0 to 9.4. I don't think there was ever any version less than 6
(though I could be wrong).
Ray.
--
Raymond O'Donn
m where ~
http://www.postgresql.org/docs/9.4/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
onsistency if I forget update/export/import on 1 or more
> table. It is terrible.
You could create a view specifically for export, which would gather
together data from all the tables.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing
SV file? - if so, delete it and try again.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;>
>> I feel neither the installation or the small postgres databases I would have
>> created use 121GB.
>>
>> Any reason why it shows 121GB
>
> Could you share with us \l+ command in psql session ?
Also, see what Windows reports as the space taken up by the install
c_num, record_id)
> TO stdout;
> 2015-02-09 15:22:04 PST [8636]: [3-1] user=pdroot,db=iii,appname=pg_dump
> FATAL: connection to client lost
There's your problem - something went wrong with the network.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent v
t group by a;
a | array_agg
---+---
1 | {abc}
2 | {def,ghi}
(2 rows)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ou
could just stop the server, delete the data directory, restore it from
the copy made above, then restart the server. You'd need to make sure
that permissions were correct.
Mind you, I've never found initdb particularly slow...
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@io
Options -> Browser ->
Binary paths, in the "PG bin path" field (this is on PgAdmin III 1.20).
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
thing like this? -
insert into
select from
cross join generate_series(1, 3)
order by
This assumes that you want each item duplicated the same number of times.
Hope this helps,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-
On 21/01/2015 18:02, Pierre Hsieh wrote:
> Hi Raymond,
>
> Thanks for your reply. Please see detail as following. Thanks again.
Can you describe *in words* what sort of calculation you want to do?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-g
ead them. Thanks
Sorry, either I'm being stupid or your description isn't clear. Can you
show your table structure, ideally with some sample data, and what you
hope to get from the query?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing l
On 21/01/2015 16:06, Brian Dunavant wrote:
> This is not quite true. I don't believe there are any flight
> simulator easter-eggs hidden inside the Postgres code. :)
No? Awww. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-gene
ind the standard
deviation of a sample then that's no problem:
http://www.postgresql.org/docs/9.4/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE
Hope this helps,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list
sier to follow.
Depending on your needs, you could use to_char() to format the value of
clock_timestamp() as you wish. This outputs a string rather than a time
value, but would be fine for logging, say.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-g
On 06/11/2014 15:24, Ramesh T wrote:
> hello,
> any guidelines is their how to use these tool..?
> not home site..
> http://phppgadmin.kattare.com/phppgadmin/...:)
Here's the home site:
http://phppgadmin.sourceforge.net
Lots of documentation available there.
On 09/10/2014 21:44, John R Pierce wrote:
> On 10/9/2014 1:41 PM, Raymond O'Donnell wrote:
>>> >The messages in the log file are: 2014-10-09 12:59:40 PDT LOG:
>>> >invalid connection type "" 2014-10-09 12:59:40 PDT CONTEXT: line 1
>>> >of c
load pg_hba.conf
Well, the error messages seem to indicate that there's a problem with
pg_hba.conf, so I'd start by reversing whatever you did there and seeing
if that fixes it.
I'd also use something other than Notepad it has a hard time with
non-Windows line endings. Not
nd approaches to fixing it:
http://blog.endpoint.com/2014/09/pgxlog-disk-space-problem-on-postgres.html
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nd approaches to fixing it:
http://blog.endpoint.com/2014/09/pgxlog-disk-space-problem-on-postgres.html
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
uilder to pgadmin3 for additional addons..
There already was a reply from someone else, yesterday I think - his
advice was to run the installer again and select StackBuilder this time.
I don't think you have to re-install Postgres, but the installer ought
to give you the option to install S
I add new records in the table or will it
> generate locks ?
>
> I am using postgresql *8.4*
Not that this helps your issue, but you may not be aware that 8.4 is now
end-of-life and so is no longer supported:
http://www.postgresql.org/support/versioning
Ray.
--
Raymond O'Donnell ::
: SELECT * FROM pg_stat_statements;
>
>
> i need to install POWA..i got powa.zip
> please let me know how to install POWA.ZIP for my postgres using putty
> tool ..
What is POWA?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing
o I have all the bells and whistles
available for development.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ASE
> WHEN NEW.period = 201001
> THEN INSERT INTO sn_dm_b.pm201001 VALUES (NEW.*);
The problem is the semi-colon after (NEW.*). There isn't one inside a
CASE construct.
Ray.
> END;
> RETURN NULL;
> END;
> $$ LANGUAGE plpgsql;
>
>
> ERROR: syntax er
On 26/06/2014 17:26, Raymond O'Donnell wrote:
> On 25/06/2014 23:19, Dennis Ryan wrote:
>> I having trouble with correct syntax to get this trigger function to
>> compile. I have tried every combination of removing the ‘;’ characters
>> but the function will not compile.
aforementioned installer) -
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
- and the log files are being created in data/pg_log as expected.
HTH,
Ray.
--
Raymond O'Donnell :: Galway
stuff to its own log.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
anana] ? how should I write the
> query using such a set ?
You can use the array "overlap" operator, something like this:
SELECT WHERE tags && ARRAY['apple', 'banana'];
See here:
http://www.postgresql.org/docs/9.3/static/functions-array.html
Ra
t how I can give
You need to specify where c_cde is coming from - so OLD.c_cde or
NEW.c_cde (or else SELECT FROM... if it's coming from somewhere else).
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgres
nd people might have some chance
of being able to help.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ervice again.
You haven't made it clear that you are actually replicating to a
different PostgreSQL server (whether on the same machine or on another
one) - is that the case?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 30/04/2014 17:32, David G Johnston wrote:
> Raymond O'Donnell wrote
>> On 29/04/2014 22:54, David G Johnston wrote:
>>> Raymond O'Donnell wrote
>>>> Hi all,
>>>>
>>>> Probably a silly question, but I'm having trouble figurin
On 29/04/2014 22:54, David G Johnston wrote:
> Raymond O'Donnell wrote
>> Hi all,
>>
>> Probably a silly question, but I'm having trouble figuring out the
>> answer... if I'm constructing an string representation of a value to go
>> into a text
On 29/04/2014 22:10, Raymond O'Donnell wrote:
> Hi all,
>
> Probably a silly question, but I'm having trouble figuring out the
> answer... if I'm constructing an string representation of a value to go
> into a text[] column, and one of the text literals includes
thing like this into a text[] column
directly? -
'{"abc", "de"f"}'
Or would I need to do this? -
E'{"abc", "de"f"}'
or something different again? I'm doing this from PHP via the Zend
framework (v.1) if it makes an
On 22/04/2014 21:26, Craig Libscomb wrote:
> On Tue, Apr 22, 2014 at 3:06 PM, Raymond O'Donnell <mailto:r...@iol.ie>> wrote:
>
> On 22/04/2014 20:47, Craig Libscomb wrote:
> > The following command:
> > DROP USER IF EXISTS jpate;
> &g
this
one connect to the database using psql, and then \du will give you a
list of all roles - in the output from \du, look at the column "Member of".
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-gen
to re-create function B - it should keep working fine.
As far as I know, functions aren't "compiled", at least at the point
when you execute CREATE FUNCTION anyway - the text representation of the
code is stored, and then loaded when the function is invoked. I could be
wrong about thi
On 15/04/2014 17:34, David G Johnston wrote:
> Raymond O'Donnell wrote
>> On 15/04/2014 17:20, David G Johnston wrote:
>>> Willy-Bas Loos-3 wrote
>>>> Hi, I ran into some strange behavior. Seems like a bug to me?
>>>>
>>>> wbloo
.5::numeric), round(0.5::double precision);
round | round
---+---
1 | 1
(1 row)
postgres=# select version();
version
-
PostgreSQL 9.1.4, compiled by Visual C++ build 1500, 64-bit
(1 row)
messages from Postgres are
usual more specific, for example, "Permission denied for relation".
It looks as if you haven't the OS permissions to read the SQL file.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-gen
1 - 100 of 1053 matches
Mail list logo