Re: [GENERAL] which odbc version (32 or 64 bit) should be installed in Client ?

El 03/07/14 21:06, sunpeng escribió: > my server is pg 9.1.13 in win8 64, my client is win xp 32 bit, which > odbc version (32 or 64 bit) should be installed in Client ? is > psqlodbc_09_01_0200.zip or psqlodbc_09_01_0200-x64.zip?or others? > thks! > peng > > Same as your client, in this case, 3

Re: [GENERAL] 9.3 debian install setup failure

On 03/21/2014 09:29 PM, john.tiger wrote: > EDIT from @rodrigo > > hmm, user postgres vs os postgres - okay understand what you mean but > how is this fixed ? or what is proper procedure ? > It depends on what you want to fix... if you want to be able to do su - postgre

Re: [GENERAL] 9.3 debian install setup failure

t up server to be booted on start up ? Is it running? I dont use debian, but something like service postgresql status can give you an idea... or, more general ps aux | grep postgres Best regards Rodrigo Gonzalez -- 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] puzzling perl DBI vs psql problem

On Thu, 13 Mar 2014 13:44:48 -0700 Susan Cassidy wrote: > No, I don't have 2 instances running. I default the port on the psql > command line, and the perl program is using 5432, as normal. > > Now, I'm discovering that syslog is no longer logging anything. I > bounced it, but to no avail. Th

Re: [GENERAL] puzzling perl DBI vs psql problem

On Thu, 13 Mar 2014 13:28:38 -0700 Susan Cassidy wrote: > No, it is connecting to localhost, which is the same system I am > running psql on. > > Susan > Well, if one query is logged and the other one is not it means that it is running against different servers (as far as I understand logging).

Re: [GENERAL] puzzling perl DBI vs psql problem

; installations. > I can bet that it is connecting to another database or server, check your perl script configuration. Best regards Rodrigo Gonzalez -- 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] Query plan for currently executing query?

On Wed, 18 Sep 2013 16:24:16 +0100 Tim Kane wrote: > > > On 18/09/2013 14:44, "Rowan Collins" wrote: > > > > >Running an EXPLAIN on the exact query should give you the plan. An > >EXPLAIN ANALYZE would have to wait for the query to complete either > >way, so you wouldn't be able to get it mid

Re: [GENERAL] problem with query

On Thu, 12 Sep 2013 19:07:04 -0300 Roberto Scattini wrote: > On Thu, Sep 12, 2013 at 7:02 PM, Bosco Rama > wrote: > > > On 09/12/13 14:49, Chris Curvey wrote: > > > Is this just a case-sentitvity issue? if personas.apellido is a > > > varchar field, then I think that's your trouble. (it would

Re: [GENERAL] foreign key to multiple tables depending on another column's value

Em 29-05-2013 12:51, Vick Khera escreveu: On Wed, May 29, 2013 at 9:58 AM, Rodrigo Rosenfeld Rosas mailto:rr.ro...@gmail.com>> wrote: I know I could use a trigger, or some check constraint maybe, to ensure the field exists upon insert (or update), but I can't ensure t

[GENERAL] foreign key to multiple tables depending on another column's value

check constraint maybe, to ensure the field exists upon insert (or update), but I can't ensure the database will become inconsistent in case I remove a mapped field from the other schema. Now I can finally explain my question: is it possible that I set some sort of foreign key whose refe

Re: [GENERAL] Throttling Streamming Replication

nder.net>> wrote: On Fri, Jan 25, 2013 at 1:59 PM, Rodrigo Pereira da Silva mailto:rodr...@paripassu.com.br>> wrote: > Hi Guys, > > We are having a problem with our infrastructure provider because the network > traffic between master and s

[GENERAL] Throttling Streamming Replication

o, it wouldn't work. Thanks in advance, -- Rodrigo Pereira da Silva rodr...@paripassu.com.br http://www.paripassu.com.br Rua Coronel Luis Caldeira, nº 67, Bloco 1, Sala 3A 88034-110 • Florianópolis • SC Tel. (48) 3207-5755 -- Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] distinct values and count over window function

Em 27-11-2012 19:50, David Johnston escreveu: From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rodrigo Rosenfeld Rosas Sent: Tuesday, November 27, 2012 4:23 PM To: pgsql-general@postgresql.org Subject: [GENERAL] distinct values and count over

[GENERAL] distinct values and count over window function

