"Alastair D'Silva" wrote:
I've recently upgraded to 7.1 and have the following situation which no
longer works:
...
As user "nmnuser":
INSERT INTO blah (info) VALUES ('foo');
I get the following error:
blah_id_seq.nextval: you don't have permissions to set sequence
Is it against the SQL standard to accept a trailing comma in a table
declaration?
CREATE TABLE "currency" (
currency_id varchar(3),
rate float, BOOM! parse error
);
As in perl, it would make life easier to simply ignore/accept a trailing
comma on table declarations.
Louis-David Mitterrand [EMAIL PROTECTED] writes:
Why not simply allow access to full perl functionality to postgres
superusers (as with C functions)?
The correct way to do this would be to offer an alternative "untrusted
plperl" language, same as we now do for pltcl --- then the dbadmin has
a
On Sun, 22 Apr 2001, Louis-David Mitterrand wrote:
Is it against the SQL standard to accept a trailing comma in a table
declaration?
Yes it is.
CREATE TABLE "currency" (
currency_id varchar(3),
rate float, BOOM! parse error
);
As in perl, it would make life
Louis-David Mitterrand [EMAIL PROTECTED] writes:
Is it against the SQL standard to accept a trailing comma in a table
declaration?
Yes ...
CREATE TABLE "currency" (
currency_id varchar(3),
rate float, BOOM! parse error
);
As in perl, it would make life
"Alastair D'Silva" [EMAIL PROTECTED] writes:
I've recently upgraded to 7.1 and have the following situation which no
longer works:
As user "nmnadmin":
CREATE TABLE blah {
id NOT NULL SERIAL,
info text NOT NULL
};
GRANT SELECT, INSERT, UPDATE, DELETE ON blah TO nmnuser;
As
Just curious, but what is the point of having times 'acurate' to the
milisecond in a database?
In my case it's a simple matter that I include a timestamp in a digital
signature, and since my timestamp comes from Java (and most Unixes are the
same), it has millisecond resolution "built in."
... if there is interest in an A4 layout of the docs, let me know...
I've gotten several requests for the A4 format, and have completed four
of the six docs in that format. Thanks for the feedback. They should be
available in the next couple of days...
- Thomas
The ps command should show the connection username, database, and
status/idle.
I like to know if a connect session is idle, before somebody can do a kill
connect session.
How can I get the session state?
Where have the sample code or doc about this?
And I want to code by c.
Thanxs
Hi.
I read in Momjian's book that to change the CHAR length of a column in a table (from
30 - 40) lets say, i'm to use the CAST command (pg 93). The fact is that the Posgres
User's manual has nothing about cast and psql doesn't understand this command :-(((
Anyone can tell me how to ajust
On Sun, 22 Apr 2001, Antonio Gennarini - Geotronix wrote:
Hi.
I read in Momjian's book that to change the CHAR length of a column in a table (from
30 - 40) lets say, i'm to use the CAST command (pg 93). The fact is that the Posgres
User's manual has nothing about cast and psql doesn't
Tom Lane wrote:
Louis-David Mitterrand [EMAIL PROTECTED] writes:
Is it against the SQL standard to accept a trailing comma in a table
declaration?
Yes ...
CREATE TABLE "currency" (
currency_id varchar(3),
rate float, BOOM! parse error
);
Is there are way to use postmaster with the -i option (accept
tcp-ip-connections) and bind only to certain addresses interfaces ?
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
I suppose it isn't a major problem, but enforcing strict grammar
helps to show up inadvertent errors. Suppose I have a set of schema
building files for a whole system; the way I do things, there may be fifty
or more files, one per table. If one of these gets corrupted in editing
(perhaps a
On Sun, Apr 22, 2001 at 07:44:46PM +0100, some SMTP stream spewed forth:
Tom Lane wrote:
Louis-David Mitterrand [EMAIL PROTECTED] writes:
Is it against the SQL standard to accept a trailing comma in a table
declaration?
Yes ...
CREATE TABLE "currency" (
Peter Pilsl [EMAIL PROTECTED] writes:
Is there are way to use postmaster with the -i option (accept
tcp-ip-connections) and bind only to certain addresses interfaces ?
In 7.1 there's a postmaster switch to bind only to one specific IP
address, rather than all addresses of the machine. See the
On Sun, Apr 22, 2001 at 03:37:12PM -0400, Tom Lane wrote:
Peter Pilsl [EMAIL PROTECTED] writes:
Is there are way to use postmaster with the -i option (accept
tcp-ip-connections) and bind only to certain addresses interfaces ?
In 7.1 there's a postmaster switch to bind only to one specific
Peter Pilsl [EMAIL PROTECTED] writes:
On Sun, Apr 22, 2001 at 03:37:12PM -0400, Tom Lane wrote:
In 7.1 there's a postmaster switch to bind only to one specific IP
address, rather than all addresses of the machine. See the docs.
Thanx, you know about 7.0.2 also ? I didnt find anything, but I
"David Wall" [EMAIL PROTECTED] writes:
The real question for me is that 7.1 docs say that the resolution of a
timestamp is 8 bytes at "1 microsecond / 14 digits", yet I generally see
-MM-DD HH-MM-SS.cc returned in my queries (both with pgsql and with
JDBC).
That's just a matter of the
On Sun, Apr 22, 2001 at 02:48:36PM -0400, Mitch Vincent wrote:
I suppose it isn't a major problem, but enforcing strict grammar
helps to show up inadvertent errors. Suppose I have a set of schema
building files for a whole system; the way I do things, there may be fifty
or more files,
Is there any way to tell where postgres is looking for it's config file,
or to tell it where to look? I compiled the 7.1RC4 source tarball with
--prefix=/usr/local (and using stow to keep things tidy in /usr/local)
but it is entirely ignoring the postgresql.conf and pg_hba.conf files.
--
Bruce
Bruce Richardson writes:
Is there any way to tell where postgres is looking for it's config file,
or to tell it where to look? I compiled the 7.1RC4 source tarball with
--prefix=/usr/local (and using stow to keep things tidy in /usr/local)
but it is entirely ignoring the postgresql.conf and
Hi Lonnie,
This is one of the reasons we are moving to an EJB server at work (we're
using Oracle there, but they wanted to accomplish the same thing you want
to do with Postgres). By exposing specialized interfaces to the db we
effectively limit the types of queries that can be run. That
On Sun, Apr 22, 2001 at 03:37:12PM -0400, Tom Lane wrote:
Peter Pilsl [EMAIL PROTECTED] writes:
Is there are way to use postmaster with the -i option (accept
tcp-ip-connections) and bind only to certain addresses interfaces ?
In 7.1 there's a postmaster switch to bind only to one
"David Wall" [EMAIL PROTECTED] writes:
The real question for me is that 7.1 docs say that the resolution of a
timestamp is 8 bytes at "1 microsecond / 14 digits", yet I generally see
-MM-DD HH-MM-SS.cc returned in my queries (both with pgsql and with
JDBC).
That's just a matter of
Thanks, Justin, as always for the gentle prodding to expound on an email
:-).
Here's a much-expanded version of the response about how to change field
types, as well as info about best practices for dumping/restoring.
As of version 7.1, PostgreSQL still lacks some commands to alter tables
On Sun, Apr 22, 2001 at 02:14:31AM -0300, The Hermit Hacker wrote:
They were running a Beta2, or something like that, database and were even
warned against it by several of us ...
That's probably overstating things a bit, but running betas and CVS snapshots
is asking for trouble and we know
Hi all~~
In the documentation of Limitations of PostgreSQL, the maximum size for a
table is 64TB on all operating system.
I am using Linux(the limitation size of ext2 file is 2GB).
Would anyone tell me if there is any solution to make a table large than 2GB
in Linux using PostgreSQL.
Thank you
datactrl wrote:
I down load pgSQL v 7.1rc1-1 rpm from ftp://ftp.postgresql.org/pub/dev/test=
-rpms/. When I install it, there is a dependency check error for libpg.so.2=
libreadline.so.4.1. My server is running RH 6.2. Do I have to upgrade to=
RH 7.x?
Try the source install,
datactrl wrote:
When will pgSQL v7.1 officially release?
It is released a week ago, take a look on the website
http://www.postgresql.org. Its definitly worth an upgrade, I like 7.1 a
lot (even the dump files look more readable).
Regards,
Nils
---(end of
On Mon, 23 Apr 2001, Albert wrote:
Hi all~~
In the documentation of Limitations of PostgreSQL, the maximum size for a
table is 64TB on all operating system.
I am using Linux(the limitation size of ext2 file is 2GB).
Would anyone tell me if there is any solution to make a table large than
Tom Lane wrote:
[EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes:
Of course not, it's not a bug - if this is a problem, it's a bug in
Postgresql:
If glibc 2.2.2 sorts that way in C locale, then glibc is broken.
But I assume you meant this is the behavior in some other
Hi Cheryl,
Do you want a one-off copy (a duplicate), or replication which
continuously keeps the databases synchronised?
Regards and best wishes,
Justin Clift
Cheryl Ayres wrote:
is there a way to replicate an existing Postgres database. We want to
duplicate it with a new name and
Sorry then. Well, I tested two cases:
- pg compiled only with enable locale and iso8859-2 works
- pg compiled with locale, enable unicode and unicode conversion doesn't
work as it should.
That's because locale support (--enable-locale) does not consider
about the Unicode support.
is there a way to replicate an existing Postgres database. We want to
duplicate it with a new name and login.
CA Web Design
Website: www.cadesign.on.ca
Email: [EMAIL PROTECTED]
Phone 519.941.6446
Proud member of:
Orangeville District Chamber of Commerce www.chamber.orangeville.on.ca
Does anyone have any experience with any of these issues?
I am currently running a web app using ASP running on IIS 4, NT Server 4.0
and Microsoft Access as a db. When I bring the server up or reboot the
server, access to the data via the web pages is very fast. However, after a
few hours of
Can anyone tell me where to download the ODBC driver windows. I just cant
find it anywhere!
Cheers!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hi all,
Currently I connect from my mac via JDBC. But are there also PostgreSQL
ODBC drivers available for the Mac?
TIA,
Nils
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Fri, Apr 20, 2001 at 03:42:24PM -0400, [EMAIL PROTECTED] wrote:
Hey folks, I sent out this question a while back without
ever getting an answer, so here I go again :)
Has anyone managed to compile a trusted plperl interpreter
into postgres? The Opcode stuff which blocks the use of
39 matches
Mail list logo