Hi
(I have posted this question to pg_advocacy as well, but I want to get
an answer or a discussion from this group as well, separate from the
advocacy group and background)
I am researching an advocation paper on Postgres. Basically I would like
to make a list of the most important strengths
Hi,
Once again, I'm providing "bleeding etch" Debian packages: 8.3.6, 8.2.12
and 8.1.16 for Debian etch as well as for Debian lenny (or newer).
However, please note that these did not run through any of the standard
Debian quality assurance procedures. Use them at your own risk.
For the experimen
Hi,
i have a table which can be altered with several additional column. How can
i test under plpgsql if a particular column already exists ?
thx.
--
Alain
---
Windows XP x64 SP2 / Fedora 10 KDE 4.2
PostgreSQL 8.3.5 / MS SQL server 2005
Apac
information_schema is the keyword here.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 07/02/2009 14:26, Alain Roger wrote:
> i have a table which can be altered with several additional column. How can
> i test under plpgsql if a particular column already exists ?
select 1 from information_schema.columns
where table_name = 'your_table_name_here'
and column_name = 'your_colum
Thanks a lot Raymond it works well.
On Sat, Feb 7, 2009 at 3:32 PM, Raymond O'Donnell wrote:
> On 07/02/2009 14:26, Alain Roger wrote:
>
> > i have a table which can be altered with several additional column. How
> can
> > i test under plpgsql if a particular column already exists ?
>
> select 1
Karsten Hilbert wrote:
> On Wed, Jan 21, 2009 at 01:49:44PM -0500, Bruce Momjian wrote:
>
> > Tom Lane wrote:
> > > Karsten Hilbert writes:
> > > > This is what my 8.3 manual says:
> > >
> > > > conkey ? int2[] ? pg_attribute.attnum ? If a table constraint, list of
> > > > columns which the con
Hi all!
I'm trying to use Postgre as a DataBase manager of a Software I'm
developing. I would like to know how to integrate an installation of Postgre
in the installation of my own software. I mean, I need to firstly install
Postgre, and when it finishes The rest of the installation of my software
On 07/02/2009 15:40, Iñigo Barandiaran wrote:
> I'm trying to use Postgre as a DataBase manager of a Software I'm
> developing. I would like to know how to integrate an installation of Postgre
> in the installation of my own software. I mean, I need to firstly install
The community installer (pgIn
Hi Raymond!
Thanks for your answer. I'm going to take a look to the silent option you
mentioned.
Any link related with this topic would be very appreciated.
Thanks in advance!
Best,
2009/2/7 Raymond O'Donnell
> On 07/02/2009 15:40, Iñigo Barandiaran wrote:
> > I'm trying to use Postgre as a D
Can someone comment on this?
---
Hiroshi Inoue wrote:
> Hi,
>
> This topic seems to be related to the bug report
> [ODBC] Localized error messages, wrong charset
> .
>
> Bruce Momjian wrote:
> > Added to TODO:
> >
> >
I have the following sql:
SELECT * from table order by dato asc limit 20 offset 0
This gives me different rows than the 20 first rows when running the following
sql:
SELECT * from table order by dato asc
Shouldn't the 20 first rows in the second sql statment be the same 20 rows that
is retu
>
> I have the following sql:
>
> SELECT * from table order by dato asc limit 20 offset 0
>
>
> This gives me different rows than the 20 first rows when running the
> following sql:
>
> SELECT * from table order by dato asc
>
>
> Shouldn't the 20 first rows in the second sql statment be the
On Sat, 7 Feb 2009 15:49:49 -0600
"Adam Rich" wrote:
> >
> > I have the following sql:
> >
> > SELECT * from table order by dato asc limit 20 offset 0
> >
> >
> > This gives me different rows than the 20 first rows when running the
> > following sql:
> >
> > SELECT * from table order by dato
On Sat, Feb 7, 2009 at 9:57 PM, Bjørn T Johansen wrote:
>> > SELECT * from table order by dato asc
is the field 'dato' the same in both cases ? if so - you're goood
just compare:
select dato from table order by dato asc limit 10;
with
select dato from table order by dato asc limit 10 offset 0;
On Sat, 7 Feb 2009 22:03:37 +
Grzegorz Jaśkiewicz wrote:
> On Sat, Feb 7, 2009 at 9:57 PM, Bjørn T Johansen wrote:
> >> > SELECT * from table order by dato asc
>
> is the field 'dato' the same in both cases ? if so - you're goood
> just compare:
>
> select dato from table order by dato asc
On Sat, Feb 7, 2009 at 10:22 PM, Bjørn T Johansen wrote:
> yes, they are the same... And returns the same, now when I have created an
> index for the dato field...
so, ales in ordunung ;)
you just have to choose different sorting key
--
GJ
--
Sent via pgsql-general mailing list (pgsql-gener
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> What logic would lead someone to separate pg_config from everything else?
>> Do people often just install the server and nothing else? Then what?
> This is actually *required* by Debian/Ubuntu packaging rules.
> The development environment
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> * Letter options in psql, pg_dump[all], pg_restore aren't consistent
> and can easily steer you very wrong. I'm looking at you, -d.
Amen!
> So, what do people say? Is Postgres perfect in your world or does
> it do some things which rub y
In the case of DBD::Pg it seems that it just uses the output of
pg_config. It seems absurd that that information can't be stored in
psql. There must be some good reason that it's not.
Is it because psql is stripped?
At least the build information (which pg_config spits out) could be stored
in a
On Feb 7, 2009, at 7:09 PM, rhubbell wrote:
In the case of DBD::Pg it seems that it just uses the output of
pg_config. It seems absurd that that information can't be stored in
psql. There must be some good reason that it's not.
Is it because psql is stripped?
At least the build information (w
On Sat, Feb 7, 2009 at 7:57 PM, Greg Sabino Mullane wrote:
> * psql doesn't do multi-line readline
I thought it started doing that in 8.2 or 8.3. At least on linux.
> * Logging could be a lot more flexible and fine-grained. Imagine being able to
> have slow queries from database X go to a sep
Here is a decent article comparing different db implementations.
http://troels.arvin.dk/db/rdbms/
It doesn't include firebird, but does include DB2 and informix. Some of
the deficiencies of Postges addressed will be rectified in the upcoming
8.4 release.
In my opinion the best two databases o
Artacus wrote:
> I think the biggest weakness of Postgres is advocacy and integration. We
> have current versions of popular distributions shipping with ancient
> versions of Postgres. Or try finding a web host that runs the current
> version of Postgres. The other day I was going to do a small
On Sat, 7 Feb 2009 19:30:37 -0800
Steve Atkins wrote:
>
> On Feb 7, 2009, at 7:09 PM, rhubbell wrote:
>
> > In the case of DBD::Pg it seems that it just uses the output of
> > pg_config. It seems absurd that that information can't be stored in
> > psql. There must be some good reason that it's
25 matches
Mail list logo
