[GENERAL] whats the standard text search query?

I have this small web aplication.When i used mysql i used to do somthing like:SELECT * FROM table WHERE name like '%searchstring%' OR description like '%searchstring%';that doesnt really looks eficient... well... actually it works with no problem. anyway... what's the standard query for a text sear

[GENERAL] help me on a trigger

I need to create a trigger that decreases on a "stocks" table the amount that have been inserted on the "tooken_from_stock" table.the trigger should be something like:CREATE TRIGGER triggerdecrease BEFORE INSERT ON tooken_from_stockEXECUTE PROCEDURE decrease();then i need to create the procedure de

[GENERAL] Offline Tablespaces and Partial Restore

es are required cluster-wide on startup. Is there a way to take these tablespaces offline so I could do some maintenace work or startup the database with the archived data offline? Thanks in advance, Pedro Ivo

Re: [GENERAL] Offline Tablespaces and Partial Restore

? Does Postgres only relies on replication for high availability? Maybe an extension that I don't know about? Any help is appreciated. Thank you 2016-01-11 22:11 GMT-02:00 David Steele : > On 1/11/16 8:41 AM, Pedro França wrote: > >> I've tried to put the data on another datab

[GENERAL] Best Postgresql books

Hi guys,  Can anyone tell me the best books about postgresql? Specialy about tunning and querys performances Thanks Enviado do meu tablet Samsung Note

Re: [GENERAL] Best Postgresql books

Thanks Steven Em 18-07-2013 23:20, Steven Schlansker escreveu: PostgreSQL 9.0 High Performance: http://www.amazon.com/books/dp/184951030X On Jul 18, 2013, at 3:11 PM, Pedro Costa wrote: Hi guys, Can anyone tell me the best books about postgresql? Specialy about tunning and querys

[GENERAL] Continuous archiving and restore questions

hat after a restore is made, I need to make a fresh base backup in order to be able to make future restores. Is this correct, or am I doing something wrong? Thank you, Pedro Salgueiro

Re: [GENERAL] Continuous archiving and restore questions

this problem is to include the following line in the recovery.conf to always restore the last available timeline: recovery_target_timeline = 'latest' Best regards, Pedro On Wed, Jan 29, 2014 at 2:15 PM, Pedro Salgueiro < pedro.salgue...@cortex-intelligence.com> wrote: >

Re: [GENERAL] Continuous archiving and restore questions

On Wed, Jan 29, 2014 at 5:26 PM, Jeff Janes wrote: > On Wed, Jan 29, 2014 at 6:15 AM, Pedro Salgueiro < > pedro.salgue...@cortex-intelligence.com> wrote: > >> Hi, >> >> In the past couple of days I have been trying Continuous Archiving and >> Point-in-Time

Re: [GENERAL] Timeline Conflict

I've been trying to use repmgr for just that purpose. Looks like it simply creates/modifies a recovery.conf pointing primary_conninfo to the new master, and then restart. It does not seem to have the ability to resolve any timeline conflicts at all. Am I using repmgr incorrectly? -Origin

Re: [GENERAL] streaming replication: one problem & several questions

Do your machines have the same architecture? (64 bit vs 32 bit) - This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or

[GENERAL] Text search configuration

Hi All, This is my first post to this mailing list, so apologies if I am sending my message to the incorrect place... My question: I have configured a very basic text search for our application, but got stuck at the point where I need the search vector to filter out some unwanted text (HTML tags

[GENERAL] Help.

I'd like to truncate varchar field befor insert and update. Any example of trigger to perform this action? Thank you. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] upper case constraint?

gt; TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Pedro Miguel G. Alves THINK - Tecnologias de Informação Av. Defensores de Chaves nº 15 4ºD, 1000-109 Lisboa Portugal Tel: +351 21 3590285 Fax: +351 21 3582729 HomePage: www.think.co.pt

[GENERAL] making multiple updates use indexes: howto?

-- Pedro Miguel G. Alves[EMAIL PROTECTED] THINK - Tecnologias de Informaçãowww.think.pt Tel: +351 21 413 46 00 Av. José Gomes Ferreira Fax: +351 21 413 46 09 nº 13 1495-139 ALGÉS ---(end of broadcast)--- TIP 8: explain

[GENERAL] pgadmin3 1.6.3 problem with geom fields

3 1.6.3 to 1.6.2 and it exhibits the same behaviour... Any thoughts highly appreciated since I rely heavily on pgadmin3 for my work! :) Kind regards, Pedro Doria Meunier -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Remi - http:/

