What about PgAdmin III, I know, it is now perfect but I prefer it a lot
against similar commercial products.
Really, I have long time looking for a product with the same specs.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michelle Konzack
Sent: Wednesd
Title: Hola «Nombre»,
I can’t believe it… spanish
spam in this list :P
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Formación On-Line - Formabyte
Sent: Miércoles, 07 de Diciembre
de 2005 03:20 a.m.
To: pgsql-general@postgresql.org
Subject: [GENERAL] CURSOS
FORM
Thanks a lot man!!! You saved my life :P
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Martes, 08 de Noviembre de 2005 04:13 p.m.
To: Cristian Prieto
Cc: pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
Subject: Re: [GENERAL
Hi, sorry for the question but I still having serious troubles with the
array_ref function. The function is not documented and I can't get a useful
example inside the contrib directory. The function is defined as:
Datum array_ref(ArrayType *array, int nSubscripts, int *indx,
int
Is there any way to get the numbers of items inside a cursor?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Thanks a lot, but I still getting an error message like this:
ERROR: cache lookup failed for type 0
What is wrong?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Lunes, 07 de Noviembre de 2005 05:17 p.m.
To: Cristian Prieto
Cc: pgsql
Hello, I'm doing a very simple C language function in PostgreSQL but I can't
figure out why this is not working, the documentation about the PostgreSQL
internals is not so good about arrays and I couldn't find a suitable example
of the use of some kind of array functions inside the pgsql source tre
Hi! I have a little trouble with a SP written in C language, I have a
function which get an array as parameter, I know I could get the array using
ArrayType *elements = PG_GETARG_ARRAY_P(n) but what about if I only want to
get just the N element from the array? For example the 3 element of this
arr
that would improve the performance of the execution of
my application.
Any idea?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian
Sent: Jueves, 03 de Noviembre de 2005 02:13 p.m.
To: Cristian Prieto
Cc: pgsql-general@postgresql.org
Subject: Re
Is there around any way to save a prepared plan in postgresql?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get thr
Thanks a lot, your answer enlighten me a lot in the path to take to resolve
the problem into the database...
Thanks man...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Miércoles, 26 de Octubre de 2005 07:38 p.m.
To: Cristian Prieto
Hi, I was working in a set of SPs inside PL/pgSQL and I was
wonder if I could return a set of variable types from a function, for example,
in some time the same function could return a set of tuples with an integer and
a string, in other times It may return a set of tuples with an integer,
Any of you knows is there is any way in pg_dump or anything
to dump just the functions from a database?
Thanks a lot in advance!
This is maybe a really newbie question, but, when I have an
SQL function like that:
$$
Insert into mytable (id, name) values ($1, $2);
$$
What return value suppose to return?
You are talking about a shmem block using by the backend, right? Or about my
"own" shmem block?. I'm very interested in the implementation of a
"constants" like functionality to pgsql, but I don't know where to start
with... Any help or ideas?
-Original Message-
From: Tom Lane [mailto:[EMA
Why not something like Mantis bug tracker? (http://www.mantisbt.org)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stuart Bishop
Sent: Jueves, 13 de Octubre de 2005 01:42 a.m.
To: Greg Stark
Cc: Neil Conway; pgsql-general@postgresql.org
Subject: Re: [GEN
Hello, just a little question, It's preferable to use Text Fields or
varchar(255) fields in a table? Are there any performance differences in the
use of any of them?
Thanks a lot for your answer!
---(end of broadcast)---
TIP 4: Have you searched ou
g a sequential scan in the table and ignores the
index, any other suggestion?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sean Davis
Sent: Lunes, 26 de Septiembre de 2005 10:24 a.m.
To: Cristian Prieto; pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Hello pals, I have the following table in Postgresql 8.0.1
Mydb# \d geoip_block
Table "public.geoip_block"
Column| Type | Modifiers
-++---
locid | bigint |
start_block | inet |
end_block | inet |
mydb# explain analyze select locid from geoip_bl
Hello, this would like to be as a newbie question but I don’t know where to
find help…
I’ve a Fedora 3 server with postgresql 8.0.1 running (rpm from the postgresql
ftp site) and PHP5 (php-5.0.3), when I try to upgrade to 8.0.3 I have conflicts
with libpq.so.3 (I guess postgresql 8.0.3 comes wi
Thanks a lot! Your help was very handy!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Douglas McNaught
Sent: Miércoles, 21 de Septiembre de 2005 02:39 p.m.
To: Cristian Prieto
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] COPY and Unicode
Hello, I need to import some amount of data using the COPY command, the main
trouble I found is that the Database is in UNICODE format and the data in
ASCII Latin-1 codepage, when I try to import it, COPY respond with:
ERROR: invalid byte sequence for encoding "UNICODE": 0xe9
CONTEXT: COPY geoip
Maybe the first 1000 rows based in the primary index
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, September 08, 2005 6:05 PM
Subject: Re: [GENERAL] Support for Limit in
Would be any future support for limit in
update/insert queries? so you could do something like
update table1 set col1=value1 limit
1000;
would update just the first 1000 rows in the table.
I've been playing a little with the SPI and I get the SPI already has the
support for limit the num
Well, I guess this could be a hard-expensive way to do it but I've done this
little Stored Function, it doesn't use a regular expresion (you could pass
your email first to one to check it out I guess).
#include "postgres.h"
#include "fmgr.h"
#include
#include
#include
PG_FUNCTION_INFO_V1(di
Does somebody could embed this regex into a pgsql ~ statement? (maybe in a
DOMAIN type?)
Thanks a lot!
- Original Message -
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Brad Nicholson" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, September 07, 2005 9:41 AM
Subject: Re: [GENERAL] E
ra" <[EMAIL PROTECTED]>
Cc: "Cristian Prieto" <[EMAIL PROTECTED]>;
Sent: Monday, September 05, 2005 10:01 PM
Subject: Re: [GENERAL] Insert Ignore or something similar...
On Sep 5, 2005, at 10:51 PM, Alvaro Herrera wrote:
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas
Hello everybody,
I've just wondered if there are any way to
implement an INSERT IGNORE in PostgreSQL, I know, I could catch an exception in
PL/pgSQL and just handle it in the right way, but I would need to write a SP for
the task. I've been lookin into the documentation and I found no simil
e SearchSysCache() and heap_beginscan().
Do you think I need to implement such thing to improve performance? any idea
in how to improve my approach to this trouble?
Thanks a lot for your answer!
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "
Hello, I've been working just a little with SPI in
a few stored functions, this is a model of my SP:
PG_FUNCTION_INFO_V1(myspi);
Datum
myspi(PG_FUNCTION_ARGS)
{
bool isnull;
bytea *val;
Oid *karg;
void *plan;
int res;
ret =
SPI_connect();
karg = (Oid *)
pallo
Title: Message
Thanks a lot! It was very helpfull!!!
- Original Message -
From:
Reid
Thompson
To: Cristian Prieto ; pgsql-general@postgresql.org
Sent: Thursday, September 01, 2005 2:43
PM
Subject: Re: [GENERAL] ECPG
examples...
http
Hello, I've been reading a little the ECPG
(Embedded SQL in C) and the doc is (I guess) very clear, but I cannot find any
examples in the documentation, any idea where to get examples? inside the pgsql
source code?
Thanks a lot!
Hi, I will try to explain the most possible my
question:
I'm writing a Store Procedure as a C Language
Function in the Database, I need to handle a bytea (binary objetc) and store it
in a modified mode in the database, I've done it in the following
way:
PG_FUNCTION_INFO_V1(myspi);
Datu
Is around there any place where I could get the
changes in PostgreSQL 8.1?
Thanks a lot
I need to fine tuning my postgresql for
performance, I depend a lot in a couple and few SPs to made a sort of kind of
tasks, the most of those pgsql sps are made in pl/pgsql, most of them are
simple:
create or replace function sp_one(id
integer)
returns setof table1 as
$$
declare
var t
Hello, I have a couple of bussy pgsql 8 servers running in my office, in
MySQL I use SHOW PROCESSLIST to show the actual process running in the
MySQL server (idle time, resources and other statistical data) and a
little perl app named mytop to show the data like the top unix
utility... There such w
Hello, I have the following sp, I need to return a 'Flag' if the ID of the
row is in the prior select, I tryed with the following code:
create or replace function sp_getadvertisers(ag integer) returns record as
$main$
declare
alladv record;
retrec record;
begin
-- Primero buscamos todas las campa
Try a
Begin
... block to watch ...
Exception
When error_code then
... What to do ...
End;
block, it works to me, it is better explained in the manual..
- Original Message -
From: "Richard Huxton"
To: "Shaun Clements" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, March 30, 2005 11
What are the differences, bugfixes, features, etc
in the 8.0.2beta1? I was looking around and I couldn't find anything related...
Could somebody help me?
Thanks!
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, March 03, 2005 4:18 PM
Subject: Re: [GENERAL] Table inherits...
On Thu, 2005-03-03 at 15:53, Cristian Prieto wrote:
When
When a table inherit another, why it doesn't
inherit their keys nor fkeys?... How do I change it?
I prefer GTK, but your platform will be Windows or *NIXes?
(If you choose Linux I will be very glad to help you)
- Original Message -
From: "Hrishikesh Deshmukh" <[EMAIL PROTECTED]>
To:
Sent: Sunday, February 27, 2005 2:47 PM
Subject: [GENERAL] GUI
Hi All,
My sincere apologies if this i
limitation still
applies.
But my table name Grupos is not a reserved keyword, so SELECT * FROM Grupos;
should work, right??? but guess what... It doesn't work too... I need to
pass SELECT * FROM "Grupos";
- Original Message -----
From: "Michael Fuhr" <[EMAIL
Why do I need to add "" to a table when doing a
query? I've checked the examples and I found no one has " around the table
names. It is something with the configuration?
If I do:
select * from users;
ERROR: relation "users" does not
exist
but:
select * from "Users";
returns all the data
Something like pgAdmin III but more oriented to use as a SP editor,
something like pl/sql developer
(http://www.allroundautomations.com/plsqldev.html)
Is something similar out there?
- Original Message -
From: "Jason Earl" <[EMAIL PROTECTED]>
To: "Cristian Prie
I've tryied with some tools as pgEditor and EMS
PostgreSQL Manager, but I need a really good pgsql and database Editor to use in
Linux or Windows. Options?
Aunque parezca increible, seguimos buscando
webdeveloper, se ofrece buen sueldo y excelente ambiente de trabajo. Patojo, vos
me dijiste que tenias a alguien, que paso? Si alguien mas esta interesado (el
sueldo es en $) porfavor, porfavor, envienme un correo...
Xaludos...
RETURNS SETOF Users gave me:
getuser
-
(cristian,hola)
- Original Message -
From: "Richard Huxton"
To: "Pavel Stehule" <[EMAIL PROTECTED]>
Cc: "Cristian Prieto" <[EMAIL PROTECTED]>;
Sent: Wednesday, February 23, 2005 10:34
ot;Users"
but inside a SP, how could I do it?
- Original Message -
From: "Jan Poslusny"
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 23, 2005 8:36 AM
Subject: Re: [GENERAL] Help with a very newbie question...
1.
Plpgsql-function can retu
pgsql function?
3. If the record value is not a right return value, what kind of return
value could I use for it?
Thanks a lot for your help...
- Original Message -
From: "Jan Poslusny"
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 23, 200
I want to create a view or a sp which returns NULL
if nothing is found and a recordset if the user is found
I wrote something like:
CREATE sp_getuser(name, pass) RETURNS record
AS
$body$
DECLARE
retval RECORD;
BEGIN
SELECT INTO retval * FROM Users
WHERE userid=name AND passwd=pass
p with SQL
commands \? for help with psql
commands \g or terminate with semicolon
to execute query \q to quit
mydb=# \i insert.sqlCREATE FUNCTIONmydb=#
select sp_insert_users_2('Cristian', 'Prieto', 'hola', '[EMAIL PROTECTED]', 0,
current_da
Hello, thanks a lot for your help and sorry for my
newbie questions...
I have the following SP:
It is indexed by iduser (a primary
key)
CREATE FUNCTION store_users(name varchar, lastname
varchar) RETURNS integer AS
$body$
DECLARE
userid INTEGER :=
nextval('this_is_a_sequence');
BEGIN
in the page http://www.postgresql.org/docs/whatsnew it's
mentioned new features in PostgreSQL 8, I've readed the PgSQL 8 manual and found
nothing about the use of SavePoints, Point-in-Time, etc...
Where could I get more info about
it?
Hello, I migrated a database from postgresql 7.4 to postgresql 8.0.1 in a
Linux Fedora Core 3.
The tables and objects in the database schema are working ok...
I was just writing that function:
--- Begin of my function ---
CREATE OR REPLACE FUNCTION "public"."sp_insert_users_new" (varchar, varchar,
55 matches
Mail list logo
