Hi,
If I run an UPDATE operation from one connection the changed data is only
visible from that connection. How do make the change visible from other
connections? Do I have to wrap everything in a transaction?
I'm using libpq if that makes a difference.
Thanks,
Andrew
> PG definitively lack BLOB support and it is a big drawback...
This statement is completly wrong.
Just look at lo_create/lo_open/lo_read/lo_write/lo_close functions
in libpq.
> Even with PG7.1 with TOAST that will remove the 8kB limit on records, there
> will be still no BLOB support.
>
> As yo
* Bruce Momjian <[EMAIL PROTECTED]> [001009 22:11] wrote:
> As many of you know, several businesses are involved in providing
> PostgreSQL support.
>
> After careful consideration, I have decided to accept a job with Great
> Bridge. There will be a press announcement tomorrow (Tuesday) with more
As many of you know, several businesses are involved in providing
PostgreSQL support.
After careful consideration, I have decided to accept a job with Great
Bridge. There will be a press announcement tomorrow (Tuesday) with more
details. I will post a URL here when I have it.
Interestingly, I
[EMAIL PROTECTED] (Martin Jacobs) writes:
> Ignoring the minor floatingpoint errors, the first annoying
> severe was in parallel group2
> sequential test create_type ... FAILED
> ERROR: TypeCreate: function 'widget_in(opaque)' does not exist
Odd. Test create_function_1 di
Jinsoo Hwang <[EMAIL PROTECTED]> writes:
> ERROR plpgsql: cache lookup for proc 163937 failed.
I suspect that you deleted and recreated the function after
creating the trigger. Currently you must recreate the trigger
after you recreate the function --- but the system won't tell
you so in any di
"Keith L. Musser" <[EMAIL PROTECTED]> writes:
> I did try out Peter's new JDBC driver on two very simple query-only
> applications. It was about 15% slower on one of the apps and 10% faster
> on the other, compared with jdbc7.0-1.2.jar. It worked correctly on
> both tests.
>
> Neither is parti
"Anton Kalauzky" <[EMAIL PROTECTED]> writes:
> Dear friends,
>
> I have two PC's with exactly the same configurations - one in my office and
> the other at home. They are running RedHat Linux 6.2 and PostgreSQL included
> in distribution. The first one I recently installed by upgrading from Li
I did try out Gunnar's new JDBC driver on two very simple query-only
applications. It was about 15% slower on one of the apps and 10% faster
on the other, compared with jdbc7.0-1.2.jar. It worked correctly on
both tests.
Neither is particularly representative, but the fact that one's faster
an
"Ally" <[EMAIL PROTECTED]> writes:
> However, I've read that Postgres 7.1 / 7.2 will accomodate larger row sizes
> and was wondering if there was a ballpark ETA / release date for them. And
> does anybody know which version will have this feature?
7.1 for sure; the feature has been working in dev
At 19:55 6/10/00 +0300, Ruslan P. Yawdoshak wrote:
>Hove i can restrict access for tables in postgeSQL
>and users can anly call function to change tables entries ?
>(In function I'll self control access)
No. There was talk about implementing this, but so far it has gone nowhere,
I think...
"Jack" <[EMAIL PROTECTED]> writes:
> I have been upgrading Postgresql version from 6.5 into 7.0 and slight
> problems emerged, probably due to my insufficient knowledge:
> 1. In the older version, in psql, I could repeat SQL commands by means of
> up-down keys - now I have to type everything again
I did try out Peter's new JDBC driver on two very simple query-only
applications. It was about 15% slower on one of the apps and 10% faster
on the other, compared with jdbc7.0-1.2.jar. It worked correctly on
both tests.
Neither is particularly representative, but the fact that one's faster
an o
"Vilson farias" <[EMAIL PROTECTED]> writes:
> I'm having problems with temporary tables in postgre.
> I've been using Postgre 7.02 in a red hat 6.2 and I'm accessing using Delphi
> 5 + Winzeos Postgre Components. I've been using for some mounths and now I
> checked that there are lots of temp tabl
On Fri, 6 Oct 2000, Stephan Szabo wrote:
> About view rules:
> Of course, you shouldn't actually be
> able to get into the situation with
> a view rule, since dropping the table
> the view points to should drop the view
> (or refuse to drop the table) it appears
> from looking at drop table in t
On Sun, Oct 08, 2000 at 01:17:45PM +1000, Ally wrote:
> I've developed a full-text, news article database in Postgres with Perl and
> the Pg module as my search front end. The only problem (that I discovered
> AFTER I'd done all my dev work) is that Postgres has an 8K row limit. About
> 3% of my a
Stephan Szabo <[EMAIL PROTECTED]> writes:
> There really isn't a spec way to do it, however,
> select distinct on (col1) col1, col2, col3, col4 from tablename;
> would get you one row for each distinct col1, but it's undefined what
> row that gets you.
You can get a well-defined result with DIS
Hove i can restrict access for tables in postgeSQL
and users can anly call function to change tables entries ?
(In function I'll self control access)
Thanx and Regards,
Ruslan.
Dear friends,
I have two PC's with exactly the same configurations - one in my office and
the other at home. They are running RedHat Linux 6.2 and PostgreSQL included
in distribution. The first one I recently installed by upgrading from Linux
6.1 and the for the second one I went through full
Hey all,
I've developed a full-text, news article database in Postgres with Perl and
the Pg module as my search front end. The only problem (that I discovered
AFTER I'd done all my dev work) is that Postgres has an 8K row limit. About
3% of my articles exceed this size limit.
I've tried splittin
Hallo,
I have been upgrading Postgresql version from 6.5 into 7.0 and slight
problems emerged, probably due to my insufficient knowledge:
1. In the older version, in psql, I could repeat SQL commands by means of
up-down keys - now I have to type everything again;
2. ODBC driver I have used to coop
>IIRC,SQL92 recommends to handle this case
>as ASSERTIONS rather than as CONSTRAINTS.
Yeah, that was my first thought was to build
them and try to make the constraint look like
an assertion. That doesn't get around locking
though.
>The implementation would be quite different from
>that of (curr
How did you install PHP & Apache? Did you configure & compile the
sources or get the rpm's from somewhere? If you're compiling PHP from
the sources, you need to configure PHP with the --with-pgsql switch. You
can check whether this is the problem (i.e. missing pgsql support) by
making a page that
Greetings,
We are developing a conference registration system using PostgreSQL.
Any one willing to share any prior work done in this area?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share
Hi,
If I run an UPDATE operation from one connection the changed data is only
visible form that connection. How do make the change visible from other
connections? Do I have to wrap everything in a transaction?
I'm using libpq if that makes a difference.
Thanks,
Andrew
Hello !
I have tables and want to restrict access for tables for all users and
write function that is users can call and\ change data in this tables.
(All persmition will be controled in function)
How is it do ?
Regards,
Ruslan.
PG definitively lack BLOB support and it is a big drawback...
Even with PG7.1 with TOAST that will remove the 8kB limit on records, there
will be still no BLOB support.
As you have indicated it seems that PG chokes on null characters. What is
needed is a varbinary type, which stores binary data
Hi,
Just wanted to let you know I posted a MD5 hash function for PostgreSQL,
based on a request I got for this kind of feature. The code is based on
the soundex module (as found in 7.0.2), with the original RSA MD5 code
found in the MD5 Perl module. (Please note the MD5 hash is not necessarily
c
(My normal mail account is dead so I'm
reading from the archives on the web :(
- And I'm not sure that my last mail on
the subject got through)
About view rules:
Of course, you shouldn't actually be
able to get into the situation with
a view rule, since dropping the table
the view points to sh
You can use a 'oid'::oid
Vitaliy..
I'm having problems with temporary tables in postgre.
I've been using Postgre 7.02 in a red hat 6.2 and I'm accessing using Delphi
5 + Winzeos Postgre Components. I've been using for some mounths and now I
checked that there are lots of temp tables in my system. These tables where
created by my a
On Thu, 5 Oct 2000, Amy Antle wrote:
> I have 2 tables in Access. I want one of them to act as an archive table.
> The first table collects records for a tempoary amount of time, and then
> drops them into another table that will store them and keep growing and
> growing each time it receive
Hi All,
I'm using Postgres for the first time and have this problem:
when I use NULL as the value of one of the parameters in my stored
procedure, all the values of all the parameters in body of procedure will
cleared to NULL too.
(I have Postgres 7.0.2 on Linux RedHat 6.2 )
The simple example:
Robert Boyd <[EMAIL PROTECTED]> writes:
> Should I get connection status before every query, and if bad, attempt
> reconnect?
Waste of time, assuming you are thinking of PQstatus(); it just returns
a field from the PGconn struct showing the last known state.
I'd suggest that *upon error* you che
hello,
i have a database and in it strings with accented characters in
latin-1 encoding, but the database has been mistakenly created with
unicode encoding. as you all know this makes pg_dump break.
what i'm enquiring is - is there a way to change the encoding
and preserve the data? i only kno
"Tamsin" <[EMAIL PROTECTED]> writes:
> I'm trying to sort out security on my db, configuring pg_hba.conf etc. I
> just wanted to check that this in't possible - I want my postgres linux user
> to be able to connect to the database without a password, but I don't want
> other users logged on to th
All,
Came across a Gartner/Tech Republic research piece on object support
in Oracle 8:
http://www.techrepublic.com/download_item.jhtml?id=dr00220001002jim01.htm
You need to register for the site, but it's free. I'd be happy to
email the PDF to anyone individually as well.
Anyone know what's n
I'm tasked with handling database connection failures
elegantly--reconnecting after failure.
I'm wondering how other people have approached this problem.
Should I get connection status before every query, and if bad, attempt
reconnect?
Any help is appreciated.
- Rob
Tom,
Thanks. Running ipcclean fixed it right away.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
On Mon, 9 Oct 2000, Tom Lane wrote:
> Travis Ba
Travis Bauer <[EMAIL PROTECTED]> writes:
> When I start postmaster, I get the following:
> IpcSemaphoreCreate: semget failed (No space left on device) key = ...
> However, it normall works fine with the setting, and a nasty
> crash killed it this morning. I think that for some reason, some
> se
looking at it now, it appears that the build tree had something stuck in
it that it was trying to use byacc vs bison, which was screwing up the
build ...
doing it manual right now, after cleaning out some cache files, and all
looks good so far ...
On Sun, 8 Oct 2000, Frank Joerdens wrote:
> e
When I start postmaster, I get the following:
IpcSemaphoreCreate: semget failed (No space left on device) key = ...
I know that this is caused by not having enough semaphores and can be
fixed by increasing some settings.
However, it normall works fine with the setting, and a nasty
crash kill
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > No spinlock. I was going to just grab a snapshot as it existed. If it
> > changes while I am grabbing it, I just try again.
>
> Unless, of course, you follow a now-dangling pointer and cause a backend
> crash. But even without that, how do you kn
On Mon, 9 Oct 2000, Bruce Momjian wrote:
> > On Mon, 09 Oct 2000, Peter Eisentraut wrote:
> > > John Menke writes:
> > > > Can you install postgresql on Win98?
> > >
> > > Clients only.
> >
> > And on Windows NT?
>
> Cygwin can run the full server on NT.
Where can I get the binarys?
"And I'm
> On Mon, 09 Oct 2000, Peter Eisentraut wrote:
> > John Menke writes:
> > > Can you install postgresql on Win98?
> >
> > Clients only.
>
> And on Windows NT?
Cygwin can run the full server on NT.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
Bruce Momjian <[EMAIL PROTECTED]> writes:
> No spinlock. I was going to just grab a snapshot as it existed. If it
> changes while I am grabbing it, I just try again.
Unless, of course, you follow a now-dangling pointer and cause a backend
crash. But even without that, how do you know whether y
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am thinking of a tcl/tk app that can go in and grab information from
> > backends by querying the actual structure values. Does gdb
> > automatically halt the running app?
>
> Yes. I suppose this is no big problem if you start a backend to be
>
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I am thinking of a tcl/tk app that can go in and grab information from
> backends by querying the actual structure values. Does gdb
> automatically halt the running app?
Yes. I suppose this is no big problem if you start a backend to be
used only as t
> Philip Warner <[EMAIL PROTECTED]> writes:
> > In the case of images, is there a way to tell TOAST not to bother even
> > trying to compress the data? (eg. JPEG files). If so, would I be right in
> > assuming that this would be better for fast retrieval (even for text
> > files)?
>
> TOAST will
[ Charset ISO-8859-1 unsupported, converting... ]
> Is all the info on using toast on the postgresql site, or is it somewhere
> else?
>
> Also, I'm assuming it is good for more than just test, correct?
We are keeping TOAST quiet until beta beings. Of course, this has
already made it to the gen
> Tom Lane wrote:
> > Frank Joerdens <[EMAIL PROTECTED]> writes:
> > > Can I go around bragging to my SQL-minded friends about using this
> > > really cool thing that no other database has, or should I keep my mouth
> > > shut because it's actually not so cool?
> >
> > IMHO it's pretty cool. You
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I want to write an admin utility that will view backend SQL queries, and
> > be able to view locks and statistics using gdb on the running backend.
>
> gdb on a backend doesn't seem to me like a reasonable component of a
> production situation. I w
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I want to write an admin utility that will view backend SQL queries, and
> > be able to view locks and statistics using gdb on the running backend.
>
> gdb on a backend doesn't seem to me like a reasonable component of a
> production situation. I w
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I want to write an admin utility that will view backend SQL queries, and
> be able to view locks and statistics using gdb on the running backend.
gdb on a backend doesn't seem to me like a reasonable component of a
production situation. I was thinking
Yes, you can use symlinks to move table files to other locaions while
the database is down.
[ Charset ISO-8859-1 unsupported, converting... ]
> If I replace the actual tables with links to a postgres database, the module
> and macros should work the same also, correct? As long as the whole
> str
> On Fri, Oct 06, 2000 at 06:05:41PM +0200, Peter Eisentraut wrote:
> > Mike Sears writes:
> > > Is there away to access a postgres database using a shell script, like bash
> > > or korn?
> >
> > There's pgbash, which might be what you want, but I've never tried it.
> > Of course psql works as
I want to write an admin utility that will view backend SQL queries, and
be able to view locks and statistics using gdb on the running backend.
> "Dale Anderson" <[EMAIL PROTECTED]> writes:
> > Is there any way to view the locks being held on a table??
>
> There is not any good way --- lock.
I see this as well on my CVS machine. I'll look to see why it's
doing that this week and 7.1 should hopefully have this fixed.
It's especially wierd since making the constraint and then putting
the same data in seems to work.
Stephan Szabo
[EMAIL PROTECTED]
On Mon, 9 Oct 2000, Vilson farias wr
58 matches
Mail list logo