Re: [GENERAL] [pgadmin-support] Problem editing tables (geom columns)

gs way too much processor time. I've tested with a micro-subset of my data (only one record with a small parish geometry) and it shows although the slowness is immediately apparent... Kind regards, Pedro Doria Meunier Dave Page wrote: > Dave Page wrote: >> Pedro Doria Meunier wrot

[GENERAL] problemas zona horaria

Estimados...tengo un problema con la zona horaria de (GMT-06:00) Guadalajara, Ciudad de México, Monterrey - Nuevo. Cuando me conecto desde una aplicacion java a un servidor postgres todo en la misma maquina a el momento de insertar registros me cambia las horas me adelanta 5 horas imagino

[GENERAL] test message

Sorry People, this is a test message as it seems mail I'm writing to this list isn't going through-- I just want to see if I get a rebound of it... Please apologize. -- Pedro Doria Meunier Ips da Olaria Edf. Jardins do Garajau, 4 r/c Y 9125-163 Caniço Madeira Portugal GSM: +351 96

[GENERAL] problems with email...

Hi. I seem to have *extreme* problems sending messages to this list... :-( Could one of the people responsible for the list see if anything is wrong with my account, please? Thanks! -- Pedro Doria Meunier Ips da Olaria Edf. Jardins do Garajau, 4 r/c Y 9125-163 Caniço Madeira Portugal GSM: +351

[GENERAL] Help needed optimizing query

int)" "Filter: (((even_code)::text = 'A'::text) OR ((even_code)::text = 'B'::text))" I still get Seq Scans although all used fields are indexed, hence the time used... :-( Although this is almost 'targeted' to the beautiful SQL head of Regina's any input would be extremely appreciated... ;-) Thank you! -- Pedro Doria Meunier Ips da Olaria Edf. Jardins do Garajau, 4 r/c Y 9125-163 Caniço Madeira Portugal GSM: +351 96 17 20 188 Skype: pdoriam http://www.madeiragps.com signature.asc Description: This is a digitally signed message part

[GENERAL] Slony replication

Hi All, I would like to implement DB replication with Slony but with a slave that will not be always available. The master would have to check first of the slave's availability and then start syncing... Is this at all possible, or am I just raving? : ) Kind regards, -- Pedro Doria Meunier

Re: [GENERAL] thank you

n-letter type ordeal. > > The point is that I hope you realize just how much you all mean to the > community. > > Kevin > > > ---(end of broadcast)--- > TIP 4: Have you searched our list archives? > >http://archives.post

[GENERAL] Problema al cargar polígonos

gracias de antemano. Un saludo. Pedro Briones García TRAGSATEC Área de SIG y Consultoría Departamento de Cartografía C/ Julián Camarillo 6, Edificio 6B - 2ª Pl. Sector B 28037 Madrid mailto:[EMAIL PROTECTED] Tfno.: +34 91 322 6489/+34 679 09 0001

Re: [GENERAL] Table lock while adding a column and clients are logged in

Re: [GENERAL] Very slow catalog query

related blog: http://devblog.famundo.com Hi 'Just Someone' I'm wondering... just 4GB of ram? What's the "normal" "hammering" -- a.k.a. user access -- to all of this? PG, as expected, launches a separate process for each connection. this eats up resource

[GENERAL] default value based on select

Hi, Is it possible to have a table's column default value set to some form of select? e.g. picking another table's value for a given SELECT ... WHERE ... Already thankful for any insight, -- Pedro Doria Meunier Ips. da Olaria, Edf. Jardins do Garajau, 4, r/c Y 9125-162 Cani

