Bruce Momjian wrote:
> Peter Eisentraut wrote:
>> Brendan Jurd wrote:
>>> * add an ISO day format pattern to to_char() called 'ID', which
>>> starts at Monday = 1, and
>>> * add an ISO year field to extract() called 'isoyear'?
>> That seems reasonable. Do you volunteer?
>
> Added to TODO:
>
>
Brandon Aiken a écrit :
It also might be a big/little endian problem, although I always thought that
was platform specific, not locale specific.
Try the UCS-2-INTERNAL and UCS-4-INTERNAL codepages in iconv, which should use
the two-byte or four-byte versions of UCS encoding using the system's
On Thu, Nov 23, 2006 at 08:53:28AM +0100, Luca Ferrari wrote:
> Hi all,
> I've got my database on which I'm building a Java application. Since I'd like
> to store information about who inserted and updated a specified record, I
> placed in my main tables a few additional fields to store such info
Luca Ferrari <[EMAIL PROTECTED]> schrieb:
> Here comes my question: how can I catch user changes to each record in the
> database without be bored with user/date details? Anyone can suggest me a
> smart solution and/or database design? Anyone has already found such kind of
> problem?
Perhaps
zenith siea wrote:
> see my operations first:
> [EMAIL PROTECTED] postgresql-8.0.8]# su postgres
> bash-2.05b$ initdb -D /usr/local/pgsql/data
> initdb: error while loading shared libraries: libssl.so.4: cannot open
> shared object file: No such file or directory
> bash-2.05b$ service postgresql s
Tino Wildenhain a écrit :
Arnaud Lesauvage schrieb:
Hi List !
I am looking for an easy URL decoding function.
I thought about using regexp_replace, but I cna't get it to work :
SELECT regexp_replace('foo%B5bar', '%(..)', '\x\\1' , 'g');
> 'fooxB5bar'
I wanted to replace %BE with the characte
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
"Worky Workerson" <[EMAIL PROTECTED]> wrote:
> This is probably a really basic question, but how do I trap when
> spi_query_exec returns an error in PL/Perl?
Tom Lane replied:
> I think you don't, without using plperlu :-(. Unless perhaps recent
>
On 11/23/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
Bruce Momjian wrote:
> Peter Eisentraut wrote:
>> Brendan Jurd wrote:
>>> * add an ISO day format pattern to to_char() called 'ID', which
>>> starts at Monday = 1, and
>>> * add an ISO year field to extract() called 'isoyear'?
>> That seems
Arnaud Lesauvage schrieb:
Tino Wildenhain a écrit :
Arnaud Lesauvage schrieb:
Hi List !
I am looking for an easy URL decoding function.
I thought about using regexp_replace, but I cna't get it to work :
SELECT regexp_replace('foo%B5bar', '%(..)', '\x\\1' , 'g');
> 'fooxB5bar'
I wanted to re
Brendan Jurd wrote:
> On 11/23/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
>> Bruce Momjian wrote:
>> > Peter Eisentraut wrote:
>> >> Brendan Jurd wrote:
>> >>> * add an ISO day format pattern to to_char() called 'ID', which
>> >>> starts at Monday = 1, and
>> >>> * add an ISO year field to ext
My application's connections against PostgreSQL 8.1.4 seem to get
stuck in deletion operations.
Some sample ps output:
postgres 18198 10.5 20.7 1072088 863040 ? S11:59 14:23
postgres: [...] DELETE waiting
postgres 18204 11.5 20.8 1072692 867708 ? S11:59 15:43
postgres:
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> "" The type names serial and serial4 are equivalent: both create integer
> columns. The type names bigserial and serial8 work just the same way, except
> that they create a bigint column. bigserial should be used if you anticipate
> the use of more
Hi everyone,
I just came across a thread in the pgsql archives from October 2000, and found
this post particularly interesting:
http://archives.postgresql.org/pgsql-sql/2000-10/msg00044.php
...because I had already been designing something similar but on a larger
scale, for an integrated infor
> > "" The type names serial and serial4 are equivalent: both create integer
> > columns. The type names bigserial and serial8 work just the same way, except
> > that they create a bigint column. bigserial should be used if you anticipate
> > the use of more than 231 identifiers over the lifetime o
On 11/24/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
Brendan Jurd wrote:
> On 11/23/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
>> Just verifying, but aren't both formats ISO? In that case maybe it'd be
>> better to have a (per database) setting that specifies which one?
>
> The term "ISO" is
Alexander Staubo <[EMAIL PROTECTED]> writes:
> My application's connections against PostgreSQL 8.1.4 seem to get
> stuck in deletion operations.
> ...
> # select * from pg_locks where pid in (18198, 18204, 18208, 18214,
> 18216);
You really need to show all of pg_locks, not a subset. In this
Hi,
I've developed an application using Nhibernate with postgresql version
8.1.4. I have encountered an adhoc application shut down with the following
error message in postgresql/data/pg_log:
LOG: XX000: could not receive data from client: No connection could be made
because the target machine a
During execution of PL/pgSQL procedure I have to send somehow few date to
another Postgress database. Is to possible to connect
to other database , if yes what is performance of such solution? Is it possible
to create DB link between two Postgres application?
Michał Szymański
Hi,
I'm running a very large and frequently updated database on a machine with
relatively limited memory (you can safely assume that the database disk usage
to available memory has a ratio of 10:1 - so clearly not all the pages can be
retained in memory).
The naive approach would presume tha
On Wednesday 20 September 2006 18:59, Brian Maguire wrote:
> I justed wanted to let you know how impressed and pleased I have been with
> postgres over the past 5 years . The timeliness and quality of the releases
> are always robust and stable. Every release has a very nice mix of admin,
> perf
Hi list !
When trying to import a 20M rows csv file into PostgreSQL, I
get :
ERROR: out of memory
État SQL :53200
Détail :Failed on request of size 1073741823.
Contexte : COPY tmp, line 1
The table has no index, no trigger, ... :
CREATE TABLE tmp
(
c1 bigint,
c2 character varying,
c3 c
"Kevin Field" <[EMAIL PROTECTED]> writes:
> Either way, are 64-bit OIDs planned within the next couple years?
No, they're not planned at all. That line of thought has pretty much
died off, to the point where OIDs in user tables are not just deprecated
but not there at all by default.
There are b
You can use the dblink (
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/) contrib
module for that purpose.
Thanks,
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 11/22/06, Szymanski, Michal (GE Money) <[EMAIL PROTECTED]> wrote:
During execution of PL/pgSQL procedu
On Nov 23, 2006, at 16:27 , Tom Lane wrote:
Alexander Staubo <[EMAIL PROTECTED]> writes:
My application's connections against PostgreSQL 8.1.4 seem to get
stuck in deletion operations.
...
# select * from pg_locks where pid in (18198, 18204, 18208, 18214,
18216);
You really need to show all o
Alexander Staubo <[EMAIL PROTECTED]> writes:
> See below. Seems 18204 is waiting for a process that is "idle in
> transaction"; makes me wish that PostgreSQL could export more
> information about the age of in-progress transactions. I am turning
> on logging so I can determine what a future h
Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
> When trying to import a 20M rows csv file into PostgreSQL, I
> get :
> ERROR: out of memory
> État SQL :53200
> Détail :Failed on request of size 1073741823.
> Contexte : COPY tmp, line 1
Can you put together a self-contained example? The reference
Hi!
Is there a way that I could create a trigger that logs the changes (updates,
deletes) of a table? I mean, I want to put in a table the changes to any
table in a database and also put in the table the column that was modified
and the corresponding value.
My audit table looks like this:
Table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/22/06 20:23, carter ck wrote:
> Hi all,
>
> I am wonderring if it is a good practice to use SERIAL index as primary
> key, as it is only available up to 999?
>
> Currently i am dealing with storing LDAP users into Postgres and i am
> lookin
On Thu, Nov 23, 2006 at 10:23:55AM -0600, Ron Johnson wrote:
> For those times when and that when numeric sequences *are* needed
> (employee_id and account_number for example) they should include a
> check digit, to ensure that you don't mis-type a number and charge
> the wrong account.
Sure, but
On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote:
> Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
> > When trying to import a 20M rows csv file into PostgreSQL, I
> > get :
>
> > ERROR: out of memory
> > État SQL :53200
> > Détail :Failed on request of size 1073741823.
> > Contexte : COPY
am Fri, dem 24.11.2006, um 0:32:30 +0800 mailte Charles Ambrose folgendes:
> Hi!
>
> Is there a way that I could create a trigger that logs the changes (updates,
> deletes) of a table? I mean, I want to put in a table the changes to any table
> in a database and also put in the table the column
Tom Lane wrote:
Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
When trying to import a 20M rows csv file into PostgreSQL, I
get :
ERROR: out of memory
État SQL :53200
Détail :Failed on request of size 1073741823.
Contexte : COPY tmp, line 1
Can you put together a self-containe
> If my database contains dates greater than DATE '-12-31' then this
> check fails.
>
> This is why I'm searching for a real MAX_DATE value in Postgres.
>
> It would be nice if there will be MAX_DATE constant in Postgres or some one
> row system table contains MAX_DATE value.
through expe
Martijn van Oosterhout a écrit :
On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote:
Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
> When trying to import a 20M rows csv file into PostgreSQL, I
> get :
> ERROR: out of memory
> État SQL :53200
> Détail :Failed on request of size 107374182
Arnaud Lesauvage a écrit :
Brandon Aiken a écrit :
It also might be a big/little endian problem, although I always thought that
was platform specific, not locale specific.
Try the UCS-2-INTERNAL and UCS-4-INTERNAL codepages in iconv, which should use
the two-byte or four-byte versions of UCS
2006/11/23, Arnaud Lesauvage <[EMAIL PROTECTED]>:
Arnaud Lesauvage a écrit :
> Brandon Aiken a écrit :
>> It also might be a big/little endian problem, although I always thought that
was platform specific, not locale specific.
>>
>> Try the UCS-2-INTERNAL and UCS-4-INTERNAL codepages in iconv, w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/23/06 10:49, Martijn van Oosterhout wrote:
> On Thu, Nov 23, 2006 at 10:23:55AM -0600, Ron Johnson wrote:
>> For those times when and that when numeric sequences *are* needed
>> (employee_id and account_number for example) they should include a
>
Hi,
Sure, but the check digit does not need to be stored, as it can be
regenerated on demand. The user interface just verifies the check
digit, then throws it away.
$ SET GEEZER
$ WRITE SYS$OUTPUT "THAT'S JUST EXTRA CYCLES WASTED BY THE"
$ WRITE SYS$OUTPUT "CLIENT. BETTER TO USE THEM FOR SOME
Arnaud Lesauvage wrote:
> Martijn van Oosterhout a écrit :
> >On Thu, Nov 23, 2006 at 11:27:06AM -0500, Tom Lane wrote:
> >>Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
> >>> When trying to import a 20M rows csv file into PostgreSQL, I
> >>> get :
> >>
> >>> ERROR: out of memory
> >>> État SQL :53
This is the example found in the documentation to dump a database.
"Examples
To dump a database:
$ pg_dump mydb > db.out"The following - $ pg_dump aurel > aurel.out - gives me
"ERROR: syntax error at or near "$" at character 1"What am I missing???Bob
To dump a database: $ pg_dump mydb > db.out"
The following - $ pg_dump aurel > aurel.out - gives me
"ERROR: syntax error at or near "$" at character 1"
What am I missing???
The $ character is there to indicate the prompt your shell gives you.
If you leave it off at the beginning of your command
>
> "Examples
> To dump a database:
>
> $ pg_dump mydb > db.out"The following - $ pg_dump aurel > aurel.out - gives
> me "ERROR: syntax
> error at or near "$" at character 1"What am I missing???Bob
The $ isn't part of the command, it just just part of the shell's command-line
prompt.
My sh
Bob Pawley wrote:
This is the example found in the documentation to dump a database.
"Examples
To dump a database:
$ pg_dump mydb > db.out"
The following - $ pg_dump aurel > aurel.out - gives me
"ERROR: syntax error at or near "$" at character 1"
What am I missing???
Bob
The "$"
No joy
pg_dump aurel > aurel.out
Returns -
ERROR: syntax error at or near "pg_dump" at character 8
I've had a bit of trouble with the PostgreSQL system if that helps. (access
violation with a reinstall)
Bob
- Original Message -
From: "Konrad Neuwirth" <[EMAIL PROTECTED]>
To: "Bob
> No joy
>
> pg_dump aurel > aurel.out
>
> Returns -
> ERROR: syntax error at or near "pg_dump" at character 8
>
> I've had a bit of trouble with the PostgreSQL system if that helps. (access
> violation with a reinstall)
that is a psql error message isn't it. pg_dump is a shell command that
Bob,
This command:
pg_dump aurel
...should output the structure and contents of your "aurel" database to
your screen SQL with comments.
What version of PostgreSQL are you running and on what operating system?
Jim
> No joy
>
> pg_dump aurel > aurel.out
>
> Returns -
> ERROR: syntax error at o
Sorry.
The command will output ... *AS* SQL with comments.
> Bob,
>
> This command:
>
> pg_dump aurel
>
> ...should output the structure and contents of your "aurel" database to
> your screen SQL with comments.
>
> What version of PostgreSQL are you running and on what operating system?
>
> Jim
>
Hi all,
I have a postgres installation thats running under 70-80% CPU usage
while
an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
Here's the scenario,
300 queries/second
Server: Postgres 8.1.4 on win2k server
CPU: Dual Xeon 3.6 Ghz,
Memory: 4GB RAM
Disks: 3 x
Bob Pawley wrote:
> No joy
>
> pg_dump aurel > aurel.out
>
> Returns -
> ERROR: syntax error at or near "pg_dump" at character 8
Looks like you're trying to run it from psql. pg_dump is a command line
utility. Run it directly from the shell command prompt (or cmd window on
windows).
Pete
>
>
i'm seeing the opposite here on our win32 pgsql instance. while mssql server
used ~50% cpu constantly (AND consuming lots of memory, pgsql runs at a low
1-5% and gives better performance even under relatively high load.
is the high cpu load coming from one particular postgres.exe process or is
Bob Pawley wrote:
No joy
pg_dump aurel > aurel.out
Returns -
ERROR: syntax error at or near "pg_dump" at character 8
I've had a bit of trouble with the PostgreSQL system if that helps.
(access violation with a reinstall)
how about giving the pg_dump command to a shell instead of inside
psql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/23/06 12:38, Sander Steffann wrote:
> Hi,
>
>>> Sure, but the check digit does not need to be stored, as it can be
>>> regenerated on demand. The user interface just verifies the check
>>> digit, then throws it away.
>>
>> $ SET GEEZER
>> $ WRIT
On Thu, 23 Nov 2006 22:31:40 -
"Gopal" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
>
>
> I have a postgres installation thats running under 70-80% CPU usage
> while
>
> an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
>
>
>
> Here's the scenario,
>
> 300 queries/sec
Is it possible to use tsearch2 to check spelling? Something like a
function that takes a single word (and a language id) and returns true
if spelled correctly false otherwise.
Thanks.
Balazs
---(end of broadcast)---
TIP 3: Have you checked our exte
Alexander Staubo <[EMAIL PROTECTED]> writes:
> On Nov 23, 2006, at 16:27 , Tom Lane wrote:
>
> > Alexander Staubo <[EMAIL PROTECTED]> writes:
> >> My application's connections against PostgreSQL 8.1.4 seem to get
> >> stuck in deletion operations.
> >> ...
> >> # select * from pg_locks where pid
On 11/23/06, Gopal <[EMAIL PROTECTED]> wrote:
I have a postgres installation thats running under 70-80% CPU usage while
an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
i somehow doubt ms sql server is 35x faster than postgresql in
production environments, even on window
56 matches
Mail list logo
