In order to move data and tables from MS SQL Server to PostgreSQL, use the
MS SQL Server DTS wizard and gave it the ODBC for PostgreSQL as the target
database.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/23/07, Robert Fitzpatrick [EMAIL PROTECTED] wrote:
On Mon,
Hi Bruno,
Am Montag, 22. Jan 2007, 23:11:41 -0600 schrieb Bruno Wolff III:
If the web server is running on the same machine as the DB,
then consider using ident authentication and connecting using domain sockets.
Ah, a good suggestion. Thanks!
I found an exhaustive documentation on
Hi all,
The *array_to_string *function used to compare the content of arrays of
doubles doesn't return the same result if the OS is Windows or if it is
a Linux system.
Here is an example using the same table content:
Result 1: 0,0.000263,*8e-06*,*8e-06*,0.000146,0.000321 [PostgreSQL
8.0.4
On Mon, Jan 22, 2007 at 05:32:13PM -0600, George Weaver wrote:
Hi all,
I have installed version 8.2.1 and downloaded the source tree in order to
compile a number of C-functions.
I have been compiling from source for contrib files and c-functions since
version 7.3 without problem.
I
On Tue, Jan 23, 2007 at 09:23:06AM +0100, Pascal Lequeux wrote:
Hi all,
The *array_to_string *function used to compare the content of arrays of
doubles doesn't return the same result if the OS is Windows or if it is
a Linux system.
Here is an example using the same table content:
On Mon, 2007-01-22 at 20:56, Lenorovitz, Joel wrote:
[snip]
ERROR: too many trigger records found for relation item
I've got this error on a development data base where we were
continuously creating new child tables referencing the same parent
table. The responsible code is in
Hi,
I have a slow response of my PostgreSQL database 7.4 using this query below
on a table with 80 rows:
select count(*)from tbl;
PostgreSQL return result in 28 sec every time.
although MS-SQL return result in 0.02 sec every time.
My server is a DELL PowerEdge 2600 with bi-processor Xeon
am Tue, dem 23.01.2007, um 12:11:40 +0100 mailte Laurent Manchon folgendes:
Hi,
I have a slow response of my PostgreSQL database 7.4 using this query below
on a table with 80 rows:
select count(*)from tbl;
How often do you want to ask the very same question?
You have enough answers,
Chad Wagner [EMAIL PROTECTED] writes:
Most people do this with a calendar table, worst case is you could use
generate_series to do it (but it's ugly, and it may not scale well --
haven't tested it) and left join it to your data table.
select cal.date, coalesce(foo.x, 0) AS x
from (select
- Original Message From: Magnus Hagander
What configure command did you run, exactly?
configure --without-zlib
I did solve the problem(?) by downloading the full distribution and using it
rather than the base distribution. With the full distribution everything
worked just as
On 1/23/07, Jorge Godoy [EMAIL PROTECTED] wrote:
select cal.date, coalesce(foo.x, 0) AS x
from (select (date_trunc('day', current_timestamp) + (s.s * interval '1
day'))::date AS date
from generate_series(1,365) AS s) AS cal
left join foo ON cal.date = foo.create_date;
Why not,
Nevertheless, the database should be able to handle any combination of
syntactically correct SQL statements without throwing errors and
maintaining the database in a consistent state. If what you're saying
is right, the error thrown here is not a user configuration error, but
an RDBMS
There are a couple of PostgreSQL tutorials around the web to make it
work with WHM.
I have followed them. Downloaded the *.rpm files and installed them.
Then gone
into my WHM (https://myserver:2087) and enabled the config, and set up
the postgres user with an su command adduser postgres.
Now
On 23.01.2007 15:10 [EMAIL PROTECTED] wrote:
Now what?
1. Where's the interactive shell?
http://www.postgresql.org/docs/8.2/static/app-psql.html
How can I start creating a database,
http://www.postgresql.org/docs/8.2/static/app-createdb.html
creating users, testing things out?
On Tue, 2007-01-23 at 14:49, Brandon Aiken wrote:
Nevertheless, the database should be able to handle any combination of
syntactically correct SQL statements without throwing errors and
maintaining the database in a consistent state. If what you're saying
is right, the error thrown here is
Martijn van Oosterhout kleptog@svana.org writes:
If you created such a function, and made an operator with it that was a
communtator of LIKE (call it is liked by), would the planner be smart
enough to split the ANY and commutate it to the normal order?
No, at least not as of 8.2, because ANY
Csaba Nagy [EMAIL PROTECTED] writes:
The responsible code is in src/backend/commands/trigger.c, and I
think it only happens if you manage to create/drop a new trigger (which
also could be a FK trigger created by a new foreign key referencing that
table, as in our case) exactly between that
Thanks Thomas.
But:
- psql at the command says
psql: FATAL: database root does not exist
- psql -d postgres at the command says
psql: FATAL: role root does not exist
How should I create the first database, or the first user etc? The
links you suggested are all *after* I login to the
Erick,
psql -U postgres
should help.
I hope you remembered the password you gave to the database superuser while
installing...
best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Out of curiosity, has the COUNT(*) with no WHERE clause slowness been
fixed in 8.x? Or is it still an issue of there's no solution that
won't harm aggregates with WHERE clauses?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Erick Papadakis wrote:
Thanks Thomas.
Please don't top-post, it disturbes the flow of the communication.
But:
- psql at the command says
psql: FATAL: database root does not exist
- psql -d postgres at the command says
psql: FATAL: role root does not exist
How should I create
Doesn't work:
- psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
- psql -U postgres -W
psql: FATAL: Ident authentication failed for user postgres
Would appreciate some insights. Where's the step by step guide to make
this work? Cpanel/WHM and Plesk are THE
Please don't top-post, it disturbes the flow of the communication.
Interesting. I prefer getting to the point an author is making.
There's documentation about that too, at the end of the installation
instructions IIRC.
I did not see them. Please point me? I'd deeply appreciate it.
Erick Papadakis schrieb:
Doesn't work:
- psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
- psql -U postgres -W
psql: FATAL: Ident authentication failed for user postgres
Would appreciate some insights. Where's the step by step guide to make
this work?
Erick Papadakis [EMAIL PROTECTED] writes:
Doesn't work:
- psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
su to postgres, then psql will let you in. Or you can RTFM about
changing the default authentication method ...
regards, tom lane
am Tue, dem 23.01.2007, um 10:12:13 -0500 mailte Brandon Aiken folgendes:
Out of curiosity, has the COUNT(*) with no WHERE clause slowness been
fixed in 8.x? Or is it still an issue of there's no solution that
won't harm aggregates with WHERE clauses?
I will try it:
scholl=# \timing
Timing
Erick,
- psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
Nice. This gives us some more information about what kind of client
authorization is configured by cpanel.
You can read everything about client-autorisation on:
On 1/23/07, Erick Papadakis [EMAIL PROTECTED] wrote:
Doesn't work:
- psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
- psql -U postgres -W
psql: FATAL: Ident authentication failed for user postgres
that is saying you need to have the password to login to
A. Kretschmer schrieb:
am Tue, dem 23.01.2007, um 10:12:13 -0500 mailte Brandon Aiken folgendes:
Out of curiosity, has the COUNT(*) with no WHERE clause slowness been
fixed in 8.x? Or is it still an issue of there's no solution that
won't harm aggregates with WHERE clauses?
I will try it:
Tom Lane wrote:
Erik Jones [EMAIL PROTECTED] writes:
... I was previously under the impression that by
tracking age(datfrozenxid) in pg_database over time I'd be able to know
how many transactions were processed in a certain amount of time.
However, I've seend that
Hello all,
I have a setup in which four client machines access
a Postgres database (8.1.1) running on a Linux box.
So, there are connections from each machine to the
database; hence, the Linux box has about 2 postgres
processes associated with each machine.
I am using the JDBC driver
On Tue, 2007-01-23 at 15:43, Tom Lane wrote:
Csaba Nagy [EMAIL PROTECTED] writes:
The responsible code is in src/backend/commands/trigger.c, and I
think it only happens if you manage to create/drop a new trigger (which
also could be a FK trigger created by a new foreign key referencing that
On Tue, Jan 23, 2007 at 09:30:49AM -0500, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
If you created such a function, and made an operator with it that
was a communtator of LIKE (call it is liked by), would the
planner be smart enough to split the ANY and commutate it
Csaba Nagy [EMAIL PROTECTED] writes:
On Tue, 2007-01-23 at 15:43, Tom Lane wrote:
All such code takes exclusive lock on the table, so the above
explanation is impossible.
Well, in that case it must be some other bug as it is readily
reproducible here. My nightly integration has this error
Hi Bruno,
Good to read that your advice to me is the solution I was considering!
Although I think this is something PostgreSQL should solve internally, I
prefer the WHERE clause over a long lasting SERIALIZABLE transaction.
Thanks,
Jan
-Original Message-
From: Bruno Wolff III
Hi,
I'm trying to make a new database, yet when I try to do this I get the
following error:
ERROR: xlog flush request 0/827520 is not satisfied --- flushed only to
0/80D7B8
CONTEXT: writing block 5 of relation 1663/16893/1259
Can someone give me a clue of what it means ?
Regards,
Steven
can anybody think of of a way to sneak these into dollar quoted
strings for substitution into create function?
would i would ideally like to do is (from inside psql shell)
\set foo 500
create function bar() returns int as
$$
declare
baz int default :foo;
[...]
that would eliminate the
On Mon, 22 Jan 2007, Bruno Wolff III wrote:
On Mon, Jan 22, 2007 at 20:25:48 +0100,
Bertram Scharpf [EMAIL PROTECTED] wrote:
What I want to do is the following:
1. Login in from a program on a client as a particualar user.
For this case you shouldn't need to do anything tricky as
Folks,
Although this is not really a JDBC problem, I initially posted it on the JDBC
group because I thought the Java folks would be there. I got no response, so
am posting here.
I have a PostgreSQL Java client CRUD GUI app that does backup and restore by
running pg_dump and pg_restore with a
I have created the following function :
CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text)
RETURNS bool AS
$BODY$
INSERT INTO tbl_xyz
(unmask_id,email_from)
VALUES ($1,$2)
$BODY$
LANGUAGE 'sql' VOLATILE;
when i try to create this fucntion by running this script, i get the
On 1/23/07, Jasbinder Singh Bali [EMAIL PROTECTED] wrote:
I have created the following function :
CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text)
RETURNS bool AS
$BODY$
INSERT INTO tbl_xyz
(unmask_id,email_from)
VALUES ($1,$2)
$BODY$
LANGUAGE 'sql' VOLATILE;
when i try to
Where is pg_hba.conf?
I tried find and whereis commands, but could not find it.
Thanks for any pointers.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
pg_hba.conf is within the PostgreSQL data directory.
That directory can be put everywhere by the installation routine.
usual places:
- on windows per default below \programme\postgresql\8.2\data
- within linux often below /var
I tried find and whereis commands, but could not find it.
Either
am Tue, dem 23.01.2007, um 11:51:00 -0500 mailte Jasbinder Singh Bali
folgendes:
I have created the following function :
CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text)
RETURNS bool AS
$BODY$
INSERT INTO tbl_xyz
(unmask_id,email_from)
VALUES ($1,$2)
$BODY$
LANGUAGE
Correct. Also you will find nearly no stuff about using apt-get and rpm,
which are some of the most used package systems on Linux on postgresql.org .
And nothing about emerge, which is central to Gentoo Linux. And no real
documentation to ports, which is prevalent on FreeBsd.
PostgreSQL.org has
On Tue, Jan 23, 2007 at 09:44:28 +0100,
Bertram Scharpf [EMAIL PROTECTED] wrote:
Hi Bruno,
Am Montag, 22. Jan 2007, 23:11:41 -0600 schrieb Bruno Wolff III:
If the web server is running on the same machine as the DB,
then consider using ident authentication and connecting using domain
On Tue, Jan 23, 2007 at 09:01:56 -0800,
Richard Troy [EMAIL PROTECTED] wrote:
On Mon, 22 Jan 2007, Bruno Wolff III wrote:
On Mon, Jan 22, 2007 at 20:25:48 +0100,
Bertram Scharpf [EMAIL PROTECTED] wrote:
What I want to do is the following:
1. Login in from a program on a
Erick Papadakis schrieb:
Correct. Also you will find nearly no stuff about using apt-get and rpm,
which are some of the most used package systems on Linux on
postgresql.org .
And nothing about emerge, which is central to Gentoo Linux. And no real
documentation to ports, which is prevalent on
On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote:
I am not speaking of exotic platforms like some obscure fork of POSIX
or something. I am speaking of Cpanel/WHM with Linux (CentOS in my
case) which must be hosted on hundreds of thousands of webservers
around the world.
Setting
On 1/23/07, Martijn van Oosterhout kleptog@svana.org wrote:
On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote:
I am not speaking of exotic platforms like some obscure fork of POSIX
or something. I am speaking of Cpanel/WHM with Linux (CentOS in my
case) which must be hosted on
Setting aside the fact that I don't even know what Cpanel is, I'm not
sure how this is practical. How many versions of Cpanel are there and
which versions of postgres do they ship? If Cpanel releases a new
version, do the postgresql docs needs to be updated?
Cpanel team takes care of all of
I think it's some sort of serum they inject into semi-skilled i.t.
workers that makes them arrogant and spout off random poorly
constructed off topic posts on professional mailing lists while asking
for help in the same breath. Fortunately, I never went to college and
missed my shot.
You
Martijn van Oosterhout wrote:
On Wed, Jan 24, 2007 at 01:31:23AM +0800, Erick Papadakis wrote:
I am not speaking of exotic platforms like some obscure fork of POSIX
or something. I am speaking of Cpanel/WHM with Linux (CentOS in my
case) which must be hosted on hundreds of thousands of
I use PostgreSQL now since about 10 years, a long time on SuSE-Linux, since
about 2 years on CentOS, also on RedHat, NetBSD and Solaris, and I never had
any problems with installation or initialization or documentation.
Simply follow the few steps at the beginning of the INSTALL file included
How about using updatedb before using whereis or locate?
Regards, Frank.
On Wed, 24 Jan 2007 01:18:20 +0800 Erick Papadakis [EMAIL PROTECTED]
thought long, then sat down and wrote:
Where is pg_hba.conf?
I tried find and whereis commands, but could not find it.
Thanks for any pointers.
On Tue, Jan 23, 2007 at 10:12:13 -0500,
Brandon Aiken [EMAIL PROTECTED] wrote:
Out of curiosity, has the COUNT(*) with no WHERE clause slowness been
fixed in 8.x? Or is it still an issue of there's no solution that
won't harm aggregates with WHERE clauses?
Probably not in the sense that you
But there are ways that we could optimize count(*) queries for specific
circumstances right? Obviously this isn't trivial, but I think it would
be nice if we could maintain a number of rows count that could be used
when performing a count(*) on the whole table (no where clause).
I don't know
On 1/23/07, Laurent Manchon [EMAIL PROTECTED] wrote:
Hi,
I have a slow response of my PostgreSQL database 7.4 using this query below
on a table with 80 rows:
select count(*)from tbl;
PostgreSQL return result in 28 sec every time.
although MS-SQL return result in 0.02 sec every time.
The management of the IPC resources on Solaris 10 has changed
(it now involves the /etc/project file)
I wonder if someone can point me to a white-paper or any other
information
for configuring shared resources (semaphores, shared memory, etc) for
Postgresql on Solaris 10.
Thanks,
Michael.
Erick Papadakis wrote:
Right now, if I wish to contribute to the documentation, how do I make
it relevant? Look at MySQL docs, or PHP manual. I can leave comments
in a context-relevant manner -- e.g., check at the bottom of page:
http://sg.php.net/manual/en/ref.pgsql.php.
Have you seen the
On Tue, Jan 23, 2007 at 02:15:23PM -0500, Jeremy Haile wrote:
But there are ways that we could optimize count(*) queries for specific
circumstances right? Obviously this isn't trivial, but I think it would
be nice if we could maintain a number of rows count that could be used
when performing
On Wed, Jan 24, 2007 at 02:17:53AM +0800, Erick Papadakis wrote:
Cpanel team takes care of all of this. All it takes is for someone
like pgsql to wake up, smell the coffee, and get over the ignorance
about a platform that is the most prevalent in the web hosting world.
Cpanel is used by
On Tue, Jan 23, 2007 at 14:15:23 -0500,
Jeremy Haile [EMAIL PROTECTED] wrote:
But there are ways that we could optimize count(*) queries for specific
circumstances right? Obviously this isn't trivial, but I think it would
be nice if we could maintain a number of rows count that could be used
folks
help me ,i cant read bytea type field's.
how to convert bytea to text or varchar ?
when using bytea types?
any clue be appreciated
best regards
mdc
__
Preguntá. Respondé. Descubrí.
Todo lo que
Estimados,
Disculpen por la pregunta pero con postgres puedo sacar un dump desde dentro
de la base y obtener lo mismo que con pg_dump
Gracias Saludos
-
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.
It sort of looks like you are trying to compile a Windows distro of the
source code on a 'Nix box to me...
--
Regards,
Gregory P. Patnude
Vice President - Applications Innovations Group
iDynaTECH, Inc
120 North Pine Street
STC - Suite 162
Spokane, WA 99202
(509) 343-3104 [voice]
Hi,
I would like to copy a schema X to a new schema Y within the same database.
Is this possible?
--
John Fabiani
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
It appears to me that there is some inconsistency in the date
calculations for my PostgreSQL install (version 8.0 on Win32).
January 07 of 2007 is a Sunday. Based on the documentation I would
expect that date to be the first day of the second week of the year
2007. That's not what I'm getting.
In article [EMAIL PROTECTED],
Merlin Moncure [EMAIL PROTECTED] writes:
can anybody think of of a way to sneak these into dollar quoted
strings for substitution into create function?
would i would ideally like to do is (from inside psql shell)
\set foo 500
create function bar() returns int
Robert Sanford [EMAIL PROTECTED] writes:
It appears to me that there is some inconsistency in the date
calculations for my PostgreSQL install (version 8.0 on Win32).
extract(DOW) follows the convention that the week starts on Sunday,
but extract(WEEK) uses the ISO convention, which includes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/23/07 17:22, Robert Sanford wrote:
It appears to me that there is some inconsistency in the date
calculations for my PostgreSQL install (version 8.0 on Win32).
January 07 of 2007 is a Sunday. Based on the documentation I would
expect that
PG community of Southern California:
PostgreSQL will have a booth at Southern California Linux Expo (SCALE5x) in
three weeks. The booth will be run by Gavin Roy and Daniel Ceregatti of
our LA community, and David Fetter and I will be helping staff it.
http://www.socallinuxexpo.org/scale5x/
It
Is there still a problem here? Does anyone know what the
problem was? I have no trouble accessing varlena.com,
but I am not a good tester for that.
I was out of town during this thread but my machine did not
go down, but my isp could have.
You could have emailed me [EMAIL PROTECTED]
---elein
elein [EMAIL PROTECTED] writes:
Is there still a problem here? Does anyone know what the
problem was? I have no trouble accessing varlena.com,
but I am not a good tester for that.
I was out of town during this thread but my machine did not
go down, but my isp could have.
You could have
On 24 Jan 2007 00:21:44 +0100, Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Merlin Moncure [EMAIL PROTECTED] writes:
can anybody think of of a way to sneak these into dollar quoted
strings for substitution into create function?
Can't you put the psql call into a
Jorge Godoy wrote:
elein [EMAIL PROTECTED] writes:
Is there still a problem here? Does anyone know what the
problem was? I have no trouble accessing varlena.com,
but I am not a good tester for that.
I was out of town during this thread but my machine did not
go down, but my isp
Fernando De Pedro wrote:
Disculpen por la pregunta pero con postgres puedo sacar un dump
desde dentro de la base y obtener lo mismo que con pg_dump
Sales de la base y ejecutas pg_dump.
...
No, no hay ninguna forma de hacerlo.
--
Alvaro Herrera
Every app has its joyful inconsistencies and learning them is part of
the process...
So if I'm currently doing a GROUP BY date_part(week, datecolumn) in a
view and I really want to be using the DOW convention I need to write a
customized get_sunday_week_num (date) to make everything consistent.
On 01/23/07 17:22, Robert Sanford wrote:
January 07 of 2007 is a Sunday. Based on the documentation I would
expect that date to be the first day of the second week of the year
2007. That's not what I'm getting. When I run:
Read the 'week' documentation carefully. ISO weeks start on Mondays.
Greetings,
I am looking into possibly contributing some code for one of the
existing PG drivers, that will allow us to, after INSERT, get a
ResultSet containing the server generated keys (sequences or other).
I've been told that (short of implementing a new V4 server protocol) the
most
Ken Johanson wrote:
-support multiple values, ie. insert int tbl (a,b) values (1,2),(3,4),
should return a result with 2 rows containing the new keys (one for each
column the users declares).
-query the values atomically (so that insert by another client won't
skew the curval / sequence)
Andreas,
Would you mind explaining what you mean by localized object names and why it
might be bad? Or where I might go to learn more?
Thanks,
-Ben
On Tuesday 23 January 2007 07:38, Tino Wildenhain wrote:
A. Kretschmer schrieb:
am Tue, dem 23.01.2007, um 10:12:13 -0500 mailte Brandon
Let's say you have a table with id, value columns.
And your normal query would be this:
INSERT into mytable (id,value) values (1,foo),(2,bar);
Your new query would be like this:
INSERT into mytable (id,value) values (1,foo),(2,bar)
RETURNING id;
And you would get a result back with one
am Tue, dem 23.01.2007, um 20:48:28 -0800 mailte Benjamin Smith folgendes:
Andreas,
Would you mind explaining what you mean by localized object names and why
it
might be bad? Or where I might go to learn more?
Thanks,
Tino wrote this ;-)
Btw.: Fullquote below make its harder to
84 matches
Mail list logo