Re: [GENERAL] default value based on select

? :) Kind regards, -- Pedro Doria Meunier Ips. da Olaria, Edf. Jardins do Garajau, 4, r/c Y 9125-162 Caniço Madeira - Portugal -- Skype : pdoriam Mobile: +351961720188 signature.asc Description: This is a digitally signed message part.

[GENERAL] Copying data from a table to another database

one please lend me a hand here? Already thankful for any insight, -- Pedro Doria Meunier <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Copying data from a table to another database

s the pkey was concerned (entry_nbr) it didn't cause me any problems as what's important were the timestamps in the relevant column. Again thanks! Best regards, -- Pedro Doria Meunier <[EMAIL PROTECTED]> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

[GENERAL] Average connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all I've googled for an answer but couldn't find one. Is there anyway to monitor the average connections to a database? Thank you in advance for any insights. BR, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam

Re: [GENERAL] Average connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Bill for your tip. As far as the table's name is concerned the only one I can find is 'pg_statistic' (under pg_catalog). I'm using PGSQL 8.2.9 on x86_64. BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam

Re: [GENERAL] Average connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, First of all thank you very much to everyone that shared their views on the task at hand! I've actually accomplished it using MRTG :) BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Bill Moran wrote: > In res

Re: [GENERAL] 10 TB database

... :) BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Michelle Konzack wrote: > Hi Artur, > > I am owner of a database about War, Worcrime and Terroism with more > then 1,6 TByte and I am already fscked... > > Am 2009-06-15 14:00:05, schrieb Artur: >> Hi! &g

[GENERAL] Upgrade

ice (sweat)... Insight on how to tackle the upgrade for these two servers (especially the FC6 one) would be much appreciated! ;-) Thanks in advance. BR. - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Commen

Re: [GENERAL] Upgrade

r is concerned to my great frustration this arch is EOL and there are no upgrade packages available... :-( Perhaps someone is able to conjure up some sort of solution for this? TY, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Greg Stark wrote: > On Thu, Jun 25, 2009 at 1:28 PM, Guy F

[GENERAL] Optimal values for 500 connections

ighly appreciated ;-) BR, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFKRRhy2FH5GXCfxAsRAt7KAJ0eiq6dcDyuvK5JpcfLb8atGd9FUAC

Re: [GENERAL] Optimal values for 500 connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Scott! As always your advice is right to the point ;-) That solved it. Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Scott Marlowe wrote: > On Fri, Jun 26, 2009 at 12:52 PM, Pedro Doria > Meunier

[GENERAL] Postgresql 8.3.7 SSL support

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi (again :] ) PGSQL 8.3.7 rpms for x86_64 aren't compiled with ssl support?! I've my server.* files in the data folder but this is what I get: Error connecting to the server: server does not support SSL, but SSL was required BR, - -- P

Re: [GENERAL] Postgresql 8.3.7 SSL support

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 (blush) (blush) Sorry for the noise I forgot to ssl=on in postgresql.conf (blush) (blush) Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Pedro Doria Meunier wrote: > Hi (again :] ) > > PGSQL 8.3.7 rpms for x86_64 aren&#

[GENERAL] Slony-I timezone setting

to 'Atlantic/Madeira' and UTC. My postgresql.conf has the same setting ('Atlantic/Madeira') Postgresql ver. 8.3.7 on Fedora 8 I feel reluctant to follow Slony's 'Best practices' depicted in the (cough) fine manual as it would mean losing any DST awareness ... An

Re: [GENERAL] Slony-I timezone setting

nf datestyle = 'iso, ymd' timezone = 'Atlantic/Madeira' BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Tom Lane wrote: > Pedro Doria Meunier writes: >> When configuring a Slony cluster I get the infamous 'ERROR: >> invalid input syntax for

Re: [GENERAL] Slony-I timezone setting

one name: "WEST" And this is when I ran out of ideas... btw: do you happen to know of a Slony mailing list? TIA, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Tom Lane wrote: > Pedro Doria Meunier writes: >> This is what's defined in postgresql.conf &g

