On May 7, 2005, at 1:10, Tom Lane wrote:
Michael Glaesemann <[EMAIL PROTECTED]> writes:
I thought that the unique key would be checked at the end of the
update
statement:
No, it's never worked that way. Each row is checked as it is inserted.
With an example like this, you may or may not get a fai
Hi Jerome,
You need to edit the pg_hba.conf file which controls the hosts Postgres will
allow to connect.
By default it's set to only allow connections from local host.
pg_hba.conf is located in the data directory of where you installed PG.
You can also tell a host to be TRUSTED, i.e no password n
On Fri, 2005-05-06 at 15:51, Aaron Steele wrote:
> dear readers,
>
> i've created a simple Fooey table that inherits from Foo:
> !--!
> CREATE TABLE Foo(
> fooid serial UNIQUE,
> footype text);
> CREATE TABLE Foo
Jonel Rienton wrote:
you know what does work, if you issue the pg_ctl stop with /usr/local/
pgsql/data2 as the argument for -D
pg_ctl -D /usr/local/pgsql/data2 stop
Yes that does work as it should. However as Tom Lane pointed out the
problem is that pg_ctl can't parse the postgresql.conf so if y
On Fri, May 06, 2005 at 01:51:45PM -0700, Aaron Steele wrote:
> dear readers,
>
> i've created a simple Fooey table that inherits from Foo:
> !--!
> CREATE TABLE Foo(
> fooid serial UNIQUE,
> footype text);
> CRE
On Fri, 6 May 2005, Aaron Steele wrote:
> dear readers,
>
> i've created a simple Fooey table that inherits from Foo:
> !--!
> CREATE TABLE Foo(
> fooid serial UNIQUE,
> footype text);
> CREATE TABLE Fooey(
>
On Thu, May 05, 2005 at 11:07:10AM -0700, Don Laurine wrote:
> We are currently transitioning to Postgresql 7.4 from Informix. IN ECPG,
> is there a Postgresql function which will convert the timestamp data
> type to a string equivalent. INFORMIX has the dtcvasc function but I
> prefer not to use
On 06/05/2005 16:22 Ying Lu wrote:
Greetings,
I tried to "Vacuum table" through JDBC. I got the following errors:
ERROR: VACUUM cannot run inside a transaction block
Does it mean I should only run vacuum through the command line such as
"psql> vacuum TableName "?
You don't say what version of t
you know what does work, if you issue the pg_ctl stop with /usr/local/
pgsql/data2 as the argument for -D
pg_ctl -D /usr/local/pgsql/data2 stop
odd tho.
On May 6, 2005, at 3:36 PM, Joshua D. Drake wrote:
Jonel Rienton wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory points
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> data_directory = '/usr/local/pgsql/data2' # use data in
> -bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc stop
Fixing this would seem to require teaching pg_ctl how to parse the
postgresql.conf file, which might be worth doing but it's
I just tried the same setup as yours, and it worked fine, i was able
to start and stop the instance.
could it be that the process didn't start at all when you started it?
regards,
-
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate
On May 6, 2005, at 3:36 PM, J
dear readers,
i've created a simple Fooey table that inherits from Foo:
!--!
CREATE TABLE Foo(
fooid serial UNIQUE,
footype text);
CREATE TABLE Fooey(
datatext);
INHERITS(Foo);
!---
Jonel Rienton wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc
might be something to look at
In version 8 you can specify the location of the data_directory with the
data_directory option
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc
might be something to look at
regards,
- -
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate
On May 6, 200
PostgreSQL 8.0.2 - Fedora 3
data_directory = '/usr/local/pgsql/data2' # use data in
hba_file = '/usr/local/pgsql/etc/pg_hba.conf' # the host-based #
ident_file = 'ConfigDir/pg_ident.conf' # the IDENT configuration file
external_pid_file = '/tmp/foo.pid' # write an ext
Hi,
I am new to PosGreSql and have problem connecting to PostGreSql from a
machine with pslodbc driver. I don't know what is wrong but in my
simple code to connect to the database using ODBCConnection from the
server machine, it does not send out error message when I specify the
server as 'localh
I'm using 9.3 and postgresql-8.0.1-6. I started Rekall which opens the
database connection wizard.
As the RDBMsS Server Type I pick the only one available:the Rekal PgSQL
Driver (Shouldn't there be drivers for other DB's in the type list also?)
The comment from the Rekal PgSQL driver dia
Hrishikesh Deshmukh wrote:
Hi All,
Does Postgresql have a "sql history of queries run" capability?
Any ideas/pointers will be a great help. Could one capture the order
and SQL queries run?!
If you are using psql there is .psql_history.
Thanks in advance and your help is appreciated.
Hrishi
I am not sure how I could encode the characters into UTF-8.
For example, I went to Unicode.org and looked up in the specs for lets say
an â is 00E2. If I wanted to do search for all names with an â in them how
would I do that?
00E2 into Octal is: 342
So would I do:
Select * from table where n
On Fri, May 06, 2005 at 05:42:38PM +0100, Peter Wilson wrote:
> I got the lack of schema changes from the Slony documentation.
This seems odd. I see Brad already told you what to look for; but
putting schema changes in through slonik was _always_ part of the
design. What's always been true (and
On Fri, May 06, 2005 at 12:09:14PM -0400, Chris Browne wrote:
> What I need, for that, is a way of grabbing all the index definitions
> for the table. One way to do that would be to run "pg_dump -s -t a",
> though I'd rather have a method that uses the connection I already
> have to the database.
On Fri, 2005-05-06 at 12:48, Hrishikesh Deshmukh wrote:
> Hi All,
>
> Does Postgresql have a "sql history of queries run" capability?
> Any ideas/pointers will be a great help. Could one capture the order
> and SQL queries run?!
>
> Thanks in advance and your help is appreciated.
There's a setti
--- [EMAIL PROTECTED] wrote:
>
> I was pleased with the progress I could make with Visual Basic and
> Postgresql, as well as what I could do through MS Access. But it
> would be so nice to have something that paints screens quickly and
> allows one to develop things fast. Powerbuilder was nice
Peter Wilson wrote:
Andrew Sullivan wrote:
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony
are over DBmirror? As far as I can see:
+ both are async Master->multiple slaves
+ both (I think) can do cascaded replicatio
Hi All,
Does Postgresql have a "sql history of queries run" capability?
Any ideas/pointers will be a great help. Could one capture the order
and SQL queries run?!
Thanks in advance and your help is appreciated.
Hrishi
---(end of broadcast)---
TIP
[EMAIL PROTECTED] (Jeff -) writes:
> On May 5, 2005, at 5:03 PM, Grant McLean wrote:
>>
>> Why would you need to take anything down to run pg_dump? And surely
>> bringing a slave up to speed using Slony would be much slower than
>> dump/restore?
>>
>
> You'd need to stop client access to PG to pre
Andrew Sullivan wrote:
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
Looking at Slony now, can someone tell me what the benefits of Slony are
over DBmirror? As far as I can see:
+ both are async Master->multiple slaves
+ both (I think) can do cascaded replication
This isn't really
On Thu, May 05, 2005 at 03:35:27PM +0100, Peter Wilson wrote:
> Looking at Slony now, can someone tell me what the benefits of Slony are
> over DBmirror? As far as I can see:
> + both are async Master->multiple slaves
> + both (I think) can do cascaded replication
This isn't really true of dbmirr
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> I thought that the unique key would be checked at the end of the update
> statement:
No, it's never worked that way. Each row is checked as it is inserted.
With an example like this, you may or may not get a failure depending on
chance physical o
On Fri, May 06, 2005 at 09:01:58AM -0400, Jeff - wrote:
> slave and hten fire up dbmirror. Although it might work if you
> install the dbmirror triggers, then dump & restore.
It's a little trickier than that, but yes, it might work. Somewhere
in my mail archives, I have a very angry rant about
[EMAIL PROTECTED] (Tony Caduto) writes:
> That's what was said 7 years ago. guess what it's still around
> and going strong. This is one of the most ridiculous arguments
> against using Delphi, every year people like you say this, then 7
> years go by and your still wrong
I wasn't the one
Hello all!
I've been working on a plpgsql function for the past couple of days and
have been wondering why it's been failing to update a table with
composite keys (where the key is a combination of two columns). I
thought it was a problem with my function code, but it appears to be
rooted i
Ying Lu wrote:
Greetings,
I tried to "Vacuum table" through JDBC. I got the following errors:
ERROR: VACUUM cannot run inside a transaction block
Does it mean I should only run vacuum through the command line such as
"psql> vacuum TableName "?
Nope, it means exactly what the error says. You ar
Greetings,
I tried to "Vacuum table" through JDBC. I got the following errors:
ERROR: VACUUM cannot run inside a transaction block
Does it mean I should only run vacuum through the command line such as
"psql> vacuum TableName "?
Thanks a lot,
Emi
---(end of broadcast)--
Michael Korotun wrote:
Yes, this is oom
Firstly it killed httpd and then postmaster. But who took all the memory? I
see there Free swap: 0Kb in the messages log - was it a reason?
Sounds likely.
I have 1GB of RAM. For shared memory I took about 262MB.
/etc/sysctl.conf
===
#shared me
They are if you are doing any of your research at work :-)
I started using Delphi for shareware/hobby products and while the
initial investment was higher, I reap the benefits of a huge third party
and open source component environment.
Lets see, say you need a syntax highlighting editor componen
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
>
> It is just too bad that there is not a better, more user friendly, well
> documented front-end tool for Postgresql in open source. It really is
> kind of a
> marketing issue, in a way. I mean, if someone could really put together
>
That's what was said 7 years ago. guess what it's still around and
going strong.
This is one of the most ridiculous arguments against using Delphi, every
year people
like you say this, then 7 years go by and your still wrong
The problem with Delphi is that it is uncertain where it will s
On Fri, 2005-05-06 at 07:54, Michael Korotun wrote:
> Hi Guys,
>
>
>
> I am writing here again. Here is the scenario of my problem:
>
>
>
> I have Postgres 8.0.1 on Linux FC3 and everything goes fine, except
> that a one time per week approximately I am getting server crash with
> a message
Michael Korotun wrote:
I have Postgres 8.0.1 on Linux FC3 and everything goes fine, except that a
one time per week approximately I am getting server crash with a message in
log:
LOG: server process (PID 5252) was terminated by signal 9
Sounds like something is sending SIGKILL (kill -9) to your b
Nageshwar Rao wrote:
How to extract date(mm/dd/yyy) from a timestamp .
See chapter 9.8. Data Type Formatting Functions, all about to_char()
If you just want your preset format you can use SELECT now()::date;
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
Peter Wilson wrote:
Grant McLean wrote:
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
One of the biggest things for Slony is that you can install slony,
set things up and it will bring the slave(s) "up to speed". You
don't need to do an initial data dump (I think you still need to
load th
On Fri, May 06, 2005 at 06:26:14PM +0530, Nageshwar Rao wrote:
>
> How to extract date(mm/dd/yyy) from a timestamp .
You could cast the timestamp to date. See also "Data Type Formatting
Functions" and "Date/Time Functions and Operators" in the "Functions
and Operators" chapter of the documentatio
On Fri, May 06, 2005 at 05:58:11AM -0700, Vidya wrote:
>
> How do I create a cursor in psql .
>
> I have a function which opens a cursor .
> SampleDB=# create function reffunc(refcursor) returns refcursor as $$
> SampleDB$# begin
> SampleDB$# open $1 for select col from test;
> SampleDB$# return
Title: Extracting date from timestamp
How to extract date(mm/dd/yyy) from a timestamp .
Hello All,
How do I create a cursor in psql .
I have a function which opens a cursor .
SampleDB=# create function reffunc(refcursor) returns refcursor as $$SampleDB$# beginSampleDB$# open $1 for select col from test;SampleDB$# return $1;SampleDB$# end;SampleDB$# $$ language sql;ERROR: syntax err
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Zlatko Matic")
wrote:
> It seems that many people fanatically recommend Delphi, while others
> fanaticaly despise Delphi. I've sent a question about comparative
> features of MS Access/Visual Studio/Delphi for working with
> databases
On May 5, 2005, at 5:03 PM, Grant McLean wrote:
Why would you need to take anything down to run pg_dump? And surely
bringing a slave up to speed using Slony would be much slower than
dump/restore?
You'd need to stop client access to PG to prevent changes from
occuring between when you take the d
Hi Guys,
I am writing here again. Here is the scenario of my
problem:
I have Postgres 8.0.1 on Linux FC3 and everything
goes fine, except that a one time per week approximately I am getting server
crash with a message in log:
==
LOG: server process (PID
On Thu, May 05, 2005 at 03:21:40PM +0100, Peter Wilson wrote:
> Why is this documentation on 'Christoper B. Browns homepage rather than
> the Slony web pages? The 'official' Slony documentation I had available
> was at :
> http://gborg.postgresql.org/project/slony1/genpage.php?howto_idx
>
On Fri, 6 May 2005 07:50 pm, CSN wrote:
> I followed the new instructions (patch, autoconf,
> configure --with-php=/usr/lib/apache/libphp5.so, etc.)
> and get this error when running 'make':
>
> make[3]: Entering directory
> `/usr/local/src/postgresql-8.0.2/src/pl/plphp'
> patching file php.h
It c
I followed the new instructions (patch, autoconf,
configure --with-php=/usr/lib/apache/libphp5.so, etc.)
and get this error when running 'make':
make[3]: Entering directory
`/usr/local/src/postgresql-8.0.2/src/pl/plphp'
patching file php.h
Hunk #1 FAILED at 291.
1 out of 1 hunk FAILED -- saving re
Mark Borins wrote:
> The encoding on my DB is Unicode, so far I have found an unaccent() function
> by looking in the mail archives it looks like the following:
>
>
> CREATE FUNCTION unaccent(text) RETURNS text AS $$
>BEGIN
>RETURN translate($1, '\342\347\350\351\352\364\373'
Grant McLean wrote:
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
One of the biggest things for Slony is that you can install slony,
set things up and it will bring the slave(s) "up to speed". You
don't need to do an initial data dump (I think you still need to load
the schema on the slav
Ying Lu wrote:
Greetings,
Through java - JDBC, trying to do "select * from Table" using "lock
table IN SHARE MODE"; Always got this error:
"current transaction is aborted, commands ignored until end of
transaction block"
One of your commands has an error, and the transaction has been aborted
be
I suppose, with regard to the question of Delphi, one might simply line up
and summarize or itemize all of the items and points PRO and CON.
One finds such PRO and CON lists for Postgresql vs MySQL vs Oracle, for
Linux vs Windows,... for so many things.
But, its all analogous to an ocean v
I am convinced that Tony Caduto is correct in everything he says about
Delphi.
If you are with some Company, and you have your full time to devote to
programming, and the support of a staff and a budget, why I am sure you can make
anything work for you. If you throw enough time and money an
Franco Bruno Borghesi wrote:
You could write a trigger like this:
CREATE OR REPLACE FUNCTION checkDate() RETURNS TRIGGER LANGUAGE 'plpgsql'
AS '
DECLARE
limitDate DATE DEFAULT current_date-''1 year''::INTERVAL;
BEGIN
IF (OLD.date<=limitDate) THEN
RAISE EXCEPTION ''C
Thanks, everyone, for suggestions regarding QT. I did find
a good book on QT in the computer section of a bookstore and spent quite some
time looking at it, the "hello world" exercise, and almost purchased it.
But I know from past experience that I am not going to make a lot of progress
t
59 matches
Mail list logo