his is what I'd like to avoid. This application is a clustered web application, so I'd rather avoid any client library support for paginating results using cursors or something like that and stick with OFFSET and LIMIT. Any help is appreciated! Thanks, Rodrigo.

[GENERAL] Message: incomplete startup packet

:12.604 CST 08P01 509b7424.45dcLOG: incomplete startup packet 2012-11-08 02:59:12.612 CST 08P01 509b7460.45eaLOG: incomplete startup packet 2012-11-08 03:00:12.617 CST 08P01 509b749c.45f2LOG: incomplete startup packet Thank you, Rodrigo Pereira da Silva. -- Sent via pgsql-general mailing list

Re: [GENERAL] Too much clients connected to the PostgreSQL Database

lot, Rodrigo Em 10/30/2012 2:10 AM, Kevin Grittner escreveu: rodr...@paripassu.com.br wrote: 150 maxActive setting, but we have some low usage application getting direct db connection(out of the pool). You will probably be better

Re: [GENERAL] Too much clients connected to the PostgreSQL Database

O and apache ones, maybe that's a problem. Thank you, Well, > Rodrigo Pereira da Silva wrote: > >> We have about 10 web applications deployed in a Tomcat 7.0 >> accessing a Postgresql 9.1 database. We do use connection pooling. >> We have the max_connection

[GENERAL] Too much clients connected to the PostgreSQL Database

r decrease performance. Thanks in advance, Rodrigo Pereira da Silva rodr...@paripassu.com.br http://www.paripassu.com.br

Re: [GENERAL] Where is diskchecker.pl ?

On 06/08/12 13:31, Bruce Momjian wrote: >> For longer terms, perhaps we should set up an URL forwarder or >> something that the docs can link through in the cases where we really >> need this, so we can more easily update the URLs? > Well, the problem there is that they don't get the real URL unles

Re: [GENERAL] How to drop a temporary view?

g the session? > TIA. DROP VIEW It will destroy the view, temporary or not... Regards Rodrigo > > -- > Vincenzo Romano - NotOrAnd.IT > Information Technologies > NON QVIETIS MARIBVS NAVTA PERITVS > -- 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] Don't Thread On Me (PostgreSQL related)

On Jan 26, 4:52 pm, Rodrigo E. De León Plicet wrote: > Quote: > > == > > This thread > > http://postgresql.1045698.n5.nabble.com/Multithread-Query-Planner-td5... > > was mentioned in a performance s

Re: [GENERAL] 9.0 EXPLAIN Buffers: written=nnnn

"actual time" is so > different from one run to the next. > I can be completely wrong, but maybe it is about hint bits. Read http://wiki.postgresql.org/wiki/Hint_Bits Thanks Rodrigo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Don't Thread On Me (PostgreSQL related)

Quote: == This thread http://postgresql.1045698.n5.nabble.com/Multithread-Query-Planner-td5143643.html was mentioned in a performance sub-group posting. Give it a read. Back? It means, so far as I can see, that PG is toast. It

[GENERAL] Hope for a new PostgreSQL era?

http://www.dbms2.com/2011/11/23/hope-for-a-new-postgresql-era/ Some of the points mentioned: - MySQL is narrowing the gap, but PostgreSQL is still ahead of MySQL in some ways. (Database extensibility if nothing else.) - Neither EnterpriseDB (which now calls itself “The enterprise PostgreSQL c

Re: [GENERAL] Strange problem with turning WAL archiving on

On 11/30/2011 01:43 PM, Tomas Vondra wrote: On 30 Listopad 2011, 17:23, BK wrote: Hi Albe, On Nov 30, 2011, at 2:31 PM, Albe Laurenz wrote: Verify the current setting with SELECT setting, source, boot_val, reset_val, sourcefile, sourceline FROM pg_settings WHERE name = 'wal_level'; If

Re: [GENERAL] What is *wrong* with this query???

El 05/11/11 01:51, Steve Murphy escribió: I give! I'm flummoxed! Here is what I have, 3 tables: schedule companybuilding status0 3 x active 4 x active 5 x active 3

Re: [GENERAL] 9.1 replication on different arch

El 02/11/11 22:40, Martín Marqués escribió: 2011/11/2 John R Pierce: On 11/02/11 11:21 AM, Martín Marqués wrote: Don't worry, they are both x86 arch, so I'll just install 32bit postgresql on the 64 bit server. That should make it work, right? yes, that should work fine. Sad thing is that it's

