I am trying to
load some 5000 records now. It is still running for past 15 minutes, but when I
check the table still I do not see records .And there is no status as how many records
are inserted. Just left it like that .Also there are couple of issues. I have
timestamp columns. In the excel
On Sat, Feb 19, 2005 at 13:30:49 -,
Richard Crawley <[EMAIL PROTECTED]> wrote:
>
> I suppose what I'm doing is building some quite large, complicated views.
> Now, thus far I haven't had much choice, and the temp tables do help
> debugging. But this approach doesn't allow the dbase any opt
Hi All,
I have a problem in updating a table using copy commands. To brief you about the table, the table has 6 columns in which it has one column for a sequence number which increments by one on each entry. There is a constraint check for one of the columns. I am copying data in all the 6 c
Craig Bryden wrote:
Hi
I am trying to read a data set in ADO. If I exclude a timestamp field that I
have in the return type, all works wonderfully. The moment I include the
timestamp (i've even tried casting it as date) it bombs out with an OLEDB
Exception of some type.
Try reading the text of t
Jerry LeVan <[EMAIL PROTECTED]> writes:
> There have been some recent discussions on Shared Memory problems
> in Darwin on the darwin-kernel list at lists.apple.com.
> The subject is : shm_open and mmap: Invalid argument?
> Tain't clear to me if this is relevant to the MacOS X and
> Postgresql sh
On Mon, Feb 21, 2005 at 03:45:42PM -0800, Mohsen Pahlevanzadeh wrote:
> 2.How i see name of my tables in shell?
> 3.How i see name of my DBs in shell?
See the psql documentation:
http://www.postgresql.org/docs/8.0/static/app-psql.html
See also "System Catalogs" and "The Information Schema":
ht
On Mon, 21 Feb 2005 15:42:15 -0800 (PST), Alonso "García" <[EMAIL PROTECTED]>
wrote:
> !Hi list¡:
> Does anybody have information about the use of
> delphi and Postgresql?
> I have installed the version 8.0 of Postgresql and
> Delphi 7 entreprise.
You have a few choices
zeos library
odbc
Dears,I'm newbie in pgsql.
I have a few question:
1.I need to use command of MySQL in pgsql.
2.How i see name of my tables in shell?
3.How i see name of my DBs in shell?
4.How i retrieve tables's name in C?
5.How i retrieve DBs's name in C?
Yours,Mohsen.
---(end of broadca
!Hi list¡:
Does anybody have information about the use of
delphi and Postgresql?
I have installed the version 8.0 of Postgresql and
Delphi 7 entreprise.
And, do you have information about MySQL an Postgresql
(a comparision)?.
THANK YOU.
__
Do Yo
any sample code?
regards,
-
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 21, 2005, at 2:05 PM, Craig Bryden wrote:
Hi
I am trying to read a data set in ADO. If I exclude a timestamp field
that I
have in the return type, all works wonderfully. The moment I incl
Hello Tom,
Monday, February 21, 2005, 4:27:42 PM, you wrote:
>> initdb fails with the following informations:
>> copying template1 to template0 ... cp:
>> /usr/local/pgsql/data/base/1/16384: Invalid argument
..
>> FATAL: could not initialize database directory
>> initdb: removing data directory
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
> Christopher Browne replied:
>> If you've got tens of thousands of relations, the tab completion code
>> has to draw the whole list of relations from pg_class into memory and
>> "marshal" it into a form usable by GNU Readline.
> Well, it's actuall
On Mon, Feb 21, 2005 at 01:27:58PM -0800, Mohsen Pahlevanzadeh wrote:
> Dears,I have started to working with libpq.But i don't know name of its
> header files.Please guide me.
See the libpq documentation for the version of PostgreSQL you're
using. Here's a link to the most recent version:
h
Dears,I have started to working with libpq.But i don't know name of its
header files.Please guide me.
Yours,Mohsen.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Feb 21, 2005, at 3:02 PM, Hrishikesh Deshmukh wrote:
I am a newbie to postgresql, i download the windows version and
installed it successfully.
I have a posgres dump file from a linux box, i want to read in this
file on my windows box. How does one do it.
The exact method depends on the format o
Hi
I am trying to read a data set in ADO. If I exclude a timestamp field that I
have in the return type, all works wonderfully. The moment I include the
timestamp (i've even tried casting it as date) it bombs out with an OLEDB
Exception of some type.
Has anyone got any ideas?
Thanks
Craig
Hi All,
I am a newbie to postgresql, i download the windows version and
installed it successfully.
I have a posgres dump file from a linux box, i want to read in this
file on my windows box. How does one do it.
Thanks in advance.
Hrishi
---(end of broadcast)-
>Greg wrote:
> > is "DROP TRIGGER" transaction safe?... I mean, could I do:
> >
> > BEGIN
> > DROP TRIGGER category_mv_ut;
> > ... insert rows
> > ... update materialized view table
> > CREATE TRIGGER category_mv_ut AFTER UPDATE ON items
> > FOR EACH ROW EXECUTE PROCEDURE update_ut();
> > COMMIT;
There have been some recent discussions on Shared Memory problems
in Darwin on the darwin-kernel list at lists.apple.com.
The subject is : shm_open and mmap: Invalid argument?
Tain't clear to me if this is relevant to the MacOS X and
Postgresql shared memory problem that I see mentioned here
from t
Steve Crawford wrote:
> On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote:
> > Added to TODO:
> >
> > * Add IP address to pg_stat_activity
>
> I like it. How about IP and port to differentiate multiple connections
> from the same host? Will this support IPV6?
Good point, added:
Thanks to all who've responded to my concern about scalability with
large numbers of tables. I am reasonably reassured.
I don't really care about the tab-completion speed - it's just that its
slowness was my "heads-up" to the fact that there could be something
related to number of tables to wo
The information on what 'volatile' indicates with a function includes the
following:
'VOLATILE indicates that the function value can change even within a single
table scan, so no optimizations can be made. Relatively few database
functions are volatile in this sense; some examples are random(), cu
The information on what 'volatile' indicates with a function includes
the following:
'VOLATILE indicates that the function value can change even within a
single table scan, so no optimizations can be made. Relatively few
database functions are volatile in this sense; some examples are
random(), cu
Russell Smith wrote:
On Mon, 21 Feb 2005 08:05 pm, Surabhi Ahuja wrote:
it now says:
i do the following
make sample
LDLIBRARY = /usr/local/pgsql/lib ./sample
LDLIBRARY: Command not found.
do you still experience problems when you run
LDLIBRARY=/usr/local/pgsql/lib ./sample
Note there is no
I have hit this as well though unlike Tony my errors are generally not test
cases!
If for example you mistype a column/variable name inside the function
Postgres will create and allow the function to run as long as the path
through the function containing the error is not executed.
It would be
Ragnar Hafstað wrote:
On Sun, 2005-02-20 at 20:01 -0500, phil campaigne wrote:
Hi gnari,
I forgot one thing. I also need to restrict the selecct with two more
qualifiers
where contest_id =1 and team='Duke'
I'm confused where to put it in the select statement. I tried this but
it doesn't work
Hello Tom,
thanks four your answer.
>> Anything I can do?
> Complain to some FreeBSD hackers? This seems like it must be a kernel
> bug (or perhaps a bug in cp itself). I don't think Postgres did
> anything wrong.
I´ll update the machine to the lastest version, Infos follows.
--
Best rega
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Phil Endecott wrote:
> For example I find that tab-completion in psql is now unusably slow
...
Christopher Browne replied:
> If you've got tens of thousands of relations, the tab completion code
> has to draw the whole list of relations from pg_clas
On Mon, Feb 21, 2005 at 02:22:20PM +0530, Surabhi Ahuja wrote:
> I give the following command now to compile sample.c
> gcc -o sample sample.c -I/usr/local/pgsql/include -L/usr/local/pgsql/lib
> -rpath/usr/local/pgsql/lib - lpq
>
> it gives this message:
> gcc: unrecognized option `-rpath/usr/
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:49, Geoffrey KRETZ wrote:
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) VALUES (
On Mon, 2005-02-21 at 09:49, Geoffrey KRETZ wrote:
> Scott Marlowe wrote:
>
> >On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
> >
> >
> >>Hi,
> >>
> >>I've got a question about a difference beetween PGS 7.2 and PGS 7.4
> >>behaviours.
> >>
> >>With PGS 7.2 :
> >> INSERT INTO table (col1, co
Jeremiah Megie <[EMAIL PROTECTED]> writes:
> Warning: pg_connect(): Unable to connect to PostgreSQL server: could
> not connect to server: Permission denied Is the server running locally
> and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Check the file permissions on the socke
Geoffrey KRETZ <[EMAIL PROTECTED]> writes:
> I've got a question about a difference beetween PGS 7.2 and PGS 7.4
> behaviours.
> With PGS 7.2 :
> INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
> With PGS 7.4 :
> INSERT INTO table (col1, col2) VALUES (val1) failed
> Is it a known bu
I've used postgres before numerous times, but I can't seem to correct
this issue. I am using PostgreSQL 7.3.4 and Fedora Core 1. I had
postgres setup and working correctly. My php scripts were interfacing
with it, no problems.
We then had our server re-formatted and had ensim installed. The
vi
Magnus Hagander wrote:
I know that part - I have my tickets already. I meant attendants, not
speakers.
Ups sorry :-)
/BL
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Geoffrey KRETZ wrote:
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
With PGS 7.4 :
INSERT INTO table (col1, col
Magnus Hagander wrote:
Speaking of which, are there any other interesting (or non-interesting)
people from the community that are gonig to be there? I know I am...
Please take a look for yourself : http://www.linuxforum.dk/2005/en
/BL
---(end of broadcast)
> >Speaking of which, are there any other interesting (or
> non-interesting)
> >people from the community that are gonig to be there? I know I am...
> >
> >
> Please take a look for yourself : http://www.linuxforum.dk/2005/en
I know that part - I have my tickets already. I meant attendants, no
Bo Lorentsen wrote:
> Bruce Momjian wrote:
>
> >We hope to have shared row locks in 8.1 for this usage.
> >
> >
> Thanks, and good news, and just what I hoped for. Are there some kind af
> priority orderet todo list somewhere ?
Sorry, no priority because we are all volunteers, though Alvaro ha
Csaba Nagy wrote:
> [snip]
> > We hope to have shared row locks in 8.1 for this usage.
>
> This feature is one I'm really waiting for ! Is there any estimate when
> 8.1 comes out ?
> I know, I know, the preferred answer is "whenever it's ready", but if
> 8.1 is not that far away, and shared row l
[EMAIL PROTECTED] writes:
> I have downloaded release 8.x for installation. Compilation and so on
> works fine (FreeBSD 5.2.1)
> initdb fails with the following informations:
> copying template1 to template0 ... cp: /usr/local/pgsql/data/base/1/16384:
> Invalid argument
> cp: /usr/local/pgsql/da
On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
> Hi,
>
> I've got a question about a difference beetween PGS 7.2 and PGS 7.4
> behaviours.
>
> With PGS 7.2 :
> INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
>
> With PGS 7.4 :
> INSERT INTO table (col1, col2) VALUES (val1) faile
Tony Caduto wrote:
> Bruce,
> On another note, is there plans to improve the type checking of stored
> functions during the save/compile?
> Currently I can pretty much make tons of mistakes (on purpose of course
> :-) and they are not flagged as errors until runtime.
> The biggest complaint I see
Scott Marlowe wrote:
On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
With PGS 7.4 :
INSERT INTO table (col1, col2) VALUES (val1) faile
> >We hope to have shared row locks in 8.1 for this usage.
> >
> >
> Thanks, and good news, and just what I hoped for. Are there
> some kind af priority orderet todo list somewhere ?
>
> Looking forward to, see You in copenhagen af LinuxForum 2005.
Speaking of which, are there any other intere
Hi,
I've got a question about a difference beetween PGS 7.2 and PGS 7.4
behaviours.
With PGS 7.2 :
INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
With PGS 7.4 :
INSERT INTO table (col1, col2) VALUES (val1) failed
Is it a known bug ?
Thx.
Geoffrey KRETZ
Four J's Development Tools
--
Bruce Momjian wrote:
We hope to have shared row locks in 8.1 for this usage.
Thanks, and good news, and just what I hoped for. Are there some kind af
priority orderet todo list somewhere ?
Looking forward to, see You in copenhagen af LinuxForum 2005.
/BL
---(end of broa
[snip]
> We hope to have shared row locks in 8.1 for this usage.
This feature is one I'm really waiting for ! Is there any estimate when
8.1 comes out ?
I know, I know, the preferred answer is "whenever it's ready", but if
8.1 is not that far away, and shared row locking will be in it, I won't
bo
Bo Lorentsen wrote:
> HI ...
>
> I have been using PG for a large project at my work (soon in
> production), and I use PG and a lot for FK/RI checks. This works nice
> when using one or two threads (cuncurrent connections), but more than
> this, and I start getting deadlocks in my FK triggers.
Hi!
Thanks, I'll try Slony-I next time - I currently lack the time to test it
beforehand on my non-production system; I'd be a bit worried about the
additional load a second PG-instance as replication slave would impose on the
machine, so at the moment I'm more confident going along the same tr
Christopher Browne wrote:
Oops! [EMAIL PROTECTED] (Phil Endecott) was seen spray-painting on a wall:
I have a single database with one schema per user. Each user has a
handful of tables, but there are lots of users, so in total the
database has thousands of tables.
If you've got tens of thousands
You might consider using Slony-I to minimize the downtime.
I haven't done an upgrade using, but know that others have, and I've
done the same using eRServer...
The idea is that you set up an 8.0.1 backend, and set up replication
well ahead of time. Replicate from the 7.4 system to the 8.0 one.
I'm pretty sure that slowness of tab completion has little to do with
the performance of the filesystems.
If you've got tens of thousands of relations, the tab completion code
has to draw the whole list of relations from pg_class into memory and
"marshal" it into a form usable by GNU Readline. TH
Quoth [EMAIL PROTECTED] ("Markus Wollny"):
> Finally the time has come for us to upgrade our PostgreSQL
> 7.4.5-servers to 8.0.1 - and though I'm very much looking forward to
> some of the new features, the dump&reload process is worrying me a
> bit this time. I've got one cluster in particular whi
Oops! [EMAIL PROTECTED] (Phil Endecott) was seen spray-painting on a wall:
> Dear Postgresql experts,
>
> I have a single database with one schema per user. Each user has a
> handful of tables, but there are lots of users, so in total the
> database has thousands of tables.
>
> I'm a bit concerned
Hi!
Thanks very much, this was exactly the kind of advice I was hoping for! I'll
give the WAL to ramdisk thing a try; fsync is off by default anyways - the data
in this cluster is not so valuable as not to risk one day of rollback for the
performance gain of having fsync turned off and I'm doin
Hello Oleg,
Yes, thanks - I have installed this patch as soon as it became available.
Concerning my largest database, I haven't yet migrated that to tsearch2 - it's
still tsearch1-based, so I intend to drop ts1 before the last dump, reload the
database with PostgreSQL 8.0.1 and deploy tsearch2
i have written a program:
#include#include
int main(){ PGconn
*myconnection = PQconnectdb("host = indra user = surabi password = test123 port
= 5432 dbname=bpsimple");
if(PQstatus(myconnection) ==
CONNECTION_OK)
printf("Connection made\n");
else
> Hello!
>
> Finally the time has come for us to upgrade our PostgreSQL
> 7.4.5-servers to 8.0.1 - and though I'm very much looking
> forward to some of the new features, the dump&reload process
> is worrying me a bit this time. I've got one cluster in
> particular which is roughly 9GB in size
Title: Tracing of tables deleting - how?
Hello, pgsql-general :)
I have a task to make a some actions on 'deleting table' event. It event my be raise both stored procederes and any other's ways (pgAdmin GUI for example).
Is any solutions for trace it and execute some actions before/after
Shaun Clements wrote:
RE: [GENERAL] Porting MySQL PHP to Postgres
I assumed as much. I was hoping there was a tool
available which someone had used and (or) what kind of stumbling blocks
to run into.
There's useful articles at:
http://www.sitepoint.com/article/site-mysql-postgresql-
El Jue 17 Feb 2005 14:27, Hugo escribió:
> hi, is it possible to change the user's password from a stored
> procedure or a funcion? I mean , is there a system function/stored
> procedure that can do it? like the dbo.sp_password found in Adaptive
> server anywhare?
Why not use ALTER USER?
--
08
Title: RE: [GENERAL] Porting MySQL PHP to Postgres
Hi Russel
I assumed as much. I was hoping there was a tool available which someone had used and (or) what kind of stumbling blocks to run into.
Thanks again.
Kind Regards,
Shaun Clements
-Original Message-
From: Russell Smith [
yes ..it worked thank u.
On Mon, 21 Feb 2005 08:41 pm, you wrote:
> Hi All
>
> I am going to attempt to move an Intranet Application across from MySQL, to
> Postgres.
> I would like to know is there any best method / tool to do this.
> The application is written in PHP. Perhaps there is someone who is using
> Postgres, wh
On Mon, 21 Feb 2005 08:05 pm, Surabhi Ahuja wrote:
> it now says:
>
> i do the following
>
> make sample
> LDLIBRARY = /usr/local/pgsql/lib ./sample
>
>
> LDLIBRARY: Command not found.
>
>
> do you still experience problems when you run
> LDLIBRARY=/usr/local/pgsql/lib ./sample
Note there
On Sun, 20 Feb 2005, Phil Endecott wrote:
Dear Postgresql experts,
I have a single database with one schema per user. Each user has a handful
of tables, but there are lots of users, so in total the database has
thousands of tables.
I'm a bit concerned about scalability as this continues to grow
Hi there,
I have downloaded release 8.x for installation. Compilation and so on
works fine (FreeBSD 5.2.1)
initdb fails with the following informations:
copying template1 to template0 ... cp: /usr/local/pgsql/data/base/1/16384:
Invalid argument
cp: /usr/local/pgsql/data/base/1/17175: Invalid ar
Markus,
have you read updated
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
about regprocedure_7.4.patch.gz and regprocedure_update.sql ?
Oleg
On Mon, 21 Feb 2005, Markus Wollny wrote:
Hello!
Finally the time has come for us to upgrade our PostgreSQL 7.4.5-serve
On Fri, 18 Feb 2005, Wang, Mary Y wrote:
Hi All,
I have been using PostgreSQL for my project repository, because it is
free and easy to use. My manager is trying to decide if he should use a
commerical database such as Oracle or PostgreSQL for a gaint information
repository for the corporate. He
On Sun, 20 Feb 2005 12:35:02 -0300 (ART), Clodoaldo Pinto
<[EMAIL PROTECTED]> wrote:
> I made the same experience now with PG 8.01, FC3 and 512MB memory. The
> previous
> was PG 7.4.6, FC2 and 1GB.
>
> The difference in performance between kernels 2.6.9-1.724 and 2.6.10-1.766 is
> still huge.
>
Title: [GENERAL] Porting MySQL PHP to Postgres
Hi All
I am going to attempt to move an Intranet Application across from MySQL, to Postgres.
I would like to know is there any best method / tool to do this.
The application is written in PHP. Perhaps there is someone who is using Postgres, who
Hi Markus,
Have you considered installing slony and replicate from the old version
to the new one ? It can do that, and when the replica is up to date, the
switchover will take minutes I guess.
Note that I have never done that so please ask others about that too, or
research for yourself ;-)
Chee
Title: Re: [GENERAL] error while loading shared libraries: libpq.so.3
it now says:
i do the following
make sample
LDLIBRARY = /usr/local/pgsql/lib ./sample
LDLIBRARY: Command not
found.
From: Russell Smith
[mailto:[EMAIL PROTECTED]Sent: Mon 2/21/2005 2:19 PMTo:
Surabhi Ahuja Cc: pgs
On Mon, 21 Feb 2005 06:17 pm, Surabhi Ahuja wrote:
> i have written a program sample.c
> it is as folllows:
> #include
> #include
> int main()
> {
> PGconn *myconnection = PQconnectdb("");
> printf("Hi");
> return 0;
> }
>
> I then compile this program using makefile
> mak
Title: Re: [GENERAL] error while loading shared libraries: libpq.so.3
I give the following command
now to compile sample.c
gcc -o sample sample.c
-I/usr/local/pgsql/include -L/usr/local/pgsql/lib -rpath/usr/local/pgsql/lib -
lpq
it gives this
message:gcc: unrecognized option `-rpath/usr
76 matches
Mail list logo