[GENERAL] pgAdmin - no_spool

stalled on localhost TIA, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFKScxm2FH5GXCfxAsRArT8AJ0cOQok2fGxBjlZkgnY0DKMlUwivwCdHx89 u0d+m9gCvCQJMyo7Yo2h

Re: [GENERAL] pgAdmin - no_spool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thanks Simon, Actually Dave has already made a patch that overcomes this issue and it's already been committed! BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Simon Riggs wrote: > On Tue, 2009-06-30 at 09:27 +0100, Ped

[GENERAL] sslv3 alert illegal parameter

ver key in place.. What can I do about it?! TIA, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFKVHAz2FH5GXCfxAsRAixyAJ9m3TxToFE1sNdeDz9SsB9IoU

Re: [GENERAL] c++ program to connect to postgre database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Rey, If you give QT4 a try I might be able to help you there ;-) Regards Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam ramon rhey serrano wrote: > > Hello, > > I'm thinking of making a program in C++ (API)

Re: [GENERAL] sslv3 alert illegal parameter [SOLVED]

angling-over-my-head feeling ... Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Albe Laurenz wrote: > Pedro Doria Meunier wrote: >> My server started spitting this out every second! >> >> LOG: could not accept SSL connection: sslv3 alert illegal >&

[GENERAL] Timestamp indicies not being used!

of devices delivering their data payload to the my_table these queries effectively block other and take postgresql to a screeching halt ... :-( Could someone PLEASE tell me how can I solve this? Thanks in advance, -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -- Sent via pg

[GENERAL] [EDIT] Timestamp indicies not being used!

27;::bpchar)" "Total runtime: 810808.298 ms" Since there are hundreds of devices delivering their data payload to the my_table these queries effectively block other and take postgresql to a screeching halt ... :-( Could someone PLEASE tell me how can I solve this? Thanks in advance

[SOLVED] Re: [GENERAL] Timestamp indicies not being used!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 First of all *thank* you very much to all that replied! :) Sam's suggestion actually did the trick! I created the multi-column index and the stalling went away. Yay! Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam

Re: [GENERAL] [EDIT] Timestamp indicies not being used!

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Alban for your considerations. The issue has already been marked as [SOLVED] following Sam's suggestion. And FYI the issue *was* urgent and the wolf *was* biting my leg! :] BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pd

[GENERAL] Posgresql to MSsql encoding problem

erish... :( I cannot simply use "Set Client Encoding to LATIN1" as the "client" itself is the script ... :) Is there a simple way to circumvent this? Already thankful for any info, Best regards, Pedro Doria Meunier -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Li

Re: [GENERAL] Posgresql to MSsql encoding problem

aforementioned connection... So, to all effects, the script is *the* client... :) Best regards, Pedro Doria Meunier On 10/09/2009 02:38 PM, Sam Mason wrote: > On Fri, Oct 09, 2009 at 11:39:47AM +0100, Pedro Doria Meunier > wrote: >> I cannot simply use "Set Client Encoding

[GENERAL] Dump Database

Dear all, I'm trying to dump my database using the following command after I enter as su postgres: pg_dump - U postgres mydb -f mydb.sql ... but I'm always having the following message: pg_dump [archiver] Could not open output file "mydb.sql" : Permission denied I try to use the same state

Re: [GENERAL] Dump Database

-0500 What does the shell command: pwd show when run immediately after you issue a su postgres command? You may want to try su - postgres to ensure you are in the postgres users home directory. From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of José

Re: [GENERAL] Visualize database schema

Hi, I use to visualize a database schema Quantum GIS or UDIG. Both are open source software and very esay to add a database schema. Best Regards, José Santos Date: Tue, 14 Aug 2012 09:54:34 +0100 Subject: [GENERAL] Visualize database schema From: dario.bera...@gmail.com To: pgsql-general@postg

[GENERAL] Add Metadata to Postgre SQL