Re: [GENERAL] inserting bytea using PHPs pg_escape_bytea()

El 20/10/11 14:13, Martín Marqués escribió: El día 19 de octubre de 2011 23:20, Jeff Davis escribió: On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote: The only concern I have is that on insertion, I get this WARNING: WARNING: nonstandard use of \\ in a string literal at character 41 H

Re: [GENERAL] script not working in php

have single quotes inside the query and the complete string is defined with single quotes too.use double quotes to define the string Rodrigo

Re: [GENERAL] stored function (possible to access file system or call java program)?

ibjvm.so lrwxrwxrwx 1 root root 57 2011-08-12 17:13 /usr/lib/libjvm.so -> /usr/lib/jvm/java-6-openjdk/jre/lib/i386/server/libjvm.so So, it is a symlink to openjdk Rodrigo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.pos

Re: [GENERAL] IDLE queries taking up space

On 08/30/2011 02:13 PM, Scott Ribe wrote: On Aug 30, 2011, at 10:03 AM, JD Wong wrote: How can I set postgres to qutomatically close connections that have finished their queries and now sit idle? AFAIK you can't, you should check |pg_terminate_backend function and see if it is useful for you

Re: [GENERAL] call initdb as regular user

On 08/18/2011 03:20 PM, alexondi wrote: Hi! Can I call initdb with some params as regular user (not root or postgres)? postgres is a normal userso no problem at all. initdb cannot be run as root May I have some problem with replication, backup or with some other subsystem? Thank you! -- Vi

Re: [GENERAL] why cannot UNION both SELECT and SHOW?

select current_setting('search_path') union select version(); Regards Rodrigo On 08/01/2011 06:07 PM, Konstantin Izmailov wrote: Is it possible instead of executing following two statements: SHOW search_path; SELECT version(); to execute just one statement returning both searc

Re: [GENERAL] using xmin in a query?

hile this query fails: select count(*) from tablename where xmin != 2 You probably want <>. That doesn't work either. What about select count(*) from tablename where xmin::text::integer != 2; Regards Rodrigo

Re: [GENERAL] No suitable driver found for jdbc:postgresql [error]

On 07/09/2011 12:56 PM, Jonathan Camilleri wrote: /Notes for Windows users/ http://www.postgresql.org/docs/9.0/static/app-psql.html

[GENERAL] Oracle / PostgreSQL comparison...

Here: http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html Any comments? -- 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] replication problems 9.0

e you don't grant the user access to all database objects I hope I am clear in my poor English Regards Rodrigo Gonzalez On 06/07/2011 08:38 PM, owen marinas wrote: Thx, Merci, Gracias Rodrigo it worked indeed, Im wondering why replication is not included in "All" regards Owen On T

Re: [GENERAL] replication problems 9.0

must be replication for the replication user Regards Rodrigo Gonzalez -- 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] Using regexp_replace to remove small words

Hi Peter, your REGEX is exactly what we were trying to find. Thank you very much! Rodrigo. -- <http://www.vivver.com.br/> *Rodrigo Mendonça** Diretor de Tecnologia Tel: 31 3025 3550 / Cel: 31 8489 3119 rodr...@vivver.com.br / direto...@vivver.com.br*

Re: [GENERAL] postgres videos - copyright issues or something else?

Maybe this link can help you http://vimeo.com/channels/postgres On Tue, 2 Nov 2010 22:11:34 +0100 Aljoša Mohorović wrote: > it's very hard to find postgres related videos although i regularly > read various blog posts mentioning some talk/conference. > is this because some copyright issues or

Re: [GENERAL] NoSQL -vs- SQL

On Mon, Oct 11, 2010 at 6:57 PM, David Boreham wrote: > http://www.xtranormal.com/watch/6995033/ > (warning: may not be sfw). ROFLMAO!!! -- 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] "private" installation of postgres

It is defined in postgresql.conf unix_socket_directory = '/var/run/postgresql' On Tue, 07 Sep 2010 17:20:24 -0700 John R Pierce wrote: > On 09/07/10 5:15 PM, Scott Ribe wrote: > > Assume I want to install an instance of postgres such that it > > cannot interfere with another install, or even

Re: [GENERAL] Is there a way to bypass sql?

