create table sample(column_sample varchar(500))
insert into sample(column_sample) values('this is first row of text' ||
chr(10) || 'this is second row of text')
Now, instead of just inserting chr(10), postgres inserts chr(13) +
chr(10). Is there a way to avoid this? Database is on a linux ser
Michael Fuhr wrote:
On Fri, Mar 03, 2006 at 05:46:59PM +1100, Chris wrote:
If I look at an index:
\di+ news_pkey
Schema | Name | Type | Owner | Description | Table
+---+---+---+-+
public | news_pkey | index | chris | | news
It do
On Fri, Mar 03, 2006 at 05:46:59PM +1100, Chris wrote:
> If I look at an index:
>
> \di+ news_pkey
>
> Schema | Name | Type | Owner | Description | Table
> +---+---+---+-+
> public | news_pkey | index | chris | | news
>
>
> It does
Hi all,
I'm trying to work out which fields an index relates to.
If I look at an index:
\di+ news_pkey
Schema | Name | Type | Owner | Description | Table
+---+---+---+-+
public | news_pkey | index | chris | | news
It doesn't sho
On Mar 2, 2006, at 2:44 PM, Scott Marlowe wrote:
On Thu, 2006-03-02 at 14:41, Andrew Watkins wrote:
I'm writing a parallel/distributed application that assesses the
performance impact of frequent insertions/selects to databases on
parallel file systems in a linux cluster environment. Currentl
We also use WebObjects with PostgreSQL and it's awesome as a web
development framework. We have it deployed on Solaris and OS X Server.
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED]
ClickSpace Interactive In
After a long battle with technology, [EMAIL PROTECTED] (Reid Thompson), an
earthling, wrote:
> Hi all,
> I'm querying for feedback/comments. Wondering what the list thinks of
> the following.
>
> Assume this is to provide a production database for a small company or
> a department. Production ho
Bruce Momjian wrote:
> CSN wrote:
> > I was playing around with negative offsets:
> >
> > select * from table1 order by col1 offset -5 limit 25;
> > select * from table1 order by col1 offset -25 limit
> > 25;
> > select * from table1 order by col1 offset -250 limit
> > 25;
> >
> > They all return
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write:
> For anyone that is interested, my problem was solved on another list.
> Turns out the TRUNCATE command that I run at the beginning of the SP
> creates and holds an access exclusive lock on the table for the entire
> duration o
"Sascha Nepper" <[EMAIL PROTECTED]> writes:
> What's that "datpath" about? Is it a version problem? postgres (PostgreSQL)
> 7.3.10-RH
Yes. Your server must be PG 8.0 or 8.1. Using the "-i" switch to
override pg_dump's version check is hardly ever a good idea --- instead,
find a newer version of
Hi,
Whenever I try to pg_dump -i my database from the bash, i receive the
following error.
pg_dump: server version: pg_dump.mo; pg_dump version: 7.3.10-RH
pg_dump: proceeding despite version mismatch
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: column "datpath" does not
On Fri, Mar 03, 2006 at 09:56:40AM +1100, Noel Faux wrote:
> Which config file will tell us how big the bock sizes are?
Run the query "SHOW block_size" in the database or use pg_controldata
from the shell. It's probably 8192; changing it is done at compile time.
--
Michael Fuhr
---
Thanks for the pointers Michael!
Which config file will tell us how big the bock sizes are?
Cheers
Noel
Michael Fuhr wrote:
On Wed, Mar 01, 2006 at 04:12:53PM +1100, Noel Faux wrote:
Now after doing some searches I managed to work out that the data
corruption starts at 902292.13
On Thu, Mar 02, 2006 at 03:18:14PM -0600, Eduardo Muoz wrote:
> Hi, I'm new with pgSQL and I'm not sure why, but I
> keep getting the same error. I want to call a function
> that returns a cursor and I keep getting the following
> exception:
>
> org.postgresql.util.PSQLException: ERROR: cursor
> "
Hi, I'm new with pgSQL and I'm not sure why, but I
keep getting the same error. I want to call a function
that returns a cursor and I keep getting the following
exception:
org.postgresql.util.PSQLException: ERROR: cursor
"" does not exist
I would appreciate any help with this problem.
This is my
Hi,
I have some tables and functions in the public schema. This was
probably not the right thing to do.
I have a seperate schema with a function and table. The function does a
select on the table.
The table and function exist in public schema and betteridea schema. I
have a user betteridea
On Thu, 2006-03-02 at 14:41, Andrew Watkins wrote:
> I'm writing a parallel/distributed application that assesses the
> performance impact of frequent insertions/selects to databases on
> parallel file systems in a linux cluster environment. Currently, the
> application calls for a database ser
I'm writing a parallel/distributed application that assesses the
performance impact of frequent insertions/selects to databases on
parallel file systems in a linux cluster environment. Currently, the
application calls for a database server to be running on each node of
the cluster. Since my en
You should also be able to Windows Scripting Host for this.
It has complete ODBC connection support, generally comes installed on all
versions of windows, and Microsoft has buckets of example scripts available
on their site.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTEC
On Wed, 2006-03-01 at 16:00 -0700, Roy Souther wrote:
> I need an Open Source SQL command line tool for Windows that will let
> me script queries to a database over an ODBC connection. It must use
> ODBC because it may or may not be PostgreSQL. Some times it will but
> the rest of the time I have n
Hello,
While doing performance tests on Windows Server 2003 I get the following:
An I/O error occured while sending to the backend.
org.postgresql.util.PSQLException: An I/O error occured while sending to the
backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl
DANTE ALEXANDRA <[EMAIL PROTECTED]> writes:
> We have a question about the contrib rpm.
> To have some tools like the "start_scripts", should we :
I don't believe the RPM distribution includes contrib/start-scripts
(mainly because that contrib directory has no Makefile that would
install the scrip
Since you mentioned Java, I thought I'd mention this. There is no reason
you cannot write a command line tool using Java. I'm no Java guru, but I
quickly wrote a simple Java program to connect to PostgreSQL (on a Linux
box) from a Windows box. I used a nice command line parser library called
JSA
"Just Someone" <[EMAIL PROTECTED]> writes:
> Some more clues that might help you see if there's a real problem, is
> that the /var/lib/pgsql/data/postmaster.pid file is created with the a
> SELinux context that's different from the rest. It is created with
> system_u:object_r:file_t while the rest
Never-mind that. I'm assuming statement_timeout is what I need?
On Mar 2, 2006, at 11:01 AM, Rick Gigger wrote:
Is there a way to put a timeout on a query so that if it runs
longer than 5 minutes or something it is just automatically
terminated?
---(end of
broadc
Is there a way to put a timeout on a query so that if it runs longer
than 5 minutes or something it is just automatically terminated?
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Mar 2, 2006, at 8:34 AM, Roy Souther wrote:
CLI = Command Line Interface
GUI = Graphical User Interface
WSI = Web Server Interface
I need a CLI app. Sorry I was not clear on this.
t4esql?
Never used it, but it may be what you need. It may or may not be open
source,
so if that's a perso
Reid Thompson schrieb:
> Scott Marlowe wrote:
>
>> Then yeah, php or perl are your only choices. Again, as is often the
>> case, better to tell us what you're tying to do, and ask for
>> suggestions, then to tell us what tool you think you need, and leave us
>> guessing as to motivation. Happens
Scott Marlowe wrote:
Then yeah, php or perl are your only choices. Again, as is often the
case, better to tell us what you're tying to do, and ask for
suggestions, then to tell us what tool you think you need, and leave us
guessing as to motivation. Happens a lot though, don't worry about it.
Then yeah, php or perl are your only choices. Again, as is often the
case, better to tell us what you're tying to do, and ask for
suggestions, then to tell us what tool you think you need, and leave us
guessing as to motivation. Happens a lot though, don't worry about it.
It's just better to des
You could easily create a console application with Lazarus or Delphi to
do this, the console app could read the script from params, standard
input, or a text file and execute it
against the server of your choice using ODBC or a native interface to libpq.
Tony
---(end
Actually not semantics. I need to script the program and there is no way to script a GUI app.
I have started using PHP. Not a great solution, extreme overkill, but it does work well.
On Thu, 2006-03-02 at 11:29 -0600, Scott Marlowe wrote:
Oh no, you were perfectly clear. I wrote my post be
Hi all,
I'm querying for feedback/comments. Wondering what the list thinks of
the following.
Assume this is to provide a production database for a small company or a
department. Production hours 5am-9pm for the most part so night-time
downtime if/when necessary would not be a problem.
Pla
Oh no, you were perfectly clear. I wrote my post because I don't know
of any CLI tools for windows that do this either, so it would seem that
a decent CLI tool wrapped in a GUI would still be acceptable. I mean,
it's a question of symatics at that point. So, that's why I suggested
some of the GU
On Thu, Mar 02, 2006 at 05:17:12PM +0100, DANTE ALEXANDRA wrote:
> We have a question concerning backup / restore of database.
> Is it right if we say that for having a complete backup, we have do :
> 1. use pg_dumpall
> 2. do a backup of the modified "template1" database with pg_dump ?
>
> Our que
DANTE ALEXANDRA wrote:
> Hello,
>
> We have a question about "pg_upgrade". We work with PostGreSQL 8.1.2.
>
> We have seen that with the 8.1.0 release, some programs from contrib are
> now included in PostGreSQL, such as "dbsize".
> Is it the same thing with "pg_upgrade" ?
> Does it still exist
Hello,
We have a question concerning backup / restore of database.
Is it right if we say that for having a complete backup, we have do :
1. use pg_dumpall
2. do a backup of the modified "template1" database with pg_dump ?
Our question is how to save and restore a template database, as
"template
CLI = Command Line Interface
GUI = Graphical User Interface
WSI = Web Server Interface
I need a CLI app. Sorry I was not clear on this.
On Thu, 2006-03-02 at 10:05 -0600, Scott Marlowe wrote:
On Wed, 2006-03-01 at 17:00, Roy Souther wrote:
> I love Linux, any tool you need it has it. Just
Hello,
We have generated a rpm with PostGreSQL 8.1.2, from the "tar.gz" file,
compiled with the "icc" Intel compiler on Red Hat Enterprise Linux 4 AS.
During the compilation, we have had few warnings, but nevertheless, we
work with this rpm without trouble.
We have a question about the contr
Hello,
We have a question about "pg_upgrade". We work with PostGreSQL 8.1.2.
We have seen that with the 8.1.0 release, some programs from contrib are
now included in PostGreSQL, such as "dbsize".
Is it the same thing with "pg_upgrade" ?
Does it still exist ? If not, is there another tool to re
On Wed, 2006-03-01 at 17:00, Roy Souther wrote:
> I love Linux, any tool you need it has it. Just try to find the most
> basic of tools for Windows, what a joke.
>
> I need an Open Source SQL command line tool for Windows that will let
> me script queries to a database over an ODBC connection. It
On Thu, Mar 02, 2006 at 05:14:54AM -0800, Emil Rachovsky wrote:
> I'm creating a temporary table in a function and using
> Alter Table ... Without OIDs, but when the function is
Why alter the table? Why not specify WITHOUT OIDS when you create
the table?
> called for the second time I get an err
The table:
CREATE TABLE DILOSIS (
DL_AEM INT NOT NULL,
DL_CODE VARCHAR(6) NOT NULL,
DL_YEAR INT NOT NULL,
DL_GRADE FLOAT(3) NOT NULL,
DL_LESTYPE INT NOT NULL,
DL_SEMESTER INT NOT NULL,
DL_DM INT NOT NULL,
DL_COEF FLOAT(3), --Syntelesti
"A. Kretschmer" <[EMAIL PROTECTED]> writes:
> am 02.03.2006, um 4:37:02 -0800 mailte [EMAIL PROTECTED] folgendes:
>> psql: could not connect to server: Connection refused
>> Is the server running on host "server-name" and accepting
>> TCP/IP connections on port 5432?
> Check the postgresql.conf
"Ingmar Brouns" <[EMAIL PROTECTED]> writes:
> With 8.1.3 I dont have the context switch problem, however now there
> is a problem with the standard deviation of response times.
Interesting, but if you don't provide a test case it's unlikely we can
comment usefully.
regards
Are you connecting to the "console" session on your Win2K3 server or to
one of the other two available remote desktop sessions? (To connect to
the console session using the RDP client from XP, you need to inclde
"/console" at the _end_ of your command line: ie: "mstsc
/v:MyRemoteServerName /consol
falcon wrote:
Hi,
Most of the web applications I work on are nothing more than front-ends
to postgresql. I have used Perl (CGI), Java, C# and am now looking at
Django. Each generation of frameworks lessens the pain of donig
web-apps, but it still seems redundant.
Does any one know of a framewo
Drupal is really nice extensible web framework written in PHP.
http://drupal.org
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
am 02.03.2006, um 4:37:02 -0800 mailte [EMAIL PROTECTED] folgendes:
> Hi All,
>
> I have the following problem.
>
> I am able to access a PostgreSQL database only as "localhost". If I try
> to open psql from a different machine with -h option, then I get the
> following error message.
>
> The
After a long battle with technology, [EMAIL PROTECTED], an earthling, wrote:
> I need the PostgreSQL server on the machine which contains the database
> to accept socket connections.
> Any help in this regard will be appreciated.
Look for the configuration file postgresql.conf.
It is doubtless
>Have you tried vacuuming more frequently?
Yes, we vacuum every 45-60 minutes. We boarder on having a vacuum running continuously vacuuming some table in the database.
Brent
This may be a newbie question, but according to the 7.4 docs, an ACCESS
EXCLUSIVE lock is only acquired by the ALTER TABLE, DROP TABLE,
REINDEX, CLUSTER, and VACUUM FULL commands.
However, when viewing pg_locks during the execution of a stored
procedure that does not perform any of the above comma
Hi All,
I have the following problem.
I am able to access a PostgreSQL database only as "localhost". If I try
to open psql from a different machine with -h option, then I get the
following error message.
The database resides on a server running Fedora Core 4 and PostgreSQL
8.1.1 server.
I am try
Hmmm... you should name a date. The first day of Spring doesn't start here
until 1st September.
Regards
Andrew
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Thursday, 2 March 2006 06:48
To: Tony Caduto
Cc: pgsql-general@postgresql.org
Subject: Re: Special offer with
> This isn't what you asked for, but if you can afford a modest amount of downtime you could always drop/recreate the indexes.
Unfortunately, we cannot afford any down time. That is why we are looking to pay someone to help us implement Tom Lane's suggested solution.
Brent
Hi,
I try to install PostgreSQL 8.1.3 on Windows2003 server. I have no
phisical access to the server, only through remote desktop. When I run
installer, i get this message:
"The PostgreSQL installer must be run on the system console, not in a
terminal service session".
Is there anything I can do
Hello,
I'm creating a temporary table in a function and using
Alter Table ... Without OIDs, but when the function is
called for the second time I get an error "relation
with OIDs ... doesn't exist" on an insert statement to
the table. I'm using Postgre 8.0 which says that
supports without OIDs. An
I'm writing my thesis on performance testing. First I had postgresql 8.0.1 installed. However when stress
testing with multiple threads I got an unacceptable amount of context switches. Thats why I installed
8.1.3 . With 8.1.3 I dont have the context switch problem, however now there is a problem w
Mary Adel wrote:
I am wondering how i can call stored procedure from php
If anyone can help it would great for me
Very small code snippet.
$sql = "SELECT my_func('para')";
$Result = pg_query($sql);
...
Regards
Russell Smith
---(end of broadcast)-
I am wondering how i can call stored procedure from php
If anyone can help it would great for me
Thanks
Mary
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
60 matches
Mail list logo
