-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Fuhr wrote:
| On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote:
|
|>carlos=# insert into test (c1) values( 'test');
|>ERROR: NEW used in query that is not in a rule
|>CONTEXT: PL/pgSQL function "t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Fuhr wrote:
| On Fri, Apr 22, 2005 at 03:31:59AM +0100, Carlos Correia wrote:
|
|>Michael Fuhr wrote:
|>| On Fri, Apr 22, 2005 at 01:44:24AM +0100, Carlos Correia wrote:
|>|
|>|>carlos=# insert into test (c1) values( 'tes
Where can I find instructions to install these functions in
my 7.4 version? I am awaret hat they are in the contrib. folder but I have
never installed functions from the contrib folder. Thanks in advance.
Carlos
Thank you Phillip. I was able to install the functions with the command
that you posted. I will look for the documents on the usage of these
functions.
-Original Message-
From: Philip Hallstrom [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 2:48 PM
To: Carlos Oliva
Cc: pgsql
Thank you Philip. I found everything and installed the functions
successfully.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Philip Hallstrom
Sent: Friday, August 19, 2005 2:48 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL
.
Am I right?
Carlos
__Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/
Hi,
Does it make any sense to change the pg_xlog position if all my disks are configured in RAID level 0?
Thanks in advance!
Benkendorf
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!
Hello,
How can I know which rows are locked?
Thanks in advance!
Benkendorf
Promoção Yahoo! Acesso Grátis: a cada hora navegada você acumula cupons e concorre a mais de 500 prêmios! Participe!
approach, but I could not figure something better. Any suggestions?
Benkendorf
Michael Fuhr <[EMAIL PROTECTED]> escreveu:
On Wed, Oct 12, 2005 at 04:11:00AM +, Carlos Benkendorf wrote:> How can I know which rows are locked?There's no query that says "show me all rows that are lo
ave less impact if youonly need to work with certain rows, and 8.1 will have SELECT FOR{ UPDATE | SHARE } [ NOWAIT ].Carlos, you said the applications were doing only inserts. Is thatright? Have you investigated what's causing the blocking? Do therows you're inserting have foreign key refe
Could anyone suggest something that we can check to
ascertain why pg_dumps fail? The pg_dump for our database just started to fail
this week. Dumps of the same database succeeded just last week. Moreover, we
can create a new database using the database (that we are trying to dump) as a
t
Hello,
Currently our company has a lot of small stores distributed around the country and in the actual database configuration we have a central database and all the small stores accessing it remotely.
All primary key tables were designed with a column identifying the store that it belongs. In
Should I set the max_fsm_pages to the value reported (vacuum
verbose) as pages stored or the value reported as total pages needed? I
ran full + analyze vacuums in my database (vacuumdb –f –z –v ) a couple of times and I got the following reports:
INFO: free space map: 454 relations,
2227
b -f -z -v)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Saturday, November 05, 2005 10:23 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting max_fsm_pages
"Carlos Oliva" <[EMAIL PROTECTED]>
)?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
Sent: Monday, November 07, 2005 2:38 PM
To: Carlos Oliva
Cc: 'Tom Lane'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting max_fsm_pages
On Sun, Nov 06, 2005 at 08:05:29PM -0500, Ca
Hi Forum,
Should autovacuum reclaim most of the free space of a
database? We are trying to configure our database and running
pg_autovacuum to streamline our database. We have increased the
max_fsm_pages to a value larger than the total pages needed (see the output
from a full vacuum bel
uum -d2 -D -U postgres > /tmp/vacuum.log 2>&1"&
Thank you in advance for your response.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matthew T. O'Connor
Sent: Thursday, November 10, 2005 2:46 PM
To: Carlos Oliva
Cc: pgsql-general
table of the database?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matthew T. O'Connor
Sent: Thursday, November 10, 2005 3:44 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Performance of autovacuum and full vacu
Hi,
Does anybody know what's the meaning of the c (lowercase) privilege in
PostgreSQL 8.2 Beta?
bd_test=# SELECT datacl FROM pg_catalog.pg_database WHERE datname='bd_test';
datacl
--
{=CTc/user1,user1=CTc/user1}
or less "ok, I knew that"; that is, it states facts
for which I know (or at least I think I know) the "theory", but it did
not clarify how to use the given tools.
Thanks,
Carlos
--
---(end of broadcast)---
TIP 1: i
Thanks Tom, for your reply.
Tom Lane wrote:
Carlos Moreno <[EMAIL PROTECTED]> writes:
Why is it that the database
cluster is resrticted to a single locale (or single set of locales) instead
of being configurable on a per-database basis?
Because we depend on libc's loc
Hi Lloyd,
Please ignore searches on names that are in lower case. The PBSI-EMR will
search only on first and last names that are in upper case. In this way, we
are synchronized with PBSI-DOC which uses and sends only upper case names,
and we avoid searching problems. Teresa and I have discussed
Thank you Michael. This should work
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Glaesemann
Sent: Wednesday, October 27, 2004 9:27 AM
To: Carlos
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] Changing access permissions without re-st
Thank you Michael. I am using the BIT_LENGTH function which seems to return
the size in bits of the stored blob
"Michael Fuhr" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Tue, Jan 25, 2005 at 04:58:33PM -0500, Carlos wrote:
>
>> Is there a way
I wrote a very basic entry about this at improveyourweb some weeks ago
(http://www.improveyourweb.com/?q=node/2). Hope it helps.
In the source code, sequence.c, you can read something like:
/*
* Decide whether we should emit a WAL log record. If so, force up
* the fetc
your desire to
| choose an index scan if your joining column's datatypes do not
| match
|
Hi,
Perhaps, you'll like this one:
http://www.memoriapersistente.pt/en/opensource/gaudi/index.html
Regards,
Carlos
- --
MEMÓRIA PERSISTENTE, Lda.
Tel.: 219 291 591 - GSM: 967 511 762
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas Kellerer wrote:
| Carlos Correia wrote on 06.12.2005 21:13:
|
|> -BEGIN PGP SIGNED MESSAGE-
|> Hash: SHA1
|>
|> Thomas Hallgren wrote:
|> | Hi,
|> | I'm about to start a new project where the first task is to
Hi, I´m trying to discover some bad SQL statements in our environment but the logs are not helping too much... they say we´ve some very bad fetch statements but I don´t know how to discover the corresponding SELECT statement... How can I find them? Some example: <10.0.1.122(3821) 5072 200
is there another way? Thanks! Michael Fuhr <[EMAIL PROTECTED]> escreveu: On Fri, Dec 16, 2005 at 06:28:03PM +, Carlos Benkendorf wrote:> I´m trying to discover some bad SQL statements in our environment> but the logs are not helping too much... they say we´ve some very> bad fetch
Hi, Is there a way to send a "show all" to a specific backend? Thanks! Benkendorf!
Yahoo! doce lar. Faça do Yahoo! sua homepage.
t creating PG functions -- but please
be tough! Don't hold back valuable feedback just because you
don't want to hurt my baby feelings! :-))
Carlos
--
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an ap
Marko Kreen wrote:
On 12/22/05, Carlos Moreno <[EMAIL PROTECTED]> wrote:
The problem is, when I execute the SQL statement:
create or replace function sha1 ;
for the second time (i.e., after making modifications and
recompiling), the *backend* crashes -- it then restarts
automat
quot; -- I don't even
know where to begin; MySQL being such a crappy toy and enjoying
such a comfortable margin of popularity in the OS world, it makes me
so angry and frustrated...
My personal advice is: UPgrade and never look back; you'll never
regret it!
Carlos
--
--
crypted / anti-spam" form of e-mail addresses
(the way they're displayed on the mailing list web site)
Any comments? If it is the first option above, then it feels like
by definition there is absolutely nothing that can be done, now
or ever :-(
Carlos
--
---
ly-connected hard drives that hit a bottleneck when the
data reaches the motherboard.
And don't even bother to show up again if you were planning to
put less than 4GB of memory!! :-)
HTH,
Carlos
--
---(end of broadcast)---
TIP 6: explain analyze is your friend
Basing on the way you did the pg_dump (without the -C option), I think you
should have created the database before you performed the pg_restore,
You can see some examples of database backup/restore in this page:
http://nediam.com.mx/en/tips/backups_pgsql.php
Regards,
Javier
On Mon, 6
Would connections to a database require crating an extra
ExclusiveLock? We have some connections to the database that happen to be “idle
in transaction” and their pids have a granted “Exclusive Lock”
in pg_locks. I cannot discern the tables where the ExclusiveLock is being
held because the
CTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Thursday, February 23, 2006 10:05 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ExclusiveLock without a relation in pg_locks
On Thu, Feb 23, 2006 at 08:54:36AM -0500, Carlos Oliva wrote:
> Would connection
CTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Martijn van
Oosterhout
Sent: Thursday, February 23, 2006 10:04 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ExclusiveLock without a relation in pg_locks
On Thu, Feb 23, 2006 at 08:54:36AM -0500, Carlos Oliva wrote:
> Would co
statement; not functions.
I will look further into these queries in case that they are using
functions.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Thursday, February 23, 2006 1:09 PM
To: Carlos Oliva
Cc: pgsql-general
SYTmpDir, SYT | 2006-02-23 14:04:49.498836-05 | 00:00:00.558588
|
9667
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Thursday, February 23, 2006 1:36 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Exclu
Hi,
In some *nix distributions the username 'postgres' is already in
/etc/passwd. If so, you don't need to create it again. Just assure that the
directory where the database cluster will reside belongs to the user
'postgres', and also when you'll go to create the DB cluster (with the command
Necesito saber si alguien sabe si puedo utilizar la instruccion between
en un selet en postgress ya que lo he
probado y no me devuelve nada.
ejemplo:
SELECT * FROM NOMBRES WHERE APELLIDO BETWEEN 'R' AND 'RO';
Gracias.
---(end of broadcast)---
T
Necesito saber de favor, si existe alguna versionde PostgreSQL para Solaris 10.
I need to know if exists some PostgreSQL version for Solaris 10.
Gracias
Saludos
Hi,
Where can I find information about installing and
running contrib/reindexdb? I have searched the manuals and appendixes without
much luck. I just know that there is a contrib for reindexing an entire
database.
We run postgresql (v 7.4.x) in Linux RedHat.
trying to
eliminate index bloating.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Thursday, May 11, 2006 11:27 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Reindexdb
Carlos Oliva wrote:
> -->
&
12:01 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Reindexdb
Carlos Oliva wrote:
> Hi Joshua,
> I think that it was installed from a RedHat distribution and the
> installation left out reindexdb from the contrib folder. I will look into
> this.
>
>
on (in a couple of days) we'll publish a new release ;-)
Regards,
Carlos Correia
- --
MEMÓRIA PERSISTENTE, Lda.
Tel.: 219 291 591 - GSM: 967 511 762
e-mail: [EMAIL PROTECTED] - URL: http://www.m16e.com
Jabber: [EMAIL PROTECTED] - MSN: [EMAIL PROTECTED] - ICQ: 257488263
GnuPG: wwwkeys.eu.pg
Are there any configurations/flags that we should re-set for
the database (v 7.4.x) in order to enable a backwards scan on an index?
We are trying to query a table in descending order. We added an index
that we were hoping would be scanned backwards but EXPLAIN never indicates that
the op
in advance for your response.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan Hodgson
Sent: Tuesday, June 06, 2006 11:05 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Backwards index scan
On June 6, 2006 07:59 am, "Carlos Oliva&quo
check" would be executing the command
"ps -C postgres" and see if there's any output.
Or, simply use the PG client library -- you will
get an error message saying that postmaster is
not running on the specified port.
Carlos
--
---(end of broadcast)-
k is more restrictive than it needs to be.
I don't know about the internals of how transactions
and locks and FK constraints are handled, but I'm
analyzing it and describing what seems to be
happening internally, based on the behaviour I
observe.
Any comments?
Carlos
--
error message corresponding to the second statement
(the one that failed). Am I correct in thinking this?
Any reason why this should be avoided? (on the plus
side, I think this might increase efficiency for
transactions where one executes several insert or
update statements).
Thanks
one* command with *one* string that contains
all the SQL's separated by semicolons. This is what I
thought might be removed in future releases, if it is
considered that it's an unnecessary extension, etc.
Thanks,
Carlos
--
---(end of broadcast)---
? How can I get a consistant behaviour?
It was tested in a Debian/unstable box, running PostgreSQL 7.4.5-3 and
Sun's JVM 1.4.2
Thanks,
Carlos
psql session:
-
mpb2-m16e=# \l
List of databases
Name| Owner | Encoding
---+--+--
mpb2-test | carlos
] Allowing user to connect to a database?
On 19/06/2003 14:04 Carlos Oliva wrote:
> Hi Paul,
> This worked very well. Perhaps, you can help me with another
> question: If I write an aaa bbb ccc of 200.200.200.0, do all clientes
> with IP addresses between 0.0.0.0 and 200.200.200.0 can con
Of scott.marlowe
Sent: Monday, June 23, 2003 3:35 PM
To: Carlos
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] Eliminating start error message: "unary operator
On Mon, 23 Jun 2003, Carlos wrote:
> Hi Forum,
> What should I correct in order to eliminate the following error
-l postgres -s /bin/sh -c "/usr/bin/pg_ctl reload -D $PGDATA -s"
> /dev/null 2>&1
}
# This script is slightly unusual in that the name of the daemon
(postmaster)
# is not the same as the name of the subsystem (postgresql)
# See how we were called.
case "$1" in
st
re -f pidofproc
declare -f status
declare -f strstr
declare -f success
declare -f warning'
+ grep 'declare -f success'
+ success 'Starting postgresql service: '
+ '[' -z '' ']'
+ initlog -q -n /etc/rc.d/init.d/postgresql -s 'Starting post
nks in advance for your response.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Tuesday, June 24, 2003 10:32 AM
To: Carlos
Cc: [EMAIL PROTECTED]; Dain
Subject: Re: [GENERAL] Eliminating start error message: "unary operator
"Car
version is 7.2.3)
Thanks,
Carlos
--
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
it? Just some PgSQL Language API
hacking and glueing with Python's C API? If somebody's got more experience
with that internals of PostgreSQL or the Python C API, i'm very interested
in getting more information about how the thing would work.
Thanks in advance,
# Carlos Villela
# [EMAIL PROTECTED]
# ICQ UIN 6962556
Hello, I working on your DB and I need to get some advanced data from the
System Catalog.
Pleace can you send me the system catalog or information.
Carlos A. García
[EMAIL PROTECTED]
--
E-Mail Gratis La Brujula www.brujula.com.ar
Su punto de partida internet
ounting of a small company... :-(
Float is out of the question, of course (if it is really stored
as a float or double).
Any suggestions?
Thanks,
Carlos
--
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ally a what-you-get-is-not-
what-you-get-until-you-divide-it-by-100 ;-)
Thanks!
Carlos
--
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
tipo|designacao
+---
S |Seminário
TP |Teorico-prática
Tx |Teórica
Px |Prática
(4 rows)
=> select * from duracoes;
tipo|duracao
+
TP |@ 1 hour 30 mins
TP |@ 2 hours
TP |@ 3 hours
Tx |@ 1 hour
Tx
Hi,
I´ve a PostgreSQL 8.0.13 running in a Windows XP Pro 2002 SP2 box that is
terminating abnormally with signal code 5 every time I make a simple select
in one of our tables.
2007-06-04 21:24:12 LOG: database system was shut down at 2007-06-04
21:23:42 E. South America Standard Time
2007-06-04
Hi all,
We are facing some problems after the migration of our PostgreSQL 8.0 to the
8.2.4 version. The entire box runs under SUSE 10.3.
bd_sgp=# select version();
version
--
Thank you Tom,
> That sounds like your unspecified "remote client" has got some issues,
> but you've not provided any details that would let anyone else figure
> it out.
The referred client is a Windows psql 8.2.4 utility. This client is running
as part of a Windows PostgreSQL 8.2.4 server where w
Hi Erik,
> Are all of these remote connections from the same machine? Did you
> upgrade your client postgres libraries on your remote machine(s) as
> well?
No, the problem happens with many machines where our Visual Basic
applications is running. After debuging the application we discovered that
Some new data about this issue:
SELECT * or naming all the columns locks the client application. Yesterday
I´ve wrongly said that when naming all the columns instead of using the *
the applications did not lock.
I can not reproduce the problem in others 8.2.4 servers. I´ve others 8.2.4
servers a
> "Carlos H. Reimer" <[EMAIL PROTECTED]> writes:
> > SELECT * or naming all the columns locks the client
> application. Yesterday
> > I´ve wrongly said that when naming all the columns instead of
> using the *
> > the applications did not lock.
>
&
> On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote:
> > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes:
> > > > SELECT * or naming all the columns locks the client
> > > application. Yesterday
> > > > I´ve wrong
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
> > On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote:
> >> It=B4s "" but the "query_start" column is refreshed.
>
> > Then the query runs and finishes and the problem is so
Hi,
After starting the debugger in a PostgreSQL 8.3 running in Windows 2003 SP2
box I'm getting in the log a lot of the following message:
LOG: loaded library "$libdir/plugins/plugin_debugger.dll
Configuration option changed to start the debugger:
shared_preload_libraries = '$libdir/plugins/plug
Hi,
I currently have my PostgreSQL server running in a windows box and now we're
migrating it to a Linux operational system.
Current windows configuration:
pg_controldata shows the LC_COLLATE and LC_CTYPE are Portuguese_Brasil.1252
psql \l command shows we have databases with encoding WIN1252 and
quivalent in "UTF8"
pg_dump: The command was: COPY brasil.cidade (gid, "municpio", "municpi0",
uf, longitude, latitude, the_geom) TO stdout;
pg_dump: *** aborted because of error
How can I fix this error?
Thank you!
2010/11/1 Filip Rembiałkowski
> 2010/11/1 C
GCC gcc (GCC)
4.4.6 20120305 (Red Hat 4.4.6-4)
(1 row)
Thank you!
Carlos Reimer
(-x) unlimited
On Thu, Dec 11, 2014 at 1:30 PM, Tom Lane wrote:
> Carlos Henrique Reimer writes:
> > I've facing an out of memory condition after running SLONY several hours
> to
> > get a 1TB database with about 23,000 tables replicated. The error oc
Slony version is 2.2.3
On Thu, Dec 11, 2014 at 3:29 PM, Scott Marlowe
wrote:
> Just wondering what slony version you're using?
>
--
Reimer
47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br
That was exactly what the process was doing and the out of memory error
happened while one of the merges to set 1 was being executed.
On Thu, Dec 11, 2014 at 4:42 PM, Vick Khera wrote:
>
> On Thu, Dec 11, 2014 at 10:30 AM, Tom Lane wrote:
>
>> needed to hold relcache entries for all 23000 table
014 at 12:05 PM, Carlos Henrique Reimer
> wrote:
> > That was exactly what the process was doing and the out of memory error
> > happened while one of the merges to set 1 was being executed.
>
> You sure you don't have a ulimit getting in the way?
>
--
Reim
bytes
Max nice priority 00
Max realtime priority 00
Max realtime timeout unlimitedunlimited
us
[root@2-NfseNet-SGDB ~]#
On Thu, Dec 11, 2014 at 6:01 PM, Tom Lane wrote:
> Carlos Henrique Reimer writes:
> > Yes,
Hi,
We're facing a weird performance problem in one of our PostgreSQL servers
running 8.0.26.
What can explain the difference between calling same query inside and
outside a cursor? If we run the query outside a cursor we got a response
time of 755ms and 33454ms if we call the same query inside a
= 2::smallint) AND ((tipopgto)::text > '
'::text)) OR ((ano = 2013::smallint) AND (mes = 1::smallint) AND (codfunc =
29602::bigint) AND (seqfunc = 2::smallint) AND ((tipopgto)::text = '
'::text) AND (codpd > 0::smallint)))
(2 rows)
Should it not be the same inside o
Hi,
I`m trying to figure out why a query runs in 755ms in the morning and
20054ms (26x) in the evening.
_
Mornin
ample that could help is this seqscan:
explain analyze select sittrib8 from iparq.arript where sittrib8=33;
In the evening:
Fri Feb 8 14:00:01 BRST 2013
QUERY
PLAN
---
Sorry for the confusion, the plans from morning and evening are really
different for sure.
Let me ensure with my team that postgresql configuration is not changed
between morning and evening and will recollect the data tomorrow.
On Wed, Feb 13, 2013 at 8:34 PM, Kevin Grittner wrote:
> Car
Hi,
We are developing a solution which will run in thousands of small cash till
machines running Linux and we would like to use PostgreSQL but there is a
insecurity feeling regarding the solution basically because these boxes
would be exposed to an insecure environment and insecure procedures like
Hi,
Currently, our application is still using PG 8.2 and we are trying to use
9.2 but there are some problems related with the implicit casts removed on
8.3.
Example:
1) select 'teste'||1;
2) select trim(1);
Select 1 & 2 does run fine on 8.2 but in 9.2 select 1 is ok and select 2
got an error d
1-to.html
>
> It'll work.
>
>
> On Wed, May 15, 2013 at 3:17 PM, Carlos Henrique Reimer <
> carlos.rei...@opendb.com.br> wrote:
>
>> Hi,
>>
>> Currently, our application is still using PG 8.2 and we are trying to use
>> 9.2 but there are some
issed that.
> Which version of 9.2 you are working with? I am also at 9.2 and its
> working fine.
> Try out using
> select 'teste'||1::int;
>
> See if it works or not.
>
>
> On Wed, May 15, 2013 at 3:41 PM, Carlos Henrique Reimer <
> carlos.rei...@opendb.co
It works if I drop the functions but then the select trim(1) does not work;
On Wed, May 15, 2013 at 5:38 PM, AI Rumman wrote:
> Drop those functions and try again.
>
>
> On Wed, May 15, 2013 at 4:22 PM, Carlos Henrique Reimer <
> carlos.rei...@opendb.com.br> wrote:
&g
as source_t
> , pg_type as target_t
> ,pg_proc as proc
> WHERE
> ct.castsource = source_t.oid
> and ct.casttarget = target_t.oid
> and ct.castfunc = proc.oid
>
> I get 144 rows.
> http://www.rummandba.com/2013/02/postgresql-type-casting-information.html
>
>
&g
Hi,
I have a Windows box running Windows Server 2003 Enterprise Edition Service
Pack 2 with PostgreSQL 8.2.23 and getting a server crash while trying to
select a table:
select * from "TOTALL.tt_est" where assina=' kdkd' ;
Dumping the table with pg_dump or creating indexes in this table produce
t
, 2013 at 8:35 AM, Craig Ringer wrote:
> On 08/04/2013 02:41 AM, Carlos Henrique Reimer wrote:
> > Hi,
> >
> > I have a Windows box running Windows Server 2003 Enterprise Edition
> > Service Pack 2 with PostgreSQL 8.2.23 and getting a server crash while
> > trying
directory to the new box.
Hope the error will not be propagated to the new box.
Reimer
On Mon, Aug 5, 2013 at 10:42 AM, Adrian Klaver wrote:
> On 08/05/2013 06:24 AM, Carlos Henrique Reimer wrote:
>
>> Hi,
>>
>> Yes, I agree with you that it must be upgraded to a support
follow to identify the root cause
in order to prevent it to happen again?
Thank you!
On Tue, Aug 6, 2013 at 9:14 PM, Sergey Konoplev wrote:
> On Tue, Aug 6, 2013 at 4:17 PM, Carlos Henrique Reimer
> wrote:
> > I have tried to drop the index and the reindex procedure but both fail
&g
Hi,
I´ve noticed in my Fedora Core 6 box running PG 8.2.3 that column
current_query of pg_stat_activity view is not showing the complete query.
The complete query:
_
SELECT INT.DESMAT, INT.ESPMAT, INT.MON
Hi,
We are facing the following problem during the PostgreSQL 8.2.4 startup in a
Windows XP/SP2 box:
2008-03-31 13:35:12 1: LOG: database system was interrupted at 2008-03-31
09:45:44
2008-03-31 13:35:12 2: LOG: checkpoint record is at 0/7588FFD8
2008-03-31 13:35:12 3: LOG: redo record is
201 - 300 of 415 matches
Mail list logo
