Richard Poole [EMAIL PROTECTED] writes:
I can't get NOT NULL variables to work at all in PL/pgSQL.
Looks like a bug to me too ... will look into it.
regards, tom lane
-Original Message-
From: Gregory Wood [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 9:12 PM
To: PostgreSQL-General
Subject: [GENERAL] Re: Test for existence of Table
DROP TABLE employees
Error: ERROR: Relation 'employees' does not exist
And execution halts which is
DROP TABLE employees
Error: ERROR: Relation 'employees' does not exist
And execution halts which is I believe why he wanted to check for the
existence before trying to DROP. I'd love to know if this exists as
well...
would come in very handy during development time.
Execution does
Hello. I am trying to use Microsoft Access 2000 with Postgresql 7.0.2
installed on a Mandrake 7.2 box. I have configured my ODBC driver and DSN
on the windows box, and have configured Postgresql to allow my machine to
connect, and have installed its ODBC driver as well. I can view and edit
I'm getting an error when forming SELECT statements using the new 7.1
EXECUTE command. The error states, simply, that there was an unexpected
SELECT within the EXECUTE command.
Which leads me to ask: can I actually form SELECT statements using
EXECUTE, or is there something else I need to be
Let me rephrase my words. :)
I have created postgresql tables with pgaccess. I am unable to add new
records to those tables using Microsoft Access 2000. How do I remedy this
situation, and also, is there a way to create tables within Microsoft Access
2000 on the Postgresql server.
appologies
On Thu, 4 Jan 2001, Tom Lane wrote:
Lincoln Yeoh [EMAIL PROTECTED] writes:
Uhoh, since I'm using perl does that mean I have to patch DBI and Pg::DBD?
Couldn't say. I didn't have much trouble setting up a Tcl application
to work smoothly with NOTIFY events, but I've never tried such a
1) Make sure the odbc data source you are using has the read only flag checked off.
2) Create a primary key index for the table. Access97 requires a primary key or it
will not allow you to edit or add any rows.
-Original Message-
From: Scott Teglasi [SMTP:[EMAIL PROTECTED]]
Sent:
Sorry guys I figured out what was wrong in my postgressql startup
script I was passing the -i option to the backend instead of the postmaster.
My fault
Scott Shealy
-Original Message-
From: Scott Shealy [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 11:31 AM
To:
Brian Troxell [EMAIL PROTECTED] writes:
I'm getting an error when forming SELECT statements using the new 7.1
EXECUTE command. The error states, simply, that there was an unexpected
SELECT within the EXECUTE command.
For no good reason that I can see, the original coding for EXECUTE
rejected
Brian Troxell wrote:
I'm getting an error when forming SELECT statements using the new 7.1
EXECUTE command. The error states, simply, that there was an unexpected
SELECT within the EXECUTE command.
Which leads me to ask: can I actually form SELECT statements using
EXECUTE, or is there
Let me rephrase my words. :)
I have created postgresql tables with pgaccess. I am unable to add
new records to those tables using Microsoft Access 2000. How do I
remedy this situation, and also, is there a way to create tables
within Microsoft Access 2000 on the Postgresql server.
Here's the story about pgsql and jail:
1. FreeBSD shared memory is _really_ shared across all jail VMs. I think
its not going to change, as this seems like a great way for processes to
exchange data...But I could be wrong. :)
2. Postgres uses some funky math to determine which shmid to use for
Gregory Wood wrote:
What would be nice is if there were a way to only DROP a table if it exists.
But I would consider this to be rather low priority.
This might help...
CREATE FUNCTION table_exists(TEXT) RETURNS BOOLEAN AS
'DECLARE
tablename ALIAS FOR $1;
temp RECORD;
BEGIN
Hi. I'm able to use Access 2000 to view and edit my tables, and to add new
records, however I am encountering a problem when adding new records to the
table.
When I add a record, I fill in the relevant fields, but when I proceed to
the next row, the row I just added shows "#Deleted" in all of
Knew about #1... and I'm not holding my breath for change gicing where
the development on that angle is heading.
In the installation directory for the jail i don't have the /storage
directory, or for that matter the ipc.h file anywhere in the pgsql
tree (both in the jail and host installations).
On Fri, 5 Jan 2001, Justin Banks wrote:
Hello -
As a followup to my mail about replication yesterday, I've
realized that I can make replication bi-directional, with each
(non-replicant master initiated) connection to a backend it's own
master with respect to that connection and all
Yes, obviously /storage/* isn't in the install dir, its the source file.
If you are using a port to compile postgres, it'd be in
/usr/ports/databases/postgresql7/work/postgresql-7.0.2/src/include
I'd suggest you do this: add a global backend_shmid_offset in ipc.c,
initialized to current default,
How do we get it?
I want to test the product.
Sandeep
On Fri, 5 Jan 2001, Justin Banks wrote:
Hello -
As a followup to my mail about replication yesterday, I've
realized that I can make replication bi-directional, with each
(non-replicant master initiated) connection to a
On Fri, 5 Jan 2001, Sandeep Joshi wrote:
How do we get it?
I want to test the product.
downloadable as a tar file from http://www.pgsql.com - Download ...
Sandeep
On Fri, 5 Jan 2001, Justin Banks wrote:
Hello -
As a followup to my mail about replication yesterday, I've
On Fri, 5 Jan 2001, Thomas T. Thai wrote:
i'm in the process of dumping out my db from mysql and importing them into
pgsql. i would appreciate some suggestions and warnings about
pitfalls. most of my mysql tables have an autoincremment field.
check out http://www.pgsql.com - Download, where
Hi!
I have some questions about coding in php with postgre.
Here is my code
$qu = pg_exec ($db_conn, "SELECT * FROM clients ORDER BY username");
$row = 0; // postgres needs a row counter other dbs might not
while ($data = @pg_fetch_object ($qu, $row)) {
echo $data-username." (";
echo
Alex Pilosov [EMAIL PROTECTED] writes:
I'd suggest you do this: add a global backend_shmid_offset in ipc.c,
initialized to current default, and an option to postgres to put a value
there.
Don't waste your time. This issue is gone in current sources. See
IpcMemoryCreate and
On Fri, 5 Jan 2001, Tom Lane wrote:
Alex Pilosov [EMAIL PROTECTED] writes:
I'd suggest you do this: add a global backend_shmid_offset in ipc.c,
initialized to current default, and an option to postgres to put a value
there.
Don't waste your time. This issue is gone in current
I said:
Alex Pilosov [EMAIL PROTECTED] writes:
I'd suggest you do this: add a global backend_shmid_offset in ipc.c,
initialized to current default, and an option to postgres to put a value
there.
Don't waste your time. This issue is gone in current sources. See
IpcMemoryCreate and
Anybody knows where I can find the windows - ODBC driver for the latest
version of PostgreSQL (7.0.3)?
Thanx
What'd happen is: Operation not permitted (EPERM, -1), so its not a
problem...
-alex
On Fri, 5 Jan 2001, Tom Lane wrote:
I said:
Alex Pilosov [EMAIL PROTECTED] writes:
I'd suggest you do this: add a global backend_shmid_offset in ipc.c,
initialized to current default, and an option to
Richard Poole [EMAIL PROTECTED] writes:
I can't get NOT NULL variables to work at all in PL/pgSQL.
Doesn't look like they've ever worked :-(. If you need a patch for
7.0.*, line 1907 of src/pl/plpgsql/src/pl_exec.c should read
if (*isNull var-notnull)
not
if (isNull
the jail can only address the PID's that operate within itself... in
effect allowing it to f'up its own enviroment only... thus the
problem with pg trying to allocate dedicated portions of the
host/system wide memory.
will up the 7.0.2 to 7.1 and give her another go around. Really would
like
"Dave VanAuken" [EMAIL PROTECTED] writes:
the jail can only address the PID's that operate within itself... in
effect allowing it to f'up its own enviroment only...
Certainly a jailed process should not be allowed to actually kill()
a process outside the jail. The question is what error code
On Fri, Jan 05, 2001 at 11:17:29PM +0100, Uro Gruber wrote:
Hi!
I have some questions about coding in php with postgre.
Here is my code
$qu = pg_exec ($db_conn, "SELECT * FROM clients ORDER BY username");
$row = 0; // postgres needs a row counter other dbs might not
while ($data =
31 matches
Mail list logo