Dear Postgre Community, I would like to know if is possible to add metadata to Schemas. I have shemas with raster layers and I would like to add to them matadata. Is possbile in Postgre? If not how can I solve this problem? Many thanks in advance. Best Regards, José Santos

Re: [GENERAL] Add Metadata to Postgre SQL

ql.org; zpsant...@hotmail.com > Subject: Re: [GENERAL] Add Metadata to Postgre SQL > > > > "José Pedro Santos" hat am 14. August 2012 um 11:15 > geschrieben: > > > > Dear Postgre Community, > > > > I would like to know if is possible to add metadata

Re: [GENERAL] Add Metadata to Postgre SQL

Postgre SQL > > On 08/14/12 2:55 AM, José Pedro Santos wrote: > > Not comments. In comments i can't use the ISO that rules Metadata XML. > > Basically put XML Metadata files inside the schemas. Is possible? > > not sure what the International Standards Organization ha

Re: [GENERAL] Add Metadata to Postgre SQL

] Add Metadata to Postgre SQL > > On 08/14/12 4:32 AM, José Pedro Santos wrote: > > With the files should came metadata to describe what is inside the > > file. I can't put in the comment options because is not ISO standart > > that allow to produce metadata. >

[GENERAL] FGS - Postgresql server install

Hi all, I'm trying to install the fgs-postgresql-server-8.4.2-linux-i386.tar.gz in FGS MAPSERVER distribution but I can't, I'm using the Linux Centos version. Anyone know the command line to install the module? Is because when I install the FGS version the module postgresql server don't came

Re: [GENERAL] FGS - Postgresql server install

Hi again, I already fix the problem, thanks. Regards José Santos > Date: Tue, 28 Aug 2012 21:44:00 +0800 > From: ring...@ringerc.id.au > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] FGS - Postgresql server install > > On 08/28/2012

[GENERAL] Postgresql Error ask for password

Dear all, Im trying to install one application in my Linux but when I try to use the expression SU postgresql it ask for password, what is the password? I try my root password but dont work. Thanks for your time Ciao Jose Santos

Re: [GENERAL] Postgresql Error ask for password

stgresql.org > Subject: Re: [GENERAL] Postgresql Error ask for password > > On 08/31/2012 07:29 AM, José Pedro Santos wrote: > > Dear all, > > > > Im trying to install one application in my Linux but when I try to use > > the expression SU postgresql it ask for pass

Re: [GENERAL] Postgresql Error ask for password

d > > On 08/31/2012 08:03 AM, José Pedro Santos wrote: > > I install the FGS distribution of MapServer, after, the plugin Postgres > > - Server. When I go to root and put in bash SU also ask for password... > > > Here is an answer from the FGS mailing list: > > ht

[GENERAL] PostgreSQL and WMS/WFS Service

Dear all, How can I set up a service for a layer stored within postgres like WMS or WFS? I have one WEBGIS Framework that only allow data with that input. Many thanks. Best Regards, José Santos

[GENERAL] PostgreSQL and WMS

Dear all, I would like to know if is possible set up a service (WMS/WFS) for a layer stored within Postgres. I have one WEBGIS application that can't connect to PostgreSQL but if I use the data inside Postgres I can get the URL from WMS and add the maps. Best Regards, José Santos

[GENERAL] pg_wrapper error

Dear all, When I try to use the command line tool shp2pgsql in the shell I have this error: Error: pg_wrapper: invalid command name I already read some information in the Debian lists but I don't understand the problem/relation with PostgreSQL. If anyone can help me with this problem plea

Re: [GENERAL] pg_wrapper error

0 > From: adrian.kla...@gmail.com > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] pg_wrapper error > > On 10/26/2012 06:16 AM, José Pedro Santos wrote: > > Dear all, > > > > When I try to use the command line tool

FW: [GENERAL] pg_wrapper error

0 > From: adrian.kla...@gmail.com > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] pg_wrapper error > > On 10/26/2012 06:16 AM, José Pedro Santos wrote: > > Dear all, > > > > When I try to use the command line tool

Re: [GENERAL] pg_wrapper error

