-> Index Scan using
ventamc_82_pr_key_idx on ventamc_82 vt (cost=0.00..55.92 rows=165 width=33)
Index Cond: (pr_key =
pp.pr_key)
Filter: ((pe_key >= 72)
AND (pe_key <= 82))
-> Hash (cost=288.36..288.36 rows=836 width=8)
-> Seq Scan on local lo (cost=0.00..288.36
rows=836 width=8)
(61 rows)
regards
Thanks in advance
Cristian Iturrieta
I found where the problem is:
http://www.postgresql.org/docs/9.1/static/release-9-1-6.html
It could be nice if something is added to the 9.2 release notes to warn the
admins.
2013/4/24 Adrian Klaver
> On 04/24/2013 11:20 AM, Daniel Cristian Cruz wrote:
>
>> I've done an expl
5:4...
> >
> >
> >
> > --
> > View this message in context:
> http://postgresql.1045698.n5.nabble.com/Migration-from-DB2-to-PostgreSQL-TIMESTAMP-arg1-arg1-tp5761389p5761390.html
> > Sent from the PostgreSQL - general mailing list archive at Nabble.com.
> >
> >
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> r...@iol.ie
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
value || 'k ON ' || table_name ||' USING btree (foo_id, foo_num)';
>> EXECUTE 'GRANT ALL ON TABLE ' || table_name || ' TO foorole, postgres';
>> EXECUTE 'GRANT SELECT ON TABLE ' || table_name || ' TO blarole';
>>
>> END IF;
>>
>> EXECUTE 'INSERT INTO ' || table_name ||' VALUES (($1).*)' USING NEW ;
>>
>> RETURN NULL;
>> END;
>> $$
>> LANGUAGE plpgsql;
>>
>>
>> but it doesn't seem to work. It doesn't actually create new partition
>> tables.
>> The entries are inserted into "foo"
>>
>> I attach a test .sql file that contains the data of the table
>>
>>
>> any help would save me from a lot of time!
>>
>> thank you in advance!
>>
>> dafni
>>
>
>
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
for this? Would like to share it?
Didn't found anything on google.
Thanks,
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
;), how can I report a issue in
pg_upgrade?
Thanks, Adrian, Tomas and Tom. It's a specific issue, it's on backup until
May, 1st. Until there, if someone would like to know something about it,
just ask me, I would like to help removing an issue.
2013/4/23 Daniel Cristian Cruz
&g
2013/4/23 Adrian Klaver
> On 04/23/2013 04:23 AM, Daniel Cristian Cruz wrote:
>
>> 2013/4/22 Daniel Cristian Cruz > <mailto:danielcristian@gmail.**com >>
>>
>>
>> query1:
>> EXPLAIN ANALYZE SELECT ced.id_evento, ced.inicio, ced.termino,
2013/4/22 Daniel Cristian Cruz
> query1:
> EXPLAIN ANALYZE SELECT ced.id_evento, ced.inicio, ced.termino, ced.evento,
> ced.id_eventos IS NOT NULL AS aula_dividida, ac.titulo, ced.id_tipo_evento,
> ced.tipo_evento, ac.media_referencia, p.nome, ef.nome AS nomeEspacoFisico,
> ( SELE
, Daniel Cristian Cruz wrote:
>
>>
>>
>>
>> 2013/4/21 Adrian Klaver > <mailto:adrian.klaver@gmail.**com >>
>>
>
>
>
>> 1)
>> Major upgrade from 9.1.4 to 9.2.4.
>> Used pg_upgrade
>> Tested on VM with
And this one only to Adrian.
Sorry to all.
-- Forwarded message --
From: Daniel Cristian Cruz
Date: 2013/4/20
Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4
To: Adrian Klaver
2013/4/20 Adrian Klaver
> On 04/20/2013 04:30 PM, Daniel Cristian Cruz wr
Sorry, I answered to Tomas only...
-- Forwarded message --
From: Daniel Cristian Cruz
Date: 2013/4/21
Subject: Re: [GENERAL] Memory usage after upgrade to 9.2.4
To: Tomas Vondra
I had the same environment, almost:
2013/4/21 Tomas Vondra
> > 2) What are the hardware
2013/4/21 Adrian Klaver
> On 04/21/2013 07:50 AM, Daniel Cristian Cruz wrote:
>
>>
>>
>>
>> 2013/4/21 Adrian Klaver > <mailto:adrian.klaver@gmail.**com >>
>>
>>
>> On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote
2013/4/21 Adrian Klaver
> On 04/21/2013 06:37 AM, Daniel Cristian Cruz wrote:
>
>> 2013/4/21 Tom Lane mailto:t...@sss.pgh.pa.us>>
>>
>>
>> Tomas Vondra mailto:t...@fuzzy.cz>> writes:
>> > I do have a log with the memory context info
15 0 6684m 228m 85m S 0.0 0.2 0:00.59 postgres: sgn2
senai 10.1.3.1(59466) idle
30503 pg91 15 0 6682m 212m 71m S 0.0 0.2 0:00.43 postgres: sgn2
senai 10.1.3.1(48499) idle
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
2013/4/20 Adrian Klaver
> On 04/20/2013 04:08 PM, Daniel Cristian Cruz wrote:
>
>> I think I didn't make it clear: the session memory usage is growing up
>> too fast, until all server memory got used and swap occurs.
>>
>> Never saw something like that. The
I think I didn't make it clear: the session memory usage is growing up too
fast, until all server memory got used and swap occurs.
Never saw something like that. The version is under a test enviroment for a
long time...
Thanks if someone could help me.
2013/4/20 Daniel Cristian Cruz
>
I'm stuck with all the same parameters
from 9.1.4.
The only solution right now is to rollback to the older version.
Does someone got something like this before?
Thanks,
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
11,2013-03-15,2013-03-21,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25,2013-03-25}
correlation| 0.459312
most_common_elems |
most_common_elem_freqs |
elem_count_histogram |
Thanks,
2013/3/21
.id_produto_educacao,
aluno_mensal.produto_educacao,
aluno_mensal.unidade,
aluno_mensal.unidade_execucao,
aluno_mensal.modalidade,
aluno_mensal.id_pessoa,
aluno_mensal.nome_pessoa,
presenca.id_diario,
aula_confirmacao.inicio::date,
presenca.justificativa_falta,
mensal.ano,
mensal.mes;
2013/3/21 Daniel Cristia
2013/3/21 Alban Hertroys
> On Mar 20, 2013, at 22:36, Daniel Cristian Cruz
> wrote:
>
> Hi,
>
> I'm trying to figure out why does the planner found 1 row estimate using
> nested loops over a big table. There is no return from it:
>
> http://explain.depesz.com/s
And now, it runs, at least:
http://explain.depesz.com/s/GDJn
No one could send a guess on it?
2013/3/21 Daniel Cristian Cruz
> I've reduced default_statistics_target to 200, and saw less nested loops.
>
> I'm trying some changes to the query, but no better results.
>
&g
eSQL 9.2.3, default_statistics_target on 1000.
I can't remember what to make PostgreSQL sees a better estimate in the scan
of aula_confirmacao and the join with presenca. I got rusty after a long
time just doing modeling.
Does someone has some idea on that?
Thanks,
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
I've reduced default_statistics_target to 200, and saw less nested loops.
I'm trying some changes to the query, but no better results.
The table presenca has 26 million rows. The table aula_confirmacao has 840
thousand rows.
2013/3/21 Daniel Cristian Cruz
> Hi,
>
> I
eSQL 9.2.3, default_statistics_target on 1000.
I can't remember what to make PostgreSQL sees a better estimate in the scan
of aula_confirmacao and the join with presenca. I got rusty after a long
time just doing modeling.
Does someone has some idea on that?
Thanks,
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
ample.html#NormalizedErrorsMostFrequentReport
I read the code yesterday, and didn't find how to get a detail through
it. Maybe my C knowledge is somewhat broken...
--
Daniel Cristian Cruz
Unidade de Tecnologia da Informação
Sistema FIESC
Rod. Admar Gonzaga, 2765 - Itacorubi - 88034-001
:
plpy.warning('test', 'detail') -> output both values
plpy.warning({'message': 'test', 'detail': 'detail'}) -> output the dict
plpy.warning('test', detail='detail') -> fail
Am I missing something?
I would r
On Fri, Jun 24, 2011 at 09:42, Rob Sargent wrote:
> Can't the service script be something like
> cd d:/me/data/PostgreSQL; ./pg_ctl.exe runservice -N "pgsql" -D
> "d:/me/etc/PostgreSQL"
Don't know about that, the service was installed by pg_ctl.
Still, if two relative paths are based on one fol
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following settings:
data_directory = '../../
On 2011-06-23 19:15, Reid Thompson wrote:
On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
not very familiar with the windows version, but I think -D is supposed to point
to the dat
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following settings:
data_directory = '../../
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
On 10/29/2005, "blackwater dev" <[EMAIL PROTECTED]> wrote:
>In MySQL, I can use the replace statement which either updates the
>data there or inserts it. Is there a comporable syntax to use in
>postgreSQL?
>
>I need to do an insert and don't want to have to worry about if the
>data is already th
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
are there any way to make them global for all the instances?
On 10/14/2005, "Douglas McNaught" <[EMAIL PROTECTED]> wrote:
>TJ O'Donnell <[EMAIL PROTECTED]> writes:
>
>> I have begun to use some static variables in my c-language
>> functions to maintain state (3rd party licensing issues) during
>
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
In my table
userid | passwd
--+
cristian | hola
If I did the following:
SELECT * FROM "Users";
I get:
userid | passwd
--+----
cristian | hola
But If I create the following Function
CREATE OR REPLACE FUNCTION getuser(varchar, varchar) RETURNS SETOF RECOR
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,
b/phpbb2-pgsql/ from where you can
download a tarball until I wake up and actually get cvs working
properly)
So, if anyone is interested, drop me a line. If you want to keep this
thread on pgsql-general, please Cc: me as I am not subscribed.
--
Birzan George Violence is the last
88 matches
Mail list logo
