That is true in 8.0 but not anymore in 8.1. The reason we invented the
"pg_pltemplate" catalog is to ensure that old dumps of PL language
definitions will track desired changes without such manual heroics ...
Tom,
Thanks for the info, I will update my article to reflect that.
--
Tony Cadut
PG Lightning does Code Completion. I don't think there is a frontend
tool that can step through a PL/pgSQL function.
Ben
""Ken Winter"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]...
Is a better PL/pgSQL editor /
debugger than pgAdmin III or phpPgAdmin available a
Hi.
I would want do a php script to access my postgres database from remote host. I
would like to know how I can do. Particularly, I would to know the default
directory where my database is located so that to be able to call it with my
php script.
---(end of broadcast)-
On Sat, 28 Jan 2006, Roderick A. Anderson wrote:
Hi Rich. Seems once again we're meeting in the same places. The Internet
sure seems small sometimes.
Hello, again, Rod.
I saw all the other posts but you might look at dbwrench (a Java
application). Does a lot more than what you need (plus
On Sat, 28 Jan 2006, Eric B. Ridge wrote:
That's because you've used the wrong syntax.
$ psql contacts -c "\dt" > xrms.tables
This is why I suggested you read the psql man page.
Well, the man page installed shows the -c option is to specify one command,
but when I try that:
[EMAIL PROTECT
Rich Shepard wrote:
I'm trying to help the XRMS developers add postgres support ('cause
that's
what I use). They've done well so far with help from other postgres users,
but now I've been asked to help getting the indices correct.
Hi Rich. Seems once again we're meeting in the same places.
Tony Caduto <[EMAIL PROTECTED]> writes:
> Another thing to keep in mind is if you restore a dump from 7.x to 8.x
> it will not do any checking unless you make a tweak, see this article:
> http://www.milwaukeesoft.com/forums/viewtopic.php?t=83
> As far as I know this affects 8.0 and 8.1, I am sure
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> I am using a create_user() SP created by "postgres" with
> "security definer" (gasp). This works just fine, however, it
> transfers createuser rights to *anyone* allowed to connect
> to the database the function is in.
Not if you restrict who's allowed
On Sat, Jan 28, 2006 at 11:04:09AM -0500, Tom Lane wrote:
> > I have a faint memory of it being possible to create users
> > "inside" *one* given database by way of a particular "create
> > user" syntax along the lines of:
> > create user [EMAIL PROTECTED] ...;
> There is the db_user_namespace kl
Rich Shepard <[EMAIL PROTECTED]> writes:
> On Sat, 28 Jan 2006, Eric B. Ridge wrote:
>
>> Again, you can't use redirection via the psql prompt. But you can do it
>> via your shell command line:
>> $ psql -c "\dt" > xrms.tables
>
>Well, that doesn't seem to be working here, either:
>
> [EMAIL
Tom ~
Thanks for the news. I'm on PostgreSQL 7.4.7, alas, and there's nothing I
can do about it because it resides on a host that I don't control. I
suppose if I don't find an alternative, I could move my development work to
a local installation of PostgreSQL 8.1.
~ Ken
> -Original Message
On Jan 28, 2006, at 4:20 PM, Eric B. Ridge wrote:
Dude, "pg_dump" is not a psql command, nor is it a SQL command.
It's a command-line program. You run it from your shell:
$ pg_dump --schema-only pg_dump > xrms-schema.dmp
pardon my type-o. This should read:
$ pg_dump --schema-only contac
On Jan 28, 2006, at 4:12 PM, Rich Shepard wrote:
Please keep replies on the mailing list.
Again, you can't use redirection via the psql prompt. But you can
do it
via your shell command line:
$ psql -c "\dt" > xrms.tables
Well, that doesn't seem to be working here, either:
[EMAIL PROT
On Sat, 28 Jan 2006, Eric B. Ridge wrote:
You can't do this via the psql prompt. A simple "\d" will output to the
screen, automatically using your $PAGER if the output is too long to fit on
your screen.
Eric,
That's what I assumed; perhaps I misunderstood Tom Lane's "what do you mean
'ofco
why not have server a start at 1 and server b start at max int8/2. that will give each server alot of orders before
you have an issue. They will will not have to play games with the sequence value.
Jim
Hi,
Your method is different from mine, but I think that both methods will
face the
On Jan 28, 2006, at 3:20 PM, Rich Shepard wrote:
contacts=# \d | less
\d: extra argument "less" ignored
You can't do this via the psql prompt. A simple "\d" will output to
the screen, automatically using your $PAGER if the output is too long
to fit on your screen.
I can, however, run '
On Sat, 28 Jan 2006, Ezra Taylor wrote:
Can you use redirection.
No. I get an error message.
contacts=# \dt > xrms.tables
No matching relations found.
\dt: extra argument "xrms.tables" ignored
Rich
--
Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
Applied
On Sat, 28 Jan 2006, Doug McNaught wrote:
You can either use 'pg_dump --schema-only' as another poster
suggested, or use the '\o' command in psql.
When I try 'pg_dump --schema-only' I get a continuation prompt, even with a
semicolon at the end of the command line. A second semicolon produces
On Sat, 28 Jan 2006, Tom Lane wrote:
Not sure why you say "of course" there. \d output is properly paginated
for me, and I believe for most people. What platform are you on, and
what do you have environment variable PAGER set to? Is the output of
plain old SELECT commands paginated for you?
There is a better editor available:
http://www.amsoftwaredesign.com
http://www.amsoftwaredesign.com/lightning_admin.php
I invite you to try it out :-)
It provides all the find/replace goto line number etc, many of the
features of a IDE such as Delphi 2006 or VS, it also has super nice
tabbed b
On 28 Jan 2006 at 13:16, Ken Winter wrote:
> I've learned that pgAdmin "syntax error" can mean anything from a
> missing ";" to a faulty block structure to an undeclared variable to. I
AFAIK, the error messages you're seeing are generated by the database
backend and not by pgAdmin - pgAdmin simp
Thank you Tom,
I also should have reread the docs on 1) and 2) -
it is mentioned there too that you have to call
PQfinish and PQclear even on failed operations.
Could you explain a bit more, where to get the OIDs?
There are really not many PQprepare examples
around (I wonder why, isn't it the fas
Rich Shepard <[EMAIL PROTECTED]> writes:
> When I open the database
> with 'psql contacts' and ask to have the tables dumped (with \d), they go
> streaming by on the display. Of course, the bash 'tee' or 'less' commands
> don't work to allow me to capture the stream to a file or page through the
>
"Ken Winter" <[EMAIL PROTECTED]> writes:
> I ask because I was stuck for two days on the following error message:
> ERROR: syntax error at or near "LOOP"
> CONTEXT: compile of PL/pgSQL function "gen_history" near line 126
> and neither of those tools offered any more help than that. It turned ou
Rich Shepard <[EMAIL PROTECTED]> writes:
>When installing the application I specified the database name as 'contacts'
> (not very innovative or clever, but descriptive). When I open the database
> with 'psql contacts' and ask to have the tables dumped (with \d), they go
> streaming by on the d
Can you use redirection.
On 1/28/06, Rich Shepard <[EMAIL PROTECTED]> wrote:
> I'm trying to help the XRMS developers add postgres support ('cause that's
> what I use). They've done well so far with help from other postgres users,
> but now I've been asked to help getting the indices correct.
>
use pg_dump --schema-only
-- Original Message ---
From: Rich Shepard <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Sat, 28 Jan 2006 10:14:05 -0800 (PST)
Subject: [GENERAL] Viewing Database Scheme
> I'm trying to help the XRMS developers add postgres support ('caus
Is a better PL/pgSQL editor / debugger than pgAdmin III or
phpPgAdmin available anywhere?
I ask because I was stuck for two days on the following
error message:
ERROR: syntax error at or near "LOOP"
CONTEXT: compile of PL/pgSQL function "gen_history"
near line 126
…and neithe
why not have server a start at 1 and server b start at max int8/2. that will
give each server alot of orders before
you have an issue. They will will not have to play games with the sequence
value.
Jim
-- Original Message ---
From: Philippe Ferreira <[EMAIL PROTECTED]>
To: M
I'm trying to help the XRMS developers add postgres support ('cause that's
what I use). They've done well so far with help from other postgres users,
but now I've been asked to help getting the indices correct.
When installing the application I specified the database name as 'contacts'
(not v
I think you need to provide a rationale why you want to control the
value of the sequence in such a way anyway, because you're trying to do
something that the system isn't likely to support. The numbers are
supposed to be "opaque", the actual values are not supposed to be
relevent.
Have a nice
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> I have a faint memory of it being possible to create users
> "inside" *one* given database by way of a particular "create
> user" syntax along the lines of:
> create user [EMAIL PROTECTED] ...;
There is the db_user_namespace kluge^H^H^H^H^Hparameter,
Alexander Farber <[EMAIL PROTECTED]> writes:
> 1) If PQconnectdb fails, do I still need to PQfinish the returned pointer?
Yes, if you don't want to leak memory.
> 2) Similar, if PQprepare fails, do I still need to PQclear its result?
Yes, if you don't want to leak memory.
> 3) Do I have to PQcl
On Thu, Jan 26, 2006 at 09:04:25PM +0100, Philippe Ferreira wrote:
> But because the sequence could not be locked, some concurrent
> transactions could have already raised it's current value in the
> meantime to, say, "1002", before the effective execution of setval().
Umm, locking sequences won't
On Thu, Jan 26, 2006 at 06:07:45PM +, Adam Witney wrote:
> Hi,
>
> I am upgrading from 7.4.8 -> 8.1.2 on Linux 2.6.14.3 #1 SMP
>
> I have installed 8.1.2 and created the database (with encoding 'UNICODE', as
> I had done in 7.4.8) and am trying to load a 7.4.8 dump file but I am
> getting a f
On 1/28/06, Matthew Hixson <[EMAIL PROTECTED]> wrote:
> So, it would seem that table names are case insensitive in select
> statements, but case sensitive in prepare statements.
>Can someone confirm or refute that?
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIER
On Jan 24, 2006, at 9:21 , Michael Glaesemann wrote:
On Jan 22, 2006, at 3:10 , Tom Lane wrote:
That's odd --- AFAIR I've never had trouble building bison on my OS X
laptop. What happens when you try?
I neglected to take any notes. I remember it was complaining about
"muscle" something-
Hello,
I don't think you can create users *inside* a database, but for each
database,
you can create global users and make them members of a group having the same
name than your database.
Then, in pg_hba.conf, the folllowing line will give to your users the
permission to
connect to the datab
Roderick A. Anderson <[EMAIL PROTECTED]> schrieb:
> Anyone aware of a lint for SQL ( 92, 99, PostgreSQL )? We want to look
> quickly at the code we're porting for any MySQL-isms so we can figure out
> what it is suppose to be so the final post will go smoother.
Nice idea. I found http://dbs.inf
Hi all,
I have a faint memory of it being possible to create users
"inside" *one* given database by way of a particular "create
user" syntax along the lines of:
create user [EMAIL PROTECTED] ...;
or similar.
Was this ever possible in PostgreSQL or is my memory playing
tricks on me ? I went bac
40 matches
Mail list logo
