Serkan,
Actually, it sounds like you don't have a primary key set up properly, and
Access can't deal with that. Check to make sure that you do! Just an idea.
You could also try adding a field named "TIMESTAMP" that is a date/time
field.
I believe that might fix the problem too. Access can be f
> I've just found out that views can be renamed using ALTER TABLE
> RENAME... iirc, VIEWs are referred to by OID from PL/SQL functions & other
> views, and by name from pl/pgsql functions.
OK. Since we can modify PL/pgSQL functions, it is no problem.
It is a pitty we don't have CREATE OR REPLACE
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 19:53
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Pseudo modification of views and triggers (again)
>
>
> Dear Dave,
>
> 1) Views
> View pseudo-modification works fine. It was im
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 19:28
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] Pseudo modification of views and triggers
>
>
> Dear Dave,
>
> I implemented pseudo-modification of views based on the
> func
Mark,
Yes,
when there is a need, then a control may be appropriate. The (unwritten) rules
are:
- Only
use controls where necessary
- Only
use standard Microsoft or home brewed controls
- Use
the normal pgAdmin licence - certainly *no* GPL (they're not compatible - that's
why the Mi
Hi,
On the PostgreSQL ODBC website (http://odbc.postgresql.org) there is a link
on the left hand column to the PG + Access FAQ which may help you.
As this is an Access problem, this is probably not the best place to ask -
you might try the [EMAIL PROTECTED] list.
Regards, Dave.
> -Original
-Original Message-From: Mark A. Taff
[mailto:[EMAIL PROTECTED]] Sent: 19 February 2002
17:01To: Dave PageCc:
[EMAIL PROTECTED]: Re: [pgadmin-hackers] Broken
sql string?
My
apologies for not sending this to the list originally. Allow me to elaborate. I am wor
Dear Dave,
1) Views
View pseudo-modification works fine. It was implemented in
pgSchema->pgView->Let Defition property. This allows the modification of view
definition only (not the name of the view).
This is OK because view names should not be changed (views can be called
inside functions or
Dave,
As
the HBX is a user-control, am I correct to presume that it is OK to make our
own user-controls? I can’t think of any neat way to do the desired entity
relationship-diagramming
module without user-controls.
Regards,
Mark
Dear Dave,
I implemented pseudo-modification of views based on the function example.
Pseudo modifiation is carried by a simple DROP /CREATE in both cases. This
was pretty easy : I just had to copy and adapt your code...
This seems to work fine. I will do the same for triggers and commit tomorr
-Original Message-From: Mark A. Taff
[mailto:[EMAIL PROTECTED]] Sent: 19 February 2002
17:01To: Dave PageCc:
[EMAIL PROTECTED]: RE: Broken sql
string?
My
apologies for not sending this to the list originally. Allow me to elaborate. I am working on a `View De
My apologies
for not sending this to the list originally. Allow me to elaborate.
I am working on a `View Designer` similar to the interface that SQL
Server uses to create new views. There
are a great many unknowns right now, and I need to get it working enough to
find out what works and
The pgAdmin CVS repository has moved!! Please update your repositories etc.
to point to cvs.pgadmin.org. The old hostname (cvs.social-housing.org) will
stay for the time being, but may be removed without notice.
Regards, Dave.
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 13:44
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] ALTER USER xxx PASSWORD ''
>
>
> Dear Dave,
>
> I migrated to PostgreSQL 7.2. pgAdmin2 does not seem to be
> able to chan
Dear Dave,
I migrated to PostgreSQL 7.2. pgAdmin2 does not seem to be able to change
passwords anymore. Is this a bug due to encryption? Can you reproce this bug
on a newly created user?
Cheers,
Jean-Michel
> -Original Message-
> From: Salil Mohanty [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 12:02
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] backup plugin
>
>
> Hi Dave,
> Is there any facility currently in postgresql to take
> backup of the WAL logs? or differential
-Original Message-From: Mark A. Taff
[mailto:[EMAIL PROTECTED]] Sent: 19 February 2002
11:26To: Dave PageSubject: Broken sql
string?
Dave,
Query sql strings taken from my new sql hbx cause the display sub (from
the sql output form, now cannibaliz
Hi Dave,
Is there any facility currently in postgresql to take
backup of the WAL logs? or differential backup? Or is
work on this thing in progress?
Salil.
--- "Mark A. Taff" <[EMAIL PROTECTED]> wrote:
> Brian,
> If you install OpenSHH (an open-source SSH client),
> you can access the
> Li
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 11:50
> To: Dave Page; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Hebrew support
>
>
> Le Mardi 19 Février 2002 10:16, Dave Page a écri
Le Mardi 19 Février 2002 10:16, Dave Page a écrit :
> Yeah, but as Danny says he can display Hebrew from PostgreSQL in MS Excel,
> surely that proves that it's not all the ODBC driver?
OK. UTF-8 is plain ASCII coded on 1, 2 or 3 caracters. If MS Excel is UTF-8
compatible and smart enough, it sho
Brian,
If you install OpenSHH (an open-source SSH client), you can access the
Linux command prompt from a DOS prompt. You can then run any of the Linux
command line interfaces to PostgreSQL, including psql, pg_dump, etc. This
works well for me if I just need quick access. However, for s
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 09:13
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Unicode/Multibyte/Hebrew/Japanese
>
>
> Le Mardi 19 Février 2002 09:50, Dave Page a écrit :
> > I want to
Le Mardi 19 Février 2002 09:50, Dave Page a écrit :
> I want to get this problem sorted out if I can - have you read the message
> I cc'd you last night yet? It's becoming more & more common & there must be
> some way around it.
I read them now and replied the best I could...
> Do you use ICQ or
> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 09:07
> To: Dave Page; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Hebrew support
>
>
> > Jean-Michel.. if you are re
Jean-Michel POURE wrote:
>
> > 1) When I try to view tables from Access XP, the arabic letters are not
> > correctly displayed: I can see only the multibyte to single byte 1:1
> > conversion. This is not that important because I don't need to see it in
> > Access because the database will be seen
> Jean-Michel.. if you are reading, have you had any more thoughts on this?
> If we knock up a test app, can you test on any of you machines? We could at
> least then allow the pgAdmin user to select the font, and have them
> download a suitable one if required.
Dear Dave,
It is not a problem of
> -Original Message-
> From: Brian [mailto:[EMAIL PROTECTED]]
> Sent: 19 February 2002 04:32
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-hackers] backup plugin
>
>
> Any plans to make a backup plugin or option on the admin tool
> to backup databases?
Brian,
I have no intention of *
Dear Nhan Dgo,
Please CC pg-odbc and pgadmin lists so that anyone can participate.
> I'm currently running Microsoft SQL Server 2000 on a Windows 2000 Server
> platform, but this is only to read the source database. I don't know how to
> retrieve the source encoding... It should be UNICODE since
> 1) When I try to view tables from Access XP, the arabic letters are not
> correctly displayed: I can see only the multibyte to single byte 1:1
> conversion. This is not that important because I don't need to see it in
> Access because the database will be seen through PHP on the web.
The odbc d
Le Lundi 11 Février 2002 09:30, Amir Behgooy a écrit :
> We are trying to design a 2 to 3 week long project for a graduate course in
> Database systems at our university. We are supposed to use PostgreSQL and
> add some functionality to it or make some appropriate modifications. Do you
> have any
30 matches
Mail list logo
