Hello PG's,
I want to extract the weekday of a given 'date' type field in my table
when selecting. How can I do this?
For example in a table "bschft_days" filled with values with type 'date'
I want to select all the days within the month 'march' and output the respective
weekday. I tryed this:
Hello community,
anyone experienced problems using postgresql distribution
on SuSE 7.1 with reiserfs???
I noticed the following problem:
When creating a table 'tableA' as User A I can not insert in this
table with User A. The error message is always:
ERROR: tableA: Permission denied.
The on
Hello community,
I have a doubt about multiple access to a table in my database.
When two people are accessing the same table for insert or update,
is the affected row locked or am I supposed to lock this row explicit
in my application???
Any help will by welcome! :)
Best Regards / Un saludo /
Hello Tom,
Tom Lane wrote:
> Jose Manuel Lorenzo Lopez <[EMAIL PROTECTED]> writes:
> > I created a table bdf_users as admin user 'postgres' and granted insert
> > access for this table to public.
> > Now I want to insert a line as user 'jose'
Hello PG's,
I am trying to use the Perl module for Postgresql, but when I start
a simple example like this:
#!/usr/local/bin/perl -w
use Pg;
$conn = Pg::connectdb("dbname=template1");
die $conn->errorMessage unless PGRES_CONNECTION_OK eq $conn->status;
$result = $conn->exec("select tablename
Hello PG's,
I am trying to compile postgresql 7.0.3 on AIX 4.3.2.
Configure worked fine with ./configure --with-CC=/usr/local/bin/gcc
--without-CXX
but after that make break up very early with the following output:
Making postgres.imp
./backend/port/aix/mkldexport.sh postgres /usr/local/pgsql/
Hello community,
I want to compile postgresql 7.0.3 on my WinNT at work, but I don't
know how! Am I supposed to compile it with VisualC++, as I read in
the docs I hope not, cause I am only a poor system admin!! :)
I have cygwin-tools on my machine so I hoped that's all I need!
Can anybody
I am trying to create a class for my application that handles
postgres access via the C interfaces.
My question is the following:
Will be PGresult also deleted when I close a connection with
PQfinish(PGconn), or am I supposed to delete the handle on
PGresult by myself after closing connection
