Michelle Konzack wrote:
Hello *,
I am searching for a weired error... Since all users are working fine,
I was now root and done a 'su - postgresql' to create a new user with
createuser --password devel.debian
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allo
Jorge Godoy wrote:
Jorge Godoy <[EMAIL PROTECTED]> writes:
Is there a better way to guarantee that there will be no gaps in my sequence
if something goes wrong with my transaction?
From the overwhelming feedback I assume there isn't a better way yet...
Thanks. I'll see how I can improve
Alvaro Herrera wrote:
Joshua D. Drake wrote:
Matthew T. O'Connor wrote:
Chris wrote:
aBBISh wrote:
You need to install & setup tsearch2.
I have a small article about how to do that here:
http://www.designmagick.com/article/27/
Also on page 3 you say, "(normal indexes will only index the firs
oops, for got the link:
http://www.pgadmin.org/download/
--- Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> > Hi Richard,
> > I'm attaching pg_hba.conf and postgresql.conf files as you had asked for.
> > Don't know if I've missed anything in these two configuration files that
> > would not let
> Hi Richard,
> I'm attaching pg_hba.conf and postgresql.conf files as you had asked for.
> Don't know if I've missed anything in these two configuration files that
> would not let
> my client machine to connect to the DB computer.
>
> Also, what exactly do u want me to install on the client compu
Yeah. I just realized when I could not start pgadminIII in the DB server computer.Added that line for localhost too :)Yeah, i need stronger authentication for my application. Thanks for the valuable advice.
Thanks again~Harpreet.On 8/13/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Sun, Aug 13, 20
On Sun, Aug 13, 2006 at 07:07:11PM -0400, Harpreet Dhaliwal wrote:
> Problem was with pg_hba.conf file
>
> ECPGdebug(1, stderr); showed that in pg_hba.conf there was setting for
> localhost only and not for other ip addresses.
>
> I had to change the configuration for IPV4 local connections
>
>
Thanks alot all.You guys have been really helpful.I've crossed the first obstacle, a major one though...Phew.Let me see where do I trip later :-)~HarpreetOn 8/13/06,
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Postgres is not installed in the client computer.> When i try to connect to the pos
Michael,Please ignore my last emailAt last I got error code 0.Problem was with pg_hba.conf fileECPGdebug(1, stderr); showed that in pg_hba.conf there was setting for localhost only and not for other ip addresses.
I had to change the configuration for IPV4 local connectionsIt should have been someth
ECPGdebug(1, stderr);After including this line of code in my program, it says:raising sqlcode -402 in line 14, 'could not connect to database dbxyz in line 14'Thanks,~Harpreet.
On 8/13/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Sun, Aug 13, 2006 at 01:58:54AM -0400, Harpreet Dhaliwal wrote:> -4
Hi Richard,I'm attaching pg_hba.conf and postgresql.conf files as you had asked for.Don't know if I've missed anything in these two configuration files that would not let my client machine to connect to the DB computer.
Also, what exactly do u want me to install on the client computer? A full fledg
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jorge Godoy wrote:
> Ron Johnson <[EMAIL PROTECTED]> writes:
>
>> Pre-allocate records. The (primary key?) field would have the
>> numbers already filled in, but all the rest of the fields in each
>> record be NULL, blanks, zeros or indicator values
> Postgres is not installed in the client computer.
> When i try to connect to the postgres db from the computer in which postgres
> is installed, it goes through. No hassles in that.
> Problem comes up when I'm trying to connect to the same database from a
> different computer in which no postgres
Postgres is not installed in the client computer.
When i try to connect to the postgres db from the computer in which postgres is installed, it goes through. No hassles in that.
Problem comes up when I'm trying to connect to the same database from a different computer in which no postgres is instal
Ron Johnson <[EMAIL PROTECTED]> writes:
> Pre-allocate records. The (primary key?) field would have the
> numbers already filled in, but all the rest of the fields in each
> record be NULL, blanks, zeros or indicator values ("~~",
> -9, etc).
>
> Then create a single-field table c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jorge Godoy wrote:
> Jorge Godoy <[EMAIL PROTECTED]> writes:
>
>> Is there a better way to guarantee that there will be no gaps in my sequence
>> if something goes wrong with my transaction?
>
> From the overwhelming feedback I assume there isn't a
Hi,
On Sun, 13 Aug 2006, Jorge Godoy wrote:
Christian Kratzer <[EMAIL PROTECTED]> writes:
I would at least try to assign multiple such numbers in batches to mimize
contention on the row you store the counter in.
What do you mean here? How would you guarantee that on of the receiver
transac
Michael Fuhr wrote:
> On Fri, Aug 11, 2006 at 11:40:53PM -0400, Harpreet Dhaliwal wrote:
> > What kind of patch are you talking about?
>
> A documentation patch. Michael Meskes, to whom I was responding,
> maintains ECPG. I was asking whether he wanted me to submit a patch
> to fix misleading pa
Christian Kratzer <[EMAIL PROTECTED]> writes:
> I would at least try to assign multiple such numbers in batches to mimize
> contention on the row you store the counter in.
What do you mean here? How would you guarantee that on of the receiver
transactions didn't rollback and left a gap in the "s
Hi,
On Sat, 12 Aug 2006, chris smith wrote:
On 8/12/06, Jorge Godoy <[EMAIL PROTECTED]> wrote:
Is there a better way to guarantee that there will be no gaps in my
sequence
if something goes wrong with my transaction?
Why does it matter?
I assume there is a reason you need it like this..
> What do i do next buddy?
> ~harpreet
When you created your database using PGadmin 3, was PGadmin 3 on your
Postgresql Server or was it
on the client machine that you are trying to establish an ECPG connection from?
I just want to be sure that you are infact able to connect to your database
fr
On Aug 13, 2006, at 2:16 pm, Thomas Kellerer wrote:
I do agree that this might be a problem of universty education
which focuses too much on theory and not on real-world problems.
From what I've seen, a bigger problem is universities that focus on
neither!!!
Ashley
-
> On 8/12/2006 Merlin Moncure <[EMAIL PROTECTED]> wrote:
> the .net 'way' of database application development is to keep
> all the logic in the .net middleware. please note that I am
> completely opposed to this because it obfuscates good data
> management practices. however based on the op's
Jorge Godoy <[EMAIL PROTECTED]> writes:
> Is there a better way to guarantee that there will be no gaps in my sequence
> if something goes wrong with my transaction?
>From the overwhelming feedback I assume there isn't a better way yet...
Thanks. I'll see how I can improve the model then to se
On Sat, Aug 12, 2006 at 02:04:42PM -0700, Jim Bryan wrote:
> Installed latest postgresql 8 on windows xp,
> everything works fine with pl/pgsql; problems creating
> a table with perl however:
>
> CREATE OR REPLACE FUNCTION datetable() RETURNS integer
> AS $$
> CREATE TABLE tabletest
> (
> da
Hi
We need to deploy postgreSQL with our new app
The app is designed in Visual Studio 2005 and deployed in its own MSI.
Our question is - is it possible to call the postgreSQL msi from our MSI or
is it possible to merge PostGreSQL msi into ours. We use Wise for Windows 6
to create our MSI.
How
Installed latest postgresql 8 on windows xp,
everything works fine with pl/pgsql; problems creating
a table with perl however:
CREATE OR REPLACE FUNCTION datetable() RETURNS integer
AS $$
CREATE TABLE tabletest
(
dayofmonth int4,
monthofyear int4,
theyear int4
)
$$
LANGUAG
Hi,
I need your help!
I vacuumed an entire database because it was having a transaction wraparound problem.
Than I dropped the database.
After running ANALYZE, the entry of the database is gone as I expected.
But when I try to connect to other databases I get the same transaction wraparound err
Ashley Moran wrote on 13.08.2006 13:46:
I can't understand how developers employed to created database-backed
applications think they can get anywhere with so little understanding of what
they are doing.
Well spoken!!
I have actually written a 10-page introduction to relational theory, based
On Aug 13, 2006, at 11:34 am, Dave Page wrote:
I see a similar issue in my line of work. Many of the programmers
(even
those working for the larger software houses in the social housing
sector)
have started out their careers as housing offices or maintenance
surveyors
or whatever and have d
On Sun, Aug 13, 2006 at 01:58:54AM -0400, Harpreet Dhaliwal wrote:
> -402 sqlcode means "connection attempt to the database did not succeed"
>
> does this mean that my application is connecting to the database server but
> somehow failing in connecting to the database dbxyz due to some
> authentic
On 13/8/06 09:57, "Thomas Kellerer" <[EMAIL PROTECTED]> wrote:
> Harald Armin Massa wrote on 13.08.2006 10:46:
>> Do you know for what benefit that happens? I have seen similiar stupidity
>> with EJB, having RI within that layer. Why are people doing this? Do they
>> know something I miss, or d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas Kellerer wrote:
> Harald Armin Massa wrote on 13.08.2006 10:46:
>> Do you know for what benefit that happens? I have seen similiar stupidity
>> with EJB, having RI within that layer. Why are people doing this? Do they
>> know something I miss, o
Harald Armin Massa wrote on 13.08.2006 10:46:
Do you know for what benefit that happens? I have seen similiar stupidity
with EJB, having RI within that layer. Why are people doing this? Do they
know something I miss, or did they just not vivist Databases 101 ?
I think this happens because of th
Merlin,the .net 'way' of database application development is to keep all the
logic in the .net middleware. please note that I am completelyopposed to this because it obfuscates good data management practices.are you serious and well informed about this? There is really again somebody throwing away
What do i do next buddy?~harpreetOn 8/13/06, Harpreet Dhaliwal <[EMAIL PROTECTED]
> wrote:i started the postmaster using pg_ctl in user a/c jsb.Switched to root and ran nmap -sS localhost
for port 5432 it says5432/tcp opne postgresOn 8/13/06,
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
--- Har
i started the postmaster using pg_ctl in user a/c jsb.Switched to root and ran nmap -sS localhostfor port 5432 it says5432/tcp opne postgresOn 8/13/06,
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
--- Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:> Hello,>> I'm really not able to connect to my dat
37 matches
Mail list logo