On Mon, Aug 9, 2010 at 1:39 PM, samantha wrote: > I have been digging into NoSQL of late (...) Be wary of DBAs Running with Scissors... http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] Can not connect remotely

On Fri, 9 Apr 2010 10:08:38 -0700 (PDT) arya6000 wrote: > > > Connection refused. Check that the hostname and port are correct and > that the postmaster is accepting TCP/IP connections. > Are you sure that your firewall is allowing connections to port 5432/tcp? Best r

Re: [GENERAL] Connect to Postgres problems

Did you reload postgres configuration after changing pg_hba.conf? On Mon, 2010-02-01 at 08:36 -0800, Christine Penner wrote: > Hi, > > I'm having trouble getting a connection to Postgres to work from > outside of my local network. It was working fine at one point. Then I > had to change IP add

[GENERAL] PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error

on "buscardocs" line 26 at for over execute statement" Can you help me about this error?, i will apreciate so much any suggestion about it. Thank's in advance, Rodrigo

Re: [GENERAL] identify Tables without primary keys - postgres

Check http://petereisentraut.blogspot.com/2009/07/how-to-find-all-tables-without-primary.html On Fri, 2010-01-15 at 11:39 -0500, akp geek wrote: > Dear all - > > I have the following query to find the tables with > primary keys. can you please help me finding the tables without > pr

[GENERAL] PostreSQL PostgreSQL 8.1.18 and Tsearch2 context error

Hi guys, I'm working with full-text search on my project, however i'm receiving an "Config file error: 7 ERROR: no tsearch config CONTEXT" message but i don't know what it means. Can you help me about this error?, i will apreciate so much any suggestion about it. Thank's in advance, Rodrigo

Re: [GENERAL] nooby q: how get a row just inserted?

On 05/30/2009 07:02 PM, Kenneth Tilton wrote: I am probably breaking the rules here which is why I have a problem, but here goes: I am trying to build an audit trail skeleton of all my table inserts. Everything table has a column for the serial ID of an audit trail table row I will create for eac

Re: [GENERAL] Code tables, conditional foreign keys?

On Fri, May 22, 2009 at 10:38 PM, Scott Marlowe wrote: > On Fri, May 22, 2009 at 4:10 PM, Benjamin Smith > wrote: >> >> Is there a better way? > > Yeah, natural keys. +1. Also, what Ben described reeks of EAV. Ben, please read: http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-ta

Re: [GENERAL] After each row trigger NOT seeing data changes?

