Hi!
I'm still dealing with "QueryBuffer exceeded, core dump..".
I've tried using
psql -e < xx.sql
psql -f xx.sql
as Bob Dusek suggested...
or inside psql with \i xx.sql.
I've broken the sql script in two... after a few lines of the second part,
the same error... should I download again and re
Hi,
I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I
see here that Valerio can export tables from Access to pgsql. How is this done?
And using forms from Access related to pgsql databases?
This could be invaluable. While I'm at it, does anyone know where there might
b
First of all.. thanks to everybody for helping me out witht the
"sequence" stuff. :)
I've got another questions for you dudes. When using a CheckBox in a
Form written in MSAccess that's related to a table in a
PostgreSQL database, if I simply turn its status from ON to OFF it works
fine, while i
I wonder if it's thorougly tested or not. I've got a 6.3.2 version what's
the matter in case of 6.4?
Sebestyén Zoltán <[EMAIL PROTECTED]>I'm believing that the Holy Spirit is
Memphisto wrote:
>
> Hi,
>
> Is there a way to display big integer numbers splitted by periods in
> PostgreSQL queries?
>
> Example: 123.456.789 instead of 123456789 .
>
> Thanks in advance
You can create a function to format numbers.
See attached example.
-Jose'-
On Mon, 18 Jan 1999, Valerio Santinelli wrote:
> I've exported a table from an existing MSAccess database to my
> PostgreSQL db.
> I use a serial ID on the table and now I'm getting errors when I add a
> new entry in the table if i don't specify the ID by hand (which should
> be placed automati
It maybe done with next syntax;
drop sequence_name;
create sequence sequence_name start start_no;
But, if you want to increment the sequence_no by one manually, then;
select nextval('sequence_name');
==ooOO /. .\ OOoo==
Dept. of Neurosurg
I've exported a table from an existing MSAccess database to my
PostgreSQL db.
I use a serial ID on the table and now I'm getting errors when I add a
new entry in the table if i don't specify the ID by hand (which should
be placed automatically by the db since it's a serial).
The exact error is t
Your script worked for me (I skipped everything related to
forms-lib), but :
- /* */ C-style comments are not allowed by perl (line #2)
- you should $sth->finish() and $dbh->disconnect() at the end of your
script to avoid warnings ("Database handle destroyed without
explicit dis
