On 25/10/12 19:45, Raymond O'Donnell wrote:
> On 25/10/2012 16:32, Linos wrote:
>> Hello,
>> there is some way to get and old integer primary key column to show the
>> "type"
>> serial at table description?
>>
>> I had a table like this:
On 25/10/12 17:39, Tom Lane wrote:
> Linos writes:
>> there is some way to get and old integer primary key column to show the
>> "type"
>> serial at table description?
>
> No, because there is no such type. "serial" is just a convenient macro
Hello,
there is some way to get and old integer primary key column to show the
"type"
serial at table description?
I had a table like this:
CREATE TABLE test
(
test_id integer NOT NULL,
CONSTRAINT test_pkey PRIMARY KEY (test_id),
);
that i would like to see as:
CREATE TABLE test
(
El 30/06/11 15:44, David Johnston escribió:
Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Linos
Sent: Thursday, June 30, 2011 9:00 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] question about query
Hi
El 30/06/11 15:44, David Johnston escribió:
Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Linos
Sent: Thursday, June 30, 2011 9:00 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] question about query
Hi
, Craig Ringer escribió:
On 30/06/2011 9:00 PM, Linos wrote:
how could i calculate this pending column that does not exists in the database
and i need to be based on last result row? I would like to get with raw SQL
but the need to use any procedural language would not be a problem.
Without knowing
Hi,
i am trying to obtain from the database what we have been doing in a excel
sheet from some time.
I have some tables where i store the documents associated with our customers,
invoices, payments and others, what i need to get from this tables it is a
movement log where i can get what paym
Hi all,
only want to link this blog post
http://blog.kimiensoftware.com/2011/04/top-10-missing-postgresql-features , i
think he may have any good points.
Miguel Angel.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
Symmetric-ds it is a replication solution that handles large objects, it is
asynchronous and multi-master, i have been using between 30 separate postgresql
connected by a slow link and until now i have been working without problems, i
think this project should be in the wiki.
http://symmetricd
Yes it seems you have reason Chris, i have been using 'timestamp with time zone'
without need it because i have read in the mailing list was good practice
because maybe one day you use the database in more timezones but i ever use the
app in the same timezone so i will convert the column datatyp
Hello,
i have reading in the mailing list any messages where different people use this
format to establish a functional index in a column using a type cast.
CREATE INDEX fecha_creacion_ordtrab ON orden_trabajo_cabecera USING btree
((time_stamp_creacion::date));
but in my postgresql 8.3 vers
Linos escribió:
Linos escribió:
Linos escribió:
Richard Huxton escribió:
Linos wrote:
Richard Huxton escribió:
Linos wrote:
2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms
sentencia:
SELECT "nombre", "subfamilia_id", "id_familia", "hasta&qu
Linos escribió:
Linos escribió:
Richard Huxton escribió:
Linos wrote:
Richard Huxton escribió:
Linos wrote:
2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms
sentencia:
SELECT "nombre", "subfamilia_id", "id_familia", "hasta", &
I have been testing with tcpdump but i dont see the problem in the
traffic (aside from the fact that it gives big jumps in ms between
packets of data, but i dont know why), i have tested on other debian
machines with the same result, i have upgraded kernel to 2.6.28 and
postgresql to 8.3.6 (e
Linos escribió:
Richard Huxton escribió:
Linos wrote:
Richard Huxton escribió:
Linos wrote:
2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms
sentencia:
SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto",
"id
Richard Huxton escribió:
Linos wrote:
Richard Huxton escribió:
Linos wrote:
2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia:
SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto",
"id_seccion"
Richard Huxton escribió:
Linos wrote:
2009-02-27 13:51:15 CET 127.0.0.1LOG: duración: 4231.045 ms sentencia:
SELECT "nombre", "subfamilia_id", "id_familia", "hasta", "foto",
"id_seccion", "id_categoria" FROM "modelo_su
Hello i have the same table with the same data in my development machine and in
a small server in production. The table is this:
Tabla «modelo_subfamilia»
Columna| Tipo | Modificadores
---+---+---
nombre| character var
A. Kretschmer escribió:
In response to Linos :
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
Other solution with
Thomas Kellerer escribió:
Linos, 27.02.2009 11:41:
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
i have been thinking
Hello,
i have a query that returns a result set like this:
item | size | stock
123 | XL | 10
123 | XXL | 5
123 | XS | 3
and i would like get the results like this:
item | XL | XXL | XS
123 | 10 | 5 | 3
i have been thinking how to do it with a plpgsql function but the numbe
Brandon Metcalf escribió:
m == [EMAIL PROTECTED] writes:
m> On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <[EMAIL PROTECTED]> wrote:
m> > m == [EMAIL PROTECTED] writes:
m> >
m> > m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <[EMAIL PROTECTED]>
wrote:
m> > m> > I have a need to
Tom Lane escribió:
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
On Fri, Aug 01, 2008 at 06:30:36PM +0200, Linos wrote:
i have migrated from Maxdb to Postgresql recently and i am having a
speed problem in large transactions over slow links because of autorollback
If the goal
David Wilson escribió:
On Fri, Aug 1, 2008 at 12:30 PM, Linos <[EMAIL PROTECTED]> wrote:
Well i would like to know if every can help with any other idea or any notes
on this problem? Other question i have it is how i could create a function
without be sure the number of columns to
Hello,
i have migrated from Maxdb to Postgresql recently and i am having a speed problem in
large transactions over slow links because of autorollback on error postgresql feature, i
create data in any tables with triggers in other tables and i do large inserts from the
data created in this
25 matches
Mail list logo