you have to change RETURN NULL; with RETURN NEW; On 05/21/2009 04:57 PM, Karl Nack wrote: I'm attempting to create an inventory of trees. Here's a simplified, sample table: CREATE TABLE tree ( tree_id SERIAL PRIMARY KEY, tree_species_id INT NOT NULL REFERENCES tree_species, tree_location POIN

Re: [GENERAL] Compatibilidad RH enterprise 5.3 !!!

2009/2/20 Angelo Astorga : > Tenia RH enterprise 3.0 con postgresql 7.4.3 y PHP 4.3.2, migre todo a RH > enterprise 5.3 con postgresql 8.1.11 y PHP 5.1.6, migre la BD y pude > montarla, pero, no tengo acceso a la BD desde apache... algun ayudita al > respecto !!! Demasiado impreciso; adicionalment

Re: [GENERAL] pg_hba reload

Use quotes, there is a space between program and files pg_ctl reload -D "c:\program files\postgresql\8.3\data" On Sat, 2009-02-14 at 15:31 -0800, Bob Pawley wrote: > I'm running 8.3 on Windows XP. > > I input > pg_ctl reload -D c:\program files\postgresql\8.3\data- or any > combination ther

Re: [GENERAL] Check if column is substring of another column

On Wed, Jan 21, 2009 at 5:44 PM, Keaton Adams wrote: > Is there a way to do this in a single SQL statement in PostgreSQL 8.1? SELECT d.policyNumber , d.CompanyName , d.Address , p.AllPolicyNumbersIncluded FROM PolicyPrint p INNER JOIN PolicyDetails d ON ( p.cicPolicyNumber =

Re: [GENERAL] problems with special characters

On Wed, Nov 26, 2008 at 3:36 PM, Karina Guardado <[EMAIL PROTECTED]> wrote: > I have a problem I have created a database with encoding SQL_ASCII and when > I insert the data using a terminal in linux and insert the data for example > Insert into mytable values(1,'Eléctrico'); it works fine but if I

Re: [SQL] [GENERAL] date range query help

On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote: > sorry I get nothing :( Of course not. None of the dates you gave in the example overlap. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [GENERAL] Get PG version using JDBC?

David Wall wrote: Is there a way to get the PG version string from JDBC? I'm using PG 8.3. Thanks, David SELECT version() ? -- 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] Need schema design advice

On Sun, Oct 12, 2008 at 8:10 PM, Ben Chobot <[EMAIL PROTECTED]> wrote: > On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote: > > could you provide a brief explanation of EAV ? > > (...) in an EAV model you would do something like: > create table eav > ( > kind text primary key, > attr text, > value t

Re: [GENERAL] FAQ: how to read EXPLAYN ANALYZE and act upon

On Wed, Sep 17, 2008 at 9:43 AM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > The subjects says it all. A couple of links that may be of use: http://pooteeweet.org/files/phpworks06/explaining_explain.pdf http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf Good l

Re: [GENERAL] web form development ide/api..

On Tue, Aug 26, 2008 at 2:41 AM, Ivan Price <[EMAIL PROTECTED]> wrote: > If anyone knows of such a thing i'd greatly appreciate some advice.. Gedafe - http://isg.ee.ethz.ch/tools/gedafe/index.en.html DaDaBIK - http://www.dadabik.org/ Good luck. -- Sent via pgsql-general mailing list (pgsql-gen

[GENERAL] PostgreSQL and SVN - help me...

Dear all, I want to know if is possible I install SVN (subversion control version) on postgresql. if is possible, is my idea the best? I need to discover links (site) where I can find good pratice information about svn. Because I found a big volume of information about svn and I can't discover wh

Re: [GENERAL] Is there any reason why "edit PostgreSQL.conf should be on my menu"

On Sat, Aug 2, 2008 at 9:14 AM, johnf <[EMAIL PROTECTED]> wrote: > I wonder if he talking about pgadmin3? It's on the menu. Only J.M. knows for sure... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [GENERAL] Data base tables design questions for: user saved forms, user parameters

On Fri, Jul 25, 2008 at 8:35 AM, Bruno Lavoie <[EMAIL PROTECTED]> wrote: > The hesitation here is : how to store the fields & values pairs, in > FIELDS_VALUES? Check out contrib/hstore: http://www.postgresql.org/docs/current/static/hstore.html -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] ER diagram software

On Tue, Jul 22, 2008 at 5:36 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote: > I've been able to find a couple of packages, but wondering if there is > a good system out there what will create an ER diagram of an existing > PostgreSQL DB. Open source would be nice. PostgreSQL Autodoc: http://www.r

Re: [GENERAL] Table X its full, what can i do now?

x asasaxax wrote: > Hi everyone, > > >I have the following sql script: > > CREATE SEQUENCE "public"."teste_seq" >INCREMENT 1 MINVALUE 1 >MAXVALUE 32767 START 1 >CACHE 1 CYCLE; > > CREATE TABLE "public"."teste" ( > "id" SMALLINT DEFAULT nextval('teste_seq'::regclass) NOT NULL

Re: [GENERAL] freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?

l processes: $ ktrace -C So, read man page, and at least ktrace -C and read the output at ktrace.out file. Best regards Rodrigo Gonzalez -- 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] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> pg_dump is working fine now, the problem appear with the pg_buffercache >> query...without it I dont notice anything wrong with DBbut of course >> there is something wrong. Can be pg_buffercache the p

Re: [GENERAL] ERROR: could not open relation with OID 2836

Alban Hertroys wrote: > On Jun 26, 2008, at 5:41 AM, Rodrigo Gonzalez wrote: > >> Tom Lane wrote: >>> Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >>>> Craig Ringer wrote: >>>>> What platform are you using? >>> >>>> It

Re: [GENERAL] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: >>> No, it's clear that things are already broken before pg_dump started. >>> You need to show us how to get to this state from a fresh database. > >> Interestin

Re: [GENERAL] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> Dont know exactly what you mean, if you are talking about the moment >> that I receive the error... > > No, it's clear that things are already broken before pg_dump started. > You need to show

Re: [GENERAL] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> Basically I should reinstall again PG with the same configuration and >> wait 1 night. Any log you need or want? anything to do besides doing the >> same I did? > > Umm ... if I reinstall PG and wa

Re: [GENERAL] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> Craig Ringer wrote: >>> What platform are you using? > >> It's running under CentOS 4.4 using ext3, no RAID or LVM. >> Server is quad xeon 64 bits 3 GHz > > Ugh, I'd have l

Re: [GENERAL] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: >>> Did you update anything else at the same time? > >> No, just postgres was updated > > Well, that does start to sound like it could be a PG bug; but no one > else i

Re: [GENERAL] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> It had been working with pgsql 8.1 and 8.2 for 2 years without problems. >> Suspicious is that problems started next day I've upgraded to 8.3. > > Did you update anything else at the same time? &g

Re: [GENERAL] ERROR: could not open relation with OID 2836

Tom Lane wrote: > Rodrigo Gonzalez <[EMAIL PROTECTED]> writes: >> PgSQL is returning that error when I open pgdmin and when I run some >> queries related to pg_buffercache. Also pg_dump cannot dump the DB. >> PgSQL version is 8.3.3 and happened one day after loading the

Re: [GENERAL] ERROR: could not open relation with OID 2836

Craig Ringer wrote: > Rodrigo Gonzalez wrote: >> PgSQL is returning that error when I open pgdmin and when I run some >> queries related to pg_buffercache. Also pg_dump cannot dump the DB. >> >> PgSQL version is 8.3.3 and happened one day after loading the DB there.

[GENERAL] ERROR: could not open relation with OID 2836

? Thanks Rodrigo Gonzalez -- 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] limits?

On Mon, Jun 23, 2008 at 2:45 PM, Kynn Jones <[EMAIL PROTECTED]> wrote: > Actually, the DB I have in mind would certainly be approaching "silly > territory." I'm looking at a schema with around 10 thousand tables (or > views). What kind of app would require such a schema? Just curious... -- Sent

Re: [GENERAL] Upgrade 8.3

E.J. Moloney escribió: I am running the following query update tempportfwdconnectiona set srcid=interface.objectid from interface where tempportfwdconnectiona.hostid=interface.host and tempportfwdconnectiona.spantreeport=interface.stpport For application reasons the spantreeport in one table

Re: [GENERAL] Unable to add a new column to a table named "in" (look like a bug ...)

Are you sure? \d "IN" Let us know if you have OTHER table called IN. When you use quotes you are making them case sensitive, so "in" != "IN" != "In" etc, etc David Gagnon escribió: Hi Adam, It worked Thanks!! But there is definitly something wrong with the error message I got (right?):

Re: [GENERAL] Master-master replication with PostgreSQL

anything better that work with pgsql Alvaro Herrera escribió: Rodrigo Gonzalez escribió: Yes and no bucardo cannot handle master-master-master What I am doing is masterA-masterB masterA-masterC masterA-masterD Oh, I see -- makes sense. Quite misleading docs, then

Re: [GENERAL] Master-master replication with PostgreSQL

Yes and no bucardo cannot handle master-master-master What I am doing is masterA-masterB masterA-masterC masterA-masterD That is something that bucardo can handle and allow me to replicate masterB-masterC but everything goes thru masterA always Alvaro Herrera escribió: Rodrigo

Re: [GENERAL] Master-master replication with PostgreSQL

Using star replication I have all the nodes as masterso n master-master replication with the common DB as master to all the nodes and all the nodes as master to the common DB Alvaro Herrera escribió: Julio Cesar Sánchez González wrote: El mié, 16-04-2008 a las 12:13 +0100, Rob Collins

Re: [GENERAL] Master-master replication with PostgreSQL

rectional and all the branches syncronized with the others. Rodrigo smime.p7s Description: S/MIME Cryptographic Signature

Re: [GENERAL] Date / interval question

On Thu, Apr 10, 2008 at 10:26 PM, kevin kempter <[EMAIL PROTECTED]> wrote: > However I'm stumped [er how to get the number of months from 09/01/2007 > thru 01/01/2007 select extract(month from (age(date '2007-1-1', date '2006-9-1'))); -- Sent via pgsql-general mailing list (pgsql-general@postgr

Re: [GENERAL] pgcrypto and dblink

Roberts, Jon escribió: I am moving from Windows to Solaris and I need pgcrypto and dblink. Where are these? I don't see anything in the configure that suggests it is even an option. Jon They are contribs, you have to install them after pgsql smime.p7s Description: S/MIME Cryptographic

Re: [GENERAL] To many records returned

Justin escribió: Have a select statement with a where clause using datestamp with timezone column compared to a date Select * from sometable where DateStampColumn > '2008-03-31' this returns records that are equal 2008-03-31 but when the query includes casting to date Select * from sometable wh

Re: [GENERAL] Secure "where in(a,b,c)" clause.

On Thu, Apr 3, 2008 at 11:50 AM, William Temperley <[EMAIL PROTECTED]> wrote: > This works very well, however I'm currently directly concatenating a sql > query: > > select st_collect(the_geom) from tiles where tilename in > ()) > > Which leaves my application vulnerable to sql injection. >

Re: [GENERAL] Problem with planner choosing nested loop

On Wed, Apr 2, 2008 at 1:20 PM, Alex Solovey <[EMAIL PROTECTED]> wrote: > In this simple (which means "reduced") test database, yes. But the actual > table "foo" in production database: > > 1. partitioned, with 50+ partitions > 2. heavily updated (and indexes make it slow) > 3. has more fields

Re: [GENERAL] Problem with planner choosing nested loop

Also important, consider creating additional indexes based on your access patterns. -- 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] Problem with planner choosing nested loop

On Wed, Apr 2, 2008 at 12:36 PM, Alex Solovey <[EMAIL PROTECTED]> wrote: > ... I have no idea how it could be fixed. - CREATE INDEX xifoo ON foo(bar_id); - ANALYZE; - Retry. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

Zdeněk Kotala escribió: Hello All, I prepared patch for renaming postgreSQL script tools like createdb, createuser, etc. to pg_createdb, pg_creteuser. Original names will be kept for 2 or 3 following versions. The main reason for the patch is to avoid possible clash of names with systems tool

Re: [GENERAL] PostgreSQL, clusters and load-balance

Bill Wordsworth escribió: On Tue, Mar 25, 2008 at 2:24 PM, Thomas Kellerer <[EMAIL PROTECTED] > wrote: Bill Wordsworth wrote on 25.03.2008 19:16: > When traffic goes up, my webserver creates multiple instances of > postgresql.exe. At some basic level, aren'

Re: [GENERAL] Converting mysql "on update" to postgres "rule"

Edward Blake escribió: Thanks to everyone who's helped me before. I'm trying to create the following mysql table in postgres: CREATE TABLE visit ( data1 varchar(30) NOT NULL, data2 varchar(30) DEFAULT NULL, data3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIM

Re: [GENERAL] begin-end blocks in psql

On 3/21/08, Gauthier, Dave <[EMAIL PROTECTED]> wrote: > I can do it in a formal declaration of a procedure, and then execute the > procedure. But is there a less formal way? No. There are no anonymous blocks in PostgreSQL. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] MySQL to Postgres question

Edward Blake escribió: The table I have in MySQL is similar to below: 0 SET FOREIGN_KEY_CHECKS=0; 1 CREATE TABLE products ( 2 product_id integer(11) not null auto_increment, 3 product_name varchar(255) not null, 4 product_descrition varchar(255) not null, 5 class_id integer

Re: [GENERAL] cast problem 8.3.1

Steve Clark escribió: Hello List, I can't seem to figure out what is this code that worked on 7.4.x. I've added cast to everything but still get: postgres error log: ERROR: operator does not exist: text = integer HINT: No operator matches the given name and argument type(s). You might need

Re: [GENERAL] Which RHEL

Tri Quach escribió: Hi All, I am not sure which RHEL is on my server. [EMAIL PROTECTED] pq8.2.6]# uname -a Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT 2004 x86_64 x86_64 x86_64 GNU/Linux Thank you for your help. Tri. cat /etc/redhat-release smime.p7s Desc

Re: [GENERAL] [HACKERS] Collating records based on a custom group by (aggregate like) function

On Tue, Mar 18, 2008 at 9:00 AM, Dan Searle <[EMAIL PROTECTED]> wrote: > I've racked my brain about this but can't think of a simple solution, > even though this appears to be a simple problem, any suggestions much > appreciated. Your fact is split across more than one row. I recommend that yo

Re: [GENERAL] Problem with async notifications of table updates

Tyler, Mark escribió: Hi, I am trying to set up a PostGreSQL database to send asynchronous notifications when certain inserts or updates are performed on the tables. The idea is I want to have publish / subscirbe model with the database in the centre as the information hub. An application wi

  1   2   3   >