Hi,
I have set of create table statements. I need to execute them at one go
instead of running individual statement to create a table.
Help !
Thx
-Original Message-
From: Timothy Perrigo [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 18, 2004 8:40 PM
To: [EMAIL PROTECTED]
Subject: Re
The first public beta for pgEdit is now available (see product
description below). If you would like to participate in the beta
program, evaluate the software and send some feedback to me (e.g.
criticism, bug reports, feature requests). The first responders will
receive a 30 day trial registrat
[EMAIL PROTECTED] writes:
> I have got old linux installation (i586 debian 2.2 kernel 2.2.19) and i can't
> upgrade it.
> My question is what version of postgres can run with glibs 1.2.
You will probably have to build from source, because no one is providing
RPMs or .debs for old platforms, but t
On 11/16/2004 6:32 AM, Holger Klawitter wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A little bit OT, but:
is there a way of removing duplicate rows in a table without OIDs?
There is still the CTID.
Jan
Mit freundlichem Gruß / With kind regards
Holger Klawitter
- --
lists klawit
On 11/16/2004 4:52 AM, Michael Glaesemann wrote:
On Nov 16, 2004, at 6:42 PM, Peter Eisentraut wrote:
Am Dienstag, 16. November 2004 10:01 schrieb Joolz:
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go aw
On Fri, Nov 19, 2004 at 01:01:07AM +0100, [EMAIL PROTECTED] wrote:
Hi,
> I have got old linux installation (i586 debian 2.2 kernel 2.2.19) and i can't
> upgrade it.
> My question is what version of postgres can run with glibs 1.2.
> ls /usr/lib/libgl* gave me
> /usr/lib/libglib-1.2.so.0 /usr/li
Hello.
I have got old linux installation (i586 debian 2.2 kernel 2.2.19) and i can't
upgrade it.
My question is what version of postgres can run with glibs 1.2.
ls /usr/lib/libgl* gave me
/usr/lib/libglib-1.2.so.0 /usr/lib/libglib-1.2.so.0.0.7
so i think i have glibc version 1.2.
glibc-config isn
We are loading a whole database using multiple copy command from inside a sql
script. Here is a couple of sample lines:
COPY choice FROM '/esc/pgrnd/prog/choice/choice.d.txt' DELIMITERS '|' WITH
NULL AS '?'; \i choice/choicePostLoad.sql;
COPY glacct FROM '/esc/pgrnd/prog/glacct/glacct.d.txt' DE
Another thing you can do if you know how to use Perl is to write a load
procedure for the ascii file. We are dumping data from a Progress database so
there was quite a lot of massaging to do, especially with some tables. We
read the Progress dump in and write it back out in the format we need fo
On Thu, 18 Nov 2004 10:56:59 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Mike Richards <[EMAIL PROTECTED]> writes:
> > PANIC: XX000: stuck spinlock (0x4035a0a0) detected at lwlock.c:242
> > ...
> > LOG: 0: server process (PID 20195) was terminated by signal 11
> > ...
> > FATAL: semctl(0, 0
Chris Green <[EMAIL PROTECTED]> writes:
> However when I try and run a postgres client process as an ordinary
> user I get the following:-
> FATAL: could not open configuration file "postgresql.conf": Permission
> denied
You don't run "postgres" as an ordinary user. You want a client
appli
On Thu, Nov 18, 2004 at 09:27:08PM +, Chris Green wrote:
> I have just installed Postgresql 7.3.4 on my slackware 9.1 system.
> The installation went fairly smoothly and the server process has
> started normally:-
>
> postgres 21027 20767 0 20:12 pts/500:00:00 -su
> postgres 21246
I have just installed Postgresql 7.3.4 on my slackware 9.1 system.
The installation went fairly smoothly and the server process has
started normally:-
postgres 21027 20767 0 20:12 pts/500:00:00 -su
postgres 21246 1 0 20:17 pts/300:00:00 /usr/bin/postmaster -D
/var/lib/postgr
Hi,
I am trying to import data using COPY, from a file containing thirty or
so COPY commands each with 0 or more rows of data. Reason, I have a
small data set I want to include into a database with an identical
schema, with existing data. I figured a good way to do this would be to
use pg_dum
On Nov 18, 2004, at 11:53 AM, Adam Witney wrote:
Hi,
Is it possible for the COPY command to read data from a file, but skip
specific columns?
You can use awk to skip fields and create an intermediate file or
better yet, just pipe the output to copy. Here is a trivial example:
awk '{ FS = "\t" ;
David Pradier wrote:
> The problem is, I don't want to use a lot of time to maintain this
> documentation, and above all, I'd prefer not to insert the information
> twice (read: a new constraint in the database should automagically
> update the documentation).
You could use the postgresql's commen
[EMAIL PROTECTED] (David Pradier) writes:
> Well, yes, that's what I currently use.
> The dot output is very interesting, but I guess the complete database
> image will be 16 meters x 16 meters large when I have finished adding
> the constraints.
> I have already stopped to print it.
> That's why I
[EMAIL PROTECTED] (David Pradier) writes:
> I've just inherited the responsibility of a postgresql database
> of roughly 480 tables and 6460 columns, mainly without constraints,
> not even foreign keys.
>
> I'd like to make it a little more orthodox (lots and lots of
> constraints, yeah !!), but I
On 18/11/04 5:15 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> Is it possible for the COPY command to read data from a file, but skip
>> specific columns?
>
> Nope. When you get into significant massaging of the input data,
> usually the best bet is to CO
Jeff Amiel wrote:
Not to question your data, but where did the info about the navy and
army using it come from? I saw nothing on the advocacy site nor did any
google search for press releases come up with anything.I'd actually
love to know how/where they are using it...
I can not tell you w
Adam Witney wrote:
Hi Joshua,
Sorry, I meant skip a column in the file, not the database table, or is that
what you meant?
No, I read your question backwards. I am sorry. As Tom Lane said, copy
the file into a temporary table and then you can deal with it from there.
Sincerely,
Joshua D. Drake
T
Not to question your data, but where did the info about the navy and
army using it come from? I saw nothing on the advocacy site nor did any
google search for press releases come up with anything.I'd actually
love to know how/where they are using it...
Uhmmm cause they are customers of mine ;
Joshua D. Drake wrote:
Adam Witney wrote:
Hi,
Is it possible for the COPY command to read data from a file, but skip
specific columns?
Crap, read your message backwards. Sorry. No you can't do this.
Sincerely,
Joshua D. Drake
\h copy
COPY tablename [ ( column [, ...] ) ]
TO { 'filename' | STD
Jeff,
Your Googler must be busted
http://www.ncstech.com/weblogic/www/what/index.jsp?page=six&&cs=landwarrior
http://www.dpi.inpe.br/geopro/referencias/shekar_spatial_databases.pdf
http://www.waterwatch.com/process/plan-datamanage.htm
Rick
Adam Witney <[EMAIL PROTECTED]> writes:
> Is it possible for the COPY command to read data from a file, but skip
> specific columns?
Nope. When you get into significant massaging of the input data,
usually the best bet is to COPY into a temp table that exactly matches
the format of the data file,
Hi Joshua,
Sorry, I meant skip a column in the file, not the database table, or is that
what you meant?
Thanks
adam
> Adam Witney wrote:
>> Hi,
>>
>> Is it possible for the COPY command to read data from a file, but skip
>> specific columns?
>
> \h copy
>
> COPY tablename [ ( column [, ..
Adam Witney wrote:
Hi,
Is it possible for the COPY command to read data from a file, but skip
specific columns?
\h copy
COPY tablename [ ( column [, ...] ) ]
TO { 'filename' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[
Hi,
Is it possible for the COPY command to read data from a file, but skip
specific columns?
Thanks
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---(end of broadcast)---
Not to question your data, but where did the info about the navy and
army using it come from? I saw nothing on the advocacy site nor did any
google search for press releases come up with anything.I'd actually
love to know how/where they are using it...
Joshua D. Drake wrote:
PostgreSQL is
On Thu, Nov 18, 2004 at 04:22:28PM +, Richard Huxton wrote:
> David Pradier wrote:
> >In fact, I have already looked a little into the tables of PostgreSQL
> >itself
> >to see if I could hack it by adding a column "Comments" in the "table of
> >columns".
> >But I guess it isn't wise nor feasib
What we are doing here is likely not applicable to you, but I'll still
tell it:
- keep the data definition in an XML document, which includes all the
comments about all the tables/fields in the schema;
- generate both the database schema and the (HTML) documentation out of
this XML using style s
David Pradier wrote:
In fact, I have already looked a little into the tables of PostgreSQL itself
to see if I could hack it by adding a column "Comments" in the "table of
columns".
But I guess it isn't wise nor feasible, is it ?
You are familiar with:
COMMENT ON TABLE t IS 'this is my table';
And
Actually I think he was asking about the software being certified for military
use. I don't believe this has been done, however, I know that postgresql was
included in a recent (I believe DOD) report about open source software being
PostgreSQL is use in several branches of the government. Inclu
On Thu, Nov 18, 2004 at 03:02:59PM +, Matt wrote:
> > The problem is, I don't want to use a lot of time to maintain this
> > documentation, and above all, I'd prefer not to insert the information
> > twice (read: a new constraint in the database should automagically
> > update the documentation
Well, yes, that's what I currently use.
The dot output is very interesting, but I guess the complete database
image will be 16 meters x 16 meters large when I have finished adding
the constraints.
I have already stopped to print it.
That's why I'd like to make something more 'paper-y' like 'The boo
Mike Richards <[EMAIL PROTECTED]> writes:
> PANIC: XX000: stuck spinlock (0x4035a0a0) detected at lwlock.c:242
> ...
> LOG: 0: server process (PID 20195) was terminated by signal 11
> ...
> FATAL: semctl(0, 0, SETVAL, 0) failed: Identifier removed
If you were getting just one of these then
frbn <[EMAIL PROTECTED]> writes:
> 8936960 2004-11-18 16:17:34 [31602] DEBUG: query: SELECT Oid FROM
> pg_index i WHERE i.indisprimary AND i.indrelid = 2178456572
> 8936961 2004-11-18 16:17:34 [31602] ERROR: dtoi4: integer out of range
This is a 7.1-vintage pg_dump bug --- it's not putting qu
On Thu, 18 Nov 2004 10:17:21 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Mike Richards <[EMAIL PROTECTED]> writes:
> > Over the past couple days I started seeing errors like this in my server
> > logs:
> > WARNING: terminating connection because of crash of another server process
>
> This is a
hi,
first: thank you very much for your support !
I now get the last postgresql stable version...
and here is the level 2 debug output :
(I'm sorry for this, it's huge)
___
8936752 /usr/bin/postmaster: ServerLoop:handling reading 5
8936753 /usr/bin/postmaster: Server
The system seems to think that a scan is cheap because the table is so
small. Have you ever ANALYZEd that table? Also, EXPLAIN ANALYZE gives a
much better idea of what is going on...
On Thu, Nov 18, 2004 at 03:55:12PM +0100, Marc Boucher wrote:
> I'm using PG 7.3.4
>
> I've a table with a column
Mike Richards <[EMAIL PROTECTED]> writes:
> Over the past couple days I started seeing errors like this in my server logs:
> WARNING: terminating connection because of crash of another server process
This is a consequence of an earlier failure --- tell us about what
happened just before that.
>
On Wednesday 17 November 2004 10:56, Jeff Eckermann wrote:
> --- Marco Bizzarri <[EMAIL PROTECTED]> wrote:
> > Hi all.
> >
> > I would like to know if postgresql has any
> > certification for the
> > military environment.
>
> There are no official certifications, nor are there
> likely to be. But
frbn <[EMAIL PROTECTED]> writes:
> we currently experience an original problem
> on a production server with a postgresql 7.1.3
> ( a bit old, I know :\ )
More than a bit. I wouldn't worry about trying to fix the installation
--- concentrate on getting a dump so you can upgrade.
> We stongly thi
Autodoc might be useful: http://www.rbt.ca/autodoc/
On Nov 18, 2004, at 8:31 AM, David Pradier wrote:
Hi !
I've just inherited the responsibility of a postgresql database
of roughly 480 tables and 6460 columns, mainly without constraints,
not even foreign keys.
I'd like to make it a little more ort
Jim Archer <[EMAIL PROTECTED]> writes:
> I need to flag a record when it is updated or when it is a new insert.
> Then I SELECT for the changed records and do something not related to
> Postgres. Easy enough, I created a trigger procedure and fired it on
> INSERT OR UPDATE and modify NEW to set
> The problem is, I don't want to use a lot of time to maintain this
> documentation, and above all, I'd prefer not to insert the information
> twice (read: a new constraint in the database should automagically
> update the documentation).
It's a while since I've used them (just coming back to pos
I'm using PG 7.3.4
I've a table with a column of type int8 where I store date-based values,
and an index exists for it.
The problem is that the index is almost never used with the '>' test.
# explain SELECT date FROM album WHERE (date='1093989600');
Index Scan using date_album_key on album (cos
Hi !
I've just inherited the responsibility of a postgresql database
of roughly 480 tables and 6460 columns, mainly without constraints,
not even foreign keys.
I'd like to make it a little more orthodox (lots and lots of
constraints, yeah !!), but I need a tool to make a documentation about
every
Jim,
How about having the trigger write the pk of the table to a new table. The
backend processing could then just join the new table on the pk to the
existing table to give you a proper result set. In the same transaction
delete the contents of the new pk table. Not as efficient as setting a
f
On Thu, Nov 18, 2004 at 12:17:01PM +0100, Dawid Kuroczko wrote:
> Correct me if I am wrong, but I think that UTF-8 is almost identical
> to ISO-8859-1 in binary form to ISO-8859-1. I mean, UTF-8 is
> ISO-8859-1 plus multibyte characters from other charsets.
No, UTF-8 and ISO-8859-1 are different
On Thu, 18 Nov 2004 11:08:38 +0100, Markus Wollny
<[EMAIL PROTECTED]> wrote:
> Oleg, what exactly do you mean by "tsearch2 doesn't support unicode yet"?
> It does seem to work fine in my database, it seems:
> ./pg_controldata [mycluster] gives me
> pg_control version number:72
> [...]
>
Over the past couple days I started seeing errors like this in my server logs:
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process
exited
Hi!
Hi!
Oleg, what exactly do you mean by "tsearch2 doesn't support unicode yet"?
It does seem to work fine in my database, it seems:
./pg_controldata [mycluster] gives me
pg_control version number:72
[...]
LC_COLLATE: de_DE.UTF-8
LC_CTYPE:
hi all,
we currently experience an original problem
on a production server with a postgresql 7.1.3
( a bit old, I know :\ )
We just want to know if somebody experienced this problem:
the error message :
"ERROR: Unable to locate type oid 0 in catalog"
I know that such a type can't exists as the ty
Why don't you check in your update trigger if the new record has the
flag "false" ? In that case you replace new with old, except you set the
flag to false. This way you can reset the flag by a simple update to
false of the flag field. All other queries should not touch the field.
In other words, u
55 matches
Mail list logo
