Hoi,
I searched the archives but couldn't find an answer to this:
I have a table (simplyfied)
CREATE TABLE test (
id INT PRIMARY KEY,
name VARCHAR(250)
);
I insert records with
INSERT INTO test (id, name)
SELECT COALESCE(MAX(id)+1, 1), 'name' FROM test
Ofcourse this gives problems when
Am Samstag, den 22.01.2005, 11:14 +0100 schrieb Ralph van Etten:
> Hoi,
>
> I searched the archives but couldn't find an answer to this:
>
> I have a table (simplyfied)
>
> CREATE TABLE test (
> id INT PRIMARY KEY,
> name VARCHAR(250)
> );
>
> I insert records with
>
> INSERT INTO test (
Ralph van Etten wrote:
Hoi,
I searched the archives but couldn't find an answer to this:
I have a table (simplyfied)
CREATE TABLE test (
id INT PRIMARY KEY,
name VARCHAR(250)
);
I insert records with
INSERT INTO test (id, name)
SELECT COALESCE(MAX(id)+1, 1), 'name' FROM test
Ofcourse this giv
On Fri, Jan 21, 2005 at 06:19:53PM -0600, Andrew L. Gould wrote:
> On Friday 21 January 2005 12:55 pm, Chris Green wrote:
[snip question]
>
> Many languages have the capacity to access PostgreSQL databases
> including Python (with PyGreSQL), Perl (with DBI), PHP (compile in
> support), Delphi an
None have mentioned pgaccess yet. I haven't used it on a regular basis, but
at least it builds and runs on my Mac (and therefore, linux, etc.)
Sean
- Original Message -
From: "Chris Green" <[EMAIL PROTECTED]>
To:
Sent: Saturday, January 22, 2005 7:57 AM
Subject: Re: [GENERAL] Data entr
On 21/01/2005 18:55 Chris Green wrote:
All I want is a way to produce reasonably functional forms for
entering data into a Postgresql database which will allow me to do the
following:-
Show a database table in a 'table view' type format which will
allow deletion, modification and insertion
On Saturday 22 January 2005 06:57 am, Chris Green wrote:
> On Fri, Jan 21, 2005 at 06:19:53PM -0600, Andrew L. Gould wrote:
> > On Friday 21 January 2005 12:55 pm, Chris Green wrote:
>
> [snip question]
>
> > Many languages have the capacity to access PostgreSQL databases
> > including Python (with
On Sat, Jan 22, 2005 at 08:13:52AM -0500, Sean Davis wrote:
> None have mentioned pgaccess yet. I haven't used it on a regular basis,
> but at least it builds and runs on my Mac (and therefore, linux, etc.)
>
It looks good but I can't work out how to actually download it.
--
Chris Green ([EMAI
> There are many free GUI's built for database access (many of them
> web-based using php); but most of them focus on database
> administration.
I think the reason for that is that database administration is easier
to parameterize.
There are so many different things that an application might (o
I know this isn't entirely postgresql specific, but it wouldn't be on
another list either so here goes...
I am writing an open source application where I would like to support
at least oracle, and possibly firebird or DB2, in addition to
postgresql which will be the default. I'm not going to try
=?ISO-8859-1?Q?Josu=E9_Maldonado?= <[EMAIL PROTECTED]> writes:
> I have a table that contains this raw data:
> epr_procode | epr_tipo | epr_mes | epr_valor | zert_title
> -+--+-+---+--
> 00C188 | VTA | 200309 | 2116. |
There's probably an obvious answer for this, but I couldn't see it in the
docs. What's the simplest way to concatenate multiple same-column values
in SQL?
For example, suppose I have table foo (key integer, id integer, entry
varchar) with data
key id entry
1 1
"Oluwatope Akinniyi" <[EMAIL PROTECTED]> writes:
> I presume this extract suggests that one is running a unix or linux
> flavour. What are the equivalent location in Windows XP?
You seem to be reading prerelease documentation.
http://www.postgresql.org/docs/8.0/static/libpq-ssl.html
Chris <[EMAIL PROTECTED]> writes:
> ... My question is how easily would this work with other databases? I
> know Oracle supports schema's, but I dont' know about the others. I
> also don't know if other databases have the concept of a search path,
> but I would think that they do.
AFAIK the idea
On Sat, Jan 22, 2005 at 02:03:58PM -0700, Ed L. wrote:
>
> There's probably an obvious answer for this, but I couldn't see it in the
> docs. What's the simplest way to concatenate multiple same-column values
> in SQL?
You can create an aggregate that does nothing but concatenate the entries:
>
> AFAIK the idea of a schema search path is specific to PG. I'm not sure
> how you will handle your "public" functions in other DBMSes.
>
>regards, tom lane
>
I'll probably have to go research this for each database. I have no
plans on immediately supporting other da
Hi.
I've started to learn SQL about 6 months ago, and now I'd upgraded
PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the
README file (how stupid I was) and there were instructions to how to do
it; the upgrade I mean. Now I'm wondering, server is not running because
fileformat
On Sun, 23 Jan 2005 00:13:08 +0200, Jarkko Elfving <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I've started to learn SQL about 6 months ago, and now I'd upgraded
> PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the
> README file (how stupid I was) and there were instructions to how to
On Sun, Jan 23, 2005 at 12:13:08AM +0200, Jarkko Elfving wrote:
> I've started to learn SQL about 6 months ago, and now I'd upgraded
> PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the
> README file (how stupid I was) and there were instructions to how to do
> it; the upgrade
"Niederland" <[EMAIL PROTECTED]> writes:
> System: the released Postgres 8.0, winXP
> Using:
> pg_dump --format=t --blobs myDB > DBFile
> pg_restore --create -dbname=crm DBFile
> Resulted in:
> pg_restore: [archiver] unsupported version (1.13) in file header
Come to think of it, I'll bet that yo
I have been having quite a time trying to figure
this one out. I have installed PostgreSQL OLE DB drivers (ver
1.0.0.15) on two separate machines. The only difference between the
two machines is the OS, 2000 Pro (SP4) and XP Pro (SP2) and both are fully
updated from fresh installs. The Po
[EMAIL PROTECTED] writes:
> Hello, all. I have a query that runs perfectly when I run it from
> pgAdmin3, but bombs when I run it from ColdFusion using the JDBC
> driver. I'm using postgres 7.4. The query uses dblink(), which I assume
> is the source of the problem.
> Can anyone provide me with
On Sat, Jan 22, 2005 at 02:03:58PM -0700, Ed L. wrote:
>
> There's probably an obvious answer for this, but I couldn't see it
> in the docs. What's the simplest way to concatenate multiple
> same-column values in SQL?
>
> For example, suppose I have table foo (key integer, id integer,
> entry va
On Sat, 22 Jan 2005 11:25:39 -0800, Chris <[EMAIL PROTECTED]> wrote:
> I know this isn't entirely postgresql specific, but it wouldn't be on
> another list either so here goes...
>
> I am writing an open source application where I would like to support
> at least oracle, and possibly firebird or D
Sounds like it could be a networking issue to me.
Perhaps the xp machine is resolving the db server name
more efficiently.
do both the xp machine and the win2k machine
1 have comparable network cards?
2 on the same subnet as each other and the db?
3 using the same dns or wins server?
you could try
Thank you Joe for leading me in the right
direction. I found the solution to the problem. It wasn't a hardware
related problem or an OLE DB driver problem...
By default, Windows XP installs the QoS Packet
Scheduler service. It is not installed by default on Windows 2000.
After I inst
Hi again...
I tried to solve my PostgreSQL cluster problem like Michael Fuhr and
Lonni Friedman helps me, but I didn't get it work. So I figured out that
if I do an fresh installation and removed the PostgreSQL completely
(even those JDBC and PL -drivers - everything) and be sure that it is
comple
Take a look at Ruby on Rails.
http://www.onlamp.com/pub/a/onlamp/2005/01/20/rails.html
I haven't used it myself yet but looking through the above walkthrough,
seems pretty easy to make data entry web forms.
Chris Green wrote:
On Fri, Jan 21, 2005 at 06:19:53PM -0600, Andrew L. Gould wrote:
On Fri
On Sun, 23 Jan 2005 08:09:15 +0200, Jarkko Elfving <[EMAIL PROTECTED]> wrote:
> Hi again...
>
> I tried to solve my PostgreSQL cluster problem like Michael Fuhr and
> Lonni Friedman helps me, but I didn't get it work. So I figured out that
> if I do an fresh installation and removed the PostgreSQL
On Sat, 2005-01-22 at 22:23 -0800, Lonni J Friedman wrote:
> On Sun, 23 Jan 2005 08:09:15 +0200, Jarkko Elfving <[EMAIL PROTECTED]> wrote:
> > Hi again...
> >
> > I tried to solve my PostgreSQL cluster problem like Michael Fuhr and
> > Lonni Friedman helps me, but I didn't get it work. So I figure
Jarkko Elfving <[EMAIL PROTECTED]> writes:
> Yes. I'm using the RPM's and yes I'd used /etc/init.d/postgresql but it
> fails with errors:
> # /etc/rc.d/init.d/postgresql start
> Initializing database: [FAILED]
> Starting postgresql service:
On Sun, 2005-01-23 at 02:15 -0500, Tom Lane wrote:
> Uh, /var/lib/pgsql should have been created for you by RPM installation.
> I'm starting to think you have a corrupted postgresql-server RPM.
>
> Also, in your prior message:
>
> > bash-3.00$ initdb -D=/var/lib/pgsql/data/
> > fgets failure: Suc
32 matches
Mail list logo