Fri, 26 Oct 2012 06:56:46 -0700 > From: adrian.kla...@gmail.com > To: zpsant...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] pg_wrapper error > > On 10/26/2012 06:33 AM, José Pedro Santos wrote: > > Postgres 9.1 in Ubuntu Distribution (12.04 LTS)

[GENERAL] Import raster file with 3 bands

Dear all, I import with sucess a 3 band image to PostgreSQL 9.1 with the raster2pgsql in Ubuntu 12.04LTS. But when I try to visualize in another software I can't see the image and it looks like the values from the other bands glue only in the first band. Do you know if there’s any problem wit

[GENERAL] how to remove a for-loop from programming language and put it into the query?

mes this query is long... about 1 minute. When I need a montly day-by-day report of 500 hardwares, it takes about half an hour. can I turn this for-loop into a single query to run in postgres? Thanks, Pedro -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] how to remove a for-loop from programming language and put it into the query?

> I'm probably misunderstanding the problem, but can't you just do: > > SELECT > diag_value > FROM > diagnose_logs > WHERE > ts <= '2009-12-25 23:59:59' > AND > hardware_id BETWEEN 1 AND 500 > ORDER BY > ts DESC > LIMIT 1 Hi Thom, Yes, I think you misunderstood. An

Re: [GENERAL] how to remove a for-loop from programming language and put it into the query?

Em 05-07-2010 12:22, Sam Mason escreveu: > > You want to be using DISTINCT ON or some sort of WINDOW function. > DISTINCT ON works with older version of PG, but isn't as standards' > conforming. The following should do the trick with DISTINCT ON: > > SELECT DISTINCT ON (hardware_id) hardware_i

[GENERAL] pgadmin3

Hi guys, What happened to pgadmin3 rpms for fedora core 10? Aren't they built yet? BR, Pedro Doria Meunier -- 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] [pgeu-general] pgday.eu

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ok a *bit* off-topic here... ;-) But who's this? He reminds me after a programming maraton! :-D Or after a cognac after red wine! :-P Whoever your are... Cheers Mate! ;) BR, Pedro On 11/12/2009 05:24 PM, Dave Page wrote: > 2009/11/1

[GENERAL] obtaining ARRAY position for a given match

ion at which 'L' is stored? Searching the Postgresql docs gives me no answer... :( Am I on a wild goose chase? Any insight highly appreciated ;) BR, Pedro Doria Meunier. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Fedora - h

Re: [GENERAL] obtaining ARRAY position for a given match

Regarding this thread... I've been away for a while... But thank you to all who replied! :) BR, Pedro On 11/19/2009 07:03 PM, Sam Mason wrote: On Thu, Nov 19, 2009 at 10:47:02AM -0800, Scott Bailey wrote: Sam Mason wrote: Is "idx" really the best name for this?

[GENERAL] C++ and Postgis

g the resulting text. This seems a bit awkward and time-consuming... Is there a better way to deal with it? Already thankful for any ideas, BR, Pedro. -- 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] Cannot login, with C/C++ program

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Did you check you pg_hba.conf ? another thing: although port defaults to 5432 you *should* specify that in the connection string. also... is "sysdba" *really* an authorized user? check your permissions... BR, Pedro. On 12/02/2009 09:42 PM

[GENERAL] Grant on table without access to other tables structure

\d cities He can see the other table names and structures... How can I revoke this rights? How can I create a new user and give him select rights on some tables, but not disclosure the full database tables and fields? PG is 8.3 Thanks, Pedro -- Sent via pgsql-general mailing l

Re: [GENERAL] need some advanced books on Postgres

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 "I hope postgres will be as popular as linux one day , :)" Where have you been all these years?!?!? Postgresql is THE database! humph! On 03/05/2010 10:01 AM, Thomas wrote: > Good advice ,tks both of you . > For database books ,I found so many good

[GENERAL] upgrading from 8.3 to 9.0

