> > Hi all,
> >
> > Im getting this error message when try to restore a database :
> >
> > ERROR: function f_validanumero_cnpj_cpf(character) does not exist
> >
> > LINE 1: SELECT (f_validanumero_cnpj_cpf(trim(cnpj_cpf)::char)=false)
> >
> > ^
> >
> > HINT: No function matches t
Hi
> > I’m getting this error message when try to restore a database :
> > ERROR: function f_validanumero_cnpj_cpf(character) does not exist
> > LINE 1: SELECT (f_validanumero_cnpj_cpf(trim(cnpj_cpf)::char)=false)
> > ^
> > HINT: No function matches the given name and argument t
Ops, Server version tested are:
PostgreSQL 11.5
and
PostgreSQL 13.1
In both cases, im making dump and restore to the same Server.
--
Att
Márcio A. Sepp
De: Márcio Antônio Sepp [mailto:mar...@zyontecnologia.com.br]
Enviada em: quinta-feira, 21 de janeiro de 2021 14:53
Para
Hi all,
Im getting this error message when try to restore a database :
ERROR: function f_validanumero_cnpj_cpf(character) does not exist
LINE 1: SELECT (f_validanumero_cnpj_cpf(trim(cnpj_cpf)::char)=false)
^
HINT: No function matches the given name and argument t
Hi all,
Update cascade apparently doesn't work as well on partiotioned tables (when
moving data between different partitions).
Please, look at example below:
-- Create master partitioned table;
CREATE TABLE users (
id serial NOT NULL,
username text NOT NULL,
pas
>
> On 1/25/19 10:21 AM, Márcio Antônio Sepp wrote:
> >
> > Hi all,
> >
> >
> > We are experiencing the follow error in last few weeks:
> >
> > Jan 25 16:03:51 FreeBSD11 kernel: pid 78639 (postgres), uid 770: exited
> on
> > signal 11 (
Hi all,
We are experiencing the follow error in last few weeks:
Jan 25 16:03:51 FreeBSD11 kernel: pid 78639 (postgres), uid 770: exited on
signal 11 (core dumped)
Jan 25 16:03:51 FreeBSD11 postgres[73403]: [7-1] 2019-01-25 16:03:51.135 -02
[73403] WARNING: terminating connection because of cr
Hi,
This query works fine:
create table t1
(d date)
PARTITION BY RANGE (d);
CREATE TABLE t1_p1 PARTITION OF t1 FOR VALUES FROM ('2000-01-01') TO
('2019-01-01');
Same query, but now (using domain):
CREATE DOMAIN ddate
AS date;
create table t1
(d ddate)
PARTI
root@pg11:/pg11/postgresql-11beta2/contrib/hstore # make
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 16: Need an
operator
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 19: Could not
find
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 20: Need an
ope
>
> If so I can tell you how I do it in Linux and you can make the
> appropriate translations to BSD.
>
> 1) cd to contrib/hstore/
>
> 2) make
>
> 3) sudo make install
>
> 4) In psql CREATE EXTENSION hstore;
Well, I allways install via pkg and I didn't find the contrib folder (:
Now, the f
Hi all,
How can i install contrib modules in pg11. Im using FreeBSD 11.2.
In specific i need to install hstore for test purpose.
Thanks in advance.
--
Att
Márcio A. Sepp
Now to the list...
> >> I'm trying to compile PostgreSQL 11beta2 but this errors occur:
> >> checking readline.h usability... no
>
> > Looks like you need whatever is the FreeBSD equivalent of readline-
> dev(el).
>
> AFAICT FreeBSD doesn't do things that way. On a nearby machine, I see
>
Hi,
Im trying to compile PostgreSQL 11beta2 but this errors occur:
root@srvbacula:/postgresql/postgresql-11beta2 # ./configure
checking build system type... x86_64-unknown-freebsd11.1
checking host system type... x86_64-unknown-freebsd11.1
checking which template to use... freebsd
13 matches
Mail list logo