o remember problems with restoring from a pgadmin's .backup file in the past... :S Any pitfalls I should be aware of? Btw: it's a reasonably large DB with 30mil+ rows... Already thankful for any insight, -- Pedro Doria Meunier GSM: +351 91 581 88 23 Skype: pdoriam signature.asc De

Re: [GENERAL] Hi iam the beginner

(sorry all, I *couldn't* resist!) Scott ... In all these years that's the 1st time I've ever 'heard' the term "massage you data" !!! All sorts of deviant thoughts come to your mind! LOL BR, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Friday

[GENERAL] COPY ... FROM Permission denied ...

ry basic Could someone please lend a hand? Thanks in advance, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] COPY ... FROM Permission denied ...

thing worked as expected. :] Thanks again. Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Tuesday 06 January 2009 06:48:47 pm Scott Marlowe wrote: > On Tue, Jan 6, 2009 at 11:41 AM, Pedro Doria Meunier > > wrote: > > Hi All, > > > > This is a bit embarassing .

[GENERAL] to_hex leading zeroes

Hi All, I'm in a bit of a pickle here with the to_hex function not returning leading zeroes ... For instance if I: SELECT to_hex(10); it returns 'a' not '0a' . Any ideas on how to overcome this? TIA, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam signature

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

than MySQL for a number of reasons: - proven robustness - tight integration with PostGIS - large user base (an always friendly bunch willing to help out each other ;-) ) - ... Regards, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Tuesday 17 March 2009 11:25:08 am Juan Pereira

Re: [GENERAL] Accent insensitive search?

Hi, use ILIKE HTH, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Wednesday 18 March 2009 04:29:24 pm cifroes wrote: > Hi, > > I have a DB in utf-8 and postgres 8.3.x. > > How can I do an accent insensitive search (like ...) ? > > > TIA signature.as

Re: [GENERAL] Accent insensitive search?

Ooops! Silly me! I should have read more carefully ... (blush) sorry! Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Wednesday 18 March 2009 04:46:16 pm Pedro Doria Meunier wrote: > Hi, > > use ILIKE > > HTH, > > Pedro Doria Meunier > GSM: +351961720188

[GENERAL] Internationalization

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm wondering how to internationalize contents of a table, short of having a column for each language string ... Anyone with some experience to share? :) Regards, Pedro Doria Meunier -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7

Re: [GENERAL] Internationalization

. Regards, Pedro Doria Meunier. Justin wrote: > Pedro Doria Meunier wrote: >> Hi all, >> >> I'm wondering how to internationalize contents of a table, short >> of having a column for each language string ... Anyone with some >> experience to share? :) >>

Re: [GENERAL] Internationalization

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you Sam for the valuable input! Best regards, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Sam Mason wrote: > On Sat, Apr 11, 2009 at 02:47:53AM +0100, Pedro Doria Meunier wrote: >> Actually what I have i

[GENERAL] help with a query

to compute the time difference. ;-)   Thanks in advance!     Pedro Doria Meunier (351) 91 302 49 72 - (351) 96 247 99 12 [EMAIL PROTECTED] MSN - [EMAIL PROTECTED] ICQ - 308-182-126 Skype: pdoriam  

[GENERAL] dump desde dentro de una base

Estimados, Disculpen por la pregunta pero con postgres puedo sacar un dump desde dentro de la base y obtener lo mismo que con pg_dump Gracias Saludos - Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to friends.

[GENERAL] Change SERIAL to INTEGER

INTEGER with some conditions. Thanks! Pedro ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Change SERIAL to INTEGER

id from pg_class where relname = 'mytable_mytableid_seq'); DROP SEQUENCE mytable_mytableid_seq; Regards Pandu On 1/27/06, Pedro Monjo Florit <[EMAIL PROTECTED]> wrote: but the last command fails, saying that mytable still uses this sequence. Is there any way to change a SERIAL type to an INTEGER? I

[GENERAL] help from Portugal

ase do not known any clues. Me, has I said, I am not expert and I a bit lost not knowing what to do next. Do you have any ideas? Thanks for any help Pedro Guedes PORTUGAL [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to inc

  1   2   >